custom tag modes

[AKBAR]

hello all,

is there a way to control the state of a custom tag?? i mean if i want to
keep the custom tag mode just to "start" and later i can (by doing
something) can get it into "inactive" mode??

thanx in advance.

akbar
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: CFERROR - MailTo

[David Shadovitz]

Let me follow up on my own message by adding something I learned from
Jeff Howden:
Hide the textarea (in IE, at least) using the style attribute:
 style="display : none;"
-David

- Forwarded message --
From: David Shadovitz <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Fri, 12 May 2000 08:05:32 -0700
Subject: Re: CFERROR - MailTo
Message-ID: <[EMAIL PROTECTED]>

Jerry,
Unfortunately, you will have a problem if error.diagnostics contains a
double quote (as it often does).  Let me invoke the hallowed name of Dave
Watts, who pointed out that the only HTML element that can safely pass
the single quotes and double quotes that appear in error.diagnostics is
the textarea.  I use hidden form fields for all but error.diagnostics;
for that one I use a tiny textarea at the bottom of the page, with a note
next to it saying, "<-- ignore this".
-David

On Fri, 12 May 2000 08:34:48 -0500 "Jerry William Richardson"
<[EMAIL PROTECTED]> writes:
> Here's what I use:
> 
> 
> 
> 
> 
> Error
> 
> 
>   function errorsubmit() {
>   document.forms[0].submit()
>   }
>   
> 
> 
> 
> http://www.yoursitenamehere.com/errorhandler.cfm"
> METHOD="POST" TARGET="_top">
>   
>VALUE="#error.diagnostics#">
>VALUE="#error.template#">
>VALUE="#error.querystring#">
>VALUE="#error.datetime#">
>   
>VALUE="#Error.HTTPReferer#">
> 
> 
> Sorry
> 
> An error occurred when you requested this page. The Webmaster has 
> been
> notified of this error. We will work to correct the problem and 
> apologize
> for the inconvenience.
> 
> 
> 
> Then errorhandler.cfm adds an entry to my project management 
> database,
> e-mails me and (between the hours of 7 AM and 11 PM) pages me with 
> the text
> of the error that occurred.
> 
> Of course on your application.cfm file you will have the entry
>  mailto="[EMAIL PROTECTED]">
> 
> Jerry Richardson
> [EMAIL PROTECTED]
> 
> 
> 
> -Original Message-
> From: Michael Paulsmeyer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 5:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: CFERROR - MailTo
> 
> 
> Thanks Jerry,
> 
> For those of us who might not know how to create a self-submitting 
> form
> using JS could you point us in the right direction?
> 
> Mike.
> 
> -Original Message-
> From: Jerry William Richardson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 12:09 PM
> To: [EMAIL PROTECTED]
> Subject: RE: CFERROR - MailTo
> 
> 
> One option is to have your cferror page be a self-submitting (using
> javascript) form that takes all the different variables from the 
> error that
> are available and submits them to a cfm page that then e-mails you.
> 
> It's the long way around the barn. Please note that if you forward 
> these
> errors to a pager, they will inevitably only occur at 4:00 AM, 
> cruelly
> depriving you of sleep until you die from exhaustion.
> 
> Jerry Richardson
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 11:00 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: CFERROR - MailTo
> 
> 
> > New to the list and I have been having a problem getting the 
> mailto
> > attribute in the CFERROR tag to work.  I have set and verified the
> > mail server in CF Administrator. What else can I look at and/or 
> do?
> 
> I could be wrong about what exactly the problem is that you're 
> having, but
> my guess is that you fell into the same trap I did when I first used
> CFERROR. That is, I thought that when I specified a MAILTO 
> attribute, that
> the CFERROR page would send an email to that address. That is not 
> the case.
> All setting the MAILTO attribute lets you do is use that attribute's 
> value
> as an error variable in the CFERROR page, so that you could do 
> something
> like this within that page:
> 
> mailto:#Error.MailTo#">Notify system administrator
> 
> It took me quite a while to figure that out, as I recall.
> 
> 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.
> 
>
-
---
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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=list

nested tags problem??

[Deva Ramesh]

hello all,

my collegue has already posted this Q. but it seems that the question was
not so clear. ok our problem is.

we have the following files in webroot directory:

1) showtable.cfm--which invokes the custom tag "listtable.cfm" which inturn
is in "cfusion/cutomtag/" directory.

2) edit.cfm-- which invokes the custom tag "edittable.cfm" which inturn is
in "cfusion/cutomtag/" directory.

now the thing is that i have a link in the custom tag "listtable.cfm" which
redirects to editable.cfm for invoking the "edittable.cfm" cutom tag.

but when i click on the link i get this following error.


Error Diagnostic Information
Cannot open CFML file 
The requested file "C:\INETPUB\WWWROOT\CUSTTAGS\EDITABLE.cfm" cannot be
found. 
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTTAGS\EDIT.CFM 
C:\INETPUB\WWWROOT\CUSTTAGS\EDITABLE.cfm Custom Tag 
The error occurred while processing an element with a general identifier of
(CF_EDITTABLE), occupying document position (2:1) to (9:22) in the template
file C:\InetPub\wwwroot\custtags\edit.cfm.
Date/Time: 05/16/00 12:07:57
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
HTTP Referer: http://127.0.0.1/custtags/showtable.cfm
Query String: ID=11

someone has answered it by asking us to use "" but the thing is
that, a cfassociate tag can only be used when we place the "child tag"
inside the "parent tag". but here in our case the edittable tag is not the
child tag but an independent tag. however if i place the "edittable.cfm"
file under the webroot, i am able to use it. but i want to keep all the
custom tags un the cfusion directory. not scattered.
sorry for being so long. but i hope u ppl understand me and help us out.
thanx in advance
ramesh





_   __  
|   |   |   |
|form page  |   |   |
|   | -->   |
|
|   |   |   |
|   |   |   |
|   |   |   |
~~  |_ |
|
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Replacing Letters in a String

[Jeff]

jon,

:~~
: From: Jonathan Karlen <[EMAIL PROTECTED]>
:
: In many languages I could store the search string
: as an array and loop through the array inserting
: '%' symbols in between each character.  I'm not
: aware of any CF way to do this.
:~~

maybe i'm not understanding exactly what you want to do, but why not use a
list with a space as a delimiter?

then, just loop over that list creating that portion of your sql statement
as the value of a cf variable.  then, in your cfquery just wrap that cf
variable with PreserveSingleQuotes() and you're home free.

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: and IIS argh!!

[Dave Watts]

> *deep breath*  OK .. not sure about WSH and ADSI .. anyone
> know of any handy resources on them?

Wrox Press has good books on both topics. The Microsoft MSDN site has a
decent amount of coverage 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: Replacing Letters in a String

[Jonathan Karlen]

Well - its not that I want to ignore the non-numeric groups, we're giving
the user the option to either search for an exact part number, a substring
or by part family (yes, it is an electronic parts database).

Creating a second field would be a serious pain as far as maintanence goes.

In many languages I could store the search string as an array and loop
through the array inserting  '%' symbols in between each character.  I'm not
aware of any CF way to do this.

Jon


- Original Message -
From: Dick Applebaum <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 10:34 PM
Subject: Re: Replacing Letters in a String


> mmm...
>
> Are you sure you want to ignore *any* number of non-numeric groups?
>
> If so, one way would be denormalization...  storing a second copy of
> the part number in the table.  This second part number would
> represent the part number in a format that could be readily searched:
>
>Real Part #   Search Part #
>----
>12AB3456  123456
>1AB23456  123456
>123AB456  123456
>
>
> Another way would be to use T/SQL statements, if the db is MS-SQL 7.
>
> I would tend to recommend the denormalization... at the cost of a few
> bytes in each record you greatly simplify the search process.
>
> The input search field can be manipulated with regexp to easily
> eliminate the non-numerics.
>
> This isn't an electronics parts db, by any chance, it it>
>
>
> HTH
>
> Dick
>
>
> At 10:42 PM -0500 5/15/2000, Jonathan Karlen wrote:
> >This is a multi-part message in MIME format.
> >
> >--=_NextPart_000_0056_01BFBEBE.CE241C80
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> >Greetings -
> >
> >I am developing a parts database for a client which is keyed by part =
> >number.  He wants to be able to search by first numeric sequence.  So, =
> >for example, a search for 123456 would return part numbers 12AB3456, =
> >1AB23456, 123AB456 and so on. =20
> >
> >>From a SQL point of view what I'd imagine I need to generate is a string
=
> >like "1%2%3%4%5%6%" to allow for characters between each number.
> >
> >Does anyone have any suggestions of how I can generate this string based
=
> >on user input?
> >
> >Thanks.
> >
> >Jonathan Karlen
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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: and IIS argh!!

[Todd Ashworth]

More stuff to have to figure out!

Maybe I can make a wig wrapper to cover my bald head when this stuff gets to
kicking my ASP and I 

*deep breath*  OK .. not sure about WSH and ADSI .. anyone know of any handy
resources on them?

.Todd

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 9:55 PM
Subject: RE:  and IIS


> > Does anyone know of a way to have CF interact with IIS?
> > Basically, what I am trying to do is make a CF app. that
> > will set up the directories and paths and settings in IIS
> > to get a web site up and going, 100% configured, without
> > using the IIS management console. I'm sure there's a way to
> > do it .. just not sure how to approach the problem.
>
> You might want to look at the HTML interface that you can install with
IIS.
> It uses ADSI from ASP; ADSI is the interface you can use to do all this
> nifty stuff. When you install IIS, in addition to the HTML management
> interface, you'll get a bunch of WSH scripts to do different management
> tasks.
>
> The bad news is that you can't use CFOBJECT to work effectively with ADSI.
> If you want to use ADSI from CF, you'll have to write wrappers in WSH or
VB
> or your compiler of choice. This isn't especially difficult, but it is
> tedious.
>
> 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.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[James Sleeman]

On Mon, 15 May 2000 22:42:36 -0400, "Dave Watts" <[EMAIL PROTECTED]> wrote:

>> seperate files once created - .mdf and .ldf (data and

> I don't think you can simply overwrite these files safely, as metadata for
> the databases is stored in the master database. At least, that's how it
> works in earlier versions. If you can shut down any database clients (like
> CF) during the process, you can restore from a backup device file (that you
> created on your development machine). This is pretty easy to do in SQL
> Server 7 and is more practical than using Data Transformation Services for
> most purposes.

Ahh, OK that is just what I wanted to know.  

Thanks...
James Sleeman

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Help Parsing a String

[Dick Applebaum]

Yoy cou treat it as a list with / as the delimiter:

   

   
   


  #box_1# #box_2#





At 9:37 PM -0700 5/15/2000, Erika Foster wrote:
>I have a field that contains the number of authorized vehicles vs. the
>number of assigned vehicles like this: 14/12.  What function would  I use to
>grab everything to the left of the "/" and then everything to the right of
>the "/" to display them in separate text boxes?
>
>Thanks,
>
>Erika Foster
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: New Window

[Jeff]

scott,

:~~
: From: Computer Simplistics Suppoer <[EMAIL PROTECTED]>
:
: What would be some JavaScript (I am assuming that
: is what I would use) to open the results of a form in a
: new window, one which I can control the size, toolbars,
: resize, etc?
:~~

first off, i'd like to invite you to join the js-jive list where this sort
of question is not offtopic.  in fact, this very question was asked and
answered today.

http://www.onelist.com/community/JS-Jive/

second, you can see an example of this implementation here:

http://members.evolt.org/jeff/code/form_to_window/

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: Help Parsing a String

[ron]

> I have a field that contains the number of authorized vehicles vs. the
number of assigned vehicles like this: 14/12.  What function would  I use to
grab everything to the left of the "/" and then everything to the right of
the "/" to display them in separate text boxes?


Erika,

Try this:





hth,

ron
http://humankindsystems.com
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: our friend CFLOCK (help!)

[Dave Watts]

> 1) Should calls to CFOBJECT be locked?  Does it depend on the
> particular type of object, and if so, do I need to lock
> CLASS="Word.Application", and how would I know in general
> which classes need to be locked?

If you know absolutely that the object you're referencing is thread-safe,
you shouldn't need CFLOCK. If not, then you do.

