Re: CFTREE or Javascript?

[David Shadovitz]

Actually it ain't that hard at all.
I followed "JavaScript DHTML Collapsible Lists",
http://developer.netscape.com/docs/technote/dynhtml/collapse/index.html

-David

On Tue, 18 Apr 2000 02:06:57 -0400 "Seth Petry-Johnson"
<[EMAIL PROTECTED]> writes:
> >Netscape has some JavaScript Tree libraries that work on IE4+ and 
> NS4+ in
> >their Developer Zone (http://developer.netscape.com) It will 
> require quit a
> >bit of manipulating to get the queries work, but it's possible.
> 
> 
> Don't quote me on this, but I believe that Netscape compliant code 
> to do
> this uses layers to accomplish the task.
> 
> IE doesn't support layers, and Netscape doesn't support document.all 
> and
> changing the "display" parameter, so there would need to be a fair 
> bit of
> effort to generate a cross browser script.  I didn't meant to imply 
> that
> this couldn't be done with Netscape, just that I had not 
> investigated it
> (and that my solution was IE only).
> 
> Regards,
> Seth Petry-Johnson

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFTREE or Javascript?

[Pete Freitag]

Yes I understand, I was just letting everyone know that it can be done cross
browser.  I also found the like on Netscape's site, so here you go...
http://developer.netscape.com/docs/technote/dynhtml/collapse/index.html

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

-Original Message-
From: Seth Petry-Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 2:07 AM
To: [EMAIL PROTECTED]
Subject: Re: CFTREE or Javascript?


>Netscape has some JavaScript Tree libraries that work on IE4+ and NS4+ in
>their Developer Zone (http://developer.netscape.com) It will require quit a
>bit of manipulating to get the queries work, but it's possible.


Don't quote me on this, but I believe that Netscape compliant code to do
this uses layers to accomplish the task.

IE doesn't support layers, and Netscape doesn't support document.all and
changing the "display" parameter, so there would need to be a fair bit of
effort to generate a cross browser script.  I didn't meant to imply that
this couldn't be done with Netscape, just that I had not investigated it
(and that my solution was IE only).

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates


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

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

Re: CFTREE or Javascript?

[Seth Petry-Johnson]

>Netscape has some JavaScript Tree libraries that work on IE4+ and NS4+ in
>their Developer Zone (http://developer.netscape.com) It will require quit a
>bit of manipulating to get the queries work, but it's possible.


Don't quote me on this, but I believe that Netscape compliant code to do
this uses layers to accomplish the task.

IE doesn't support layers, and Netscape doesn't support document.all and
changing the "display" parameter, so there would need to be a fair bit of
effort to generate a cross browser script.  I didn't meant to imply that
this couldn't be done with Netscape, just that I had not investigated it
(and that my solution was IE only).

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

Re: [slight OT] Using Triggers

[Ken M. Mevand]

i have just written a stored procedure in SQL 7 that inserts a row in the
order table, which in turn sets off a trigger to update the stock. if there
is not enough stock, the trigger raise an error using RAISERROR. the problem
now is that the stored procedure cannot trap the error and the error is
immediately returned to CF.


- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 18, 2000 3:12 AM
Subject: RE: [slight OT] Using Triggers


> > in my shopping cart check out process, once an order
> > has been recorded, i want to update the stock levels
> > of my inventory too.
> >
> > i'm thinking of using triggers, so that if there is
> > not enough stock, the trigger should raise an error
> > (i'm using MSSQL7). in this case, how can ColdFusion
> > know that the error is "out of stock" and the product
> > ID of the error?
>
> If your trigger returns a recordset, the CFQUERY tag which caused the
> trigger to fire will receive that recordset. So, you could write a trigger
> that returns a value using a SELECT statement, and read that value from
CF.
>
> Since you're using SQL Server 7, you might want to try doing this in a
> stored procedure, as there's generally less overhead involved with stored
> procedures than triggers. Also, with a stored procedure, you could return
a
> value instead of a recordset, and read that value without the overhead
> involved with recordsets.
>
> 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.

arrays that build dynamic fields and javascript.

[Sean Renet]

Okay I have a form/table that I build from an array. What I need to do is
create some one the fly math for inverse cells of this table.  that is, if
the value of row 1 column 2 is input to be 2, then the value of row 2 column
1 must be .50.  So I need to write some javascript that takes the value put
into the field and onblur or whatever writes its its inverse into its
reciprocal cell.  The problem is how do I know what the name of the field is
when the field name is dynamically generated?

Ex:




SELECT  *
FROMcrits











 
  
   
  
   
  
 



 
 
  
   
  
  
  #crit#
  
  
  
 

 
 #crit#
 
  
  #MyArray[Counter][element]#
  
 
 
 




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

[Pete Freitag]

Netscape has some JavaScript Tree libraries that work on IE4+ and NS4+ in
their Developer Zone (http://developer.netscape.com) It will require quit a
bit of manipulating to get the queries work, but it's possible.

CFTree on the other hand probably won't be much of a problem to set up with
the recursion if you use CFX_MakeTree it sorts the query for you.  I have
never used it in a live environment so, I am not familiar with the pitfalls
of it.

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

-Original Message-
From: Seth Petry-Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 12:05 AM
To: [EMAIL PROTECTED]
Subject: Re: CFTREE or Javascript?


>My question is does CFTree allow this and how easy is it to use CFTree
tags?
>I've heard it's quite problematic and that I'd be better off just using a
>javascript with queries.  Any info would be greatly appreciated.


CFTree does allow you to display hierarchical information in an
expanding/collapsing format, and so theoretically it would suffice for your
task.  There is a fair amount of customization that can be done using the
various parameters to the tag.  Perhaps the greatest advantage to CFTree is
that, since it spawns a Java app, it should work in any Java enabled
browser.

On the other hand, the fact that it is a Java app may also be one of its
greatest *disadvantages*, depending on your view of Java.  I guess that is
just a matter of perspective .

I used CFTree for this sort of thing at one time, but I recently re-did it
using IE specific DHTML.  The expanding and collapsing of elements is really
quite trivial using the CSS property "display", but since Netscape 4.x does
not allow you to modify this value through script my JS solution is IE
dependant.  The other advantage to using JS to do this is that I can expand
and collapse branches with one click, whereas CFTree requires a double click
(my client hates to double click).

After working with both solutions I think I like the JS version better.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates




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

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

Re: forum suggestions?

[Sean Renet]

Actually most hosts disable that stuff.  So if you are going to develop for
clients on shared servers, its something you have to deal with.  You just
have to figure out work arounds.  For instance you can't use CFContent to
dynamically make a downloadable excel file, you have to instead have them
already created in a folder.
And for the rest of you. Most of us wish we had the Al Haig type of control
you have over your clients, and one day when I make enough money I will move
to disneyland and live right next to you.
- Original Message -
From: "Stephen M. Aylor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 9:56 PM
Subject: Re: forum suggestions?


> > the following tags will be disabled:
> > "CF File, CF Directory, CF Content, CF Object, CF Registry, CF FTP, CF
> > Adminsecurity, CF Execute, CF Grid, CF Tree"
>
>
>  :-)
>
> Steve
>
> --

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

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

[Fred Sanders]

Then exactly why are you using Cold Fusion???  Its obviously not the tool
for the job in your case.

Fred T. Sanders
Galveston Island, TX
--
Having a bad day?
Imagine this...

You are in total seclusion from that hectic place called "The World".
The soothing sound of a gentle waterfall fills the air with a cascading
serenity.
The water is clear.
You can easily make out the face of the person you are holding underwater.

Feeling better?


- Original Message -
From: "Robby Grant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 6:00 PM
Subject: forum suggestions?


> I am trying to find a discussion forum for a new site I'm working on. We
do
> not have a dedicated host and this means the following tags will be
> disabled:
> "CF File, CF Directory, CF Content, CF Object, CF Registry, CF FTP, CF
> Adminsecurity, CF Execute, CF Grid, CF Tree"
>
> Any suggestions would be greatly appreciated.
>
> Robby Grant
> www.ringger.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: forum suggestions?

[Stephen M. Aylor]

> the following tags will be disabled:
> "CF File, CF Directory, CF Content, CF Object, CF Registry, CF FTP, CF
> Adminsecurity, CF Execute, CF Grid, CF Tree"


 :-)

Steve

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

Re: CFTREE or Javascript?

[Seth Petry-Johnson]

>My question is does CFTree allow this and how easy is it to use CFTree
tags?
>I've heard it's quite problematic and that I'd be better off just using a
>javascript with queries.  Any info would be greatly appreciated.


CFTree does allow you to display hierarchical information in an
expanding/collapsing format, and so theoretically it would suffice for your
task.  There is a fair amount of customization that can be done using the
various parameters to the tag.  Perhaps the greatest advantage to CFTree is
that, since it spawns a Java app, it should work in any Java enabled
browser.

On the other hand, the fact that it is a Java app may also be one of its
greatest *disadvantages*, depending on your view of Java.  I guess that is
just a matter of perspective .

I used CFTree for this sort of thing at one time, but I recently re-did it
using IE specific DHTML.  The expanding and collapsing of elements is really
quite trivial using the CSS property "display", but since Netscape 4.x does
not allow you to modify this value through script my JS solution is IE
dependant.  The other advantage to using JS to do this is that I can expand
and collapse branches with one click, whereas CFTree requires a double click
(my client hates to double click).

After working with both solutions I think I like the JS version better.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates



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

RE: CFLOCATION and targets

[Richard Darracott]

Possibly, but I would want index.cfm to be targeted to _top rather than it
build a frame set within the current frame.

E.g.

In normal use the site has 2 frames a left hand side Menu and rest of screen
content area.

---
|   |   |
| Frame1| Frame 2   |
|  Menu | Content Area  |
|   |   |
---

The page that is redirecting is in frame 2 and I want to redirect to a page
that would completely replace frames 1 and 2
e.g.
---
|   |
| Login Screen  |
|   |
---

Would that method allow me to do that?

Thanks
Richard




> -Original Message-
> From: stas [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 18, 2000 2:50 PM
> To: [EMAIL PROTECTED]
> Subject: RE: CFLOCATION and targets
>
>
> It sound too simple, but can you not do a cflocation with an
> URL parameter
> to a page with a frameset where the target would be the frame
> you passed via
> the URL param?
>
> as in:
>
> 
> 
>
> in the receiving page:
>
> 
> 
>   .
>   
>   .
> 
>
> -Original Message-
> From: Richard Darracott [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 17, 2000 10:35 PM
> To: [EMAIL PROTECTED]
> Subject: CFLOCATION and targets
>
>
> Hi,
> I'm trying to something very simple but that doesn't seems to
> be supported
> in the CFLOCATION tag.  What I need to do is to redirect the
> viewer to a
> page, but also be able to specify the target frame to load in.
> For example if the user has not interacted with the page for
> a specified
> amount of time I would like to redirect them back to the login page.
> However the authenticated site is framed so I need to
> redirect to target
> _top to wipe out the side menu frame as well as the currently
> focused frame.
>
> Does anyway know of a way of doing this? Or know of a custom
> tag?  The only
> way I have come up with is to redirect to a page that has a JavaScript
> redirect with the correct target information in it.
>
> Thanks (and hope I made sense)
>
> Richard Darracott
> Software Development Manager
> 7am.com Limited
>
>
>
>
>
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/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.

CFTREE or Javascript?

[Marco Gil]

I'm looking at making a tree structure where the administrator would be able
to pick how he wants to view the data in his tables In other words.. I'm
going to have a left table and a right table on the page with the left table
having the Tree effect where when he clicks on an item in the tree.. it
expands down with other options...

My question is does CFTree allow this and how easy is it to use CFTree tags?
I've heard it's quite problematic and that I'd be better off just using a
javascript with queries.  Any info would be greatly appreciated.

Marco

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Suggestions for Third Party Mapping Services

[Michael Imhoff]

I did the mapping implementations for http://www.abraauto.com and
http://www.miracle-ear.com both with MapQuest and was happy with it.

I imagine there are others out there but MapQuest isn't a bad idea if you
can afford it.

-Michael


Michael Imhoff  www.omnicypher.com  icq: 10495667
[EMAIL PROTECTED] (home)  (320) 255-4447 (home)
[EMAIL PROTECTED] (cell)  (612) 247-8159 (cell)
Allaire Alliance Consulting Partner


- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "cf-talk" <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 5:37 PM
Subject: Suggestions for Third Party Mapping Services


> I'm looking for suggestions for mapping services (ala MapQuest) that offer
> the usual "display a road map for this address" type of features.
> Zooming, panning, lookup by longitude and latitude as well as address,
> driving directions.
>
> We've been in contact with MapQuest and would like to hear about other
> similar services, perhaps for a lower cost than MapQuest.  Oh, and CF
> integration is always a consideration.  I believe MapQuest operates
> through a CGI installed your web server.
>
> Thanks,
> Jim
>
> --

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

[stas]

It sound too simple, but can you not do a cflocation with an URL parameter
to a page with a frameset where the target would be the frame you passed via
the URL param?

as in:




in the receiving page:



.

.


-Original Message-
From: Richard Darracott [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 10:35 PM
To: [EMAIL PROTECTED]
Subject: CFLOCATION and targets


Hi,
I'm trying to something very simple but that doesn't seems to be supported
in the CFLOCATION tag.  What I need to do is to redirect the viewer to a
page, but also be able to specify the target frame to load in.
For example if the user has not interacted with the page for a specified
amount of time I would like to redirect them back to the login page.
However the authenticated site is framed so I need to redirect to target
_top to wipe out the side menu frame as well as the currently focused frame.

Does anyway know of a way of doing this? Or know of a custom tag?  The only
way I have come up with is to redirect to a page that has a JavaScript
redirect with the correct target information in it.

Thanks (and hope I made sense)

Richard Darracott
Software Development Manager
7am.com Limited






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

CFLOCATION and targets

[Richard Darracott]

Hi,
I'm trying to something very simple but that doesn't seems to be supported
in the CFLOCATION tag.  What I need to do is to redirect the viewer to a
page, but also be able to specify the target frame to load in.
For example if the user has not interacted with the page for a specified
amount of time I would like to redirect them back to the login page.
However the authenticated site is framed so I need to redirect to target
_top to wipe out the side menu frame as well as the currently focused frame.

Does anyway know of a way of doing this? Or know of a custom tag?  The only
way I have come up with is to redirect to a page that has a JavaScript
redirect with the correct target information in it.

Thanks (and hope I made sense)

Richard Darracott
Software Development Manager
7am.com Limited





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

[Bill Killillay]

Ok, I know that there is bound to be somebody out there that is a whiz with
this stuff.  Here is the situation.  I have a frames page web site and the
owner wants to have a script in the top of each of the "Body" pages that if
you come directly to one of those it tests the location bar and sends you to
the opening page so that the user is then in frames.  I wrote a simple
script for this and it works great.  Now the challenge is to extend that so
that it sets a cookie, using JavaScript, with the value of the page that the
user is on.  Then in the Frames page that sets every thing up for it to read
the cookie and send load the "Body" section of the frames with the value of
the cookie.  If the value of the cookie is not there then it needs to
default to the real opening main page.  Included below are two pieces of
script that I have worked up but I am over my head from here and need some
help badly.

This is the script to jump to the home frames page




This is what I did to the above script to set the cookie (I hope)




Now in the frames page it's self I need to check that cookie and write the
value of it out.








As you can imagine and see though, document.write just returns the word
index on my page.  What am I doing wrong here.  What's the best method to do
this and write it into the frames page.  Does anybody need to see the frames
page to be able to help more.

Thanks.

Bill Killillay
ICQ @ 8425781

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
"An investment in Knowledge always pays the best interest."
   -Benjamin Franklin-
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Get Paid to Surf the Web.  It's free, easy and fun.
Sign up for AllAdvantage.com at

http://alladvantage.com/go.asp?refid=FIB-034

Most of us are on it every day all day anyway, why not give
yourself a pay raise for 25 hours a month.

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

[Hubert Earl]

ok
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 15, 2000 3:01 PM
Subject: Auto Reply to your message ...


> This is a MIME-encapsulated message
>
> --=38F7D2960123/server0.sys-con.com
>
>   -  The following text is an automated response to your
essage  -
> Hi-
> I am travelling overseas and will be back Monday April 24th.
> Please contact [EMAIL PROTECTED] for any urgent issues.
> Best regards,
> Robert
>
> --=38F7D2960123/server0.sys-con.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: ADO is 20% faster than CFQUERY was [Re: Native SQL Server driver?]

[Aymeric Grassart]

As I replied to Dan Switzer's similar comment. Doesn't CF by default
pool multiple cfqueries to the same datasource within the same page to
the same ODBC connection ? I also understand that the first query run
will check for an open connection to that datasource. I guess this means
enhanced performance when pooling across distinct clients requests for
cfquery; but a server scoped pool within the cf_ado tag could also be
implemented.

I'll run some more tests and keep you informed.

Dave Watts wrote:
> 
> > Calling ADO through CFOBJECT is 20% faster than CFQUERY !!!
> >
> > Test it yourself at http://dev.aylo.com/testing/Perf/db.cfm
> 
> When I tested it myself, using one iteration, the speeds were consistently
> the same for either one; each would return 46-47 ms or 62-63 ms. I think
> there's an issue with your looping construct, which is inflating the values
> for CFQUERY.
> 
> >   
> >   
> >   select * from licenses
> >   
> >   
> 
> In this loop, I don't think you're guaranteed that it will use the same
> connection each time; CF handles connection pooling, but the CF developer
> has little control over whether a specific connection will be reused.
> 
> >> ACTION="CREATE">
> >   
> >   
> >> ACTION="CREATE">
> >> conn,1,1,1)>
> >   
> 
> In this loop, you're creating a single connection before the loop, and
> within the loop you're forcing all the recordsets through that one
> collection.
> 
> To me, this illustrates one of the problems of testing using loops. A better
> testing methodology is to run multiple clients, and return average times
> across those clients. Of course, it's certainly possible that ADO is faster
> than CFQUERY, but I can't be sure that this test demonstrates that. It may
> also be the case that, aggregated across an entire server or application,
> CFQUERY performes better since it handles connection pooling in the
> background.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444

-- 
Aymeric Grassart<-> Chief Technology Officer
http://www.aylo.com <-> Aylo Inc.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: ADO is 20% faster than CFQUERY was [Re: Native SQL Server driver?]

[Dave Watts]

> Calling ADO through CFOBJECT is 20% faster than CFQUERY !!!
>
> Test it yourself at http://dev.aylo.com/testing/Perf/db.cfm

When I tested it myself, using one iteration, the speeds were consistently
the same for either one; each would return 46-47 ms or 62-63 ms. I think
there's an issue with your looping construct, which is inflating the values
for CFQUERY.

>   
>   
>   select * from licenses
>   
>   

In this loop, I don't think you're guaranteed that it will use the same
connection each time; CF handles connection pooling, but the CF developer
has little control over whether a specific connection will be reused.

>ACTION="CREATE">
>   
>   
>ACTION="CREATE">
>conn,1,1,1)>
>   

In this loop, you're creating a single connection before the loop, and
within the loop you're forcing all the recordsets through that one
collection.

To me, this illustrates one of the problems of testing using loops. A better
testing methodology is to run multiple clients, and return average times
across those clients. Of course, it's certainly possible that ADO is faster
than CFQUERY, but I can't be sure that this test demonstrates that. It may
also be the case that, aggregated across an entire server or application,
CFQUERY performes better since it handles connection pooling in the
background.

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: weird CF error or not weird but i have never seen it.

[Seth Petry-Johnson]

>I have two queries on the same page, both are pulling info by an client_id
>and one other field but on one of the queries i keep getting this error.


Without seeing your code the only advice I can give is to fully scope your
variables.  For example, instead of using #project# use #qryName.project#
(where qryName is the name of a query) or #form.project# or whatever.  You
may have variables named "project" in multiple scopes, and CF may be
inadvertently reading the wrong scope. If you fully scope the variable when
you reference it then CF has less quess work to do, which means less chance
of errors (and it will run faster too).

Post your code if you still have problems.  A piece of advice, however:
change your mail client to send in PLAIN TEXT format to this list.  The list
server doesn't seem to be accepting HTML formatted messages.  It botches the
MIME encoding and any code you include will come through all botched up.
This makes reading the post difficult, which in turn means less chance of
you getting an answer.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

ADO is 20% faster than CFQUERY was [Re: Native SQL Server driver?]

[Aymeric Grassart]

Not to put CF more down than I usually do, but what I just found out
_really_ surprised me.

Calling ADO through CFOBJECT is 20% faster than CFQUERY !!!

Test it yourself at http://dev.aylo.com/testing/Perf/db.cfm

My question, what does CFQUERY use to access ODBC ? Would anyone be
interested in using a select
query tag that we are currently working on ?

Here's the url's code:




Loops: 





select * from licenses



#times# recordsets containing #licenses.recordcount# records
pulled in #numberformat(evaluate(endat-startat))# ms.








#times# recordsets containing #rs.recordcount# records pulled
in #numberformat(evaluate(endat-startat))# ms.



Dave Watts wrote:
> 
> > ODBC certainly isn't anywhere near native SQL support - it is
> > a generic middleware datasource driver - and although OLEDB is
> > closer, it still isn't native SQL. OLEDB drivers are available
> > for numerous applications including the Access Jet Engine just
> > like ODBC.
> >
> > Nearer to native still would be be by using the SQL DB-LIB
> > API for CF to talk to SQL Server.
> 
> Microsoft provides lots of APIs to connect to databases (DB-Library, RDO,
> ADO, etc), but none of these is more "native" than OLEDB. Native doesn't
> necessarily mean lowest-level, it means the method that the vendor defines
> as native. Microsoft has declared this to be OLEDB. If you use the data
> transfer tools inside of Enterprise Manager, you'll connect via OLEDB. The
> fact that OLEDB providers are available for other platforms is also
> unimportant.
> 
> After all, if you look at native drivers for other platforms, you face the
> same availability of alternatives. If you connect natively to Oracle 8i, CF
> simply communicates directly with the Net8 client, which itself is analogous
> to OLEDB. I'd guess that the SQL Plus client talks at a lower level than
> Net8. When you connect to SQL Server 7 using ODBC, CF talks to ODBC, which
> talks to OLEDB. Using OLEDB instead of ODBC cuts out the middleman, so to
> speak.
> 
> 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.

-- 
Aymeric Grassart<-> Chief Technology Officer
http://www.aylo.com <-> Aylo Inc.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: JWS & CF

[Dave Watts]

> Has anyone convinced CF to work with JWS?

If by JWS you mean Sun's Java Web Server, if that server can invoke programs
through CGI, you can use CF with it. You won't, however, be able to use a
native API interface, which means that you'll have to put CFML.EXE in your
cgi-bin directory, and invoke CF scripts with URLs that look something like:

http://www.myserver.com/cgi-bin/cfml.exe?template=/myfile.cfm

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.

JWS & CF

[Cary Gordon]

Has anyone convinced CF to work with JWS?


Cary Gordon
The Cherry Hill Company

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

Test--please ignore!

[Nathan Chen]

Test

--
Nathan Chen
(208)-426-8470
Computer Control Systems, Inc.


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

forum suggestions?

[Robby Grant]

I am trying to find a discussion forum for a new site I'm working on. We do
not have a dedicated host and this means the following tags will be
disabled:
"CF File, CF Directory, CF Content, CF Object, CF Registry, CF FTP, CF
Adminsecurity, CF Execute, CF Grid, CF Tree"

Any suggestions would be greatly appreciated.

Robby Grant
www.ringger.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: UNSUBSCRIBE

[Seth Petry-Johnson]

>Hi, my name is Julia Green and I am a Cold Fusion Programmer at UPS.
>Did you mean that I personally should unsubscribe?

Yes.  We want you to cease and desist posting immediately. Get outta here!

Sorry... I couldn't resist .  You might want to create a filter in your
email client that automatically puts all messages from this list into their
own folder.  That makes it easier to tell if an email was sent directly to
you (will appear in the main folder) or to the list (will appear in the new
folder).

To create a new thread just send an email to [EMAIL PROTECTED]  You
can also reply to an existing message and change the subject line.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

Re: UNSUBSCRIBE

[Jennifer]

At 06:38 PM 4/17/00 -0400, you wrote:
>Mr. Haubrich --
>
>Hi, my name is Julia Green and I am a Cold Fusion Programmer at UPS.
>Did you mean that I personally should unsubscribe?

No, he is trying to unsubscribe by ignoring the message at the bottom of 
each post that tells people how to unsubscribe. Don't worry about him.

>  I actually need to post
>to solve a DateDiff() problem in a Vacation Posting problem I am doing
>at work?  However, I don't have the code as of yet.  Probably tomorrow...
>
>Also, I am a little at lost at where and how I should post?  Should I just
>reply
>to an email, or is there an actual board where I should post and how should
>I do it?

You can post to the forums at allaire (I think it's forums.allaire.com but 
you can find it in the support section of the website). You can post here 
by sending a message to [EMAIL PROTECTED], the address that you 
just replied to.

>If you can help me with any of these problems, great?

Well, the problem is pretty unclear at this point, but you said that you 
will have some code tomorrow (or thereabouts). When you have more 
information, just send it in (I suggest starting a new topic with a 
descriptive subject line) and I'm sure that someone around here will be 
happy to help you out if they can. Code is always helpful, but attachments 
are bad form. The code should be included in the text of the message.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: UNSUBSCRIBE

[David Hannum]

Oh my dear Julia,

Mr Haubrich is unsubscribing. That's how you do it here.  8-)  This is
what's called a list-serv and you will get every message that's posted to
it.  You ask questions by sending emails to the server address and you reply
by simply hitting reply in your email client.

Enjoy and learn.

Dave  8-)


- Original Message -
From: Julia Green <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 6:38 PM
Subject: Re: UNSUBSCRIBE


> Mr. Haubrich --
>
> Hi, my name is Julia Green and I am a Cold Fusion Programmer at UPS.
> Did you mean that I personally should unsubscribe?  I actually need to
post
> to solve a DateDiff() problem in a Vacation Posting problem I am doing
> at work?  However, I don't have the code as of yet.  Probably tomorrow...
>
> Also, I am a little at lost at where and how I should post?  Should I just
> reply
> to an email, or is there an actual board where I should post and how
should
> I do it?
>
> If you can help me with any of these problems, great?
>
> Julia Green
> Julia Computer Consulting
> http://www.juliagreen.com/
> Email:  [EMAIL PROTECTED]
> Phone:  617-926-3413
> FAX:  413-771-0306
> - Original Message -
> From: Frederic Haubrich <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, April 17, 2000 6:23 PM
> Subject: UNSUBSCRIBE
>
>
> > Please unsubscribe
> >
> > Thank you,
> >
> > Frederic Haubrich
> > HOP.com
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

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

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

Re: UNSUBSCRIBE

[Julia Green]

Mr. Haubrich --

Hi, my name is Julia Green and I am a Cold Fusion Programmer at UPS.
Did you mean that I personally should unsubscribe?  I actually need to post
to solve a DateDiff() problem in a Vacation Posting problem I am doing
at work?  However, I don't have the code as of yet.  Probably tomorrow...

Also, I am a little at lost at where and how I should post?  Should I just
reply
to an email, or is there an actual board where I should post and how should
I do it?

If you can help me with any of these problems, great?

Julia Green
Julia Computer Consulting
http://www.juliagreen.com/
Email:  [EMAIL PROTECTED]
Phone:  617-926-3413
FAX:  413-771-0306
- Original Message -
From: Frederic Haubrich <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 6:23 PM
Subject: UNSUBSCRIBE


> Please unsubscribe
>
> Thank you,
>
> Frederic Haubrich
> HOP.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.

Suggestions for Third Party Mapping Services

[Jim McAtee]

I'm looking for suggestions for mapping services (ala MapQuest) that offer
the usual "display a road map for this address" type of features.
Zooming, panning, lookup by longitude and latitude as well as address,
driving directions.

We've been in contact with MapQuest and would like to hear about other
similar services, perhaps for a lower cost than MapQuest.  Oh, and CF
integration is always a consideration.  I believe MapQuest operates
through a CGI installed your web server.

Thanks,
Jim

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

[Ryan Hill]

My apologies but I haven't been following the thread too closely, is the
variable scoped and are the application names unique?  Dave is probably
right on the money with this one, my guess is that a simultaneous write was
occuring and the server is corrupting the variable memory.  Allaire was here
last week load testing and I picked up a lot of knowledge about using CFLOCK
- Raymond Camden can testify to this too, methinks.

In a similar memory corruption scenario, we found that Server was
unresponsive after applying a light load of about 30 simultaneous users
against our server - all sorts of nasty looking errors in our logs, etc.
Wrapping our session and application scopes inside CFLOCKS brought our
access times down considerably, and we were able to throw 4x the number of
simultaneous sessions without the server so much as blinking.

Regards,
Ryan

Ryan Hill, MCSE
Director, Systems Integration
Market Matrix, Inc.
http://www.marketmatrix.com 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 17, 2000 3:10 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: naming conflict?
> 
> 
> > the weirdest thing... i have three applications with the same
> > lines of code in each application.cfm. the first two
> > applications had no problem. the third application would crash
> > every page load whining that it couldn't assign a "symbol" to
> > the application variable. after a scratching my head for half
> > an hour, we restarted the CF service and had no further problem.
> >
> > ideas?
> 
> Nope, I haven't a clue, really. If I had to guess, I'd 
> suspect some odd
> memory allocation problem.
> 
> 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: naming conflict?

[Jennifer]

At 05:54 PM 4/17/00 -0400, you wrote:
> > > is there issue with using the same name as both a key and a structure?
> > > for example, notice the use of "foo":
> > >
> > > 
> > >application.foo = StructNew();
> > >application.foo.bar = true;
> > >application.myVar = StructNew();
> > >application.myVar.foo = false;
> > > 
> >
> > There shouldn't be, although from a readability perspective it's probably
> > not too helpful to reuse variable names even within different scopes. What
> > happens when you try it?
>
>the weirdest thing... i have three applications with the same lines of code
>in each application.cfm. the first two applications had no problem. the
>third application would crash every page load whining that it couldn't
>assign a "symbol" to the application variable. after a scratching my head
>for half an hour, we restarted the CF service and had no further problem.
>
>ideas?

Have you tested the other applications since restarting the server? I feel 
like one of the other applications will start having a problem.

If they are on the same server, make sure that the Application.cfm file 
http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

UNSUBSCRIBE

[Frederic Haubrich]

Please unsubscribe

Thank you,

Frederic Haubrich
HOP.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.

Cookies on IE/Mac

[Dana Larose]

Hello everyone,

We've just run into a problem while testing a site and I thought I would see
if anyone has any insights.

>From what we can gather,  doesn't appear to work under IE 4.01 on
a Mac.  In Netscape on the Mac (as well as either browser on the PC), the
page works fine, but the cookie isn't being set under IE (we have the ask to
approve cookie option on).  The tag we're using is dead simple...



Has anyone encounter anything like this?

Thanks in advance!

Dana Larose
Database Design
www.cdnwebdesign.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.

weird CF error or not weird but i have never seen it.

[Shawn Regan]

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

I have two queries on the same page, both are pulling info by an client_id
and one other field but on one of the queries i keep getting this error.

Expression result cannot be converted to a string

Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
evaluate to a value that can be converted to a string for output or dynamic
text accumulation purposes. Complex objects, such as queries, arrays, and
COM/DCOM objects, cannot be represented as strings.

The error occurred while processing an element with a general identifier of
(#project#), occupying document position (16:10) to (16:18).

The first query has no problem with #project# but the second one does.

Anyone seen this? Its a Eval version of CF server I'm going to install the
single user server today.

Shawn Regan

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






weird CF error or not weird but i have never seen it.



I have two queries on the same page, both are pulling =
info by an client_id and one other field but on one of the queries i =
keep getting this error.

Expression result cannot be converted to a =
string


Expressions used inside tags like CFOUTPUT, CFQUERY, =
CFMAIL, etc. must evaluate to a value that can be converted to a string =
for output or dynamic text accumulation purposes. Complex objects, such =
as queries, arrays, and COM/DCOM objects, cannot be represented as =
strings.

The error occurred while processing an element with a =
general identifier of (#project#), occupying document position (16:10) =
to (16:18).

The first query has no problem with #project# but the =
second one does.


Anyone seen this? Its a Eval version of CF server I'm =
going to install the single user server today.


Shawn Regan




--_=_NextPart_001_01BFA8B9.E4AB2F60--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: naming conflict?

[Dave Watts]

> the weirdest thing... i have three applications with the same
> lines of code in each application.cfm. the first two
> applications had no problem. the third application would crash
> every page load whining that it couldn’t assign a “symbol” to
> the application variable. after a scratching my head for half
> an hour, we restarted the CF service and had no further problem.
>
> ideas?

Nope, I haven't a clue, really. If I had to guess, I'd suspect some odd
memory allocation problem.

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: naming conflict?

[Mike Amburn]

> > is there issue with using the same name as both a key and a structure?
> > for example, notice the use of "foo":
> >
> > 
> >application.foo = StructNew();
> >application.foo.bar = true;
> >application.myVar = StructNew();
> >application.myVar.foo = false;
> > 
>
> There shouldn't be, although from a readability perspective it's probably
> not too helpful to reuse variable names even within different scopes. What
> happens when you try it?

the weirdest thing... i have three applications with the same lines of code
in each application.cfm. the first two applications had no problem. the
third application would crash every page load whining that it couldn’t
assign a “symbol” to the application variable. after a scratching my head
for half an hour, we restarted the CF service and had no further problem.

ideas?

mike

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

RE: Saving Files To Local Hard Drive

[Eric Duncan]

Erika,
Did you do that over a LAN or over the Internet?

Eric Duncan
BiggByte Software, Inc.
www.biggbyte.com

-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 5:31 PM
To: [EMAIL PROTECTED]
Subject: Re: Saving Files To Local Hard Drive

I've done this using .bat files to copy Word templates to the appropriate
directory.

Erika

- Original Message -
From: "Eric Duncan" <[EMAIL PROTECTED]>
To: "Cf-Talk@Houseoffusion. Com" <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 2:30 PM
Subject: Saving Files To Local Hard Drive


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Is there a way to save a file (.csv, .txt, etc.) to a users local hard
> drive, without the users intervention?
>
> Eric Duncan
> BiggByte Software, Inc.
> www.biggbyte.com
>
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>  xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> 
>  charset=3Diso-8859-1">
> 
> 
> 
> cid:[EMAIL PROTECTED]">
> 
> 
> 
> 
> 
>
> 
>
> 
>
>  color=3Dblack
> face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
> Arial'>Is there a way to save a file (.csv, .txt, etc.) to a users local =
> hard
> drive, without the users =
> intervention?
>
>  color=3Dblack
> face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
> Arial'> 
>
>  ont
> size=3D2 color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:
> 12.0pt;font-family:Verdana;color:black'>Eric Duncan size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black;mso-color-alt:windowtext'> an>
>
>  size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black'>BiggByte Software, =
> Inc. size=3D2 color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:
> 12.0pt;font-family:Verdana;color:black;mso-color-alt:windowtext'> :p>
>
>  size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black'>www.biggbyte.com color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><=
> /p>
>
>  color=3Dblack>  color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><=
> /p>
>
> 
>
> 
>
> 
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0--
>
> --

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


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

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

Re: CF and SQL Server split

[Jacob]

Should not be a problem.  Have SQL Server running on a seperate 
machine.  In the Cold Fusion administrator, create the datasource with the 
ip address of the sql server.  Also, create a user in sql server for cold 
fusion to use.  For example, create the user "internet" in the SQL server 
logins.  Use this user for cold fusion to connect to sql server when you 
create the datasource.

Jacob


At 04:44 PM 4/17/00 -0400, you wrote:
>I would really appreciate it of someone would give me a hand with this
>one...
>
>I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0.  I want to
>remove IIS and CF from that server and install it on a separate server.  The
>catch is that the two servers (both NT 4) are in different domains (not
>trusted).  Is there a way to connect the two machines so that the CF server
>can access the SQL data sources?  Caution: I am an intermediate that has
>never done cross-server or cross-domain communication.
>
>Thanks,
>
>Rob


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

Re: CF and SQL Server split

[Tinh Tran]

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

Hi
You can try to connect to SQL server as usual.  On ODBC page, under sql server name, 
use sql server IP (xxx.xxx.xxx.xxx) instead of server name (DB1).  Under username, use 
this
format  SQLDomainName\UserName and whatever the password for that user.

Tinh Tran
Event411.com


"Robert M. Saxon, Jr." wrote:

> I would really appreciate it of someone would give me a hand with this
> one...
>
> I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0.  I want to
> remove IIS and CF from that server and install it on a separate server.  The
> catch is that the two servers (both NT 4) are in different domains (not
> trusted).  Is there a way to connect the two machines so that the CF server
> can access the SQL data sources?  Caution: I am an intermediate that has
> never done cross-server or cross-domain communication.
>
> Thanks,
>
> Rob
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

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



Hi
You can try to connect to SQL server as usual.  On ODBC page,
under sql server name, use sql server IP (xxx.xxx.xxx.xxx) instead of server
name (DB1).  Under username, use this format  SQLDomainName\UserName
and whatever the password for that user.
Tinh Tran
Event411.com
 
"Robert M. Saxon, Jr." wrote:
I would really appreciate it of someone would give
me a hand with this
one...
I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0. 
I want to
remove IIS and CF from that server and install it on a separate server. 
The
catch is that the two servers (both NT 4) are in different domains
(not
trusted).  Is there a way to connect the two machines so that
the CF server
can access the SQL data sources?  Caution: I am an intermediate
that has
never done cross-server or cross-domain communication.
Thanks,
Rob
--
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.


--9A550CA2DEBD45E5C2E080F0--


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Saving Files To Local Hard Drive

[Erika Foster]

I've done this using .bat files to copy Word templates to the appropriate
directory.

Erika

- Original Message -
From: "Eric Duncan" <[EMAIL PROTECTED]>
To: "Cf-Talk@Houseoffusion. Com" <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 2:30 PM
Subject: Saving Files To Local Hard Drive


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Is there a way to save a file (.csv, .txt, etc.) to a users local hard
> drive, without the users intervention?
>
> Eric Duncan
> BiggByte Software, Inc.
> www.biggbyte.com
>
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>  xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> 
>  charset=3Diso-8859-1">
> 
> 
> 
> cid:[EMAIL PROTECTED]">
> 
> 
> 
> 
> 
>
> 
>
> 
>
>  color=3Dblack
> face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
> Arial'>Is there a way to save a file (.csv, .txt, etc.) to a users local =
> hard
> drive, without the users =
> intervention?
>
>  color=3Dblack
> face=3DArial> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
> Arial'> 
>
>  ont
> size=3D2 color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:
> 12.0pt;font-family:Verdana;color:black'>Eric Duncan size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black;mso-color-alt:windowtext'> an>
>
>  size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black'>BiggByte Software, =
> Inc. size=3D2 color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:
> 12.0pt;font-family:Verdana;color:black;mso-color-alt:windowtext'> :p>
>
>  size=3D2
> color=3Dblack face=3DVerdana> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
> font-family:Verdana;color:black'>www.biggbyte.com color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><=
> /p>
>
>  color=3Dblack>  color=3Dblack> style=3D'color:black;mso-color-alt:windowtext'><=
> /p>
>
> 
>
> 
>
> 
>
> --=_NextPart_000_0010_01BFA88A.4512B3B0--
>
> --

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

Saving Files To Local Hard Drive

[Eric Duncan]

This is a multi-part message in MIME format.

--=_NextPart_000_0010_01BFA88A.4512B3B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Is there a way to save a file (.csv, .txt, etc.) to a users local hard
drive, without the users intervention?

Eric Duncan
BiggByte Software, Inc.
www.biggbyte.com


--=_NextPart_000_0010_01BFA88A.4512B3B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40">






cid:[EMAIL PROTECTED]">










Is there a way to save a file (.csv, .txt, etc.) to a users local =
hard
drive, without the users =
intervention?

 

Eric Duncan

BiggByte Software, =
Inc.

www.biggbyte.com<=
/p>

 <=
/p>







--=_NextPart_000_0010_01BFA88A.4512B3B0--

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

[stäs]

Thanks, that worked!

At 04:42 PM 04/17/2000 -0400, Dave Watts wrote:
> > This gives me an error:
> >
> >  > dbtype="ODBC">
> > SELECT YEAR,
> >QUARTER,
> >REF_PERCENT,
> >sum(PRICE) AS tot_price,
> >sum(REF_RENUMERATION) AS tot_renum
> > FROM ORDER_AFFILIATE
> > WHERE AFF_ID = '#URL.RecordID#'
> > GROUP BY YEAR, QUARTER
> > 
>
>I think you'll have to group by REF_PERCENT as well.

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

[Dave Watts]

> is there issue with using the same name as both a key and a structure?
> for example, notice the use of "foo":
>
> 
>application.foo = StructNew();
>application.foo.bar = true;
>application.myVar = StructNew();
>application.myVar.foo = false;
> 

There shouldn't be, although from a readability perspective it's probably
not too helpful to reuse variable names even within different scopes. What
happens when you try it?

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.

naming conflict?

[Mike Amburn]

is there issue with using the same name as both a key and a structure?
for example, notice the use of "foo":


   application.foo = StructNew();
   application.foo.bar = true;
   application.myVar = StructNew();
   application.myVar.foo = false;



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: (event) CFSeattle.org: Wireless ColdFusion

[Won Lee]

I am interested in this topic as well. 

Anyone on this list already created CF Apps for cellies?

If so you can contact me off the list at [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: garbarge at top of .cfm pages

[Deanna L. Schneider]

Supposedly this is fixed in the latest update (4.5.1). Our admin hasn't
installed it yet, so can't say for sure. It tends to happen on macs running
IE.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
302 Hiram Smith
1545 Observatory Dr.
Madison, WI 53706
(608) 265-7923



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

garbarge at top of .cfm pages

[Ken Zey]

This is a multi-part message in MIME format.
--26BE8D0ADC6E4F8853E0B670
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I am getting garbage of the following type at the top of cfm pages:

Page-Completion-Status: Normal Set-Cookie: CFID=11951; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie:
CFTOKEN=55300633;expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/;
Connection: close

This seems to have started after I installed 4.5 on the server. It does
not show up on all computers that view the same page, and does not
always show up... in fact I can't determine the pattern.  Two of the
three 4.5 cfservers I have set up exibit this behavior and it sometimes
seems related to the use of cfstudio in that the machine that develops
the pages using studio sees the garbarge but another one accessing that
server does not.


Anyone have any idea where to look.

--26BE8D0ADC6E4F8853E0B670
Content-Type: text/x-vcard; charset=us-ascii;
 name="ken.zey.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ken Zey
Content-Disposition: attachment;
 filename="ken.zey.vcf"

begin:vcard 
adr;dom:;;205 N 13th Street  Rogers, AR  72756;Rogers, AR;;;
n:Zey;Ken
x-mozilla-html:FALSE
org:Greenfield Industries
version:2.1
email;internet:[EMAIL PROTECTED]
title:System Manager
tel;fax:501-619-4877
tel;work:501-621-4777
x-mozilla-cpt:;0
fn:Ken Zey
end:vcard

--26BE8D0ADC6E4F8853E0B670--

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

[Dave Watts]

> This gives me an error:
> 
>  dbtype="ODBC">
> SELECT YEAR,
>QUARTER,
>REF_PERCENT,
>sum(PRICE) AS tot_price,
>sum(REF_RENUMERATION) AS tot_renum
> FROM ORDER_AFFILIATE
> WHERE AFF_ID = '#URL.RecordID#'
> GROUP BY YEAR, QUARTER
> 

I think you'll have to group by REF_PERCENT 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.

CF and SQL Server split

[Robert M. Saxon, Jr.]

I would really appreciate it of someone would give me a hand with this
one...

I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0.  I want to
remove IIS and CF from that server and install it on a separate server.  The
catch is that the two servers (both NT 4) are in different domains (not
trusted).  Is there a way to connect the two machines so that the CF server
can access the SQL data sources?  Caution: I am an intermediate that has
never done cross-server or cross-domain communication.

Thanks,

Rob

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

cfmail error

[Tim Bahlke]

I am getting the following error message when I try to use cfmail.  Can
someone share with me what his means?
unknown exception condition
TagCFMail::sendMessage
Thanks
Tim




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

help with query

[stäs]

Guys,

This gives me an error:


SELECT YEAR,
   QUARTER,
   REF_PERCENT,
   sum(PRICE) AS tot_price,
   sum(REF_RENUMERATION) AS tot_renum
FROM ORDER_AFFILIATE
WHERE AFF_ID = '#URL.RecordID#'
GROUP BY YEAR, QUARTER



The error:

Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-00979: not a GROUP BY 
expression
Data Source = "REISDB"
The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (9:1) to (9:73).


Any ideas? Thanks!

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

Re: with multiple values pre-selected problem

[B.Cravens]

Nope.  You'll have to do it using  and  tags.. wrap a
cfoutput around .. and make it selected ()
according to whatever conditionality you need.

Billy

- Original Message -
From: "Jeff Trull" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 1:57 PM
Subject:  with multiple values pre-selected problem


Is there a way to load a CFSELECT box with multiple values preselected when
querying from a table?

This structure returns one value preselected?

  
  

If anyone can help please post to the list or email me directly at
[EMAIL PROTECTED]

Thanks,
Jeff


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

[Michael Imhoff]

http://www.onProject.com is a great system and it's done in fusebox.

It's worth a look and if you have any specific questions, let me know.

Hope that helps,
-Michael


Michael Imhoff  www.omnicypher.com  icq: 10495667
[EMAIL PROTECTED] (home)  (320) 255-4447 (home)
[EMAIL PROTECTED] (cell)  (612) 247-8159 (cell)
Allaire Alliance Consulting Partner


- Original Message -
From: "Jennifer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 2:37 PM
Subject: CF project management prepackaged solution?


> Does anyone know of any CF based project management solutions and if so,
> any recommendations? (I'm trying to avoid purchasing an MS product.)
Thanks!
> --

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

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

RE: CF project management prepackaged solution?

[Jennifer]

I think we'd rather have something that would run on the server that is 
already dedicated and used as our intranet server. But thanks for the 
information!

Jennifer

At 03:41 PM 4/17/00 -0400, you wrote:
>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_01BFA8A5.01CAF854
>Content-Type: text/plain;
> charset="iso-8859-1"
>
>http://www.webperfect.com/intranet
>
>CF Based WAP Compliant / Web-based Intranet Solution including Project
>Management, PIM, Document Library, and Forms Management.
>
>Check it out!
>
>-Original Message-
>From: Jennifer [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 17, 2000 3:38 PM
>To: [EMAIL PROTECTED]
>Subject: CF project management prepackaged solution?
>
>
>Does anyone know of any CF based project management solutions and if so,
>any recommendations? (I'm trying to avoid purchasing an MS product.) Thanks!

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

Re: When are Form Variables created

[B.Cravens]

No, the link will take precedence over the onClick.  Since the form never
gets submitted, no form variables will be created.  If you want a regular
anchor to trigger the form submit, then use this instead:
Submit.

--
Billy Cravens
[EMAIL PROTECTED]


- Original Message -
From: "Miriam Hirschman" <[EMAIL PROTECTED]>
To: "CF Forum" <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 2:06 PM
Subject: When are Form Variables created


HI,

Are Form variables created, by calling the submit method using
JavaScript,like in the code below??


Submit
Thanks,

---miriam


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

Calendar: is there a good free one!

[Paul Ihrig]

Hello!
Have been messing around with others generous code.
But am looking for a better solution.

All i need is a good calendar [that is Free]
That allows users to post info to days of the week, recurrences
would be nice.
and a little bit of an admin page that lets some on delete bad
posts, if possible.

I have looked at most the cf_tags at allaire as well as some posts
that have been returned from the forums.
have looked at eventCalendar & InstaCalendar.

so if you have seen something better
i would appreciate it greatly.

have a good day.
-paul
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: reading cookies (Am I being black-balled?)

[light-years.com]

turning on debugging in CF Admin will give you access to all your CGI
Variables... very handy when trying to determine value of your cookie
and much more. I just turn em on for my IP address only.

-mike

> -Original Message-
> From: Lon Lentz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 17, 2000 12:04 PM
> To: [EMAIL PROTECTED]
> Subject: RE: reading cookies (Am I being black-balled?)
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 17, 2000 2:55 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: reading cookies (Am I being black-balled?)
>
> On a slightly off-topic note, you can see that it's
> valuable at times to be
> able to see and understand what's going on "under the HTTP
> covers". The Perl
> script I used for this example lets you do this very
> easily, and it's
> available at http://www.compansr.demon.co.uk/. Enjoy!
>
>
>
>
>   I will give it a try. Thanks.
>
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to [EMAIL PROTECTED]
with 'unsubscribe' in the body.


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

Re: Dynamic Image Display, Tables

[Curtis Layton]

The Code:


Other Content


Here's the red line graphic.






   

 





 


Supposed to meet with the Header Graphic here..










- Original Message -
From: "Seth Petry-Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 3:28 PM
Subject: Re: Dynamic Image Display, Tables


> >This is a multi-part message in MIME format.
>
> 
> >
> >
> >>BACKGROUND=3D"#URLPrefix#images/common/redline.gif">
> >>HEIGHT=3D"5"> 
> >   
> >  
> > 
> 
>
> I don't know about anyone else, but I don't feel like spending the effort
to
> decipher the actual code from the convoluted mess above.  Could you please
> re-post the code using PLAIN TEXT rather than HTML formatted email?  Not
> only does the HTML encoding result in the mess you see above but it also
> wastes bandwidth.
>
> Regards,
> Seth Petry-Johnson
> Argo Enterprise and Associates
>
> --

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

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

RE: CF project management prepackaged solution?

[Padraig I.J. Burns]

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_01BFA8A5.01CAF854
Content-Type: text/plain;
charset="iso-8859-1"

http://www.webperfect.com/intranet  

CF Based WAP Compliant / Web-based Intranet Solution including Project
Management, PIM, Document Library, and Forms Management.

Check it out!

-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 3:38 PM
To: [EMAIL PROTECTED]
Subject: CF project management prepackaged solution?


Does anyone know of any CF based project management solutions and if so, 
any recommendations? (I'm trying to avoid purchasing an MS product.) Thanks!

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

--_=_NextPart_001_01BFA8A5.01CAF854
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: CF project management prepackaged solution?



http://www.webperfect.com/intranet" =
TARGET=3D"_blank">http://www.webperfect.com/intranet  &nbs=
p;   


CF Based WAP Compliant / Web-based Intranet Solution =
including Project Management, PIM, Document Library, and Forms =
Management.

Check it out!


-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 3:38 PM
To: [EMAIL PROTECTED]
Subject: CF project management prepackaged =
solution?



Does anyone know of any CF based project management =
solutions and if so, 
any recommendations? (I'm trying to avoid purchasing =
an MS product.) Thanks!
---=
---
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_01BFA8A5.01CAF854--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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 project management prepackaged solution?

[Jennifer]

Does anyone know of any CF based project management solutions and if so, 
any recommendations? (I'm trying to avoid purchasing an MS product.) Thanks!
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Dynamic Image Display, Tables

[Seth Petry-Johnson]

>This is a multi-part message in MIME format.


>
>
>   BACKGROUND=3D"#URLPrefix#images/common/redline.gif">
>   HEIGHT=3D"5"> 
>   
>  
> 


I don't know about anyone else, but I don't feel like spending the effort to
decipher the actual code from the convoluted mess above.  Could you please
re-post the code using PLAIN TEXT rather than HTML formatted email?  Not
only does the HTML encoding result in the mess you see above but it also
wastes bandwidth.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

RE: [slight OT] Using Triggers

[Dave Watts]

> in my shopping cart check out process, once an order
> has been recorded, i want to update the stock levels
> of my inventory too.
>
> i'm thinking of using triggers, so that if there is
> not enough stock, the trigger should raise an error
> (i'm using MSSQL7). in this case, how can ColdFusion
> know that the error is "out of stock" and the product
> ID of the error?

If your trigger returns a recordset, the CFQUERY tag which caused the
trigger to fire will receive that recordset. So, you could write a trigger
that returns a value using a SELECT statement, and read that value from CF.

Since you're using SQL Server 7, you might want to try doing this in a
stored procedure, as there's generally less overhead involved with stored
procedures than triggers. Also, with a stored procedure, you could return a
value instead of a recordset, and read that value without the overhead
involved with recordsets.

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: Oracle Stored Proc - Included Code...

[Olive, Christopher M Mr USACHPPM]

oh.  you can't use DB_VARNAME with a native driver.  i was reading up on
this matter in the KB.  someone mentioned this (in a Forum post, actually).

try removing the DBVARNAMe parameter to the SP.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 2:42 PM
To: [EMAIL PROTECTED]
Subject: Oracle Stored Proc - Included Code...


I've included my code this time. I'm sure it's something easy but I dont'
know what.

Thank you!

Scott Rowe

Oracle stored proc:

Create Procedure usercheck
 (UserID IN NUMBER, TimeLastVisit OUT VarChar2)
AS
 BEGIN
 --check for a user--
 Select To_Char(TimeLastVisit,'-mm-dd HH24:mi:ss')
 INTO TimeLastVisit
 FROM UsersLoggedIn
 WHERE UserID = UserID;
EXCEPTION
 When NO_DATA_FOUND
 THEN TimeLastVisit := 0;
END;









This is the error:

Oracle Error Code = 1036

ORA-01036: illegal variable name/number


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

When are Form Variables created

[Miriam Hirschman]

HI,

Are Form variables created, by calling the submit method using
JavaScript,like in the code below??


Submit
Thanks,
 
 ---miriam

--
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: reading cookies (Am I being black-balled?)

[Lon Lentz]

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 2:55 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: reading cookies (Am I being black-balled?)

On a slightly off-topic note, you can see that it's valuable at times to be
able to see and understand what's going on "under the HTTP covers". The Perl
script I used for this example lets you do this very easily, and it's
available at http://www.compansr.demon.co.uk/. Enjoy!




  I will give it a try. Thanks.

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

RE: reading cookies (Am I being black-balled?)

[Dave Watts]

>   It seems then that I assumed too much. I figured if CF
> writes it, then CF should have access to all of it. If the
> client sends the cookie back with every http request, CF
> should have a way of accessing the cookie's attributes.

The client doesn't send everything back - it only returns the name and
value - so that's all you can see from CF. Here's a sample HTTP request
header from my browser, as seen through a nifty little Perl proxy script:

 --> C06 --> S07 GET /figleafhome/images/menu_right.GIF HTTP/1.1
 --> C06 --> S07 Accept: */*
 --> C06 --> S07 Referer:
http://localhost:8080/figleafhome/menu.cfm?location=1
 --> C06 --> S07 Accept-Language: en-us
 --> C06 --> S07 Accept-Encoding: gzip, deflate
 --> C06 --> S07 User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT
5.0)
 --> C06 --> S07 Host: localhost:8080
 --> C06 --> S07 Connection: Keep-Alive
 --> C06 --> S07 Cookie: CLIENT_ID=1; CFID=99367; CFTOKEN=28414731
 --> C06 --> S07  Body was 0 bytes

You'll notice that there's a single header, Cookie, which lists name-value
pairs. That's all the browser sends back to the server.

On a slightly off-topic note, you can see that it's valuable at times to be
able to see and understand what's going on "under the HTTP covers". The Perl
script I used for this example lets you do this very easily, and it's
available at http://www.compansr.demon.co.uk/. Enjoy!

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.

with multiple values pre-selected problem

[Jeff Trull]

Is there a way to load a CFSELECT box with multiple values preselected when querying 
from a table?

This structure returns one value preselected?

  
  

If anyone can help please post to the list or email me directly at [EMAIL PROTECTED]

Thanks,
Jeff

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

Dynamic Image Display, Tables

[Curtis Layton]

This is a multi-part message in MIME format.

--=_NextPart_000_0067_01BFA87C.7480EA80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I'm having a problem with our page header in which I am trying to =
dynamically display a redline to meet another graphic.  This works fine =
in IE5, but Netscape doesn't want to accept it.  Any suggestions are =
appreciated.

The Code:


Other Content


Here's the red line graphic.



   
    
   
  
 


Supposed to meet with the Header Graphic here..








Tia,

Curt

Curtis C. Layton
Web Applications Developer
Words In Progress, Inc.
(410) 667-4986
[EMAIL PROTECTED]
http://www.wordsinprogress.com

--=_NextPart_000_0067_01BFA87C.7480EA80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi,
I'm having a problem with our page =
header in=20
which I am trying to dynamically display a redline to meet another=20
graphic.  This works fine in IE5, but Netscape doesn't want to =
accept=20
it.  Any suggestions are appreciated.
 
The Code:
 

Other =
Content
 
 
Here's the red line =
graphic.
 
  &n=
bsp;  &n=
bsp;    <=
;/TABLE>   <=
/DIV>
 
Supposed to meet with the Header =
Graphic=20
here..
 
    

 

 
Tia,
 
Curt
 
Curtis C. LaytonWeb Applications=20
DeveloperWords In Progress, Inc.(410) 667-4986mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
http://www.wordsinprogress.com">http://www.wordsinprogress.com

--=_NextPart_000_0067_01BFA87C.7480EA80--

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

[Chris Giminez]

I just asked Allaire this question and was told maybe in a month.


Chris Giminez




> Hy!
>
> When can we expect CF Express for Linux?
>
> Lep pozdrav,
>
> Iztok
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>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 Express for Linux

[Iztok Polanic]

Hy!

When can we expect CF Express for Linux?

Lep pozdrav,

Iztok

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

[Scott Rowe]

I've included my code this time. I'm sure it's something easy but I dont'
know what.

Thank you!

Scott Rowe

Oracle stored proc:

Create Procedure usercheck
 (UserID IN NUMBER, TimeLastVisit OUT VarChar2)
AS
 BEGIN
 --check for a user--
 Select To_Char(TimeLastVisit,'-mm-dd HH24:mi:ss')
 INTO TimeLastVisit
 FROM UsersLoggedIn
 WHERE UserID = UserID;
EXCEPTION
 When NO_DATA_FOUND
 THEN TimeLastVisit := 0;
END;









This is the error:

Oracle Error Code = 1036

ORA-01036: illegal variable name/number

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: A Good CF Host Has What?

[pardeep]

Try www.abihosting.com - they are not only very reasonable on price and 
also very good on the cust support. Another good feature is you get SQL 7 
ODBC connection included in the price.

At 09:39 AM 4/17/2000 -0700, you wrote:
> > I'm curious what people find to be important in a host.  But not only that,
> > but how difficult those things are to implement.  To me, I would think that
> > having enough bandwidth is a problem a host can easily fix with money
> > (getting a OC-12 instead of a T-3, etc.).  But I would think something are
> > more difficult to implement, like good customer service.
>
> I just want best bang for the buck. 100Megs+, coupla ODBC sources,
>webtrends, decent amount of traffic allocation, etc... For $20/mo or less.
>That's primary. And secondly, I don't expect lightning fast support
>response. But an answer in 24 hrs is more than reasonable.
>
>
>
>   Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515
>  TIBCO Finance Technology - Web Group - Senior Web Engineer
>  Work: 650-461-3472   Pager: 800-759-x1702632   Fax: 650-461-3003
>  3375 Hillview Avenue. Palo Alto, CA. 94304.
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>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 Stored Proc - In/Out Variable example

[Olive, Christopher M Mr USACHPPM]

http://www.allaire.com/handlers/index.cfm?ID=8353&Method=Full&PageCall=/supp
ort/index.cfm

this is the KB article on the process.  it's kind of vague, but i used it as
a template for my own SPs in Oracle 8i.  ( i just started working on them a
few days ago. )

BTW, the mysterious "maxrows" parameter to CFSTOREDPROC param is
undocumented.  it shows up in the error message if you have strict attribute
checking turned on in your CF Admin, but nowhere is it actually documented.


if you have any questions, feel free to contact me on/off list.  it's a
subject that i think Allaire should have given more thought to when they
released CF.  (of course, i think 4.5.1 fixes it.  but we ALL can't have the
latest version (at least that's what my manager says...)).

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 1:43 PM
To: CF-Talk
Subject: Oracle Stored Proc - In/Out Variable example


Does anyone have an example of an Oracle stored proc with in/out values and
the example Code to go with it. I keep getting errors such as illegal
variable name/number  OR wrong number or types of arguments in call to
'USERCHECK' ORA-06550: line 1, column 7: PL/SQL: Statement ignored. I'm
stuck and I'm a novice with Oracle. Please help.

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: reading cookies (Am I being black-balled?)

[Lon Lentz]

> From: Dave Watts [mailto:[EMAIL PROTECTED]]
>
>> Then Allaire's Fast Track training book is rather misleading. It
>> states that you can access a cookie through that convention.
>
> I'm kind of curious where it says that; I've been teaching the course for
> the last couple of years, but haven't seen anything that I'd interpret to
> mean that a cookie has more than one property - its value - available. In
> any case, from the CF perspective, cookies are simply a scope to which
> simple variables may belong.


  It seems then that I assumed too much. I figured if CF writes it, then CF
should have access to all of it. If the client sends the cookie back with
every http request, CF should have a way of accessing the cookie's
attributes.

  Page 11-5: "...You would access a cookie simply by using it and prefixing
it with the Cookie  prefix."

  There's nothing there stipulating that the attribute values (other than
name and value) are not available. Perhaps adding the word "value" or
"variable" after cookie above might have made it a little clearer. Or an
outright statement that the other 4 attributes are write only.

  Silly me.


Lon Lentz
Applications Developer - GetLists.Com
DataWarehousing and List Sales - Market your lists on the Net!
[EMAIL PROTECTED]
941-541-9000 Ext. 210

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

[mherbene]

There is another archive, though it only has recent messages, here:

[EMAIL PROTECTED]

-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 2:07 PM
To: [EMAIL PROTECTED]
Subject: Re: Archives disappeared at egroups?


If I remember correctly (and I make no guarantees about that) we reached 
our size quota about that time.I believe M. Dinowitz (or somebody else 
around here-- there are only so many things that I can remember in detail) 
is working on a new system but it is not yet in place.

At 02:09 PM 4/17/00 +0200, you wrote:
>Very good.
>I watched the same.
>And also if I go via eGroups directly to CF-Talk it is not showing the very
>last messages of this mailing-list forum.
>The last messages are from January.
>
>Uwe
>
>SD Solutions
>Uwe Degenhardt
>Fon: 08122/903791
>Fax: 08122/903792
>Web: www.sdsolutions.de
>E-Mail: [EMAIL PROTECTED]
>- Original Message -
>From: "Chris Tazewell" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, April 17, 2000 1:17 PM
>Subject: Archives disappeared at egroups?
>
>
>Anyone know what happened to the CF-Talk archive at houseoffusion
(egroups)?
>
>Cheers
>Taz
>
>---
-
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>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: Reading the Type of a Row?

[Seth Petry-Johnson]

>Let's say I have a date/Time field in the database I could automatically
>use a function that uses the appropriate Formatting in CF. Or I have a
>Memofield wich should create an textarea in a form?

I don't know if you can get the info from SQL or not, but I have done
something like this with great success.

I created a table with the following fields (well, almost... I've left most
of the advanced things out... trade secrets and all )

.FieldName
.DataType
.InputType

This table has a record for each field in a products table.  Using the
DataType (text, integer, real, etc) and InputType (text box, text area, etc)
I wrote some very generic code that dynamically displays a form and handles
the insert, delete, and update requests from that form.

This works great in that by simply changing the data in the "config" table I
can use this same form and insert/update code on just about any site.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

Re: Archives disappeared at egroups?

[Jennifer]

If I remember correctly (and I make no guarantees about that) we reached 
our size quota about that time.I believe M. Dinowitz (or somebody else 
around here-- there are only so many things that I can remember in detail) 
is working on a new system but it is not yet in place.

At 02:09 PM 4/17/00 +0200, you wrote:
>Very good.
>I watched the same.
>And also if I go via eGroups directly to CF-Talk it is not showing the very
>last messages of this mailing-list forum.
>The last messages are from January.
>
>Uwe
>
>SD Solutions
>Uwe Degenhardt
>Fon: 08122/903791
>Fax: 08122/903792
>Web: www.sdsolutions.de
>E-Mail: [EMAIL PROTECTED]
>- Original Message -
>From: "Chris Tazewell" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, April 17, 2000 1:17 PM
>Subject: Archives disappeared at egroups?
>
>
>Anyone know what happened to the CF-Talk archive at houseoffusion (egroups)?
>
>Cheers
>Taz
>
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>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: HOLY COW!

[Jennifer]

Maybe it's beer:30 everywhere? Everyone alter your brain chemistry or your 
water balance and relax!

At 10:48 PM 4/16/00 -0700, you wrote:
>I have no idea, but there seems to be a lot of rules and a lot of sensitive
>people on all the lists as of late.
>
>- Original Message -
>From: "Kevin R. Merker" <[EMAIL PROTECTED]>
>To: "cf-talk" <[EMAIL PROTECTED]>
>Sent: Sunday, April 16, 2000 4:47 PM
>Subject: HOLY COW!
>
>
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_0036_01BFA7FE.291902E0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> >
> > Everyone take a chill pill. I don't think it's a full moon? =
> > What' Uppp!
> >
> > KM=20
> >
> >
> > --=_NextPart_000_0036_01BFA7FE.291902E0
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 
> > 
> >  > http-equiv=3DContent-Type>
> > 
> > 
> > 
> > 
> >  
> > Everyone take a chill pill. I don't think it's a full moon?=20
> > What' Uppp!
> >  
> > KM 
> >  
> >
> > --=_NextPart_000_0036_01BFA7FE.291902E0--
> >
> > --
>
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>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.

Oracle Stored Proc - In/Out Variable example

[Scott Rowe]

Does anyone have an example of an Oracle stored proc with in/out values and
the example Code to go with it. I keep getting errors such as illegal
variable name/number  OR wrong number or types of arguments in call to
'USERCHECK' ORA-06550: line 1, column 7: PL/SQL: Statement ignored. I'm
stuck and I'm a novice with Oracle. Please help.

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: reading cookies (Am I being black-balled?)

[Dave Watts]

> > As you saw, what Lon wrote is incorrect.  Cookie.expires refers to a
> > cookie named expires, not to the 'expires' property of a cookie.
> >
> > On Fri, 14 Apr 2000 23:14:06 -0400 Bud <[EMAIL PROTECTED]>
> > writes:
> > On 4/14/00, Lon Lentz penned:
> > >  Just refer to the name of the attribute you want to use -
> > >#cookie.name_of_attribute#
> >
> > That doesn't work. cookie.expires returns an error.
> > cookie.cookiename.expires returns an error.
>
> Then Allaire's Fast Track training book is rather misleading. It
> states that you can access a cookie through that convention.

I'm kind of curious where it says that; I've been teaching the course for
the last couple of years, but haven't seen anything that I'd interpret to
mean that a cookie has more than one property - its value - available. In
any case, from the CF perspective, cookies are simply a scope to which
simple variables may belong.

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.

Reading the Type of a Row?

[Urs Nyffenegger]

Hi all

I try to ease my work a bit, and I came across an idea, that, if
possible, would help my abstraction of code a little bit more:

Is it possible with CF/SQL to know for each row what type of data it
expects/contains?
Let's say I have a date/Time field in the database I could automatically
use a function that uses the appropriate Formatting in CF. Or I have a
Memofield wich should create an textarea in a form?


??

/later

--
urs nyffenegger|   new media developer
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
NO INK AG - Ihr Partner für Neue Medien
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
http://www.noink.ch   |  ++41 56 618 30 02


--
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: Native SQL Server driver?

[Dave Watts]

> ODBC certainly isn't anywhere near native SQL support - it is
> a generic middleware datasource driver - and although OLEDB is
> closer, it still isn't native SQL. OLEDB drivers are available
> for numerous applications including the Access Jet Engine just
> like ODBC.
>
> Nearer to native still would be be by using the SQL DB-LIB
> API for CF to talk to SQL Server.

Microsoft provides lots of APIs to connect to databases (DB-Library, RDO,
ADO, etc), but none of these is more "native" than OLEDB. Native doesn't
necessarily mean lowest-level, it means the method that the vendor defines
as native. Microsoft has declared this to be OLEDB. If you use the data
transfer tools inside of Enterprise Manager, you'll connect via OLEDB. The
fact that OLEDB providers are available for other platforms is also
unimportant.

After all, if you look at native drivers for other platforms, you face the
same availability of alternatives. If you connect natively to Oracle 8i, CF
simply communicates directly with the Net8 client, which itself is analogous
to OLEDB. I'd guess that the SQL Plus client talks at a lower level than
Net8. When you connect to SQL Server 7 using ODBC, CF talks to ODBC, which
talks to OLEDB. Using OLEDB instead of ODBC cuts out the middleman, so to
speak.

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: What's the difference between...

[Seth Petry-Johnson]

>I guess I'm trying to ask, if CFMODULE allows you to put tags somewhere
>other than
>   - in the same directory as the calling template, or
>   - in the CustomTags directory
>is there any "price" to pay in calling it via CFMODULE instead of as a
>custom tag?


I prefer to use the CFMODULE syntax for application/site specific custom
tags for two reasons:
1) The CustomTags directory is not cluttered up with tags that relate to
only one site
2) Its easier to move the site from server to server without having to worry
about copying portions of the CustomTags directory.  Obviously, when writing
portable "modules" this is a big plus.

I place very generic tags that might be used across numerous sites in the
CustomTags directory and call them with the CF_ syntax.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

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

RE: Changing Domain Names

[jstiefel]

Cgi.Server_Name should give you the info you're looking for...

-Original Message-
From: Andrew C. Davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 1:30 PM
To: Cold Fusion List
Subject: Changing Domain Names


I've changed domain names one my sites from www.site1.com to
www.site2.com. Currently www.site1.com and www.site2.com both point to
the same site.

What I want to do is prompt a user who comes into my site from the
original url (www.site1.com) to update their bookmarks to the new url.  

I know there is a real simple solution to this, but I want to find out
what some others have done.  Any ideas?
 
Andrew C. Davis 
[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.

Changing Domain Names

[Andrew C. Davis]

I've changed domain names one my sites from www.site1.com to
www.site2.com. Currently www.site1.com and www.site2.com both point to
the same site.

What I want to do is prompt a user who comes into my site from the
original url (www.site1.com) to update their bookmarks to the new url.  

I know there is a real simple solution to this, but I want to find out
what some others have done.  Any ideas?
 
Andrew C. Davis 
[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: next 5 records

[Steve Dworman]

This is a multi-part message in MIME format.

--=_NextPart_000_0013_01BFA870.6E046AD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



-Original Message-
From: Akbar Pasha [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 3:31 AM
To: '[EMAIL PROTECTED]'
Subject: next 5 records


hi everybody,

this may look silly but i have a small problem. i hvae a query and for the
first time i want to display 5 records and on pressing the next button it
should show next 5 records...and so on. i remember seeing a solution for
this long back but i forgot. so, can anyone plzz send me the code??

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.

--=_NextPart_000_0013_01BFA870.6E046AD0
Content-Type: application/octet-stream;
name="NEXTN.CFM"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="NEXTN.CFM"





Next-N example with caching











SELECT  LastName, FirstName
FROM Employees=20
ORDER BY  LastName, FirstName


Number of rows:  #GetEmp.RecordCount#



#GetEmp.FirstName# #GetEmp.LastName#






Previous






Previous




   





Next


Next













--=_NextPart_000_0013_01BFA870.6E046AD0--

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

RE: What's the difference between...

[Dave Watts]

> Is calling a custom tag by  any more efficient
> or inefficient (in terms of memory, processor overhead,
> etc) than calling it by ?

I don't know. I've heard opinions on both sides, but haven't seen any
definitive, universal evidence which is faster, and in any case, the
performance differences seem to be minimal.

> I guess I'm trying to ask, if CFMODULE allows you to put tags
> somewhere other than
>- in the same directory as the calling template, or
>- in the CustomTags directory
> is there any "price" to pay in calling it via CFMODULE instead of
> as a custom tag?

One price, from a perspective other than performance, is that it makes the
coding of nested custom tags a bit harder, when those nested tags
communicate with the parent tags using CFASSOCIATE or the GetBaseTagData
function.

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.

maintaining decimal place

[Jay Wigginton]

I am having trouble for some reason with having data entered via a form into
an Access database  and keeping the decimal places entered in place...
person enters 2.5 the database rounds it to 2...  if I set the database to
number, type double... it maintains the decimal places but then CF displays
all the numbers entered with a decimal place and a zero added...  2.5
entered displays as 2.5 181 entered displays as 181.0I have never
had this problem before that I can remember   Am I losing my mind here
and just not doing something right?

thanks
Jay

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: A Good CF Host Has What?

[Tariq Ahmed]

> I'm curious what people find to be important in a host.  But not only that,
> but how difficult those things are to implement.  To me, I would think that
> having enough bandwidth is a problem a host can easily fix with money
> (getting a OC-12 instead of a T-3, etc.).  But I would think something are
> more difficult to implement, like good customer service.

I just want best bang for the buck. 100Megs+, coupla ODBC sources,
webtrends, decent amount of traffic allocation, etc... For $20/mo or less.
That's primary. And secondly, I don't expect lightning fast support
response. But an answer in 24 hrs is more than reasonable.



  Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515
 TIBCO Finance Technology - Web Group - Senior Web Engineer
 Work: 650-461-3472   Pager: 800-759-x1702632   Fax: 650-461-3003
 3375 Hillview Avenue. Palo Alto, CA. 94304.

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

[Deanna L. Schneider]

Hm...interesting idea, Kevin. Thanks.
-Deanna



Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
302 Hiram Smith
1545 Observatory Dr.
Madison, WI 53706
(608) 265-7923



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

[Tariq Ahmed]

Wow, I'm actually impressed. Good bang for the buck.

On Sat, 15 Apr 2000, Todd Ashworth wrote:

> Our company is also getting into the hosting game.  We are new to the field,
> but not inexperienced.  We are new enough that we don't have any hard and
> fast rules.  We will work with you to give you exactly what you need at not
> much cost.  We have a full, almost completely 'unused' T1 and all of our
> equipment is located in house, which I personaly administer and maintain,
> 24/7.  I don't really want to spam the group with all of our specs, so if
> you want any more info, Email me at [EMAIL PROTECTED]  I'll see if we can
> do what you want and if we can, we can probably cut you a deal.
> 
> or,
> 
> Take a look at www.prizmweb.com  They offer a lot for the money.  I can't
> really comment on support since I have only needed any 2 times total, but
> for those 2 times, I got a satisfactory answer within 24 hours.  I use them
> for my personal stuff, so as to avoid 'taking advantage' of company assets.
> Only complaint is that sometimes they are a *little* slow, but that just may
> be my RTH .. I dunno.  It's never been that big of a deal.
> 
> Todd
> 
> - Original Message -
> From: Tariq Ahmed <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 14, 2000 9:46 PM
> Subject: RE: WebHosting
> 
> 
> >
> >
> > Ya unfortunately I found out about the CFOBJECT disabled thing
> > after I signed up. And I emailed them explaining they're being paranoid
> > for no reason. They were like whatever.
> >
> > But there are few CF 4.0 sites that give you 100megs, unlim ODBC
> > sources, unlim traffic for $15/mo. So I was going for the most I could get
> > for $15/mo or less.
> >
> > Check out www.builder.com from CNET. Let's you search for web
> > hosting companies based on certain criteria (CF, perl, traffic
> > limitations, etc...).
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
> 


  Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515
 TIBCO Finance Technology - Web Group - Senior Web Engineer
 Work: 650-461-3472   Pager: 800-759-x1702632   Fax: 650-461-3003
 3375 Hillview Avenue. Palo Alto, CA. 94304.

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

[Kevin Marshall]

Deanna,

It looks like you are trying to perform a left outer join between a single 
table on the left and two inner joined tables on the right.  If that's the 
case, I've tried to do this several times - also in Access - and never 
gotten it to work.  There is a workaround, though.  Whether you consider it 
advisable is up to you.

You can create a query _in_Access_ that performs the inner join and then 
reference the Access query as a table.  Works pretty slick and doesn't seem 
to negatively affect performance.  The downside is that you are stuck with 
the Access query which you gotta remember to have in your database (if you 
have multiple copies...dev & prod, etc.) and which you may have to change 
to add/remove fields in the future.

Hope this helps, I'll be watching the thread for other, wiser ideas.

Kevin

At 11:26 AM 4/17/00 -0500, you wrote:
>This is slightly off topic, but I'm sure there are sql gurus out there who
>know how to do this.
>
>I'm trying to join three tables (category, subcat, catrelation), pulling all
>records from category, and using the  tag to output
>the results, so that if someone chooses a category, the second select box is
>populated with the appropriate subcategories. I have it working when I don't
>care if the categories that don't have subs are included. But I do care! So,
>how do I get this to work in one query that I can reference in the custom
>tag?
>
>Oh yah, and this is in access right now. The error I get is "join type not
>supported." I've already tried going back to access to create the query, and
>it basically tells me I have to do it in two queries
>
>Grrr. Frustrated.
>
>
>SELECT c.cat_id, c.cat_name, s.subcat_id, s.subcat_name
>FROM category c left outer join catrelation r on c.cat_id = r.cat_id, subcat
>s
>WHERE c.cat_id = r.cat_id AND
>   s.subcat_id = r.subcat_id
>
>
>THanks!
>-d
>
>
>Deanna Schneider
>Interactive Media Developer
>UWEX Cooperative Extension Electronic Publishing Group
>302 Hiram Smith
>1545 Observatory Dr.
>Madison, WI 53706
>(608) 265-7923

--
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500

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

Cold Fusion Studio 4.0

[andrew m kneisler]

--openmail-part-0aa2bc92-0001
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: Quoted-Printable
Content-Disposition: inline

Has anyone found a good retail place to buy Cold Fusion Studio 4.0 or
4.5???
=A0

Andrew Kneisler=20
BNMD/ODS User Interface Team
Phone: 913-315-6583=20
[EMAIL PROTECTED]=20

=A0


--openmail-part-0aa2bc92-0001--

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

[Reid Philpot]

I am that "London Developer" and can't agree more with what Scott has said
(and I'm not saying this just because he's my boss), Perforce is a wonderful
product which has made a potentially difficult situation very easy. Other
great features include being able to skip back to previous changes in the
documents history so you can eradicate any error your boss may have made.
:-)

-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 5:11 PM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


Yep, it does work that way. I work with another developer in London and due
to our combined laziness, I mean time-zone difference, this program allows
him to not have to wait for me to get in so he can change something. It's
really easy to merge the differences as well. It can even auto-merge for you
which I've heard is pretty accurate but I'm afraid to try. When you merge it
will show you the original page code and your changes in one color, the
other persons changes in another one. You can then easily merge the two
together. Or you can viciously overwrite all their changes. :-)

Scott

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:59 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


Actually, it does a bit compare and can merge the edited sections together,
letting the user confirm the changes before saving them.

I'm not saying this is a feature that should be used widely, but there have
been a number of times a developer has left work without checking a document
back in, where I just needed to make a quick change to the document.
(Usually a spelling error or something like that.) Unfortunately, with them
having the document checked out, I can't make the change. This feature would
allow me to make the change, then when they go to check in the document, it
will warn them that a change has occurred and show them what the document
looks like with the merged changes. They can then either except the changes
or save only their version. (At least this is the way I gather it works from
the docs-I've yet to try it.)

-Dan

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:50 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:49 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


backburner until I had more time to play with it. However, there are some
really killer features (like being able to have multiple developers work on
the same document) which I'm dying to play around with. Unfortunately, I

Doesn't that break the whole concept change control? This feature is
currently available windows explorer.

Duane


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
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: Blue arrow on CF Studio project folders

[Aidan Whitehall]

>> Does anyone know what the blue arrow on CF Studio project folders
>> means? Is
>> it "another" bug?
>
>I believe it means that any files added to the physical folder will
>automatically be added to the project as well.
>
>You can shut this off by right clicking the folder / choose properties.
>There are two toggles for auto-including all files and all sub-folders. The
>subfolders take on the properties of the parent unless told otherwise.

Yeppers... it's cause Auto Include files is turned on (right-click on the
folder and select Properties).

BTW, I had 4.5a installed and every time I turned this on today it threw an
error when closing or saving the project.  Upgrading to 4.5.1 fixed it.




-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

three table sql join

[Deanna L. Schneider]

This is slightly off topic, but I'm sure there are sql gurus out there who
know how to do this.

I'm trying to join three tables (category, subcat, catrelation), pulling all
records from category, and using the  tag to output
the results, so that if someone chooses a category, the second select box is
populated with the appropriate subcategories. I have it working when I don't
care if the categories that don't have subs are included. But I do care! So,
how do I get this to work in one query that I can reference in the custom
tag?

Oh yah, and this is in access right now. The error I get is "join type not
supported." I've already tried going back to access to create the query, and
it basically tells me I have to do it in two queries

Grrr. Frustrated.


SELECT c.cat_id, c.cat_name, s.subcat_id, s.subcat_name
FROM category c left outer join catrelation r on c.cat_id = r.cat_id, subcat
s
WHERE c.cat_id = r.cat_id AND
  s.subcat_id = r.subcat_id


THanks!
-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
302 Hiram Smith
1545 Observatory Dr.
Madison, WI 53706
(608) 265-7923



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

Re: CF 4.5 and Port 25

[Adrian Cooper]

- Original Message -
From: Andrew C. Davis <[EMAIL PROTECTED]>
Sent: 17 April 2000 15:49

> I've recently upgraded to CF 4.5 Pro and eversince, my SMTP software,
> which uses port 25, does not work.  Does CF 4.5 "take over" port 25?

What dialog do you get if you telnet to port 25 on that IP address? If you get
the SMTP greeting, then the problem is likely elsewhere.

Adrian Cooper.


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

[Adrian Cooper]

- Original Message -
From: Dan Blickensderfer <[EMAIL PROTECTED]>
Sent: 17 April 2000 16:54

> I was wanting to know some opinions on any good cf web base email app.
>
> Specs.
> round robin dns load balance on multiple NT 4.0 Servers
> CF 4.5X
> support multiple domains
> BCC
> send / receive file attachments
> address books

iMS/FusionMail has almost all of your requirements, in addition to which it is a
very powerful and flexible mail system by any standards:

http://www.coolfusion.com/iMS.htm

Round robin DNS is a function of DNS, and not of an MTA.

Adrian Cooper.


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

[Scott Rowe]

Yep, it does work that way. I work with another developer in London and due
to our combined laziness, I mean time-zone difference, this program allows
him to not have to wait for me to get in so he can change something. It's
really easy to merge the differences as well. It can even auto-merge for you
which I've heard is pretty accurate but I'm afraid to try. When you merge it
will show you the original page code and your changes in one color, the
other persons changes in another one. You can then easily merge the two
together. Or you can viciously overwrite all their changes. :-)

Scott

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:59 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


Actually, it does a bit compare and can merge the edited sections together,
letting the user confirm the changes before saving them.

I'm not saying this is a feature that should be used widely, but there have
been a number of times a developer has left work without checking a document
back in, where I just needed to make a quick change to the document.
(Usually a spelling error or something like that.) Unfortunately, with them
having the document checked out, I can't make the change. This feature would
allow me to make the change, then when they go to check in the document, it
will warn them that a change has occurred and show them what the document
looks like with the merged changes. They can then either except the changes
or save only their version. (At least this is the way I gather it works from
the docs-I've yet to try it.)

-Dan

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:50 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 11:49 AM
To: [EMAIL PROTECTED]
Subject: RE: Source Control


backburner until I had more time to play with it. However, there are some
really killer features (like being able to have multiple developers work on
the same document) which I'm dying to play around with. Unfortunately, I

Doesn't that break the whole concept change control? This feature is
currently available windows explorer.

Duane


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