> > ...there is still a very good reason to CFLOCK a CFLOCATION.
> > Any time the page you are transferring to depends on a value
> > being set in the originating page, CFLOCK is almost mandatory.
> > Otherwise, the multi-threading nature of CF may perform the
> > CFLOCATION *before* the variables are set or a query is complete,
> > which could *royally* hose the next page. Granted, this is
> > usually only a major problem when network latency is extremely
> > low (local LAN), but I have seen it enough times to know it is
> > a very subtle GOTCHA.
>
> I don't understand this at all.  If I have:
>
>File1.cfm:
>   
>  
>   
>   
>
>File2.cfm:
>   
>  name=#session.name#
>   
>
> How can the CFLOCATION be performed BEFORE the  "greg"> is executed?  What would the lock around cflocation
> look like, and how would it prevent the problem?

CF, while it generally seems like a batch language where everything executes
from top-to-bottom, is actually a bit more complex, I think. I know that
when you use a CFLOCATION tag, CF stops looking for tags to process, and
immediately sends the HTTP header back to the browser. I also know that the
CF engine does perform some tasks asynchronously, so that it may actually
start executing the CFLOCATION before the previous CFSET has completed. The
server would then start processing the browser's next request. As Mike
Sheldon noted, this is pretty rare, but it does happen, and it's one of
those wacky things that's hard to track down.

> 5.  Do you have to cflock this:
> isDefined("application.foo")? I assume not, but want to make sure.

You wouldn't think you'd have to lock this, but it is a read, and according
to the one guy on Earth who should know:

"Simeon Simeonov wrote:
> IsDefined() cannot be used on shared variables without locking!

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: New Window

[Duane Boudreau]

Try this:


function PopUpWindow(url, hWind, nHeight, nWidth, nStatus, nScroll,
nResizable) {
var cToolBar = "toolbar=0,location=0,directories=0,status=" + nStatus +
",menubar=0,scrollbars=" + nScroll + ",width=" + nWidth + ",height=" +
nHeight + ",resizable=" + nResizable;
var popupwin = window.open(url, hWind, cToolBar);
}


Open Window

Duane Boudreau
CFExperts.Com


-Original Message-
From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 11:31 PM
To: [EMAIL PROTECTED]
Subject: OT: New Window


What would be some JavaScript (I am assuming that is what I would use) to
open the results of a form in a new window, one which I can control the
size, toolbars, resize, etc?

I am thinking something like:



from what I have seen. Any help would be appreciated. Thanks!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
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: Help Parsing a String

[David Gassner]

Erika, you can treat it as a list with "/" as the delimiter:





David Gassner
Vintage Business Applications

> -Original Message-
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 9:38 PM
> To: [EMAIL PROTECTED]
> Subject: Help Parsing a String
>
>
> I have a field that contains the number of authorized vehicles vs. the
> number of assigned vehicles like this: 14/12.  What function
> would  I use to
> grab everything to the left of the "/" and then everything to the right of
> the "/" to display them in separate text boxes?
>
> Thanks,
>
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

Re: Have I set a record?

[Todd Ashworth]

hmmm .. maybe, but actually the 'school' thread has been right on topic, if
you ask me.  I've decided to stick with Cold Fusion as a career, but I was
wrestling with spending the money and extremely valuable time furthering my
education.  One of the things I was considering was, what impact, if any,
would an advanced degree have on my future as a Cold Fusion developer?
Thanks to all who answered .. this has been very enlightening .. I'm
applying tomorrow :)

.Todd

P.S. Obviously, you aren't *that* busy if you have time to read all the
messages in these threads *and* count them ;)

- Original Message -
From: Randy Adkins <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 2:13 PM
Subject: Re: Have I set a record?


> Greg,
>
> I agree. This use to be a nice list for information.
> However it seems recently it has turned into a chat line.
>
> So many things off-topic.
>
> Sorry for this POST. But we are CF programmers here
> to help with other CF problems.
>
> Not discuss lives thoughts and so-called great wisdoms.
>
> Lets try to stay with CF topics.

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

Help Parsing a String

[Erika Foster]

I have a field that contains the number of authorized vehicles vs. the
number of assigned vehicles like this: 14/12.  What function would  I use to
grab everything to the left of the "/" and then everything to the right of
the "/" to display them in separate text boxes?

Thanks,


Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[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: our friend CFLOCK (help!)

[Greg Saunders]

I'm re-posting my list of CFLOCK questions, with a few new questions added
to the list.  


1) Should calls to CFOBJECT be locked?  Does it depend on the particular
type of object, and if so, do I need to lock CLASS="Word.Application", and
how would I know in general which classes need to be locked?  


2) Someone (I think Michael Dinowitz) once recommended: "use CFLOCK on all
direct network calls  (CFHTTP, CFFTP, etc. NOT CFMAIL)."  Does this include
CFFILE?  How about CFDIRECTORY?

Actually, I found part of the answer to this question in the manual:

Using CFLOCK around file manipulation constructs can guarantee that file 
updates do not fail due to files being open for writing by other
applications
or ColdFusion tags.

Does this mean that you do NOT have to lock CFDIRECTORY?  Also, I
understand the part about preventing writing by other CF tags, but I don't
understand the part about preventing failure due to other apps having the
file open, especially given the sample syntax in the docs, which uses just
the name of the file:







3) And someone else (I think Michael Sheldon) once said:

>...there is still a very good reason to CFLOCK a CFLOCATION.
>Any time the page you are transferring to depends on a value being set in
>the originating page, CFLOCK is almost mandatory. Otherwise, the
>multi-threading nature of CF may perform the CFLOCATION *before* the
>variables are set or a query is complete, which could *royally* hose the
>next page. Granted, this is usually only a major problem when network
>latency is extremely low (local LAN), but I have seen it enough times to
>know it is a very subtle GOTCHA.

I don't understand this at all.  If I have:

   File1.cfm:
  
 
  
  

   File2.cfm:
  
 name=#session.name#
  

How can the CFLOCATION be performed BEFORE the  is executed?  What would the lock around cflocation look like, and
how would it prevent the problem?



4.  Has anyone tested CFLOCK's "throwOnTimeout" flag?  I have a frameset
with 2 frames, and inside each is:

   
  
  I'm inside the lock.
   
   I'm outside the lock.

This code will throw an error in one of the frames regardless of the value
of throwOnTimeout.



5.  Do you have to cflock this:   isDefined("application.foo")?   I assume
not, but want to make sure.



Gregory M. Saunders, Ph.D.
Senior Design Architect
Cognitive Arts Corporation (http://www.cognitivearts.com)
120 S. Riverside Plaza, Suite 1520
Chicago, IL 60606

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Replacing Letters in a String

[Dick Applebaum]

mmm...

Are you sure you want to ignore *any* number of non-numeric groups?

If so, one way would be denormalization...  storing a second copy of 
the part number in the table.  This second part number would 
represent the part number in a format that could be readily searched:

   Real Part #   Search Part #
   ----
   12AB3456  123456
   1AB23456  123456
   123AB456  123456


Another way would be to use T/SQL statements, if the db is MS-SQL 7.

I would tend to recommend the denormalization... at the cost of a few 
bytes in each record you greatly simplify the search process.

The input search field can be manipulated with regexp to easily 
eliminate the non-numerics.

This isn't an electronics parts db, by any chance, it it>


HTH

Dick


At 10:42 PM -0500 5/15/2000, Jonathan Karlen wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_0056_01BFBEBE.CE241C80
>Content-Type: text/plain;
>   charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Greetings -
>
>I am developing a parts database for a client which is keyed by part =
>number.  He wants to be able to search by first numeric sequence.  So, =
>for example, a search for 123456 would return part numbers 12AB3456, =
>1AB23456, 123AB456 and so on. =20
>
>>From a SQL point of view what I'd imagine I need to generate is a string =
>like "1%2%3%4%5%6%" to allow for characters between each number.
>
>Does anyone have any suggestions of how I can generate this string based =
>on user input?
>
>Thanks.
>
>Jonathan Karlen
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: converting word docs to HTML [solved!]

[Greg Saunders]

With relentless off-list help from David Shadovitz, we finally have code (below) to 
convert Word documents into HTML!  There are a few minor issues/questions embedded in 
the code, but it works quite nicely, and it works with Word 2000.  Thanks to David and 
all others who helped!

Gregory M. Saunders, Ph.D.
Senior Design Architect
Cognitive Arts Corporation (http://www.cognitivearts.com)
120 S. Riverside Plaza, Suite 1520
Chicago, IL 60606


























failed...#CFCATCH.message#








HTML for sample word doc



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

OT: New Window

[Computer Simplistics Suppoer]

What would be some JavaScript (I am assuming that is what I would use) to
open the results of a form in a new window, one which I can control the
size, toolbars, resize, etc?

I am thinking something like:



from what I have seen. Any help would be appreciated. Thanks!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Web registrars may take back your domain name

[Nick Baker]

Scott,

What you have addressed may be true, and is nice as far as it goes. (FYI if 
you use the
right options you can register as many as you want with Network Solutions 
as well.
But it does cost more with Netsol.)

Bulkregister's does not offer all of the automated features. That is not to 
suggest that
in the total scheme of things that Bulkregister is any less capable than 
any of the other
Registrars. To date NONE of the Registrar services can provide the total 
repertoire of
domain management services needed by the entire Internet community in an 
automated
fashion.

So! The point of the original post was that the ability to transfer between 
Registrars was
not as claimed in the quoted article.

Nick


>I can recommend bulkregister.com.
>
>While they are a smaller place, they offer MUCH better pricing and have all
>automated forms that WORK! I am registering domains at $15 a year right now
>with them. Their service works great and is almost always up and working and
>is very easy to use. It even stores information as default for registering
>so that if you register a lot to one person, it is easy to just type in the
>name and go.
>
>Scott Berry
>--
>Computer Simplistics Support
>"Simple Solutions for a Complex World"
>http://www.c-s.net
>661-296-4315
>
>
>- Original Message -
>From: "S.E.Fling" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, May 15, 2000 5:56 PM
>Subject: Re: Web registrars may take back your domain name
>
>
> > I'm not surprised that Network Solutions is the bottleneck, it took me 2
>months just to change my e-mail address. The automated solution didn't work
>and whenever I tried to contact a
> > live person, I kept getting referred back to the stupid forms. I finally
>had to create a letter, and FAX it to them with ID and proof of address. I'm
>going to transfer all of my
> > domains away from them as soon as I figure out how it all works.
> >
> > sf
> >
> > Nick Baker wrote:
> >
> > > This article contains a very misleading error.
> > >
> > > "The Buyers' Guide explains that it's relatively easy to wave goodbye to
> > > one registrar and transfer your domain name to another."
> > >
> > > Apparently, no one attempted to verify this with an actual transfer. I
>have
> > > been attempting to transfer a domain name from Bulkregister to Network
> > > Solutions for over 2 months. At this point the problem has been with
> > > Network Solutions. They have admitted that they do not, yet, have the
> > > mechanism in place to handle these kinds of transfers.
> > >
> >
> > --
>
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>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: Netscape Image problem

[Jeff]

james,

:~~
: From: Pecora, James <[EMAIL PROTECTED]>
:
: I am getting a wierd response from NN 4.08 (and
: others) regarding the resolution of an image.
:
: 
:~~

nn doesn't like the percentage value of the width.  change nothing but that
and it will load every time.

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: Uploading SQL Server databases

[Dave Watts]

> This is true the master db does contain info about the DB
> including the security settings and things like that. But I
> think as long as the services are stopped then there should
> not be a problem.
>
> Again I am not sure because the only thing I have done it
> with was a small static DB but it is worth a try.

There's no need to try this. You can easily back up your database to a file,
copy the file to a new server, and restore from that file, without having to
shut down the database server or worry about losing info. I do this quite
often when I have to deploy a new version of a database.

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.

Regular Expressions

[David Cummins]

Hi everybody

I've got a bit of a problem with regular expressions. We've taken over
development of a web site from other developers, and they didn't tell us
which templates are scheduled to run automatically.

My idea was to look for pages that don't have any user interaction in
them, i.e. no  tags. This should be able to be done easily from
ColdFusion Studio's extended find. The only problem is, how do you
specify the concept of "any file which does not contain this string" in
regular expressions?

If anybody has any ideas, please let me know.

David
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[Nick McClure]

>I don't think you can simply overwrite these files safely, as metadata for
>the databases is stored in the master database. At least, that's how it
>works in earlier versions. If you can shut down any database clients (like
>CF) during the process, you can restore from a backup device file (that you
>created on your development machine). This is pretty easy to do in SQL
>Server 7 and is more practical than using Data Transformation Services for
>most purposes.

This is true the master db does contain info about the DB including the 
security settings and things like that. But I think as long as the services 
are stopped then there should not be a problem.

Again I am not sure because the only thing I have done it with was a small 
static DB but it is worth a try.



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[Dave Watts]

> Correct, but different servers will do things differently,
> SQL server (so far as I can see) stores a database in two
> seperate files once created - .mdf and .ldf (data and
> transaction log files), my question is can I just replace
> these files with newer versions to bring the remote database
> schema up to date, or will I have to interact with the server
> and re-create my database every time ?

I don't think you can simply overwrite these files safely, as metadata for
the databases is stored in the master database. At least, that's how it
works in earlier versions. If you can shut down any database clients (like
CF) during the process, you can restore from a backup device file (that you
created on your development machine). This is pretty easy to do in SQL
Server 7 and is more practical than using Data Transformation Services for
most purposes.

> Have you used SQL Server ?  The enterprise manager looks an
> awful lot like a GUI to me :-)

SQL Server 7's GUI provides a lot more functionality than did previous
versions, although you could always build a database table-by-table in SQL
Enterprise Manager, even in earlier versions.

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.

Replacing Letters in a String

[Jonathan Karlen]

This is a multi-part message in MIME format.

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

Greetings -

I am developing a parts database for a client which is keyed by part =
number.  He wants to be able to search by first numeric sequence.  So, =
for example, a search for 123456 would return part numbers 12AB3456, =
1AB23456, 123AB456 and so on. =20

>From a SQL point of view what I'd imagine I need to generate is a string =
like "1%2%3%4%5%6%" to allow for characters between each number.

Does anyone have any suggestions of how I can generate this string based =
on user input?

Thanks.

Jonathan Karlen
**
Jonathan R. Karlen
Karlen Internet Solutions
[EMAIL PROTECTED]
www.karlen.com

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









Greetings -
 
I am developing a parts database for a client which =
is keyed=20
by part number.  He wants to be able to search by first numeric=20
sequence.  So, for example, a search for 123456 would return part =
numbers=20
12AB3456, 1AB23456, 123AB456 and so on.  
 
From a SQL point of view what I'd imagine I need to =
generate=20
is a string like "1%2%3%4%5%6%" to allow for characters between each=20
number.
 
Does anyone have any suggestions of how I can =
generate this=20
string based on user input?
 
Thanks.
 
Jonathan Karlen
**Jonathan R.=20
KarlenKarlen Internet Solutionsmailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]http://www.karlen.com">www.karlen.com

--=_NextPart_000_0056_01BFBEBE.CE241C80--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[Nick McClure]

>Correct, but different servers will do things differently, SQL server (so 
>far as I can see) stores a database in two seperate files once created - 
>.mdf and .ldf (data and transaction log files), my question is can I just 
>replace these files with newer versions to bring the remote database 
>schema up to date, or will I have to interact with the server and 
>re-create my database every time ?

I have done this before, it does work, But you have to be careful. All SQL 
Server services should be stopped, then you should replace the files, and 
start the services.

The DB I got it to work on was a small one with fairly static data.

In order to do it via CF I would remote stop the services using the netsvc 
command that comes with NT Server Resource Kit 4.0 (the file does work on 
2000). Then use cffile to move the file, then use the netsvc command again 
to start them.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Able Commerce

[[EMAIL PROTECTED]]

At 07:20 PM 5/15/2000 -0400, you wrote:
>Anyone use Able Commerce?
>
>if you do, tell me :-)

We have used it at

http://www.rivermyst.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: CF and the Palm VII

[Howie Hamlin]

Session params (cfid/cftoken) in the url should work...

Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com

Please vote for iMS in the Most Innovative category here:
*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***

Check out inFusion Mail Server - the world's most configurable email server

- Original Message -
From: Nick McClure <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 10:13 PM
Subject: CF and the Palm VII


> I am trying to password protect a site for use with the Palm VII, however
> the pqa stuff does not support cookies. Does anybody know of a better way
> with CF to protect a site?
>
>
>
> --
> Nick McClure [EMAIL PROTECTED]
> Technical Director 606.245.9656
> squareFish www.squareFish.com
>
> --

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

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

RE: CF and the Palm VII

[Bryan Batchelder]

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_01BFBEDE.00D33E70
Content-Type: text/plain;
charset="iso-8859-1"

Wow, I am working on something very similar.

A colleague developed a hack session system.  With Palm_Session table, he
just took the cfToken and cfId and threw them in a table with the unique
deviceid of the palmVII.

then on every page acces, he gets the cfToken and cfId with a query using
the deviceid and a small incrementing value passed in hidden form fields or
passed along the URL in the form of GET variables.

Not sure how secure that is, considering the entire pipe is encrypyed
through Palm.Net I am not too worriedmight take a closer look at it
later on.

If you have any further questions, email me.

--b



-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 10:14 PM
To: [EMAIL PROTECTED]
Subject: CF and the Palm VII


I am trying to password protect a site for use with the Palm VII, however 
the pqa stuff does not support cookies. Does anybody know of a better way 
with CF to protect a site?



--
Nick McClure [EMAIL PROTECTED]
Technical Director 606.245.9656
squareFish www.squareFish.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.

--_=_NextPart_001_01BFBEDE.00D33E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: CF and the Palm VII



Wow, I am working on something very similar.


A colleague developed a hack session system.  =
With Palm_Session table, he just took the cfToken and cfId and threw =
them in a table with the unique deviceid of the palmVII.

then on every page acces, he gets the cfToken and =
cfId with a query using the deviceid and a small incrementing value =
passed in hidden form fields or passed along the URL in the form of GET =
variables.

Not sure how secure that is, considering the entire =
pipe is encrypyed through Palm.Net I am not too worriedmight take a =
closer look at it later on.

If you have any further questions, email me.


--b




-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]<=
/FONT>
Sent: Monday, May 15, 2000 10:14 PM
To: [EMAIL PROTECTED]
Subject: CF and the Palm VII



I am trying to password protect a site for use with =
the Palm VII, however 
the pqa stuff does not support cookies. Does anybody =
know of a better way 
with CF to protect a site?




--
Nick McClure [EMAIL PROTECTED]
Technical Director 606.245.9656
squareFish www.squareFish.com


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



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

Zip Code FYI

[Computer Simplistics Suppoer]

There are some nifty tags in the dev exchange that use the USPS site to do a
zip to city lookup, fyi.

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Storing Credit Card details securely

[James Sleeman]

On Mon, 15 May 2000 12:32:14 +0100, Stewart McGowan <[EMAIL PROTECTED]> 
wrote:
> I think you're over complicating your business rules; if you store the
> credit card details why do u need to access them again at the client, don't
> u just charge the card for subsequent purchases automatically?

Also to Russ Michaels...

I think you misunderstand :-)  We don't need to present the details back to the user 
(as Russ says, I can just show them the last four digits or something), but if the 
card is to be charged again I need a way to securely store the full details, only for 
the administrators to see by supplying the private key perhaps.

Obviously they need to be stored on the server and I'm sure that the server is quite 
secure - but you can never be 100% sure of that and so some encryption will be needed 
to ensure that even if a no-good-nik gets access to the database itself that unless 
(s)he has quite a few years of computing time spare that the credit card details are 
going to be quite safe.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[James Sleeman]

On Tue, 16 May 2000 00:02:17 +0100, Russ Michaels <[EMAIL PROTECTED]> wrote:
>
> Your gonna be needing to do some reading up on database servers before you 
> embark on this methinks.

I am a BSc. with a CS major, one of my final courses was for the most part made up of 
studying SQL in Ingres, so I do know some things about database servers driven by SQL, 
and using them from commandline based tools.

> There is a big difference between an Access database file and SQL Server. A 
> database server does not have separate files like Access, the database are 
> self-contained within the server itself.

Correct, but different servers will do things differently, SQL server (so far as I can 
see) stores a database in two seperate files once created - .mdf and .ldf (data and 
transaction log files), my question is can I just replace these files with newer 
versions to bring the remote database schema up to date, or will I have to interact 
with the server and re-create my database every time ? 

> You do not have a GUI for making your databases like Access, you write 
> scripts that build them for you. Although there are a number of 3rd party 
> products that will connect to your database and allow you to build the 
> scripts visually. 

Have you used SQL Server ?  The enterprise manager looks an awful lot like a GUI to me 
:-)

> A database server really needs to be a completely separate machine rather 
> than installing SQL server on the same machine as your webserver. You can 
> setup different partitions and have a live server and a development server 
> if you are not able to have a SQL server locally.

It's not my problem where the server is - I don't even know if it is in this country, 
as I say we don't own our own servers,  I don't develop directly on the hosts servers 
but on my own workstation and then synchronize the two, partly this is so I can change 
things while the application is live and then just upload the changes once everything 
checks out and partly because our own net connection isn't the hottest of items 
sometimes :-(

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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 the Palm VII

[Nick McClure]

I am trying to password protect a site for use with the Palm VII, however 
the pqa stuff does not support cookies. Does anybody know of a better way 
with CF to protect a site?



--
Nick McClure [EMAIL PROTECTED]
Technical Director 606.245.9656
squareFish www.squareFish.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: and IIS

[Tom Rainey]

Is there a enterprise solution for standardizing file and variable case size
when moving from cf on nt to unix?

-Tom

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 6:55 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE:  and IIS


> Does anyone know of a way to have CF interact with IIS?
> Basically, what I am trying to do is make a CF app. that
> will set up the directories and paths and settings in IIS
> to get a web site up and going, 100% configured, without
> using the IIS management console. I'm sure there's a way to
> do it .. just not sure how to approach the problem.

You might want to look at the HTML interface that you can install with IIS.
It uses ADSI from ASP; ADSI is the interface you can use to do all this
nifty stuff. When you install IIS, in addition to the HTML management
interface, you'll get a bunch of WSH scripts to do different management
tasks.

The bad news is that you can't use CFOBJECT to work effectively with ADSI.
If you want to use ADSI from CF, you'll have to write wrappers in WSH or VB
or your compiler of choice. This isn't especially difficult, but it is
tedious.

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.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Setting up new site in IIS

[Bryan Laplante]

I have a similar situation, where I have to develop multiple web sites on
the same machine. I do like the last reply and set a mapping to the
alternate root so that the relative links will resolve correctly and then I
take an additional step as follows.

1. Go to C:\WINNT\system32\drivers\etc\hosts
When you edit the file you will see an entry for 127.0.0.1   localhost
2. Add an additional entry for 127.0.0.1:81 NewWebSiteName
3. Save file and use your Browser to access http://NewWebSiteName/ as the
address of the new site.
4. If you create a virtual map in CF administrator it should work.
5. Oh ya, don't forget to the start the new web site.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 8:49 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Setting up new site in IIS


> I'm trying to set up a new site within IIS. I've got it set
> up to use the same IP address, but a different port number (81)
> in this case. All works well until I get to a point where I'm
> trying to use CFINCLUDE to load a template (and this isn't a CF
> issue, but a general directory structure issue) - using a slash
> at the start of the address, to tell it "go to the root" will try
> and go to the root of the DEFAULT web site, and not the second
> site. I've still got ":81" in my URL, BTW.

If I understand you correctly, and you're doing something like this:



then it is a CF issue. The above CFINCLUDE, beginning with a slash, doesn't
mean that it will look at the document root of the virtual web server, as it
would with an IMG or A tag, but rather that it will look at the mappings in
the CF Administrator. Now, there can only be one "/" mapping in the CF
Administrator, so CF will always go to the same directory to get the file.

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.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Able Commerce

[Paul's Mail]

Yep,
I have 5 sites up with Able. Now installing their auction software.

Paul Burgess

> -Original Message-
> From: Jake Hileman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 16, 2000 12:21 AM
> To: [EMAIL PROTECTED]
> Subject: Able Commerce
>
>
> Anyone use Able Commerce?
>
> if you do, tell me :-)
>
> Jake
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Zip Convert

[Computer Simplistics Suppoer]

Thanks!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: "Joel Richards" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 6:46 PM
Subject: Re: Zip Convert


> --=_14808935==_.ALT
> Content-Type: text/plain; charset="us-ascii"
>
> JCSZIP is a really good Access 97 Database
> Web address is: http://www.jcsm.com/
> At 06:23 PM 5/15/00 -0700, you wrote:
> >Any access 97 databases that convert a zip code to a city?
> >
> >Scott Berry
> >--
> >Computer Simplistics Support
> >"Simple Solutions for a Complex World"
> >http://www.c-s.net
> >661-296-4315
> >
> >
> >
> >
>
>---
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
> Joel Richards
> Web Developer
> Brainstorm Industries
> [EMAIL PROTECTED]
> --=_14808935==_.ALT
> Content-Type: text/html; charset="us-ascii"
>
> 
> JCSZIP is a really good Access 97 Database
> Web address is:
> http://www.jcsm.com/" eudora="autourl">http://www.jcsm.com/
> At 06:23 PM 5/15/00 -0700, you wrote:
> >Any access 97 databases that convert a zip code to a city? 
> >
> >Scott Berry
> >--
> >Computer Simplistics Support
> >"Simple Solutions for a Complex World" 
> >http://www.c-s.net/"
eudora="autourl">http://www.c-s.net
> >661-296-4315
> >
> >
> >
> >
>
>
--
> >Archives:
> http://www.egroups.com/list/cf-talk"
eudora="autourl">http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit 
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk
> or 
> >send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in 
> >the body.
> 
>
> Joel Richards
> Web Developer
> Brainstorm Industries
> http://www.brainstormin.net/">[EMAIL PROTECTED]
>
> --=_14808935==_.ALT--
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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: and IIS

[Dave Watts]

> Does anyone know of a way to have CF interact with IIS?
> Basically, what I am trying to do is make a CF app. that
> will set up the directories and paths and settings in IIS
> to get a web site up and going, 100% configured, without
> using the IIS management console. I'm sure there's a way to
> do it .. just not sure how to approach the problem.

You might want to look at the HTML interface that you can install with IIS.
It uses ADSI from ASP; ADSI is the interface you can use to do all this
nifty stuff. When you install IIS, in addition to the HTML management
interface, you'll get a bunch of WSH scripts to do different management
tasks.

The bad news is that you can't use CFOBJECT to work effectively with ADSI.
If you want to use ADSI from CF, you'll have to write wrappers in WSH or VB
or your compiler of choice. This isn't especially difficult, but it is
tedious.

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: Setting up new site in IIS

[Dave Watts]

> I'm trying to set up a new site within IIS. I've got it set
> up to use the same IP address, but a different port number (81)
> in this case. All works well until I get to a point where I'm
> trying to use CFINCLUDE to load a template (and this isn't a CF
> issue, but a general directory structure issue) - using a slash
> at the start of the address, to tell it "go to the root" will try
> and go to the root of the DEFAULT web site, and not the second
> site. I've still got ":81" in my URL, BTW.

If I understand you correctly, and you're doing something like this:



then it is a CF issue. The above CFINCLUDE, beginning with a slash, doesn't
mean that it will look at the document root of the virtual web server, as it
would with an IMG or A tag, but rather that it will look at the mappings in
the CF Administrator. Now, there can only be one "/" mapping in the CF
Administrator, so CF will always go to the same directory to get the file.

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: Zip Convert

[Joel Richards]

--=_14808935==_.ALT
Content-Type: text/plain; charset="us-ascii"

JCSZIP is a really good Access 97 Database
Web address is: http://www.jcsm.com/
At 06:23 PM 5/15/00 -0700, you wrote:
>Any access 97 databases that convert a zip code to a city? 
>
>Scott Berry
>--
>Computer Simplistics Support
>"Simple Solutions for a Complex World" 
>http://www.c-s.net
>661-296-4315
>
>
>
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

Joel Richards
Web Developer
Brainstorm Industries
[EMAIL PROTECTED]
--=_14808935==_.ALT
Content-Type: text/html; charset="us-ascii"


JCSZIP is a really good Access 97 Database
Web address is:
http://www.jcsm.com/" eudora="autourl">http://www.jcsm.com/
At 06:23 PM 5/15/00 -0700, you wrote:
>Any access 97 databases that convert a zip code to a city? 
>
>Scott Berry
>--
>Computer Simplistics Support
>"Simple Solutions for a Complex World" 
>http://www.c-s.net/" eudora="autourl">http://www.c-s.net
>661-296-4315
>
>
>
>
>--
>Archives:
http://www.egroups.com/list/cf-talk" 
eudora="autourl">http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" 
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or 
>send a message to [EMAIL PROTECTED] with
'unsubscribe' in 
>the body.


Joel Richards
Web Developer
Brainstorm Industries
http://www.brainstormin.net/">[EMAIL PROTECTED]

--=_14808935==_.ALT--

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

Slightly OT: Stable door shuts

[Peter Tilbrook]

Microsoft, stung by criticism that its Outlook mail program helped the
spread of the Love Bug virus, said today it will offer two new security
features soon. An Outlook upgrade will prevent executable code from coming
attached to email, and a patch will alert users when an email attempts to
send itself via your address book. The new security software will be
available free from next Monday. See
http://www.microsoft.com/presspass/press/2000/May00/SecurityUpdatePR.asp

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

Zip Convert

[Computer Simplistics Suppoer]

Any access 97 databases that convert a zip code to a city? 

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World" 
http://www.c-s.net
661-296-4315




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Web registrars may take back your domain name

[Computer Simplistics Suppoer]

I can recommend bulkregister.com.

While they are a smaller place, they offer MUCH better pricing and have all
automated forms that WORK! I am registering domains at $15 a year right now
with them. Their service works great and is almost always up and working and
is very easy to use. It even stores information as default for registering
so that if you register a lot to one person, it is easy to just type in the
name and go.

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: "S.E.Fling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 5:56 PM
Subject: Re: Web registrars may take back your domain name


> I'm not surprised that Network Solutions is the bottleneck, it took me 2
months just to change my e-mail address. The automated solution didn't work
and whenever I tried to contact a
> live person, I kept getting referred back to the stupid forms. I finally
had to create a letter, and FAX it to them with ID and proof of address. I'm
going to transfer all of my
> domains away from them as soon as I figure out how it all works.
>
> sf
>
> Nick Baker wrote:
>
> > This article contains a very misleading error.
> >
> > "The Buyers' Guide explains that it's relatively easy to wave goodbye to
> > one registrar and transfer your domain name to another."
> >
> > Apparently, no one attempted to verify this with an actual transfer. I
have
> > been attempting to transfer a domain name from Bulkregister to Network
> > Solutions for over 2 months. At this point the problem has been with
> > Network Solutions. They have admitted that they do not, yet, have the
> > mechanism in place to handle these kinds of transfers.
> >
>
> --

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

Hahah More

[Computer Simplistics Suppoer]

Ok.. now that my weather is working =)

I need stock quotes and a search function:

Stock Quote: I just have yahoo opening in another window with the quote,
however, I would like to include the quote in the page. Any services that
provide this?

Search: Just a simple web search, yahoo is fine. It again opens in another
window, but I would like to include the results in my own page (sort of like
a cfinclude). Any help on this?

Can anyone tell I am working on a portal site? hahah

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315




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

RE: Slightly OT: Lighten things up a little

[Owens, Howard]

When ever I teach, my first night lecture ususally include a talk about this
career field and one of the things I always tell the students ... "When I
was a kid, I asked my mom about becoming a doctor. She said, 'Well, that's a
fine job and you can make lots of money, but you never really stop going to
school. (and I hated school). Doctors have to read all of the medical
journals and read medical books and never stop learning because medicine
changes so fast.  Well, that didn't sound too appealing to me, but guess
what happened when I became an adult ... I went into the Internet
development, where technology is constantly changing and you have to keep
learning to keep up and you have to read all the journals and learn, learn,
learn all of the time."

If you're not prepared to be a life-long learner, this is not a good career
choice.

H.

=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=

> -Original Message-
> From: Michael Kear [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 3:58 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: Slightly OT: Lighten things up a little
> 
> This will amuse some of you no doubt ... my 20 year old son dropped out of
> university.  He just wouldn't put in the work and the results reflected
> his effort.   He's got a job in a support department for a software
> company.
> 
> After he made the decision to drop out (only days before the decision was
> made for him I should add) he sat back in the couch and said "A. At
> last.  I'm finished with all that learning!"
> 
> HEhehe  . hate to have bad news for you kid, but your learning's only just
> started.
> 
> Seems to me the vast majority of people earning a living in Internet
> disciplines are doing things they never learned in university.  Technology
> is just moving far too fast for schools to keep up.
> 
> Similarly, if we let our own knowledge fall behind, we're dead ducks.
> 
> 
> Cheers,
> Mike Kear
> AFP Web Development
> Windsor, NSW, Australia
> 
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Web registrars may take back your domain name

[S.E.Fling]

I'm not surprised that Network Solutions is the bottleneck, it took me 2 months just 
to change my e-mail address. The automated solution didn't work and whenever I tried 
to contact a
live person, I kept getting referred back to the stupid forms. I finally had to create 
a letter, and FAX it to them with ID and proof of address. I'm going to transfer all 
of my
domains away from them as soon as I figure out how it all works.

sf

Nick Baker wrote:

> This article contains a very misleading error.
>
> "The Buyers' Guide explains that it's relatively easy to wave goodbye to
> one registrar and transfer your domain name to another."
>
> Apparently, no one attempted to verify this with an actual transfer. I have
> been attempting to transfer a domain name from Bulkregister to Network
> Solutions for over 2 months. At this point the problem has been with
> Network Solutions. They have admitted that they do not, yet, have the
> mechanism in place to handle these kinds of transfers.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Weather Revisited

[Scott Weikert]

I'll see if I can dig something up.

> -Original Message-
> From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 5:08 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Weather Revisited
> 
> 
> Any URL for that? I looked at their site but didn't find 
> anything but their
> "magnet".
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Database Structure Question

[Heather Haindel]

Assuming I understand correctly, you have two
entities...audience and event. Each event on your
calendar can be classified under one to many audience
(types). Each audience (type) can be a classification
for zero to many events. That gives you a many to many
relationship between audience and event.

In order to normalize this, you need an intersection
table. I would create these three tables:

audience - audience_id (PK), audiencename
event - event_id (PK), eventname, eventdescription
audience_event - audevent_id (PK), audience_id (FK),
event_id (FK)


--- Kurt Wiersma <[EMAIL PROTECTED]> wrote:
> 
> I have a database which is going to hold events for
> a calendar app. In it I
> have a table for audiences which has an audienceID
> and audience name. Inside
> the calendar table I have a field for audienceIDs
> where I was thinking of
> keeping a comma delimited list of audienceIDs.
> 
> The problem is I cannot join the two tables very
> easily in this format. I
> want the user to be able to check a checkbox for
> each audience they would
> like the event to be categorized under.
> 
> Can anyone suggest a better database structure or
> code that would allow the
> two tables to be joined under this structure? Please
> cc my email address in
> the reply as I am on the digest format right now!
> 
> Thanks for you help,
> 
> -- Kurt
> 
>
--
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


__
Do You Yahoo!?
Send instant messages & get email alerts 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: E-Commerce Packages

[S.E.Fling]

--052A94E1DB6B8F98381B982B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I had good luck with  -- http://twcreations.com

sf

Vance Duke wrote:

> A month or 2 ago, there was discussion regarding Able Commerce.  I am
> looking for some of the E-Commerce packages, that are ColdFusion based and
> are customizable, that were discussed in addition to Able Commerce.  I am
> putting together a presentation and would like several options.  I think I
> remember a package that was around $150 but can not remember what is was
> called.
>
> Thanks,
> Vance Duke
> Applications Developer
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--052A94E1DB6B8F98381B982B
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



I had good luck with  -- http://twcreations.com">http://twcreations.com
sf
Vance Duke wrote:
A month or 2 ago, there was discussion regarding
Able Commerce.  I am
looking for some of the E-Commerce packages, that are ColdFusion based
and
are customizable, that were discussed in addition to Able Commerce. 
I am
putting together a presentation and would like several options. 
I think I
remember a package that was around $150 but can not remember what is
was
called.
Thanks,
Vance Duke
Applications Developer
--
Archives: http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.


--052A94E1DB6B8F98381B982B--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Weather Revisited

[Computer Simplistics Suppoer]

Any URL for that? I looked at their site but didn't find anything but their
"magnet".

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: "Scott Weikert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 5:01 PM
Subject: RE: Weather Revisited


> Weather Channel has something fairly similar - subscribe to their service
(I
> dunno if it's pay or not - I didn't set up the relationship) and they'll,
a
> few times over the day, FTP you some comma-delimited text files, that you
> can parse and dump into DB tables to your heart's content... they'll give
> you all the graphics (sunny, cloudy, etc) also.
>
> --Scott
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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: Weather Revisited

[Computer Simplistics Suppoer]

Well, I could always setup a download for the graphic and other info to save
them locally if I want, but in this case their server is so DAMN fast, that
I have no problems displaying instant data.

Thanks!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 4:38 PM
Subject: RE: Weather Revisited


> I thought you'd like that!  It won't help you get data into a database to
> build your own tools, but it makes for a great free weather service.
>
> We use it in our AvantGo Palm/Windows CE channel and a few other areas.
>
> --Doug
>
> -Original Message-
> From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 3:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Weather Revisited
>
>
> OH DANG!! Kick butt!! That is what we have all been looking for!!
>
> http://weatherguys.com/downloadweather.asp
>
> THANKS!
>
> Scott Berry
> --
> Computer Simplistics Support
> "Simple Solutions for a Complex World"
> http://www.c-s.net
> 661-296-4315
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, May 15, 2000 2:25 PM
> Subject: RE: Weather Revisited
>
>
> > Check out www.weatherguys.com for some free weather tools.
> >
> > -Original Message-
> > From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 15, 2000 11:58 AM
> > To: [EMAIL PROTECTED]
> > Subject: Weather Revisited
> >
> >
> > Ok.. so what I setup was the script to grab weather using cfschedule oh,
> > every 15 minutes and store it in a database. Then I just grab the
database
> > value on the page.
> >
> > Is there a less computer intensive way to do this? I hate to do a query
> each
> > time the page loads just for the temperature =). Can I cache it
somewhere?
> >
> > Scott Berry
> > --
> > Computer Simplistics Support
> > "Simple Solutions for a Complex World"
> > http://www.c-s.net
> > 661-296-4315
> >
> >
> >
> >
>
> --
> --
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > 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: Member database with access levels -=- CF4.0.1+Access97

[Computer Simplistics Suppoer]

When do the session variables end?

The great thing about the cookies is that if the user comes back a few days
later.. viola! he can be automatically logged in.

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315

- Original Message -
From: "Sharon DiOrio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 4:08 PM
Subject: Re: Member database with access levels -=- CF4.0.1+Access97


> Cookies are the answer yes.  But even more than that, CF has the ability
to
> maintain sessions for a user automatically (so that you don't have to
> manage the cookies, etc.)
>
> In your application.cfm file, put the following:
>
> 
>  clientmanagement="no">
> 
> 
> 
>
> Then in your login action page, you do something like this:
>
> 
> SELECT FirstName, LastName, UserLevel
> FROM Users
> WHERE UserName = '#FORM.UserName#'
> AND Password = '#FORM.Password#'
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> Now that you've enabled and set SESSION variables, they will be available
> to you anywhere in the site.
>
> For example.
>
> 
> 
> Button
> 
>
> HTH!
>
> Sharon
>
>
> At 05:49 PM 5/15/2000 -0400, Tiffany wrote:
> >Hi, I'm 18 years old and have been working with CF for a few months now.
> >I have read books, articles, etc and have learned enough on my own to use
> >CF with Access 97 to make simple DB's -- adding, updating, deleting
> >records, setting variables, using CFMail, etc. You know, the easy stuff.
> >I think it's really cool, I love ColdFusion!
> >
> >My next project is to create a database of members with access levels. I
> >have fields like:
> >
> >MemberName
> >Password
> >MemberSince
> >AccessLevel
> >
> >I'm trying to figure out how to use session variables and cookies and
> >stuff to log a user into a section of a website that will display certain
> >options (links basically) depending on their access level (levels are
> >like 1 to 5).  However, the only part I have done is checking their
> >username and password against the database and sending them to a page
> >once they have successfully logged in. The thing is, how do you make it
> >so someone cant just copy the URL they were sent to when they logged in
> >and paste in a browser window and have it pop up?  Cookies right?
> >
> >What I am looking for is someone to point me in the direction or to a
> >resource that could explain how some of this works (coding wise).. any
> >suggestions.. anything will help.
> >
> >Thanks!!  :)
> >
> >*~Tiffany~*
> >
> >
>
>---
> ---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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: Weather Revisited

[Scott Weikert]

Weather Channel has something fairly similar - subscribe to their service (I
dunno if it's pay or not - I didn't set up the relationship) and they'll, a
few times over the day, FTP you some comma-delimited text files, that you
can parse and dump into DB tables to your heart's content... they'll give
you all the graphics (sunny, cloudy, etc) also.

--Scott

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

Re: Slightly OT: Lighten things up a little

[Seth Petry-Johnson]

Umm... you guys think you could move this thread to CF-Community?  I really
didn't want to be the one to complain about this, but this is REALLY, REALLY
off topic.  The *original* post to this thread was OT, and the actual
subject of the thread has changed at least 4 times, taking it more OT each
time .

Thanks,
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: Member database with access levels -=- CF4.0.1+Access97

[Justin MacCarthy]

Hi Tiffany,

What you need to do is check that the user is logged in on each page you
want to secure. One way to do this is the application.cfm to check if the
user is checked in 

 






    goto login page!



This will check to see if the user is logged in when any page in the
application directory is called...

Another way is to create a file to include just at the top of pages you
want to secure..
 asecurepage.cfm ###



a secure page 

## isSecure.cfm #





##  login.cfm   #









So if someone goes to www.yoursite.com/asecurepage.cfm, the IsSecure.cfm
template will look for the cfid & cftoken, to figure out what user this is;
if they are logged in (and haven't timed out) they can view the page
otherwise they are directed to logon.cfm

As far as cookies are concerned you can choose to use them or not, but if
you don't you have to pass Session.UrlToken (which contains cfid & cftoken)
from Page to page via the URL to keep state..otherwise the cfid & cftoken
are set as cookies

Hope that helps :-)

~ Justin MacCarthy
~ Irish CF Head 

you said>
>username and password against the database and sending them to a page
>once they have successfully logged in. The thing is, how do you make it
>so someone cant just copy the URL they were sent to when they logged in
>and paste in a browser window and have it pop up?  Cookies right?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Weather Revisited

[dougn]

I thought you'd like that!  It won't help you get data into a database to
build your own tools, but it makes for a great free weather service.

We use it in our AvantGo Palm/Windows CE channel and a few other areas.

--Doug

-Original Message-
From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 3:16 PM
To: [EMAIL PROTECTED]
Subject: Re: Weather Revisited


OH DANG!! Kick butt!! That is what we have all been looking for!!

http://weatherguys.com/downloadweather.asp

THANKS!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 2:25 PM
Subject: RE: Weather Revisited


> Check out www.weatherguys.com for some free weather tools.
>
> -Original Message-
> From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 11:58 AM
> To: [EMAIL PROTECTED]
> Subject: Weather Revisited
>
>
> Ok.. so what I setup was the script to grab weather using cfschedule oh,
> every 15 minutes and store it in a database. Then I just grab the database
> value on the page.
>
> Is there a less computer intensive way to do this? I hate to do a query
each
> time the page loads just for the temperature =). Can I cache it somewhere?
>
> Scott Berry
> --
> Computer Simplistics Support
> "Simple Solutions for a Complex World"
> http://www.c-s.net
> 661-296-4315
>
>
>
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Searching with one form field

[John Allred]

Nick,

Thanks a bunch. I figured there was a technique like this, but I just
couldn't find it. As it turned out, I figured another route to the same
thing. Who is it who's famed for saying, "On the other hand, you could
try..."? Dave?

I simply added:

OR
lcase(FN + ' ' + LN) LIKE '%#lcase(SearchText)#%'

to the WHERE clause of my query. 

Thanks for the help. I'll hang on to this one for future reference.

--John


Nick Slay wrote:
> 
> Hi John,
> 
> You can split out the words from the entry field using lists, for example:
> 
> 
>  
>  
> 
>  
> 
> 
> Nick
> 
> At 14:02 15/05/00 -0500, you wrote:
> >I have a field, (Person), in a form which will search according to the
> >following criteria:
> >
> >WHERE   
> > lcase(FN) LIKE '%#lcase(Person)#%' OR
> > lcase(LN) LIKE '%#lcase(Person)#%' OR
> > lcase(Real_Name) LIKE '%#lcase(Person)#%'
> > 
> >
> >I don't have the first and last names combined anywhere in my database,
> >and unless I have users enter names in separate first and last name
> >entry fields (which I'd rather not do), they WILL put both names in the
> >search field. This, of course, won't work.
> >
> >I've RTFM, but I can't figure how to either split out the words in the
> >entry field, or combine two of my database fields within the WHERE
> >clause of my query.
> >
> >Has anyone done something like this? Any help appreciated.
> >
> >--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.

-- 
John Allred / Jackson, Mississippi
Webmaster, Mississippi Counties
http://www.mscounties.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: Access Date/Time Function, problem solved!

[ldang {Lily Dang}]

Thank you all for your help, I got it to work, I used
#CreateODBCDate(1/1/00)#

Kelly was right, Access doesn't like single quotes around dates.

Thanks, 
Lily
-Original Message-
From: William Adamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 4:16 PM
To: [EMAIL PROTECTED]
Subject: RE: Access Date/Time Function


It looks like Access thinks they're integers and is trying to
divide 1 by zero indicating that they're not actually a date type(?)
You might try the IsDate() function to verify that you have a data
type of type date and then force it to date using CreateODBCDate().

#DateDiff("d", "#CreateODBCDate('1/1/00')#',
'#CreateODBCDate('12/1/00')#')#



-Original Message-
From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 1:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Access Date/Time Function


Hi All,

I am using Access 2000.  When I try to do search for the date range say,
from '1/1/00' to '12/1/00'.  Access gives me an error saying that it's not
divisible by 00.  Any help would be greatly appreciated.

Thanks,
Lily


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

Able Commerce

[Jake Hileman]

Anyone use Able Commerce?

if you do, tell me :-)

Jake

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

Re: Slightly OT: Lighten things up a little

[Jake Hileman]

word, that's what i'm saying... school can NOT keep up. half the professors
there got their degrees in the early 80s and late 70s... bleh.. please mr.
professor have a seat, lemme show ya a lil' sumtin sumtin.. :-)

as you can tell, i'm young, i'm 18, own my own hosting company and finished
my first year of college this year.. and guess what... it's my last too.

learning cf now... cf rocks... but it uses too much mem.. hahaha

thanks guys, rock on.

jake
- Original Message -
From: "Michael Kear" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 6:57 PM
Subject: RE: Slightly OT: Lighten things up a little


> This will amuse some of you no doubt ... my 20 year old son dropped out of
> university.  He just wouldn't put in the work and the results reflected
> his effort.   He's got a job in a support department for a software
> company.
>
> After he made the decision to drop out (only days before the decision was
> made for him I should add) he sat back in the couch and said "A. At
> last.  I'm finished with all that learning!"
>
> HEhehe  . hate to have bad news for you kid, but your learning's only just
> started.
>
> Seems to me the vast majority of people earning a living in Internet
> disciplines are doing things they never learned in university.  Technology
> is just moving far too fast for schools to keep up.
>
> Similarly, if we let our own knowledge fall behind, we're dead ducks.
>
>
> Cheers,
> Mike Kear
> AFP Web Development
> Windsor, NSW, Australia
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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 Web Store

[Jake Hileman]

If anyone here is or has used CF web store, please email me.. :-)

thanks guys,

[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: and IIS

[Jake Hileman]

Yeah there is a way and I just set that up actually.  But you can't do it in
CF, must be done in ASP.  :-(  There is a way to do it with WSH but it's a
big security risk.

email me for more info.. I should probably sell what I wrote.. a lot of
people seem to want something like it.  :-)

Jake
- Original Message -
From: "Todd Ashworth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 5:26 PM
Subject:  and IIS


> Does anyone know of a way to have CF interact with IIS?  Basically, what I
> am trying to do is make a CF app. that will set up the directories and
paths
> and settings in IIS to get a web site up and going, 100% configured,
without
> using the IIS management console.  I'm sure there's a way to do it .. just
> not sure how to approach the problem.
>
> .Todd
>
>
>
> --

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: JS - Controlling Form Dropdown Boxes:

[Peter Tilbrook]

Hmmm. They might have something at the JavaScript source (an excellent site)
at:

http://www.javascriptsource.com

Cheers!


-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 16 May 2000 2:23 AM
To: [EMAIL PROTECTED]
Subject: OT: JS - Controlling Form Dropdown Boxes:


This one's for the JS Guru's;

If I have, x number of elements in a dropdown box that allows multiple
choices, can I lock out, say, elements 6 & 7 if they choose
#1, or lock out 9 & 10 if they pick #2?  Can you do something like that?

Thanks,
Dave


=
"Always Drink Upstream From The Herd!"

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





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

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

Re: Member database with access levels -=- CF4.0.1+Access97

[Sharon DiOrio]

Cookies are the answer yes.  But even more than that, CF has the ability to
maintain sessions for a user automatically (so that you don't have to
manage the cookies, etc.)

In your application.cfm file, put the following:







Then in your login action page, you do something like this:


SELECT FirstName, LastName, UserLevel
FROM Users
WHERE UserName = '#FORM.UserName#'
AND Password = '#FORM.Password#'











Now that you've enabled and set SESSION variables, they will be available
to you anywhere in the site.

For example.



Button


HTH!

Sharon


At 05:49 PM 5/15/2000 -0400, Tiffany wrote:
>Hi, I'm 18 years old and have been working with CF for a few months now.
>I have read books, articles, etc and have learned enough on my own to use
>CF with Access 97 to make simple DB's -- adding, updating, deleting
>records, setting variables, using CFMail, etc. You know, the easy stuff.
>I think it's really cool, I love ColdFusion!
>
>My next project is to create a database of members with access levels. I
>have fields like:
>
>MemberName
>Password
>MemberSince
>AccessLevel
>
>I'm trying to figure out how to use session variables and cookies and
>stuff to log a user into a section of a website that will display certain
>options (links basically) depending on their access level (levels are
>like 1 to 5).  However, the only part I have done is checking their
>username and password against the database and sending them to a page
>once they have successfully logged in. The thing is, how do you make it
>so someone cant just copy the URL they were sent to when they logged in
>and paste in a browser window and have it pop up?  Cookies right?
>
>What I am looking for is someone to point me in the direction or to a
>resource that could explain how some of this works (coding wise).. any
>suggestions.. anything will help.
>
>Thanks!!  :)
>
>*~Tiffany~*
>
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
> 

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Uploading SQL Server databases

[Russ Michaels]

Your gonna be needing to do some reading up on database servers before you 
embark on this methinks.
There is a big difference between an Access database file and SQL Server. A 
database server does not have separate files like Access, the database are 
self-contained within the server itself.
You do not have a GUI for making your databases like Access, you write 
scripts that build them for you. Although there are a number of 3rd party 
products that will connect to your database and allow you to build the 
scripts visually. Such as SQL Programmer, Sybase Central or Toad for Oracle.
A database server really needs to be a completely separate machine rather 
than installing SQL server on the same machine as your webserver. You can 
setup different partitions and have a live server and a development server 
if you are not able to have a SQL server locally.


  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.

Re: Advice on approach

[Russ Michaels]

Just add another column into your database called APPROVED.
When you insert submissions into the database just set this flag as true 
and do not display any entries that have this flag set as true.
When you validate them, just set the flag to zero so that the records are 
shown.



  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.

RE: Slightly OT: Lighten things up a little

[Michael Kear]

This will amuse some of you no doubt ... my 20 year old son dropped out of
university.  He just wouldn't put in the work and the results reflected
his effort.   He's got a job in a support department for a software
company.

After he made the decision to drop out (only days before the decision was
made for him I should add) he sat back in the couch and said "A. At
last.  I'm finished with all that learning!"

HEhehe  . hate to have bad news for you kid, but your learning's only just
started.

Seems to me the vast majority of people earning a living in Internet
disciplines are doing things they never learned in university.  Technology
is just moving far too fast for schools to keep up.

Similarly, if we let our own knowledge fall behind, we're dead ducks.


Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Member database with access levels -=- CF4.0.1+Access97

[Chris Giminez]

Have a one folder for login. Enable session variables in the application.cfm file
Have another folder for protected templates. Again, enable session variables in the 
application.cfm
file.

When the user successfully logs in, set a session variable to their access level.
Now, in the protected folder - application.cfm, check for the existence of the 
session.accesslevel
variable. If it doesn't exist, cflocation back to the login page
If it does exist, process the users queries or location based on their level of access.
If they try to change url variables without the correct session variable set, you can 
reject their
request.
If they try to go straight into a protected area without login in first, they'll be 
redirected to
the login page.

Chris




> Hi, I'm 18 years old and have been working with CF for a few months now.
> I have read books, articles, etc and have learned enough on my own to use
> CF with Access 97 to make simple DB's -- adding, updating, deleting
> records, setting variables, using CFMail, etc. You know, the easy stuff.
> I think it's really cool, I love ColdFusion!
>
> My next project is to create a database of members with access levels. I
> have fields like:
>
> MemberName
> Password
> MemberSince
> AccessLevel
>
> I'm trying to figure out how to use session variables and cookies and
> stuff to log a user into a section of a website that will display certain
> options (links basically) depending on their access level (levels are
> like 1 to 5).  However, the only part I have done is checking their
> username and password against the database and sending them to a page
> once they have successfully logged in. The thing is, how do you make it
> so someone cant just copy the URL they were sent to when they logged in
> and paste in a browser window and have it pop up?  Cookies right?
>
> What I am looking for is someone to point me in the direction or to a
> resource that could explain how some of this works (coding wise).. any
> suggestions.. anything will help.

>
> Thanks!!  :)
>
> *~Tiffany~*
>
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>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: Oracle 8.0 help

[Troy Johnson]

use the "output" parameter in the  tag.

-Original Message-
From: David Pierce [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 3:14 PM
To: [EMAIL PROTECTED]
Subject: Oracle 8.0 help


Has anyone found out how to return a result set from an Oracle stored Proc?
Any help you could provide would be great. Thanks..


David Pierce
Sharpsource
(925) 240-8515 EX:114
[EMAIL PROTECTED]
1240 Central Blvd., Suite A
Brentwood, CA 94513
www.sharpsource.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.

Setting up new site in IIS

[Scott Weikert]

Hey gang -

I'm trying to set up a new site within IIS. I've got it set up to use the
same IP address, but a different port number (81) in this case. All works
well until I get to a point where I'm trying to use CFINCLUDE to load a
template (and this isn't a CF issue, but a general directory structure
issue) - using a slash at the start of the address, to tell it "go to the
root" will try and go to the root of the DEFAULT web site, and not the
second site. I've still got ":81" in my URL, BTW.

Any IIS jockeys out there who can point me in the right direction? Drop me a
line off the list, if you would - conserve bandwidth! :)

--Scott
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: calling a custom tag from another custom tag?

[Russ Michaels]

There is no problem doing this, you can happily nest custom tags inside 
each other.




  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.

Re: Storing Credit Card details securely

[Russ Michaels]

You seem to be making things more complicated for yourself.
You do not need to send creditcard details back to clients for the world to 
see, you just store them on a database server that cannot be accessed from 
the web, I.E it is locally networked to the webserver.
The most you would need to do when someone re-orders is to send back the 
last 4 digits of their card for confirmation that they wish to use the same 
card.




  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.

Oracle 8.0 help

[David Pierce]

Has anyone found out how to return a result set from an Oracle stored Proc?
Any help you could provide would be great. Thanks..


David Pierce
Sharpsource
(925) 240-8515 EX:114
[EMAIL PROTECTED]
1240 Central Blvd., Suite A
Brentwood, CA 94513
www.sharpsource.com



--
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: Weather Revisited

[Computer Simplistics Suppoer]

OH DANG!! Kick butt!! That is what we have all been looking for!!

http://weatherguys.com/downloadweather.asp

THANKS!

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 2:25 PM
Subject: RE: Weather Revisited


> Check out www.weatherguys.com for some free weather tools.
>
> -Original Message-
> From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 11:58 AM
> To: [EMAIL PROTECTED]
> Subject: Weather Revisited
>
>
> Ok.. so what I setup was the script to grab weather using cfschedule oh,
> every 15 minutes and store it in a database. Then I just grab the database
> value on the page.
>
> Is there a less computer intensive way to do this? I hate to do a query
each
> time the page loads just for the temperature =). Can I cache it somewhere?
>
> Scott Berry
> --
> Computer Simplistics Support
> "Simple Solutions for a Complex World"
> http://www.c-s.net
> 661-296-4315
>
>
>
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Searching with one form field

[Nick Slay]

Hi John,

You can split out the words from the entry field using lists, for example:


 
 

 



Nick


At 14:02 15/05/00 -0500, you wrote:
>I have a field, (Person), in a form which will search according to the
>following criteria:
>
>WHERE   
> lcase(FN) LIKE '%#lcase(Person)#%' OR
> lcase(LN) LIKE '%#lcase(Person)#%' OR
> lcase(Real_Name) LIKE '%#lcase(Person)#%'
> 
>
>I don't have the first and last names combined anywhere in my database,
>and unless I have users enter names in separate first and last name
>entry fields (which I'd rather not do), they WILL put both names in the
>search field. This, of course, won't work.
>
>I've RTFM, but I can't figure how to either split out the words in the
>entry field, or combine two of my database fields within the WHERE
>clause of my query.
>
>Has anyone done something like this? Any help appreciated.
>
>--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: Member database with access levels -=- CF4.0.1+Access97

[Computer Simplistics Suppoer]

The basic idea I use on my pages works like this:

Main Page (log in, which transfers to "member's area" page)

Member's Area (set cookie with username & access level, etc / also check for
existence of cookies and then you know they have them and what resources
they have access to / if no cookie, send them back to the login page)
Then any queries you want to do later on, you just pull their member name
from the cookie. Also, you use CFIF to give the options on the access
levels.. so:


Level 5 information

Level one info

Etc.

On any page that you need to be logged in to see, you simply throw the
script at the top of the page to check for the cookie. If no cookie, abort
and pop them back to the login page. Same goes for access. If a page should
only be accessed by level 5 users, throw a script at the top to check their
level, and if not five abort and throw them back to the last page they came
from or the main page.

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: "Tiffany" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 2:49 PM
Subject: Member database with access levels -=- CF4.0.1+Access97


> Hi, I'm 18 years old and have been working with CF for a few months now.
> I have read books, articles, etc and have learned enough on my own to use
> CF with Access 97 to make simple DB's -- adding, updating, deleting
> records, setting variables, using CFMail, etc. You know, the easy stuff.
> I think it's really cool, I love ColdFusion!
>
> My next project is to create a database of members with access levels. I
> have fields like:
>
> MemberName
> Password
> MemberSince
> AccessLevel
>
> I'm trying to figure out how to use session variables and cookies and
> stuff to log a user into a section of a website that will display certain
> options (links basically) depending on their access level (levels are
> like 1 to 5).  However, the only part I have done is checking their
> username and password against the database and sending them to a page
> once they have successfully logged in. The thing is, how do you make it
> so someone cant just copy the URL they were sent to when they logged in
> and paste in a browser window and have it pop up?  Cookies right?
>
> What I am looking for is someone to point me in the direction or to a
> resource that could explain how some of this works (coding wise).. any
> suggestions.. anything will help.
>
> Thanks!!  :)
>
> *~Tiffany~*
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
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: Advice on approach

[Nick Slay]

Hi John,

I don't think you'd notice any performance penalties at all.   In each of 
your four templates that list out the links simply edit your CFQUERY tag 
that get's the links from the database, and add WHERE StatusFlag = 1.  On 
the search page, add the same WHERE StatusFlag = 1 to the search 
query.  They're the only changes that you'll need to make on the 'live' side.

Nick



At 09:02 15/05/00 -0500, you wrote:
>Thanks, Nick.
>
>This makes sense, as it's probably simpler than trying to maintain two
>sets of tables. However, there may be a downside: I have five templates,
>plus a search form that look at these links. Four of them list all of
>the links in various ways. For each, I would have to add the display
>flag. Given that the number of links is likely to climb to nearly 10,000
>at some point, do you think there would be a performance penalty?
>
>Thanks so much for the opinion.
>
>--John
>
>Nick Slay wrote:
> >
> > Hi John,
> >
> > Personally, I'd have a StatusFlag on my Link Table.   Let people submit
> > links directly to the Links table and set the StatusFlag to 0,
> > (Pending).  Create yourself a password protected admin script that let's
> > you update the StatusFlag, then once the Links have been approved, set the
> > StatusFlag to 1 (Ok).   The page on your site that lists the links then
> > only needs to query the records that have a StatusFlag = 1.
> >
> > HTHAL
> >
> > Nick
> >
> > At 06:42 15/05/00 -0500, you wrote:
> > >I accept submissions for links to be listed on one of my sites.
> > >Originally, this was merely by E-mail. Then I set up a form, so I could
> > >get as many fields filled in as possible and save some research time.
> > >The form generated an E-mail to me and the sender.
> > >
> > >Now, I'd like to have submitters enter the info directly in my database.
> > >Should I let them enter it in my main tables, or should I create
> > >separate tables and, once I approve the submissions, copy them to the
> > >main tables?
> > >
> > >If I do it the first way, I'd need to set up a flag to allow display,
> > >once I've approved the submission. Any thoughts on the best way to do
> > >this?
> > >
> > >TIA,
> > >--John Allred
> > >
> > >
> > >--
> > >John Allred / Jackson, Mississippi
> > >Webmaster, Mississippi Counties
> > >http://www.mscounties.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.
>
>--
>John Allred / Jackson, Mississippi
>Webmaster, Mississippi Counties
>http://www.mscounties.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.

Cfhttp behind firewall???

[joeug]

Hello all,
  I am having trouble using CFHTTP to connect outside
the firewall, i have specified  all the specifiations need proxyserver,
port etc and CF gives me back an error "Connection Failure" has
anyone had similar problems? We are using CF4.5.1
My code looks like

http://www.yahoo.com" Method="Get" proxyserver=""
resolveurl="Yes">



#Cfhttp.filecontent#

and this gives me "Connection Failure".

Appretiate it.
Thanks
Joe

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



-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Able Commerce Help

[Russell, Bonnie]

yes, I've followed their directions in the system administrators
documentation, and that's how my troubles began.

I need to have a complete copy of the program files since we'll be modifying
them slightly for one customer.  When we bought this package, that was one
of the requirements and we have the developers edition.

I've been all through their site and read most of their documentation.  I
have to admit, I'm the first at our company to actually use the able
commerce, but as long as I don't change any mappings, there hasen't been any
problems.

This was supposed to be a 3 day project which is now going on 3 weeks and
the customer is not happy and I'm getting to the point where ulcers look
like welcome relief compared to the stress they're putting us under.

Is there a particular FAQ that you're referring to?

Thanks for the info
Bonnie



-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 5:16 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Able Commerce Help


You just need to have unique wizards or are you trying to dulicate the whole
package?  Have you checked out the extensive faq's on customization at the
able website?

Emmet McGovern
developer/ Byte Size Inc

-Original Message-
From: Russell, Bonnie [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 2:58 PM
To: '[EMAIL PROTECTED]'
Subject: Able Commerce Help


Has anyone had experience using able commerce and customizing for a
particular customer.  What I need is to have a separate directory for
program files for one customer while using the original able commerce
program files for everyone else.  Everytime I follow the directions to copy
the files and change the mapping for my one store, all the stores stop
working.  I've been on the phone with able commerce, and so far they've
given me nothing but the brush off.

So how do you set up a store with it's own program files?

Bonnie Russell
[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: Cisco Local Director/CF and Winnt

[Nick McClure]

I would like to see this as well.

At 04:32 PM 5/15/2000 -0400, you wrote:
>Lincoln,
>
>How about asking the questions publicly?
>
>We are going to be looking at implementing a balancing solution (most
>probably the Local Director) and would appreciate seeing what
>issues/questions you have and the responses you get.
>
>
>Sean
>
>P.S.Isn't a list-server/newsgroup to allow the community to benefit
>from each other knowledge/experience?
>
>  -Original Message-
>From:   Lincoln Manning [mailto:[EMAIL PROTECTED]]
>Sent:   Monday, May 15, 2000 3:43 PM
>To: [EMAIL PROTECTED]
>Subject:Cisco Local Director/CF and Winnt
>
>Is someone available off list to answer a couple of questions?
>
>--
>Lincoln Manning
>Web Application Developer
>Applied Virtual Vision
>[EMAIL PROTECTED]
>http://www.avv.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.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  606.245.9656
squareFish Mediawww.squareFish.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.

Database Structure Question

[Kurt Wiersma]

I have a database which is going to hold events for a calendar app. In it I
have a table for audiences which has an audienceID and audience name. Inside
the calendar table I have a field for audienceIDs where I was thinking of
keeping a comma delimited list of audienceIDs.

The problem is I cannot join the two tables very easily in this format. I
want the user to be able to check a checkbox for each audience they would
like the event to be categorized under.

Can anyone suggest a better database structure or code that would allow the
two tables to be joined under this structure? Please cc my email address in
the reply as I am on the digest format right now!

Thanks for you help,

-- Kurt

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Boolean fields in Foxpro

[Bill Grover]

Michael,

Not a problem getting back.  I have never tried to do a pack via ODBC.
Pack is a native FoxPro command and as such I don't believe you can do it
from the ODBC driver.

It sounds like in order to physically remove the records you will need to
write a FoxPro program that will pack the database for you.  BTW, to do a
pack you will need exclusive use of the table(s).  So part of this process
will be to insure that everyone is out of the database before doing the
pack, or it will fail.

Are you having problems when the records are deleted having them retrieved?
 The way we deal with this is to have a field in the record that marks the
record as "deleted" without relying on FoxPro's deleted flag.  Usually we
use a DateTime field like tablename_deleted_datetime.  The default value of
this field is NULL and when we want to delete the record we store the
current datetime in the field.  Then when we select records we add 'AND
ISNULL(table_deleted_datetime)' to the where clause to filter these
records.  Make sure to set an index on the table for this field so your
query is Rushmore Optimizable.

FYI, if it appears that my responses are a bit slow I appologize.  I'm on
vacation from 5/15 until 5/30 but, as you can tell, I do check my E-Mail
once a day.  Also I only get the digest version so depending on when the
CF-Talk is delivered and I check mail will dictate when I reply.

Talk to you soon.

Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850

Phone:  301-424-3300 x396
FAX:301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]

 Original Message 
Date: Mon, 15 May 2000 15:51:53 +0100
From: Michael O Reilly <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
Message-ID: 

Bill,

Apologies for not replying. The ISDN link for web and e-mail died on
Thursday and didn't come back until today.
After removing the Boolean field from the table, I discovered that the
numeric field I assumed was working correctly had been causing my problem
all along.
I am now able to add, modify and delete records using SQL.
I now have another problem. In Foxpro, records are marked for deletion. They
are only actually deleted when a PACK command is issued.
SQL delete command's only mark the record deleted. 
I want to schedule a .cfm which will pack all the tables once a week.

Do you know anything about sending 'PACK' command to Foxpro within SQL.
I'm sure this problem would affect all Xbase derived databases.

Regards
Michael O'Reilly
Analyst Programmer
TransAer


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

Member database with access levels -=- CF4.0.1+Access97

[Tiffany]

Hi, I'm 18 years old and have been working with CF for a few months now.
I have read books, articles, etc and have learned enough on my own to use
CF with Access 97 to make simple DB's -- adding, updating, deleting
records, setting variables, using CFMail, etc. You know, the easy stuff.
I think it's really cool, I love ColdFusion!

My next project is to create a database of members with access levels. I
have fields like:

MemberName
Password
MemberSince
AccessLevel

I'm trying to figure out how to use session variables and cookies and
stuff to log a user into a section of a website that will display certain
options (links basically) depending on their access level (levels are
like 1 to 5).  However, the only part I have done is checking their
username and password against the database and sending them to a page
once they have successfully logged in. The thing is, how do you make it
so someone cant just copy the URL they were sent to when they logged in
and paste in a browser window and have it pop up?  Cookies right?

What I am looking for is someone to point me in the direction or to a
resource that could explain how some of this works (coding wise).. any
suggestions.. anything will help.

Thanks!!  :)

*~Tiffany~*


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Access Date/Time Function

[Kelly Matthews]

Are you putting single quotes around the dates in the WHERE CLAUSE?
If so try removing them it shouldnt need quotes I have run into this before.
Kelly


> -Original Message-
> From: Marcus [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 5:04 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: Access Date/Time Function
> 
> > I am using Access 2000.  When I try to do search for the date range say,
> > from '1/1/00' to '12/1/00'.  Access gives me an error saying that it's
> not
> > divisible by 00.  Any help would be greatly appreciated.
> 
> thats because the computer is trying to do the math you have put in front
> of
> it.
> 
> 1/1/00 is 1 divided by 1 divided by 00... can't divide by 0 so it errors.
> 
> Marcus
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Weather Revisited

[dougn]

Check out www.weatherguys.com for some free weather tools.

-Original Message-
From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 11:58 AM
To: [EMAIL PROTECTED]
Subject: Weather Revisited


Ok.. so what I setup was the script to grab weather using cfschedule oh,
every 15 minutes and store it in a database. Then I just grab the database
value on the page.

Is there a less computer intensive way to do this? I hate to do a query each
time the page loads just for the temperature =). Can I cache it somewhere?

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
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: Weather Revisited

[Jennifer]

We get our weather through an ftp function. As I've said, someone actually 
pays for this service from AccuWeather. Basically, they have ftp servers 
with generated content for the area specified by the customer. We ftp in, 
grab the file in our folder, parse it, and create a text file for inclusion.

At 06:41 AM 5/16/00 +1000, you wrote:
>the idea of having a dynamic weather message is fantastic my question is
>where do you source the wether information from as in from what part of a
>weather based information website ?
>- Original Message -
>From: Top-Link Tech (John Ceci) <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, May 16, 2000 6:38 AM
>Subject: RE: Weather Revisited
>
>
> > Scott,
> >
> > Have your CF Schedule script create an HTML file with the weather in the
> > format you output it and then just include it on your page and overwrite
>the
> > file each time the schedule runs...Totally eliminates the need for a
> > database call...
> >
> > HTH,
> > John
> >
> > -Original Message-
> > From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 15, 2000 1:58 PM
> > To: [EMAIL PROTECTED]
> > Subject: Weather Revisited
> >
> >
> > Ok.. so what I setup was the script to grab weather using cfschedule oh,
> > every 15 minutes and store it in a database. Then I just grab the database
> > value on the page.
> >
> > Is there a less computer intensive way to do this? I hate to do a query
>each
> > time the page loads just for the temperature =). Can I cache it somewhere?
> >
> > Scott Berry
> > --
> > Computer Simplistics Support
> > "Simple Solutions for a Complex World"
> > http://www.c-s.net
> > 661-296-4315
> >
> >
> >
> >
> > --
>--
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > 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: Able Commerce Help

[Emmet McGovern]

You just need to have unique wizards or are you trying to dulicate the whole
package?  Have you checked out the extensive faq's on customization at the
able website?

Emmet McGovern
developer/ Byte Size Inc

-Original Message-
From: Russell, Bonnie [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 2:58 PM
To: '[EMAIL PROTECTED]'
Subject: Able Commerce Help


Has anyone had experience using able commerce and customizing for a
particular customer.  What I need is to have a separate directory for
program files for one customer while using the original able commerce
program files for everyone else.  Everytime I follow the directions to copy
the files and change the mapping for my one store, all the stores stop
working.  I've been on the phone with able commerce, and so far they've
given me nothing but the brush off.

So how do you set up a store with it's own program files?

Bonnie Russell
[EMAIL PROTECTED]

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

RE: Passing Flash Variables to CF??

[Jason Egan]

Here is the thread that helped me
- Original Message -
From: "Mark Zukiwsky" <[EMAIL PROTECTED]>
To: "Sean Renet" <[EMAIL PROTECTED]>
Sent: Saturday, March 04, 2000 11:11 PM
Subject: Re: Flash w/ CF


> >Mark I went to flasher and I do not see an archive for the list. could
you
> >forward me your post.  I am trying to figure out how to use flash to
> >retrieve variables from CF also.
>
> Hi Sean,
>
> Here's my post to the Flasher list from last week. They were asking
> the same thing you were.
>
> Just a note about the use of lists - this code was originally for use
> in Director Shockwave. I used lists so I could suppress white space
> and extraneous tab characters that were ending up in my variables,
> and for passing cf lists directly to Lingo Lists.
>
> Contact me if you have any questions.
>
> Mark Zukiwsky
> Edmonton, Canada
>
> --
-
> Date: Thu, 2 Mar 2000 14:24:00 -0700
> To: Flash List
> From: Mark Zukiwsky <[EMAIL PROTECTED]>
> Subject: Re: FLASH: Can anyone help me with flash and Cold Fusion?
> Cc: [EMAIL PROTECTED]
> Bcc:
> X-Attachments:
>
> Hi Sarah,
>
> Here's an example of a ColdFusion template that I'm using to get data
> into Flash. I'm using the POST function in Flash to fetch my
> variables. My Flash Post action is something like:
>
>Set Variable: "baseURL" = "http://mark.foxmicro.net/flash/"
>Set Variable: "CFtemplate" = "getMenuData.cfm"
>Set Variable: "SiteID" = 1
>Set Variable: "eof" = 0
>Set Variable: "index" = 1
>Load Variables (baseURL & CFtemplate, 0, vars=POST)
>Go to and Play ("Check")
>
> That calls the following ColdFusion template:
> 
> 
> 
> 
>
> 
> 
> SELECT busUnit, unitName, novaUnit, activeUnit
> FROM UnitTBL
> WHERE SiteID = #Trim(FORM.SiteID)#
> ORDER BY novaUnit, unitName
> 
>
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
> 
>
>
>
>
>
>
>
>
>&#unitX#=#tempUnit#
>&#unitNameX#=#URLEncodedFormat(tempName)#
>&#companyX#=#tempNova#
>&#activeX#=#tempActive#
>#chr(13)#
> 
> &unitCount=#flashtext.recordCount##chr(13)#
> &eof=1
> 
>
> The above template would return output like:
> 
>
&unit1=1&unitName1=NOVA%20%2D%20Joffre%20Personnel&company1=True&active1=Tru
e
>
&unit2=11&unitName2=Coutts%20Electrical%20Ltd%2E&company2=False&active2=True
> &unit3=3&unitName3=HATSCAN&company3=False&active3=True
> &unit4=4&unitName4=Modern%20Plant%20Services&company4=False&active4=True
> &unit5=10&unitName5=multimedia%20works&company5=False&active5=False
> &unit6=12&unitName6=O%27Reilly%20Insulators%20Inc%2E&company6=False&ac
> tive6=True
> &unit7=2&unitName7=Quinn%20Contracting&company7=False&active7=True
> &unitCount=7
> &eof=1
>
> Then in Flash I'd check whether the variables have been loaded by
> checking the value that the value of eof = 1:
>
>If (eof = 1)
>Go to and Play ("Done")
>Else
>Go to and Play ("Check")
>End If
>
> After the variables have been loaded, I use this action to convert
> the results to variables:
>
>Loop While (index <= unitCount)
>Set Variable: "tempUnitID" & index = Eval("unit" & index)
>Set Variable: "tempUnit" & index = Eval("unitName" & index)
>Set Variable: "tempCompany" & index = Eval("Company" & index)
>Set Variable: "tempActive" & index = Eval("active" & index)
>Set Variable: "index" = index + 1
>End Loop
>Go to and Play ("Display")
>
> Now, depending on what you're doing in your display, the results
> should display something like:
>
> http://mark.foxmicro.net/flashmenu/
>
> This example posts a random siteID to the ColdFusion template. To see
> the data that is used to build this menu try:
>
> http://mark.foxmicro.net/cf_flash/flashtest3.cfm?SiteID=1 or
SiteID=11937
>
> I hope this helps.
>
> 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.

and IIS

[Todd Ashworth]

Does anyone know of a way to have CF interact with IIS?  Basically, what I
am trying to do is make a CF app. that will set up the directories and paths
and settings in IIS to get a web site up and going, 100% configured, without
using the IIS management console.  I'm sure there's a way to do it .. just
not sure how to approach the problem.

.Todd



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

RE: Access Date/Time Function

[William Adamsen]

It looks like Access thinks they're integers and is trying to
divide 1 by zero indicating that they're not actually a date type(?)
You might try the IsDate() function to verify that you have a data
type of type date and then force it to date using CreateODBCDate().

#DateDiff("d", "#CreateODBCDate('1/1/00')#',
'#CreateODBCDate('12/1/00')#')#



-Original Message-
From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 1:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Access Date/Time Function


Hi All,

I am using Access 2000.  When I try to do search for the date range say,
from '1/1/00' to '12/1/00'.  Access gives me an error saying that it's not
divisible by 00.  Any help would be greatly appreciated.

Thanks,
Lily


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

Cluster Environment

[Michael Paulsmeyer]

Hello All,

My question is if two users hit a clustered site and both hit a different
server, could those servers create the same cfid/cftoken combination?
Asking this question because a client wants to move from session variables
to client variables and I want to assure him that this situation will not
happen or that if it does there are simple measures to take to resolve it.

Thanks In Advance,
Mike Paulsmeyer.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Weather Revisited

[Computer Simplistics Suppoer]

Can you give me some more insight into this? How would I accomplish this?

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315


- Original Message -
From: "Steve Bernard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 1:44 PM
Subject: RE: Weather Revisited


> You could cache the query or store the information in an APPLICATION or
> SERVER scoped variable.
>
> Steve
>
> -Original Message-
> From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 2:58 PM
> To: [EMAIL PROTECTED]
> Subject: Weather Revisited
>
>
> Ok.. so what I setup was the script to grab weather using cfschedule oh,
> every 15 minutes and store it in a database. Then I just grab the database
> value on the page.
>
> Is there a less computer intensive way to do this? I hate to do a query
each
> time the page loads just for the temperature =). Can I cache it somewhere?
>
> Scott Berry
> --
> Computer Simplistics Support
> "Simple Solutions for a Complex World"
> http://www.c-s.net
> 661-296-4315
>
>
>
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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: Access Date/Time Function

[Marcus]

> I am using Access 2000.  When I try to do search for the date range say,
> from '1/1/00' to '12/1/00'.  Access gives me an error saying that it's not
> divisible by 00.  Any help would be greatly appreciated.

thats because the computer is trying to do the math you have put in front of
it.

1/1/00 is 1 divided by 1 divided by 00... can't divide by 0 so it errors.

Marcus

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Cisco Local Director/CF and Winnt

[Lincoln Manning]

OK,
We have implemented a server farm with Local Director.  It works sort of , but I find 
that the failover is slow. In other words If I shut down a server or if a server 
fails, the users
connected to that server, are not automatically sent to another server.  Most of those 
users experience problems.  This should not happen.  Furthermore, since implementation 
I am
getting errors in my CFServer log over and over again, which causes the servers to 
sometimes crash.  I checked this error and it seems to be an NT Network error, but I 
am not able to
get to the bottom of it.

""Error","TID=217","05/15/00","16:42:55","Unable to write reply -- client browser 
stopped waiting for request. "
"Error","TID=217","05/15/00","16:42:55","Windows NT error number 109 occurred."


"Leyne, Sean" wrote:

> Lincoln,
>
> How about asking the questions publicly?
>
> We are going to be looking at implementing a balancing solution (most
> probably the Local Director) and would appreciate seeing what
> issues/questions you have and the responses you get.
>
> Sean
>
> P.S.Isn't a list-server/newsgroup to allow the community to benefit
> from each other knowledge/experience?
>
>  -Original Message-
> From:   Lincoln Manning [mailto:[EMAIL PROTECTED]]
> Sent:   Monday, May 15, 2000 3:43 PM
> To: [EMAIL PROTECTED]
> Subject:Cisco Local Director/CF and Winnt
>
> Is someone available off list to answer a couple of questions?
>
> --
> Lincoln Manning
> Web Application Developer
> Applied Virtual Vision
> [EMAIL PROTECTED]
> http://www.avv.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.

--
Lincoln Manning
Web Application Developer
Applied Virtual Vision
[EMAIL PROTECTED]
http://www.avv.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: Have I set a record?

[Eric Dawson]

and certainly the longest off topic thread to go without whining about being 
OT.


From: "Randy Adkins" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Have I set a record?
Date: Mon, 15 May 2000 14:13:47 -0400

Greg,

I agree. This use to be a nice list for information.
However it seems recently it has turned into a chat line.

So many things off-topic.

Sorry for this POST. But we are CF programmers here
to help with other CF problems.

Not discuss lives thoughts and so-called great wisdoms.

Lets try to stay with CF topics.



- Original Message -
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: "Cold Fusion" <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 2:03 PM
Subject: Have I set a record?


 > Ok, started with a little post asking for my "you know you're a cold
fusion
 > programmer when..." request, and has since mutated into schools, jolt
cola,
 > and "get a life"I counted 132 threads off this one request.  So I
claim
 > the record for "biggest cf-talk thread in history" unless someone cares 
to
 > challenge :-)  Not meant to brag or anything
 >
 > Gregory Harris (tekiegreg)
 > [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.


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

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

Is cf-community offically dead?

[pan]

Apparently cf-talk has subsumed cf-community.
Anyone besides me have a problem with this?

Should we who are too much into being techno-geeks
just fade away from cf-talk?

The signal to noise ratio seems to have gone to hell
in the past four months - when this happened before it
was transitory and a few admonishments seemed to
have corrected the problem. Now, it seems that 
30%+ of the messages to this list should have been
posted to cf-community.

Have things changed like I am characterizing it?

Pan "... fading away"





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Weather Revisited

[Steve Bernard]

You could cache the query or store the information in an APPLICATION or
SERVER scoped variable.

Steve

-Original Message-
From: Computer Simplistics Suppoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 2:58 PM
To: [EMAIL PROTECTED]
Subject: Weather Revisited


Ok.. so what I setup was the script to grab weather using cfschedule oh,
every 15 minutes and store it in a database. Then I just grab the database
value on the page.

Is there a less computer intensive way to do this? I hate to do a query each
time the page loads just for the temperature =). Can I cache it somewhere?

Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315





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

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

Re: Slightly OT: Lighten things up a little

[Nick & Loretta Pioch]

HA HA HA HA!  That's what I learned too with my engineering degree!!! (oh how many 
hammers I have used!)
And before that, with my physics degree, I learned that the most difficult solution 
must be the best solution!!!
HA HA HA HA !

-- Loretta Pioch

Stewart McGowan wrote:

> ah I did engineering and I learned there that if it didn't work you found
> the biggest hammer and made it work :)
>
> > -Original Message-
> > From: Stephanie Cunningham [SMTP:[EMAIL PROTECTED]]
> > Sent: 15 May 2000 18:14
> > To:   [EMAIL PROTECTED]
> > Subject:  RE: Slightly OT: Lighten things up a little
> >
> > I completely agree with you.  The main thing I got out of my comp sci
> > degree
> > was the ability to think more logically.  And, boy, do I know how to sort
> > (bubble, merge, radix, quicksort)!
> > Woo Hoo!!  Let the fun begin!

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