Connection Faliure !!! again!

[Vincent]

hi,
  I seem to be facing this problem over and over again .
Every morning i get up to find that my Index page runs in to a
CONNECTION FALIURE !
and I cant for the life of me figure out why this happens and there
are just 3 queries in it ... that retrieves just a few lines from the
database 

But still the error occures
how can I make it such that that the file does not create a .map & .tmp
file on the server ???

regards,
VIN


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Scheduled Task

[Ed Toon]

I assume there's some way to schedule a task on NT... on a Unix-type machine
I'd just add a cron job and use lynx or wget to call a URL.


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

Scheduled Task

[Gary J. Groomer]

Does anyone know how to run a "CFM" file, periodically, without the use of
ColdFusion's scheduled task functions?  For example, every 24-hours at a
specified time.  My web site is hosted on a shared server and the hosting
company won't allow the use of the CF Administrator's scheduled tasks, nor
will they allow the use of CFSCHEDULE.  They say that both modify the
registry and modification of the registry has been disabled
for security reasons.  Any ideas would be greatly appreciated.

Gary Groomer


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: CFSELECT, selected= doesnt work?! Am I going crazy?

[James]

Change it to this

[cfform action="#CGI.SCRIPT_NAME#" method="post">
  [cfselect name="letter" >
[option value="A">Apple
[option value="B" selected>Bear
[option value="C">Car
  [/cfselect>
  [input type=submit>
[/cfform>

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 9:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: CFSELECT, selected= doesnt work?! Am I going crazy?


I have been banging my head on the simplest thing. Why doesn't THIS work? It
doesn't select choice 'B'.

[cfform action="#CGI.SCRIPT_NAME#" method="post">
  [cfselect name="letter" selected="B">
[option value="A">Apple
[option value="B">Bear
[option value="C">Car
  [/cfselect>
  [input type=submit>
[/cfform>

(please excuse the [ I dont know how else to show HTML/CFML without my mail
program eating the tags)



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032


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

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

CFSELECT, selected= doesnt work?! Am I going crazy?

[Peter Theobald]

I have been banging my head on the simplest thing. Why doesn't THIS work? It doesn't 
select choice 'B'.

[cfform action="#CGI.SCRIPT_NAME#" method="post">
  [cfselect name="letter" selected="B">
[option value="A">Apple
[option value="B">Bear
[option value="C">Car
  [/cfselect>
  [input type=submit>
[/cfform>

(please excuse the [ I dont know how else to show HTML/CFML without my mail program 
eating the tags)



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

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

Wrapping Problems in CFMAIL - 4.51

[Bud]

--_-1244254973==_ma
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

Hi. I have an application at virtualscape on their 4.51 servers. Same 
app I have on other 4.51 servers and on plenty of 4.01 servers. I'm 
getting a strange wrapping, or I should probably say "not wrapping" 
problem.

Here is the simple code. At the top of the cfmail tag it wraps fine:

***
Thank you for your purchase.

Please return soon.

Invoice Number 004247:

Qty. - Product Name - Price Each
Total For Item (Quantity X Price)


But at the bottom:

Here is the code:

Purchased by #mem_id#:
Payment Method: #payment_type#
#Firstname# #Lastname#
#Company#
#email#
#address#, #address2#
#City#, #state# #zip#
#Country#
#phone#

Here is the output:

Purchased by 0007020001:
Payment Method: Online CC Bud Schneehagen [EMAIL PROTECTED] 7517 
SW 7th St N. Laud., FL 33068US 954-721-3452

The line starting with Payment Method always comes out on one line. 
Why? I've tried everything. Manually going through and entering each 
line break manually again. Uploading from Mac and Windows. As ascii 
and as binary. It's very annoying as it's also erratic. Some lines 
break fine. Some don't.

I extremely HATE 4.51. Nothing but problem after problem.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--_-1244254973==_ma
Content-Type: text/html; charset="us-ascii"


Wrapping Problems in CFMAIL -
4.51
Hi. I have an application at virtualscape on their 4.51 servers.
Same app I have on other 4.51 servers and on plenty of 4.01 servers.
I'm getting a strange wrapping, or I should probably say "not
wrapping" problem.

Here is the simple code. At the top of the cfmail tag it wraps
fine:

***
Thank you for your purchase.

Please return soon.

Invoice Number 004247:
 
Qty. - Product Name - Price Each
Total For Item (Quantity X Price)


But at the bottom:

Here is the code:

Purchased by #mem_id#:
Payment Method: #payment_type#
#Firstname# #Lastname#
#Company#
#email#
#address#,
#address2#
#City#,
#state#
#zip#
#Country#
#phone#

Here is the output:

Purchased by 0007020001:
Payment Method: Online CC Bud Schneehagen
[EMAIL PROTECTED] 7517 SW 7th St N. Laud., FL 33068US
954-721-3452

The line starting with Payment Method always comes out on one
line. Why? I've tried everything. Manually going through and entering
each line break manually again. Uploading from Mac and Windows. As
ascii and as binary. It's very annoying as it's also erratic. Some
lines break fine. Some don't.

I extremely HATE 4.51. Nothing but problem after problem.

-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452


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

Using Application Variables to Cache Static Query Results

[Peter Theobald]

This Allaire KnowledgeBase article tells us how to store a query in the Application 
scope for queries like a list of States that should be shared by all users.

http://www.allaire.com/Handlers/index.cfm?ID=1582&Method=Full

Curiously, the article never locks any of the Application variables or queries. Does 
Allaire not follow it's own locking recommendations? Do we have the locking 
recommendations all wrong? It's a mystery...

Anyway...

Can anyone describe the different advantages and disadvantages of caching a query vs. 
storing it in Application scope?



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[paul smith]

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

Right.  This is what Allaire recommends in "ColdFusion Best Practices"


 SELECT FirstName, LastName
 FROM Users
 WHERE UserID = #request.UserID#


 


at http://www.allaire.com/handlers/index.cfm?id=17318&method=full

But for Structures, this was thrashed out recently in the Fusebox list.  I 
thought the consensus there was not to bother with the additional step of 
copying the structures, and use something like the following in 
qry_globals.cfm or Application.cfm:







...read data here into Application.MyStruct for some
time



(See the posting by BOROVOY on 29 Aug 2000)

best,  paul

At 09:29 PM 9/1/00 -0400, you wrote:
>At 01:48 PM 9/1/2000 -0400, Peter Theobald wrote:
> >Paul, why did you set the data in a temporary structure, then copy it to
>the application structure?
> >Did you intend to put a lock around the application structure?
>
>I don't know about Paul, but I generally build structures in local scope
>and then copy them to application (or session) scope with a single cflock
>for the copy, instead of locking the entire process.  Particularly if I'm
>initializing a bunch of structures, I'll build them all and copy them all
>under one cflock.
>
>Sharon




Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
P: (510) 763-2358
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W: http://www.support.net

--=_184807419==_.ALT
Content-Type: text/html; charset="us-ascii"


Right.  This is what Allaire recommends in "ColdFusion Best
Practices"


SELECT
FirstName, LastName
FROM
Users
WHERE
UserID = #request.UserID#





at
http://www.allaire.com/handlers/index.cfm?id=17318&method=full" 
eudora="autourl">http://www.allaire.com/handlers/index.cfm?id=17318&method=full

But for Structures, this was thrashed out recently in the Fusebox
list.  I thought the consensus there was not to bother with the
additional step of copying the structures, and use something like the
following in qry_globals.cfm or Application.cfm:

 
 
 
 
 
 
...read data here into Application.MyStruct for some 
time 
 


(See the posting by BOROVOY on 29 Aug 2000)

best,  paul

At 09:29 PM 9/1/00 -0400, you wrote:
At 01:48 PM 9/1/2000 -0400, Peter Theobald
wrote:
>Paul, why did you set the data in a temporary structure, then copy it
to
the application structure?
>Did you intend to put a lock around the application structure?

I don't know about Paul, but I generally build structures in local
scope
and then copy them to application (or session) scope with a single
cflock
for the copy, instead of locking the entire process.  Particularly
if I'm
initializing a bunch of structures, I'll build them all and copy them
all
under one cflock.

Sharon





Paul Smith, Web/Database Droid 
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611 
P: (510) 763-2358 
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W:
http://www.support.net/" eudora="autourl">http://www.support.net


--=_184807419==_.ALT--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Javascript -> Cold Fusion.

[Peter Theobald]

Well, you can pick up CF variables in Javascript easier than that. Just set them 
directly!
 
 var x = #cfvar#;
 

The server side Cold Fusion will spit out the above to the browser.

For reading Javascript variables in Cold Fusion you are correct, setting 
form.element.value = 'X' will send it to CF on the next trip to the server.

Arrays and structures are no help because the client doesn't know about them.

At 07:32 PM 9/1/00 -0600, Dru Whitledge wrote:
>I've been thinking on the same subject, but haven't had time to play with
>it yet. 
>
>What about using  FORM element values (value=' 'or  text or hidden) for a
>limited means of passing variables. Both HTML (the JS DOM) and CF access
>that data directly at different times, but maybe on different sides of the
>server.  var X = form.element.value should pick up a variable set by CF
>. form.element.value = 'X' should set it for CF to grab on the next
>trip to the server. Is there a better way to do this? 
>
>What about passing data in structures or arrays. Anyone given that any
>thought?
>
>I did see a piece somewhere on using WDDX to pass variables to JS or vice
>versa, but if it still takes a trip to the server to do it, why not just
>use the FORM elements?
>
>Dru
>
>
>At 20:59 9/1/2000 -0400, Peter Theobald wrote:
>>Since Javascript runs only on the client and Cold Fusion runs only on the
>serve, you have to pass the JavaScript variables to a CFM page through a
>URL request as URL or Form variables.
>>
>>At 05:26 PM 9/1/00 -0400, Bill Davidson wrote:
>>>This is a multi-part message in MIME format.
>>>
>>>--=_NextPart_000_018F_01C01439.B56720E0
>>>Content-Type: text/plain;
>>>charset="iso-8859-1"
>>>Content-Transfer-Encoding: quoted-printable
>>>
>>>Does anyone know of an easy method to get Javascript variable =
>>>information to CF variables?  Or more specifically how to get the =
>>>browser dimensions/screen resolution into a CF variable?  Is WDDX the =
>>>answer?
>>>
>>>TIA,
>>>Bill
>>>/intraget
>>>
>>>--=_NextPart_000_018F_01C01439.B56720E0
>>>Content-Type: text/html;
>>>charset="iso-8859-1"
>>>Content-Transfer-Encoding: quoted-printable
>>>
>>>
>>>Does anyone know of an easy method to = get=20 Javascript variable
>information to CF variables?  Or more = specifically how=20 to get the
>browser dimensions/screen resolution into a CF = variable?  Is=20 WDDX the
>answer?
>>> 
>>>TIA,
>>>Bill
>>>/intraget
>>>
>>>--=_NextPart_000_018F_01C01439.B56720E0--
>>>
>>>--
>
>>>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body. 
>>
>>
>>---
>>Peter Theobald, Chief Technology Officer
>>LiquidStreaming http://www.liquidstreaming.com
>>[EMAIL PROTECTED]
>>Phone 1.212.545.1232 Fax 1.212.679.8032
>>
>>---
>---
>>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>>
>>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures No? Cached Queries Yes?

[Sharon DiOrio]

It would depend a lot on how you're using the information now, that is, how
people are accessing it.  Structures (particularly nested structures) are
great for drill down information.  But if you're doing a lot of looping,
then queries might be faster.  

What might work is the nested structure like:

APPLICATION.newark["Access Control Systems"] = an ordered array of listings
(You can use "non-standard" key names provided you build and access the
structure using array notation.  I.e., APPLICATION.newark.Access Control
Systems would not work.)

You *can* loop over structures, either as a collection, or by pulling the
keys with a StructKeyList().  I've done some sites where I kept a good
portion of the "common" information in large hierarchical structures that I
used all over the site.  Sometimes I looped over the structure, sometimes I
pulled detailed information from several layers into the structure.  I
liked having one place for all the information.  But if I didn't need the
information in a structure, I'm just as happy saving a query or two to
APPLICATION scope.

If you have more detailed information about what you're trying to
accomplish, I can give you some more ideas.

Sharon

  
At 06:47 PM 9/1/2000 -0700, paul smith wrote:
>Thanks for jumping in, Sharon.  Good suggestions.
>
>In just a few minutes mulling over your ideas, I've
>come up with some possibilities.
>
>My app is a Yellow Pages.
>
>So one query I have been running is to list all
>Headings that start with "A" for example
>(Academies, Access Control Systems, Accessories-Fashion,
>and so forth...)
>
>So your approach would be to load all Headings that begin
>with A into a structure, all those that begin with B
>into another structure, and so forth.  Right?  This
>eliminates a call to the DB.
>
>Another would be to load all Listings in one city, say
>New York into a structure, all Listings in Newark into
>another structure, and so forth.
>
>Is this the idea?  Do you have any specific suggestions
>for Yellow Pages?
>
>best,  paul
>
>
>At 09:18 PM 9/1/00 -0400, you wrote:
>>OK, gonna jump in on this one now.
>>
>>I don't use cached queries.  I use scoped queries.  Essentially the same
>>thing, but I like managing my own caching rather than allowing the server
>>to determine what gets cached (based on the rotating list of "last used").
>>Just a preference.
>>
>>But on the queries vs. structures discussion you're comparing apples and
>>oranges.  If you have data that you're going to loop over and output, use a
>>query.  That's what they're designed for.  But if you're going to call
>>individual pieces of data (particularly organizationally nested pieces of
>>data) than use a structure, much quicker to point to exactly what you want
>>than to loop to find it.
>>
>>Example, a structure that holds school information:
>>
>>schools.schoolname.class.teacher = "[teachername]"
>>
>>In my code (where I know the school and class):
>>#schools[schoolname][class]["teacher"]# will output teacher name.
>>
>>I can pull this information out of a resident structure much quicker than
>>running a query, or even looping through a query to find the information I
>>want.  This may not be the best example, but it may help to look at some of
>>the queries you're running to get complex information and see where a
>>nested structure (queried for and built once) saved into application scope
>>(then copied to request scope with cflock for usage) might be a better
>>alternative.
>>
>>I *love* structures and I'm open to any questions on using them efficiently.
>>
>>Sharon
>>
>>P.S.,  rules for working with structures, whether it's faster or 
>>not.
>>
>>--

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures No? Cached Queries Yes?

[paul smith]

Thanks for jumping in, Sharon.  Good suggestions.

In just a few minutes mulling over your ideas, I've
come up with some possibilities.

My app is a Yellow Pages.

So one query I have been running is to list all
Headings that start with "A" for example
(Academies, Access Control Systems, Accessories-Fashion,
and so forth...)

So your approach would be to load all Headings that begin
with A into a structure, all those that begin with B
into another structure, and so forth.  Right?  This
eliminates a call to the DB.

Another would be to load all Listings in one city, say
New York into a structure, all Listings in Newark into
another structure, and so forth.

Is this the idea?  Do you have any specific suggestions
for Yellow Pages?

best,  paul


At 09:18 PM 9/1/00 -0400, you wrote:
>OK, gonna jump in on this one now.
>
>I don't use cached queries.  I use scoped queries.  Essentially the same
>thing, but I like managing my own caching rather than allowing the server
>to determine what gets cached (based on the rotating list of "last used").
>Just a preference.
>
>But on the queries vs. structures discussion you're comparing apples and
>oranges.  If you have data that you're going to loop over and output, use a
>query.  That's what they're designed for.  But if you're going to call
>individual pieces of data (particularly organizationally nested pieces of
>data) than use a structure, much quicker to point to exactly what you want
>than to loop to find it.
>
>Example, a structure that holds school information:
>
>schools.schoolname.class.teacher = "[teachername]"
>
>In my code (where I know the school and class):
>#schools[schoolname][class]["teacher"]# will output teacher name.
>
>I can pull this information out of a resident structure much quicker than
>running a query, or even looping through a query to find the information I
>want.  This may not be the best example, but it may help to look at some of
>the queries you're running to get complex information and see where a
>nested structure (queried for and built once) saved into application scope
>(then copied to request scope with cflock for usage) might be a better
>alternative.
>
>I *love* structures and I'm open to any questions on using them efficiently.
>
>Sharon
>
>P.S.,  rules for working with structures, whether it's faster or 
>not.
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Javascript -> Cold Fusion.

[Sharon DiOrio]

You can use wddx to do this.  Essentially  will build a javascript
array that you can work with.  Takes some tinkering, but is very cool.

Sharon

At 05:26 PM 9/1/2000 -0400, Bill Davidson wrote: 
>
> This is a multi-part message in MIME format. 
>
> --=_NextPart_000_018F_01C01439.B56720E0 
> Content-Type: text/plain; 
> charset="iso-8859-1" 
> Content-Transfer-Encoding: quoted-printable 
>
> Does anyone know of an easy method to get Javascript variable = 
> information to CF variables? Or more specifically how to get the = 
> browser dimensions/screen resolution into a CF variable? Is WDDX the = 
> answer? 
>
> TIA, 
> Bill 
> /intraget 
>
> --=_NextPart_000_018F_01C01439.B56720E0 
> Content-Type: text/html; 
> charset="iso-8859-1" 
> Content-Transfer-Encoding: quoted-printable 
>
>
> Does anyone know of an easy method to = get=20 Javascript variable
> information to CF variables?  Or more = specifically how=20 to get the
> browser dimensions/screen resolution into a CF = variable?  Is=20 WDDX the
> answer?
>  
> TIA,
> Bill
> /intraget
>
>
> --=_NextPart_000_018F_01C01439.B56720E0-- 
>
> --
>  
> Archives:
> http://www.mail-archive.com/cf-talk@houseoff
> usion.com/ 
> To Unsubscribe visit
>
> ht
> tp://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a
> message to [EMAIL PROTECTED] with 'unsubscribe' in the
body. 




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: Javascript -> Cold Fusion.

[Dru Whitledge]

I've been thinking on the same subject, but haven't had time to play with
it yet. 

What about using  FORM element values (value=' 'or  text or hidden) for a
limited means of passing variables. Both HTML (the JS DOM) and CF access
that data directly at different times, but maybe on different sides of the
server.  var X = form.element.value should pick up a variable set by CF
. form.element.value = 'X' should set it for CF to grab on the next
trip to the server. Is there a better way to do this? 

What about passing data in structures or arrays. Anyone given that any
thought?

I did see a piece somewhere on using WDDX to pass variables to JS or vice
versa, but if it still takes a trip to the server to do it, why not just
use the FORM elements?

Dru


At 20:59 9/1/2000 -0400, Peter Theobald wrote:
>Since Javascript runs only on the client and Cold Fusion runs only on the
serve, you have to pass the JavaScript variables to a CFM page through a
URL request as URL or Form variables.
>
>At 05:26 PM 9/1/00 -0400, Bill Davidson wrote:
>>This is a multi-part message in MIME format.
>>
>>--=_NextPart_000_018F_01C01439.B56720E0
>>Content-Type: text/plain;
>>charset="iso-8859-1"
>>Content-Transfer-Encoding: quoted-printable
>>
>>Does anyone know of an easy method to get Javascript variable =
>>information to CF variables?  Or more specifically how to get the =
>>browser dimensions/screen resolution into a CF variable?  Is WDDX the =
>>answer?
>>
>>TIA,
>>Bill
>>/intraget
>>
>>--=_NextPart_000_018F_01C01439.B56720E0
>>Content-Type: text/html;
>>charset="iso-8859-1"
>>Content-Transfer-Encoding: quoted-printable
>>
>>
>>Does anyone know of an easy method to = get=20 Javascript variable
information to CF variables?  Or more = specifically how=20 to get the
browser dimensions/screen resolution into a CF = variable?  Is=20 WDDX the
answer?
>> 
>>TIA,
>>Bill
>>/intraget
>>
>>--=_NextPart_000_018F_01C01439.B56720E0--
>>
>>--

>>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body. 
>
>
>---
>Peter Theobald, Chief Technology Officer
>LiquidStreaming http://www.liquidstreaming.com
>[EMAIL PROTECTED]
>Phone 1.212.545.1232 Fax 1.212.679.8032
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
>
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[Sharon DiOrio]

At 01:48 PM 9/1/2000 -0400, Peter Theobald wrote:
>Paul, why did you set the data in a temporary structure, then copy it to
the application structure?
>Did you intend to put a lock around the application structure?

I don't know about Paul, but I generally build structures in local scope
and then copy them to application (or session) scope with a single cflock
for the copy, instead of locking the entire process.  Particularly if I'm
initializing a bunch of structures, I'll build them all and copy them all
under one cflock.

Sharon

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures No? Cached Queries Yes?

[Sharon DiOrio]

OK, gonna jump in on this one now.

I don't use cached queries.  I use scoped queries.  Essentially the same
thing, but I like managing my own caching rather than allowing the server
to determine what gets cached (based on the rotating list of "last used").
Just a preference.

But on the queries vs. structures discussion you're comparing apples and
oranges.  If you have data that you're going to loop over and output, use a
query.  That's what they're designed for.  But if you're going to call
individual pieces of data (particularly organizationally nested pieces of
data) than use a structure, much quicker to point to exactly what you want
than to loop to find it.

Example, a structure that holds school information:

schools.schoolname.class.teacher = "[teachername]"

In my code (where I know the school and class):
#schools[schoolname][class]["teacher"]# will output teacher name.

I can pull this information out of a resident structure much quicker than
running a query, or even looping through a query to find the information I
want.  This may not be the best example, but it may help to look at some of
the queries you're running to get complex information and see where a
nested structure (queried for and built once) saved into application scope
(then copied to request scope with cflock for usage) might be a better
alternative.

I *love* structures and I'm open to any questions on using them efficiently.

Sharon

P.S.,  rules for working with structures, whether it's faster or not.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Dates

[Peter Theobald]

BTW, it's funny you singled out the Sybase driver as being bad with dates. I am using 
Sybase 11.9.2 and it is WONDERFUL with dates. It can take just about anything I throw 
at it and figure out what date I mean.

At 08:02 PM 9/1/00 -0400, Rick Osborne wrote:
>Peter Theobald said:
>>What exactly is the difference between the different date types?
>
>Nothing.  Just different ways of representing the same data to different
>precision.  A timestamp (ts) includes hour/minute/second whereas a small
>date (d) includes only the year/month/day itself.  Like the difference
>between and integer and a real (float).
>
>>I tried inserting the actual string {ts '2000-09-02 00:00:00'}
>>and it does NOT work, so a date value is not just a string that
>>represents a date.
>
>Um, actually, yeah it is.  :)  Did you try the insert with a real SQL client
>or did you try it with CF?  I'm willing to bet that if you tried it with CF
>then you ran into the same issue I posted about earlier today: CF escaped
>your single-quotes and turned it into {ts ''2000-09-02 00:00:00''}, which is
>illegal.  Try wrapping it in a PreserveSingleQuotes().
>
>>I tried inserting the string "2 Sep 2000" and it works fine...
>>so why do I need all these date functions?
>
>Because some SQL engines are smarter about dates than others.  Some can take
>just about any human-readable date format and parse it.  Others have to have
>it in a certain form or you're toast.  IIRC, older versions of Access
>required you to wrap the dates in hashes (#08/31/2000#) instead of single
>quotes.  The plethora (not of balloons, Jefe, but) of date functions and
>formats is to help accomodate the different engines.  I seem to remember
>having a bunch of scripts originally written for Access, then migrated to
>Sybase XI ODBC, then Sybase XI Native, then SQL Server ODBC, then to SQL
>Server OLEDB, (it was really good code) and I know we had to go through and
>change the dates in all of our queries at least twice.  (Yet again IIRC, the
>Sybase Native drivers have horrible date parsers.)
>
>Hope that clears it up.  :)
>
>-Rick


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Javascript -> Cold Fusion.

[Peter Theobald]

Since Javascript runs only on the client and Cold Fusion runs only on the serve, you 
have to pass the JavaScript variables to a CFM page through a URL request as URL or 
Form variables.

At 05:26 PM 9/1/00 -0400, Bill Davidson wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_018F_01C01439.B56720E0
>Content-Type: text/plain;
>charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Does anyone know of an easy method to get Javascript variable =
>information to CF variables?  Or more specifically how to get the =
>browser dimensions/screen resolution into a CF variable?  Is WDDX the =
>answer?
>
>TIA,
>Bill
>/intraget
>
>--=_NextPart_000_018F_01C01439.B56720E0
>Content-Type: text/html;
>charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>Does anyone know of an easy method to = get=20 Javascript variable information to CF 
>variables?  Or more = specifically how=20 to get the browser dimensions/screen 
>resolution into a CF = variable?  Is=20 WDDX the answer?
> 
>TIA,
>Bill
>/intraget
>
>--=_NextPart_000_018F_01C01439.B56720E0--
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Javascript -> Cold Fusion.

[Bill Davidson]

Sorry for the MIME message (if it reached you all that way.)  I am used to
lists that handle that.

And thanks in advance for any light someone can shed on this...

[original message]
Does anyone know of an easy method to get Javascript variable information to
CF variables?  Or more specifically how to get the browser dimensions/screen
resolution into a CF variable?  Is WDDX the answer?

TIA,
Bill
/intraget

- Original Message -
From: Bill Davidson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 5:26 PM
Subject: Javascript -> Cold Fusion.


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_018F_01C01439.B56720E0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Does anyone know of an easy method to get Javascript variable =
> information to CF variables?  Or more specifically how to get the =
> browser dimensions/screen resolution into a CF variable?  Is WDDX the =
> answer?
>
> TIA,
> Bill
> /intraget
>
> --=_NextPart_000_018F_01C01439.B56720E0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Does anyone know of an easy method to =
> get=20
> Javascript variable information to CF variables?  Or more =
> specifically how=20
> to get the browser dimensions/screen resolution into a CF =
> variable?  Is=20
> WDDX the answer?
>  
> TIA,
> Bill
> /intraget
>
> --=_NextPart_000_018F_01C01439.B56720E0--
>
> --

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

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

Re: [OT: ColdFusion Job Opening at Unisyn Software]

[JL]

Wailap Lam
11775 S. Shannan St. Apt#415, Olathe, KS 66062, USA
 (785) 550-3376
E-Mail: [EMAIL PROTECTED]

OBJECTIVE 
Seeking a challenging position as a Software Engineer or Web Programmer in a
progressive company where I can apply and extend my knowledge and skills in
software development and design.

EDUCATION 
* Bachelor of Science in Computer Science, 
  The University of Kansas, Lawrence, KS, USA, August 1998
* Bachelor of Science in Electrical Engineering, 
  The University of Kansas, Lawrence, KS, USA, May 1997

WORK EXPERIENCE
* Programmer, January 1999 - Present
   SupplyTrak LLC (InterDirect Inc.), Shawnee, Kansas
* Develop/Maintain/Enhance/Debug a web-based software SupplyTrak for medical
industry.  Projects include security system, merchandising reports, automated
report system, etc.
* Experience in Cold Fusion 4.01, WDDX, JavaScript, Dynamic-HTML, CSS, DOM,
HTML, Stored Procedures, Transact-SQL.
* Competency with Microsoft NT 4.0 Server, IIS 4.0, Access and SQL Server
6.5/7.0.
* Familiar with Internet Explorer (5.X) and Netscape browsers (4.X and 6.0). 
Program in a database with over 100 tables and several data sources.

RELATED COURSES 
* Software Engineering I
* Operating Systems
* Database Systems
* Computer Systems & Assembly Language
* Computer Architecture

* Computer Algorithms 
* Programming Language 
* Communications Systems 
* Computer Graphics
* Compiler

PROJECTS 
* HTTP Web Server
Learned the low-level details of how the Web works. Implemented a web server
in Chez Scheme to evaluate the server's design and to determine whether or not
it can be improved. 
* Library Database
Created a WWW interface using SQL and CGI(C++), in which the user can check
in/out or search for a book, and workers can add/delete a member or a worker.


TECHNICAL EXPERIENCE 
* Proficient in programming BASIC, C, C++, Scheme, SQL, RDBMS, HTML, DHTML,
CGI, Cold Fusion 4.0, Java 2 (JDK1.2.2, J2SDK1.3), JavaScript, Lex and Yacc,
OpenGL, Client/Server, Nachos, and VB5.0 
* Experienced in microcontroller applications utilizing Motorola 68HC11 MCU 
* Experienced in using Microsoft Access and SQL-Server 6.5/7.0
* Familiar with DOS, Windows NT, Windows 95/98, UNIX, and Linux environment 
 
PERSONAL INFORMATION
* Self-motivated, responsible and able to adapt to new environment 
* Experienced in technical writing
* Willing to relocate





Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

CF Article in WebReview

[Chris Montgomery]

Feature: Fun with ColdFusion
http://webreview.com/pub/2000/09/01/feature/index01.html?wwwrrr_2901
.txt
It's a powerful energy source, but it doesn't require nuclear
reactivity to work. ColdFusion will fuel your Web sites cleanly,
safely, and easily. John Paul Ashenfelter explains how.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603Fax 210-490-4692
Allaire Software Sale!  http://www.astutia.com/store
Find a Job in San Antoniohttp://www.sajobnet.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[paul smith]

At 01:48 PM 9/1/00 -0400, you wrote:
>Paul, why did you set the data in a temporary structure, then copy it to 
>the application structure?

Other than that was the way I was taught to do it, I believe it's needed to 
create a structure with "N-columns" (in my case, Class_ID, Class_Name, 
Pages, and NewPages, or 4 columns) and "M-rows" (in my case over 7,000 
rows), or what I think many must call a "Nested Structure"

>Did you intend to put a lock around the application structure?

Yes.  I actually did put a LOCK there but I kept getting some error 
message.  I haven't had time to sort it out.

BTW, Dan Switzer has a super tutorial on Structures at:

http://www.oacfug.org/dsp_articles.cfm/dsp_Articles.cfm?view=Articles_35

(the page throws a JS error for me, clicking on "No" seemed to work)

best,  paul


>At 01:26 PM 8/31/00 -0700, paul smith wrote:
> >Here's an example:
> >
> > PASSWORD="#pass#">
> >SELECT Class_ID, Class_Name, Pages, NewPages
> >FROM YellowPages (nolock)
> >
> >
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >best,  paul
> >
> >At 10:45 AM 8/31/00 -0400, you wrote:
> >> Is there a way to add multiple records into a structure or do 
> I have
> >>to make an array of strucutres. Right now I made an aray of strucutures but
> >>I want to make sure that is the most logical way to be doing it.
> >
> >- 
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 
> or send a message to [EMAIL PROTECTED] with 'unsubscribe' 
> in the body.
>
>
>---
>Peter Theobald, Chief Technology Officer
>LiquidStreaming http://www.liquidstreaming.com
>[EMAIL PROTECTED]
>Phone 1.212.545.1232 Fax 1.212.679.8032
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.




Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
P: (510) 763-2358
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W: http://www.support.net

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Dates

[Rick Osborne]

Peter Theobald said:
>What exactly is the difference between the different date types?

Nothing.  Just different ways of representing the same data to different
precision.  A timestamp (ts) includes hour/minute/second whereas a small
date (d) includes only the year/month/day itself.  Like the difference
between and integer and a real (float).

>I tried inserting the actual string {ts '2000-09-02 00:00:00'}
>and it does NOT work, so a date value is not just a string that
>represents a date.

Um, actually, yeah it is.  :)  Did you try the insert with a real SQL client
or did you try it with CF?  I'm willing to bet that if you tried it with CF
then you ran into the same issue I posted about earlier today: CF escaped
your single-quotes and turned it into {ts ''2000-09-02 00:00:00''}, which is
illegal.  Try wrapping it in a PreserveSingleQuotes().

>I tried inserting the string "2 Sep 2000" and it works fine...
>so why do I need all these date functions?

Because some SQL engines are smarter about dates than others.  Some can take
just about any human-readable date format and parse it.  Others have to have
it in a certain form or you're toast.  IIRC, older versions of Access
required you to wrap the dates in hashes (#08/31/2000#) instead of single
quotes.  The plethora (not of balloons, Jefe, but) of date functions and
formats is to help accomodate the different engines.  I seem to remember
having a bunch of scripts originally written for Access, then migrated to
Sybase XI ODBC, then Sybase XI Native, then SQL Server ODBC, then to SQL
Server OLEDB, (it was really good code) and I know we had to go through and
change the dates in all of our queries at least twice.  (Yet again IIRC, the
Sybase Native drivers have horrible date parsers.)

Hope that clears it up.  :)

-Rick

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

RE: [OT] submit form with ENTER

[Steve Pierce]

Yep that is a Netscape feature.

-Original Message-
From: Birgit Pauli-Haack [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 5:26 PM
To: [EMAIL PROTECTED]
Subject: [OT] submit form with ENTER



Using a login form in Netscape 4.7, I am not able to send the form
by hitting the Enter-Key. I have to use the mouse and click on the
send-button, which is one of these unimportant, yet annoying
things...

Is there a method in HTML, JavaScript or so to make the send-button
ENTER-Key 'enabled'?
It works just fine in IE..

Somebody an idea? Please per PM, 'cause it's OT.
Thanks


Best regards,
 Birgit



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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: getting data from queries as a structure/array

[Peter Theobald]

You can still use Evaluate, just don't use the structure dotted notation. 
Evaluate("foo[""#quux#""]") should work.

At 04:50 PM 9/1/00 -0400, Rick Osborne wrote:
>Oh, one more reason for not using Evaluate() - structures can hold keys that
>aren't CF-Variable-Name-Compliant and Evaluate() can't handle them.  For
>example, numeric struct keys will generate an error with Evaluate():
>
>The code:
>
>01: 
>02: 
>03: 
>04: 
>05:   
>06:   
>07:   
>08:   
>09:   
>10: #CFCATCH.Message#
>11: 
>
>The output:
>
>   An error occurred while evaluating the expression:
> brick=Evaluate("foo.#quux#")
>   Error near line 9, column 13.
>   An error has occurred while processing the expression:
>  foo.12345
>   Invalid parser construct found on line 1 at position 4.
>   ColdFusion was looking at the following text:
>   .
>   Invalid expression format. The usual cause is an error
>   in the expression structure.
>
>-Rick
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Forced Evaluation of Custom Tag Reference?

[Peter Theobald]

evaluate(fieldname)

At 04:29 PM 9/1/00 -0400, Jamie Jackson wrote:
>Okay, here's what I'm trying to do: 
>I have a custom tag call embedded in a database field, which is being
>displayed on a Web page. 
>Right now, the custom tag call doesn't work, because it's showing up in the
>source without being evaluated. 
>So my database field says: 
>...blah blah blah blah attribute2="blah"> ...
>And it shows up in my source like this... 
>...blah blah blah blah attribute2="blah"> ...
>Any way to get CFServer to evaluate the reference? 
>Thanks, Jamie 
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Rick Osborne]

Just 'cause I'm on a run of disagreeing with Jeremy today ... ;)

Jeremy Allen said:
>Since one object merely references something else and does nto
>actually copy the data and get its own set of data
>So, this opens up some interesting possibilities.
>Namely custom data structures among other things.
>CF sucks with recursion still and I would be very afraid to
>use custom tags to manipulate a custom data structure built
>using this method..
>I cant imagine this being overly useful to your average CF
>developer, But I guess in some cases this proves to be
>truly useful.

Most definitely.  For the last project I was on this proved to be
*obscenely* useful.  We essentially ended up loading the entire database
(some 50+ tables from a nice relational DB in 3rd normal form) into memory,
not as queries, but as structures, arrays, lists, etc.  (Okay, so we had the
occasional query stored in memory, too.)  We basically denormalized the
data, in memory, for maximum speed.  Everything started at the Application
scope and just worked its way down through about a dozen layers at its
deepest point.  Using this, we got it down to where we could do massive
reports and use dozens of dynamic objects per page and not have to do a
single database call.  It was lightning fast, and that was one of the major
reasons.

The entire system was (is) strictly CFMODULE-based, and everything only
knows its little piece of the system and doesn't mess with anyone else's.
We would pass in a reference to a branch in the main tree (structure) and
that was all that the module would know about.  It wouldn't care where that
branch actually came from or where it was going, it just needed that data.
Locking was easy because the module would only have to lock that branch if
it was going to modify it, and since each module only modified it's piece of
the system you never had to worry about one module modifying another
module's data.

We essentially combined all the best aspects of CFObject and Fusebox without
any of the baggage.  (And, truth be told, the project was started before
either of those things existed.)  Without references, I don't even know if
that would be possible.  If it would be, I certainly wouldn't want to
maintain the code for it.

And, as my parting blow: it's not CF that sucks with recursion, it's the
programmer.  I've *never* had a problem with recursion (well, none that
wasn't immediately obvious as a "doh!") and I've used it quite a bit.  (I've
said it before and I'll say it again!  :)

-Rick

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: DATA MISSING!!! (back button)

[David Hannum]

It's a page that either does not cache, or has a short cache time (this done
via JS or Meta Tags).  When you go to re-view the page, it's is telling you
that you have to actually rebuild the page by resubmitting the form info
(which IS still cached) and run the script again to see the output.

Dave


- Original Message -
From: Mike Deane <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 2:22 PM
Subject: DATA MISSING!!! (back button)


> 
> Data Missing
>
> This document resulted from a POST operation and has expired from the
> cache. If you wish you can repost the form data to recreate the document
> by pressing the
> reload button.
> 
>
> When I hit the back button in Netscape I get this error message.  What
> gives?  How do I fix this?
> Thank you.
> /mdeane
> --

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 Conferance 2000 :: Do you want my registration?

[Paul Ihrig]

 huray!
i get to go!
we just got in a billable account today, so i am no longer over head.
now i just need to keep up 30% chargability.

: ]
any one out there using Ultra Dev?
i would like to see a Server Behavior created for CFFILE.
let me know.
-paul

-Original Message-
From: Chris Michl
To: [EMAIL PROTECTED]
Sent: 8/30/00 3:33 PM
Subject: Re: CF Conferance 2000 :: Do you want my registration?

Paul,

I started working with Cold Fusion about  four years ago (version 1.5)
-- my
professional background is actually on the network engineering side of
IT.
Though I did not learn anything earth-shattering at last year's
conference,
I can definitely say it was worth every penny. I came away with new
perspectives that I wouldn't have understood if I had stayed home -- and
I
think I'm a more valuable developer/employee as a result. I'll be
attending
this year's conference with the same expectations.

 Regards,

Chris Michl
- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 1:38 PM
Subject: RE: CF Conferance 2000 :: Do you want my registration?


> Ok.
>
> So  my manager comes up to me today & says.
> Can you justify what you may learn from the conference, with the total
cost
> of flights & hotel.
>
> ? not sure, I reply.
>
> Will I even be here at this company come November now that I must be
30 %
> billable I ask him?
> That's not the point he says.
>
> Then I ask if he is satisfied with all the friggin forms I build day
in &
> out?
> He says sure.
>
> So why go?
> To be aware of emerging technologies.
>
> So, I am a newbie to intermediate at CF.
> Do you think that the conference will be worth it, as far as learning
more
> about CF & Development?
>
> Sorry for the OT:
> Have a few more hours befor I can cancell & still get 50% back.
>
> Thanks
> -paul


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: DATA MISSING!!! (back button)

[Rick Osborne]

This occurs when you do something akin to the following:

Start at .
POST to .
POST again to .
Go back to .

Since  was generated by a POST, Navigator (and even IE) will not
let you see the page again.  That's the way it works.  The same thing can
happen if the file stays the same and is POSTing to itself.  (Like a
wizard.)

Two solutions:

1. Use the GET method.
2. Make the URL unique each time:
   a. Start at 
   b. POST to 
   c. POST to 

-Rick

-Original Message-
From: Mike Deane [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 2:23 PM
To: '[EMAIL PROTECTED]'
Subject: DATA MISSING!!! (back button)



Data Missing

This document resulted from a POST operation and has expired from the
cache. If you wish you can repost the form data to recreate the document
by pressing the
reload button.


When I hit the back button in Netscape I get this error message.  What
gives?  How do I fix this?
Thank you.
/mdeane

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Simple IIS question(3)

[Ed Toon]

Yes, Apache NT is an operating system. It used to be known as Windows NT,
but the Apaches took over Redmond in retaliation for hundreds of years of
abuse. You will have to get rid of all Microsoft products prior to
installing it.

-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:43 PM
To: [EMAIL PROTECTED]
Subject: Simple IIS question(3)


Is Apache NT an operating system?
If it is an OS, then will I have to remove Win 98 from
my computer before installing it?

Appreciate.
A.B.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: sorting a table

[Peter Theobald]

Yes, I just pass the parameters back in to the same page and use SQL 'ORDER BY'

Order by LastName

...
Last Name
...

At 02:08 PM 9/1/00 -0400, Johnson, Dana wrote:
>Hello All:
>
>I was wondering if anybody has a routine or tag that sorts a dynamic table
>by clicking the table headers to sort in asc or des order by column
>
>here is what I have
>
>
>
>
>
>
>
>
>
> 
>
>p.s not critical just testing
>
>Dana E. Johnson
>Sr. Web Developer
>CIT
>VTF/Technology Financing Services
>[EMAIL PROTECTED]
>(904) 620-7458
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Regarding CF Forum2.0

[Adrian Cooper]

- Original Message -
From: "Adrian Cooper" <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 11:58 PM


> I have 2.06 running fine with SQL Server 7 - but the upsize wizard didn't
work.
> I got it working by creating the SQL database manually and using DTS to get
the
> table structures across.

I should add that I believe that people should ideally distribute the SQL script
for apps like these along with the Access mdb. The sql script for Forums is only
a 14Kb file.

Adrian Cooper.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Regarding CF Forum2.0

[Adrian Cooper]

- Original Message -
From: "John McKown" <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 8:09 PM


> We are using the ForumSpot upgrade and it seems to run much more smoothly
> than 2.0.
> We had a lot of problems with the SQL upsize wizard (even on 2.0.6) and we
> ended up importing the Access tables using the SQL Enterprise Manager.

I have 2.06 running fine with SQL Server 7 - but the upsize wizard didn't work.
I got it working by creating the SQL database manually and using DTS to get the
table structures across.

Adrian Cooper.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: timetrouble

[mr_0rga5m / Blueyonder]

Hi

Needs to be a string like:

#ParseDateTime("2000/09/01 10:30:22")#

- Original Message -
From: "Mark Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 5:55 PM
Subject: timetrouble


> #ParseDateTime(2901103022)#
>
> What am I doing wrong?
>
> Mark
> --

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: timetrouble

[Mark Warrick]

That's not a valid date for use with the function ParseDateTime.

You can use the functions Left, Mid, and Right to turn the date parameters into 
objects that you could then use with DateFormat, TimeFormat, and CreateODBCDateTime 
functions.


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


> -Original Message-
> From: Mark Davies [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 01, 2000 9:56 AM
> To: [EMAIL PROTECTED]
> Subject: timetrouble
> 
> 
> #ParseDateTime(2901103022)#
> 
> What am I doing wrong?
> 
> Mark
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL to Exchange/Outlook?

[Marius Milosav]

http://www.cftipsplus.com/cftipsplus/CFTIPS_e-ZINE/00028/00028.cfm

Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: Robert Everland <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 1:42 PM
Subject: RE: SQL to Exchange/Outlook?


> I know there is a site out there that has a ton of CF stuff on it
> and one of them is a way to play with objects in Microsoft Outlook.
(anyone
> know, now would be the time to mention it) If you could use the Outlook
> object I am sure it wouldn't take long to make a query from SQL and add it
> in to Exchnage.
>
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 31, 2000 4:32 PM
> To: [EMAIL PROTECTED]
> Subject: SQL to Exchange/Outlook?
>
>
>
> Has anyone worked with any gateways or other tools where you could pull
data
> from MS SQL and have that data be pushed into Exchange/Outlook as
contacts,
> appointments, to do lists, etc.?
>
> E-mail me off-list at [EMAIL PROTECTED] if you have done any work with
> this.
>
> --Doug
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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

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

Scalabilty Web Site

[dougn]

Greetings!

Threads on "Scaling CF" are about 99% questions and only 1% answers.
Unfortunately, there just isn't much information published on this subject.
I've been giving numerous presentations on Scalability and how Autobytel.com
does it.  I've also been compiling a lot of notes.  My hope was to publish a
white paper and perhaps a book on the topic, but that requires more
organization and time than I really have.  So instead, I've created a
section of my personal web site where I'm going to put small articles, tips,
techniques, code snippets, rants, links, etc.  I'm also going to try to
consolidate threads I see in the CF-TALK and other lists to see if I can
commpile answers to commonly asked questions.

The site is in its early stages, but if you have a few minutes and are
interested, you can try it at: http://doug.nottage.com/cf
All I ask is that if you do try it, you take a minute to e-mail me and let
me know if it was helpful and what I could do to make it better.  If you
have any topics you would like to see covered, feel free to e-mail me at
[EMAIL PROTECTED]  More articles are coming and if you sign up to the mailing
list, you'll know when new things are available.

Have a great Labor Day weekend all!

--Doug
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: sorting a table

[Mark Warrick]

Are you asking whether the data can be sorted without a return trip to the server?  If 
so, I believe that's a CSS or JavaScript question.  Any client-side gurus out there?

Otherwise, you can pass a variable into the query that got the results in the first 
place like "orderby" and pass through a column name into your query using the order by 
SQL function.

Confusing?

Here's an example:

SELECT whatever
FROM whatever_table
WHERE whatever
ORDER BY #orderby#

Does that help?

---mark

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


> -Original Message-
> From: Johnson, Dana [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 01, 2000 11:08 AM
> To: '[EMAIL PROTECTED]'
> Subject: sorting a table
> 
> 
> Hello All:
> 
> I was wondering if anybody has a routine or tag that sorts a dynamic table
> by clicking the table headers to sort in asc or des order by column
> 
> here is what I have
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
> 
> p.s not critical just testing
> 
> Dana E. Johnson
> Sr. Web Developer
> CIT
> VTF/Technology Financing Services
> [EMAIL PROTECTED]
> (904) 620-7458
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: Web Database Solution

[CF]

There is a PHP version of what you are talking about.  It works with MySQL,
and PHP, but I'm sure you could pull some of the SQL, layout and
functionality ideas for it.

It's called phpMyAdmin.
http://phpwizard.net/projects/phpMyAdmin/index.html

HTH,

Peter Janett

New Media One Web Services

WEB HOSTING FOR WEB DEVELOPERS

  -> Sun, IRIX, NT, Linux <-
PHP, MySQL, Perl, Cold Fusion,
MS SQL, ASP, SSI, SSL
http://www.newmediaone.net
[EMAIL PROTECTED]
  (303)828-9882

- Original Message -
From: Nick McClure <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 9:59 AM
Subject: Web Database Solution


> I have been thinking about developing a CF app that will let me work with
> my SQL Server via the web.
>
> But before I get into that I wanted to see if there was already a good one
> out there.
>
> I would like to have as much of the functionality as Enterprise Manager as
> I can.
>
> Anybody know of a good one?
> --
> Nick McClure [EMAIL PROTECTED]
> Technical Director 859.245.9656
> squareFish Media www.squareFish.com
>
> --

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 Drivers

[Ed Toon]

There was a leak in the native driver for Oracle 8... No idea if there still
is. Might've just been a Solaris thing too. As for CF Server, well, we can
all hope...

Ed

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

TTMYGG: Single-quote escaping

[Rick Osborne]

(From the "Things that make you go 'Gr'" file...)

This is an extremely rhetorical question, but what is up with the stupid
in-query single quote escaping?  Sometimes it works, sometimes it doesn't.
I think I've tracked it down to a simple rule: if your variable has brackets
[] in it, it isn't escaped, but otherwise it is.  So, if you are going to
access the data using an array (or a structure with brackets) you need to
escape the single quotes *before* you use them in the query.  Other wise,
don't escape them or they'll just be escaped again.

How exceedingly lame.  One or the other.  Make up your mind.

Code used to test and results follow.

Results:

Strings work.
Arrays are broke.
Structs with dots work.
Structs with brackets are broke.

Code:







  
  SELECT *
  FROM bugs_bugs
  WHERE (area_tx = '#string#')
  
  Strings work.
Strings are broke.


  
  SELECT *
  FROM bugs_bugs
  WHERE (area_tx = '#array[1]#')
  
  Arrays work.
Arrays are broke.


  
  SELECT *
  FROM bugs_bugs
  WHERE (area_tx = '#struct.name#')
  
  Structs with dots work.
Structs with dots are broke.


  
  SELECT *
  FROM bugs_bugs
  WHERE (area_tx = '#struct["name"]#')
  
  Structs with brackets work.
Structs with brackets are
broke.



--
Rick Osborne

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

Javascript -> Cold Fusion.

[Bill Davidson]

This is a multi-part message in MIME format.

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

Does anyone know of an easy method to get Javascript variable =
information to CF variables?  Or more specifically how to get the =
browser dimensions/screen resolution into a CF variable?  Is WDDX the =
answer?

TIA,
Bill
/intraget

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








Does anyone know of an easy method to =
get=20
Javascript variable information to CF variables?  Or more =
specifically how=20
to get the browser dimensions/screen resolution into a CF =
variable?  Is=20
WDDX the answer?
 
TIA,
Bill
/intraget

--=_NextPart_000_018F_01C01439.B56720E0--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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] submit form with ENTER

[Birgit Pauli-Haack]

Using a login form in Netscape 4.7, I am not able to send the form
by hitting the Enter-Key. I have to use the mouse and click on the
send-button, which is one of these unimportant, yet annoying
things...

Is there a method in HTML, JavaScript or so to make the send-button ENTER-Key 
'enabled'?
It works just fine in IE..

Somebody an idea? Please per PM, 'cause it's OT.
Thanks
  

Best regards,
 Birgit 


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Large query to web

[GeckoX]

I'm not sure why you would want to display that many records to the
browser, but I found that another web-development tool I use, talentsoft
Web+, can do what you need just fine.

I did a test in Web+ of 150,000 records in a simple MS Access database and
selected them and displayed them all to the screen simply using the
 loop tag (works similar to ).

It took a while (about the 45 seconds you mentioned) and correctly
displayed all 150,000 records.

If you feel you really need to display that many, you might want to try
talentsoft Web+ if you can't get CF to do this. Their url is
http://www.talentsoft.com.

Hope this helps.
:geckox


> 
> --
> 
> Date: Thu, 31 Aug 2000 08:16:37 -0400
> From: "Woodcock, Jonathan" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: Large Query to web
> Message-ID: <[EMAIL PROTECTED]>
> 
> Hi everybody,
> 
> I am trying to present a very large chunk of data to users via a web page.
> The query takes 45 seconds to run (optimized) in the Query Analyzer and
> yields 100,000 records.
> 
> Good 'ol CFOUTPUT will not work.  IE chokes if there are more than 5,000 or
> so records.  It takes so long for the page to render.
> 
> I am wondering if anybody else has been here before and has any suggestions
> ?
> 
> Perhaps :
> - Have SQL output a flat file and point to that with CF.
> - Write to an Excel file with an ODBC Driver ?
> - Explore CFX_Excel
> - Limit view to 5,000 at a time.
> 
> Thanks for any pointers.
> 
> Jonathan Woodcock
> 
> --
> 

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

Dates

[Peter Theobald]

What exactly is the difference between the different date types?

"2 Sep 2000"
CreateDate("2000", "9", "2")  (outputs: {ts '2000-09-02 00:00:00'} )
CreateODBCDate(CreateDate("2000", "9", "2")) (outputs: {d '2000-09-02'} )

I tried inserting the result of these functions and they all work.
I tried inserting the actual string {ts '2000-09-02 00:00:00'} and it does NOT work, 
so a date value is not just a string that represents a date.
I tried inserting the string "2 Sep 2000" and it works fine... so why do I need all 
these date functions?

Note: I am not asking what DateFormat is good for, obviously it is good for formatting 
human readable output. I am referring only to working with date variables and SQL.

---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: getting data from queries as a structure/array

[Rick Osborne]

Oh, one more reason for not using Evaluate() - structures can hold keys that
aren't CF-Variable-Name-Compliant and Evaluate() can't handle them.  For
example, numeric struct keys will generate an error with Evaluate():

The code:

01: 
02: 
03: 
04: 
05:   
06:   
07:   
08:   
09:   
10: #CFCATCH.Message#
11: 

The output:

   An error occurred while evaluating the expression:
 brick=Evaluate("foo.#quux#")
   Error near line 9, column 13.
   An error has occurred while processing the expression:
  foo.12345
   Invalid parser construct found on line 1 at position 4.
   ColdFusion was looking at the following text:
   .
   Invalid expression format. The usual cause is an error
   in the expression structure.

-Rick

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Where can I get custom tag to ZIP files ?

[Chris Straight]

You could also write a java CFX tag using the java.util.zip classes. There
is a greate example towards the back of the "CORE JAVA2 Volume
1-Fundamentals which can get you started...

Chris Straight
Web Applications Developer
University of Oregon Bookstore, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331 x215
http://www.uobookstore.com

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 5:52 PM
To: [EMAIL PROTECTED]
Subject: RE: Where can I get custom tag to ZIP files ?


You could just use zlib and do your own compression
decompression in a CFX.. its not terribly complex
since I have used it before in PerlScripts and
for some C programming I did :)

zlib is free btw and you can find more examples
of it in use than you can shake a stick at :)

Jeremy Allen
[EMAIL PROTECTED]

-Original Message-
From: lsellers [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 3:49 AM
To: [EMAIL PROTECTED]
Subject: RE: Where can I get custom tag to ZIP files ?




> Hi,
> I am trying to make a script that can zip log files through
> ColdFusion tags.
>
> Do you have any idea where I can get the specialized custom tag like
> CFX_Zip?
>
> Thanks in advanced

Buy Ben Forta's tag or roll your own. Only two options... unless you cf
generate bat files and cfexecute them to use pkzip25.exe.

--min


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


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Found NT Auth_User -- Need a FULLNAME

[lsellers]

> When I got in this morning, I d/l Lewis's tag (getUserGroups) and started
> working with it (I had considered it, but was turned off by the $200 -

Well, it is about 25,000 lines of c code. So think of it as less than a
penny a line. Sounds cheaper that way. :)

--min

> didn't see the freeware text, but your app is very nice - good
> job). Then I
> d/l domainUser. Perfect solution. I can't help but think of all the time I
> spent learning/working with the other tags (time not wasted, but
> not exactly
> productive!)
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Rick Osborne]

This is not true.  :)  The StructClear() function does the exact same thing
your loop does - it completely empties the structure of both keys and values
(data).  Don't believe me?  Try it:



  

#StructCount(Bag)#

#StructCount(Bag)#

You will get the following result:
100
0

-Rick

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:49 PM
To: [EMAIL PROTECTED]
Subject: RE: StructClear


StructDelete(structure, key) :)

If you wanted to clear the structe you COULD





And you are left with a mere shell of
the structure you once had  :)

Or you can use StructClear which clears
out the *data* only.

Jeremy

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

Forced Evaluation of Custom Tag Reference?

[Jamie Jackson]

Okay, here's what I'm trying to do: 
I have a custom tag call embedded in a database field, which is being
displayed on a Web page. 
Right now, the custom tag call doesn't work, because it's showing up in the
source without being evaluated. 
So my database field says: 
...blah blah blah blah  ...
And it shows up in my source like this... 
...blah blah blah blah  ...
Any way to get CFServer to evaluate the reference? 
Thanks, Jamie 

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: timetrouble

[Zachary Bedell]

>From the Docs:

"When passing a date/time value as a string [to ParseDateTime], make sure it
is enclosed in quotes.  Otherwise, it is interpreted as a number
representation of a date/time object, returning undesired results."

So...  Try some quotes...

> -Original Message-
> From: Mark Davies [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 01, 2000 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: timetrouble
> 
> 
> #ParseDateTime(2901103022)#
> 
> What am I doing wrong?
> 
> Mark
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Query problem with IE

[Ian]

Every now and then I get errors on queries where "favicon.ico" gets tossed
into one of the variable fields. It is always the same field which is a
numeric. I know that this has something to do with IE looking for a favorite
icon but does anyone know how to work around this without replacing numeric
fields in queries with text?

Caught an exception, type = DATABASE [Microsoft][ODBC SQL Server Driver][SQL
Server]The column prefix 'favicon' does not match with a table name or alias
name used in the query.SQL = "SELECT 
Subject
FROM
Subject
WHERE
categoryCode = 'Re'
AND
SubCategoryCode = 'B'
AND
SubjectCode = favicon.ico"


Get your own FREE, personal Netscape WebMail account today at 
http://home.netscape.com/webmail
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: StructClear

[Dave Watts]

> StructDelete(structure, key) :)
> 
> If you wanted to clear the structe you COULD
> 
> 
>   
> 
> 
> And you are left with a mere shell of
> the structure you once had  :)
> 
> Or you can use StructClear which clears
> out the *data* only.

Looping over the structure and deleting each member with StructDelete will
be equivalent to using StructClear, which deletes all keys and values from
within the structure. CF doesn't have a way of representing uninitialized
variables - variables without values.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Jeremy Allen]

Just as a cool point to bring up.

This is what you would consider passing by reference.

Since one object merely references something else
and does nto actually copy the data and get its
own set of data (passing by value).

So, this opens up some interesting possibilities.

Namely custom data structures among other things.

I am kind of glad allaire did this however.. I
do think it tends to confuse msot people since
I cant think of any other data type in CF that
behaves the way structures do.

CF sucks with recursion still and I would
be very afraid to use custom tags to manipulate
a custom data structure built using this
method.. (Such as a Stack of Queue) perhaps..
was there not a CFDJ article talking about this?

I cant imagine this being overly useful to your
average CF developer,
But I guess in some cases this proves to be
truly useful.



Jeremy Allen
[EMAIL PROTECTED]
Insert Quarter Here >[   ]<

-Original Message-
From: Rick Osborne [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: StructClear


Stas-

The StructClear() function completely empties a structure; keys and
everything.  Let's extend this for a second.  Take the following situation:

   
   
   

A structure with 2 keys, right?  Now, you can clear this structure one of
two ways:

   
   
   

There is an important distinction, however.  Remember that structures are
passed (and assigned) by reference.  So, let's assume that foo still has
some data in it, and let's add the following scenario:

   

Now, whether you use StructClear() or StructNew() actually matters!  This is
because brick and foo now point to the *same data*.  Not copies of the data,
but the same data.  To show this, you could now do:

   
   #foo.bat#

This is perfectly valid.  So, as you can see, StructClear() and StructNew()
will now do two very different things.  If you use StructClear():

   

Then you are acting on the reference, you will therefore be clearing out the
brick structure while you are at it:

   #StructCount(brick)#
   

But, it we back up and use StructNew() instead:

   

Then we are now simply overwriting foo's copy of the reference.  So foo gets
a new structure and brick stays intact:

   #StructCount(brick)#
   
   #StructCount(foo)#
   

In this way, you can see that assigning to foo does not affect brick, but
using functions that work on foo will affect brick (because the functions
take a copy of the reference, while assigning overwrites the reference with
a new one).

So, to answer your second function, you can clear a structure any way you
want:

   
   
   
   

This distinction actually has several uses, but it's a bit tricky if you
aren't wary of it.  I've helped many a CF programmer who were tearing their
hair out because they had used one instead of the other.  :)

HTH,
Rick


-Original Message-
From: Stas Newdel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 5:45 PM
To: CFTalk
Subject: StructClear


Does StructClear reset keys in a structure to be blank, or does it remove
the keys? Also, what's a function to get rid of a structure altogether?

Thank you



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


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Justin Kidman]

Not quite true.  Just ran a test and StructClear deletes the keys just like
your loop does.  Here is code you stick on any template to try:





alert("#IsDefined('myStruct.data')#");

alert("#IsDefined('myStruct.data')#");



I used js because I threw this in to a fusebox app I was working on and
alerts don't mess up how the page looks.

Justin Kidman

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 9:49 AM
To: [EMAIL PROTECTED]
Subject: RE: StructClear


StructDelete(structure, key) :)

If you wanted to clear the structe you COULD





And you are left with a mere shell of
the structure you once had  :)

Or you can use StructClear which clears
out the *data* only.

Jeremy

-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 11:02 AM
To: [EMAIL PROTECTED]
Subject: Re: StructClear


StructClear destroys struct keys.  As for deleting structures altogether,
I'm not sure.  Surely there's got to be a way to unset variables, right?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Stas Newdel <[EMAIL PROTECTED]>
To: CFTalk <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 3:44 AM
Subject: StructClear


>Does StructClear reset keys in a structure to be blank, or does it remove
>the keys? Also, what's a function to get rid of a structure altogether?
>
>Thank you
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Escaping Pound Signs in a CF Query....

[Rif Kiamil]

What about [Cust#] ?

-Original Message-
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: 01 September 2000 15:58
To: [EMAIL PROTECTED]
Subject: RE: Escaping Pound Signs in a CF Query


I gave that a shot last night, to no avail... It just doesnt seem to like
the pound sign(#) in the sql query.  I'm trying to get the new db guy to
change the field name, but it's going to take a while, so i'd like to create
a workaround..

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:04 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Escaping Pound Signs in a CF Query


Yes. Either change it Cust ## or something else like Cust num. This also
applies to using the hex colour codes - eg: ##ff intead of the usual
#ff - within CFOUTPUT. The double pound signs cancel out the usual
CFOUTPUT requirement.

Peter Tilbrook
Internet Applications Developer
Aspect Computing Pty. Ltd.
19-25 Moore Street
Turner, ACT, 2612
AUSTRALIA

http://www.aspect.com.au

Phone: (02) 6247 7677
Fax: (02) 6249 1620
Mobile: 0428 765 020

ACT ColdFusion Users Group - http://203.37.24.198


-Original Message-
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 September 2000 5:00
To: Cf-Talk
Subject: Escaping Pound Signs in a CF Query


For some strange and utterly inconvenient reason, our former Access Database
guy had created a form field named Cust#.  I imagine this stands for
CustNumber, but CF doesn't seem to agree.  Is there a way to escape a #
(pound sign) so i can query the table?

I've tried doing a "Cust# As CustNum" as well as Cust##.  Nothing seems to
work.

Anyone know of anything?

Thanks In Advance!!

Mark Armendariz
Righteous Design



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

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


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

Simple IIS question(3)

[aslam bajaria]

Is Apache NT an operating system?
If it is an OS, then will I have to remove Win 98 from
my computer before installing it?

Appreciate.
A.B.

--- Chris Lott <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> > IIS4 comes with NT4 Option Pack, it is not part of
> Windows98. You
> > cannot  run windows98 as a server, unless your
> just using it for
> > local development  of course, in which case you
> can use PWS
> > (Personal Web Server) but it's a  bit crap, give
> O'Reily Webserver
> > Pro a try.
> 
> For development on win98, use Apache NT. Free, and
> smaller footprint
> than either of those mentioned so far. 
> 
> c
> - --
> Chris Lott
> 
> 
> -BEGIN PGP SIGNATURE-
> Version: PGP Personal Privacy 6.5.3
> Comment: KeyID: 0x51046CFD [this signature for
> sender verification]
> 
>
iQA/AwUBOa0qW9aLYehRBGz9EQL6VgCeI2Xg2C8TVy54rSGb8En+PkURA8EAoIUG
> F1fJhPqjc4N7YH8BiC5Mvhis
> =zvHf
> -END PGP SIGNATURE-
> 
> 
>
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


__
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: NT Authentication (revisited with a twist)

[Paul Sizemore]

When I got in this morning, I d/l Lewis's tag (getUserGroups) and
started
working with it (I had considered it, but was turned off by the $200 -
didn't see the freeware text, but your app is very nice - good job).
Then I
d/l domainUser. Perfect solution. I can't help but think of all the time
I
spent learning/working with the other tags (time not wasted, but not
exactly
productive!)

Thank you, and remember,

The Internet is like a bunch of garage sales; You're not guaranteed
anything, but sometimes you find a real treasure.

Paul

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 8:29 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: NT Authentication (revisited with a twist)

> Here is the situation I am in. I am running IIS4 and CF4. I
> have a site that has its own login page through CF. What I
> want to do is use CGI.AUTH_USER to bypass this page. Some of
> the clients are logged into a NT system and some are not, that
> is the reason for the multiple login areas. If those clients
> are logged into their NT systems I want to be able to grab
> their username to run against our database of users. If they
> are not I just want to show the login template so they can
> enter the username and password that way. I am having
> difficulties figuring out if this is even possible. I
> can not seem to get IIS not prompt the user with the
> username/password dialog box for them to enter their NT
> username and password. What I want to do is just populate
> the cgi variables so I can do the processing through CF
> without creating NT user accounts on the web server for the
> users that will be accessing the site. Is this possible??

There are a couple of things you'll have to keep in mind, and a couple of
issues you'll have to resolve.

1. Of your NT users, are their browsers automatically set to log them in
with their existing credentials? If not, they'll be prompted for an NT
username and password by the browser when they visit the page that requires
web server authentication.

2. You can't set the CGI.AUTH_USER variable yourself.

3. If you use web server authentication on a page, the web server will force
the user through a prompt if that user hasn't already authenticated
themselves, so if you put a form on that page, the user will never see the
form unless they've already passed through the web server authentication.

One thing that comes to mind, that you can do, is direct the user to a web
server authenticated page. If the user then clicks "cancel" because they're
not an NT user, you can have the 401 error messages actually redirect to a
file in IIS. That file must be an HTML file, but it can have a META refresh
tag which redirects the user to a non-authenticated page, which would
contain your form for querying the database. You could have your
authenticated page redirect to that form's action page, which could be
written to query the database with either the form data or the CGI.AUTH_USER
value, although you won't have access to the NT password and would have to
rely solely on the username for your query in this case.

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Found NT Auth_User -- Need a FULLNAME

[Rick Osborne]

Don't forget to send the author an email and let him know that you find the
tag useful.  Compliments and feedback keep freeware/opensource developers
motivated.  ;)

-Rick

-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Found NT Auth_User -- Need a FULLNAME


When I got in this morning, I d/l Lewis's tag (getUserGroups) and started
working with it (I had considered it, but was turned off by the $200 -
didn't see the freeware text, but your app is very nice - good job). Then I
d/l domainUser. Perfect solution. I can't help but think of all the time I
spent learning/working with the other tags (time not wasted, but not exactly
productive!)

Thank you, and remember,

The Internet is like a bunch of garage sales; You're not guaranteed
anything, but sometimes you find a real treasure.

Paul
-Original Message-
From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 9:02 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Found NT Auth_User -- Need a FULLNAME

I think you'll find a tag on allaire's developer exchange called
CFX_DomainUser which will do this and is also free.




>> I've searched the archives and experimented with several tags, but can
not
>> find how to pull a full name of the user.
> I have the CGI.Auth_User  from the NT Authorization (the employees
>> initials), but now I want their FULLNAME (from NT). How do I get this?
>>
>> Paul

>Well,... if you go to
>http://www.intrafoundation.com/intranethostingtoolkit.zip and download the
>eval zip you'll find a little freeware tag included called
>cfx_getusergroups. In a round about way you can get the fullname from that
>(you'll have to cfloop the query though).

>--min


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

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

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Regarding CF Forum2.0

[John McKown]

We are using the ForumSpot upgrade and it seems to run much more smoothly
than 2.0.
We had a lot of problems with the SQL upsize wizard (even on 2.0.6) and we
ended up importing the Access tables using the SQL Enterprise Manager.
Don't forget to go in and manually edit your application.cfm as per the
upsize instructions.

John McKown, VP Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 Dover, DE 19901
email: [EMAIL PROTECTED] 
phone: 302-736-5515
fax: 302-736-5945
icq: 1495432



> -Original Message-
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 31, 2000 5:33 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Regarding CF Forum2.0
>
>
> Check out http://www.forumspot.org for the latest "open source" version of
> it - 2.06 - with heaps of bug fixes and instructions for upsizing to SQL
> Server.
>
> Peter Tilbrook
> Internet Applications Developer
> Aspect Computing Pty. Ltd.
> 19-25 Moore Street
> Turner, ACT, 2612
> AUSTRALIA
>
> http://www.aspect.com.au
>
> Phone: (02) 6247 7677
> Fax: (02) 6249 1620
> Mobile: 0428 765 020
>
> ACT ColdFusion Users Group - http://203.37.24.198
>
>
> -Original Message-
> From: John McKown [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 1 September 2000 0:00
> To: [EMAIL PROTECTED]
> Subject: RE: Regarding CF Forum2.0
>
>
> I have it running.  What kind of errors are you getting?
> It never really ran well until we upsized it to SQL.
>
> John McKown, VP Business Services
> Delaware.Net, Inc.
> 30 Old Rudnick Lane, Suite 200 Dover, DE 19901
> eMail: [EMAIL PROTECTED] 
> Phone: 302-736-5515 Fax: 302-736-5945 ICQ: 1495432
>
>
>
> > -Original Message-
> > From: Vincent [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 30, 2000 5:58 AM
> > To: cftalk
> > Subject: Regarding CF Forum2.0
> >
> >
> > hi,
> >   I was wondering if any one here has installed the CF Forums2.0 ?
> > Cause, I have been facing some crazy errors with it when Im trying to
> > post some items.
> >
> > regards,
> > vin
> >
> >
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

Scalabilty Web Site

[dougn]

Greetings!

Threads on "Scaling CF" are about 99% questions and only 1% answers.
Unfortunately, there just isn't much information published on this subject.
I've been giving numerous presentations on Scalability and how Autobytel.com
does it.  I've also been compiling a lot of notes.  My hope was to publish a
white paper and perhaps a book on the topic, but that requires more
organization and time than I really have.  So instead, I've created a
section of my personal web site where I'm going to put small articles, tips,
techniques, code snippets, rants, links, etc.  I'm also going to try to
consolidate threads I see in the CF-TALK and other lists to see if I can
commpile answers to commonly asked questions.

The site is in its early stages, but if you have a few minutes and are
interested, you can try it at: http://doug.nottage.com/cf
All I ask is that if you do try it, you take a minute to e-mail me and let
me know if it was helpful and what I could do to make it better.  If you
have any topics you would like to see covered, feel free to e-mail me at
[EMAIL PROTECTED]  More articles are coming and if you sign up to the mailing
list, you'll know when new things are available.

Have a great Labor Day weekend all!

--Doug
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Illegal operation in CFHTTP

[Dave Watts]

> What might cause the following occasional error, apparently 
> related to the use of CFHTTP to create a query from a text file?
> --
> Message: Illegal operation in Cold Fusion Extension (CFX)
> Detail: You have attempted to refer to an invalid row/column 
> combination of a query. 
> This query contains 1 rows. ...

This most likely indicates that you're not receiving the nicely formatted
text file you're expecting to receive. If your CFHTTP request retrieves
anything else, like a 404 error or a CF error, the query parsing used by
CFHTTP will fail with this message.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

DATA MISSING!!! (back button)

[Mike Deane]

Data Missing

This document resulted from a POST operation and has expired from the
cache. If you wish you can repost the form data to recreate the document
by pressing the
reload button.


When I hit the back button in Netscape I get this error message.  What
gives?  How do I fix this?
Thank you.
/mdeane
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

E rror??

[sebastian palmigiani]

I don't how to resolve this error with moving a file with . Anyone
can help?

Sebastian

-


Error processing CFFILE

Unable to move file 'c:\inetpub\wwwroot\cfscripts\hangman\testing.txt' to
path 'c:\inetpub\wwwroot\cfscripts\hangman\adams\testing.txt'. This function
is only valid in Win32 mode. (error 120)

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (23:1) to (25:37).


Date/Time: 08/31/00 20:53:48
Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
Remote Address: 127.0.0.1
Template: C:\Inetpub\wwwroot\CFscripts\HangMan\CFfile.cfm

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 I want in CF (was: Learning ASP)

[Steve Bernard]

Fixing old problems is definitely more needed than new features like XML. I
wasn't suggesting that Allaire develop a proprietary parser, but rather, do
exactly as you said and plug in a third-party parser. Granted, I am assuming
that there is a vendor who makes a parser for both Windows and *NIX systems.
This method is exactly what Allaire does now to provide a lot of the core
functionality of CF. It is also used as an excuse when things don't work out
as well as they should. When I've requested better RegEx support from
Allaire, they've kept saying, "It's not our fault, the third-party RegEx
engine we use doesn't support those features." A more prominent example is
CFHTTP. Prior to the 4.5.x series CFHTTP didn't support SSL. Why? Because
Allaire used the WinInet.dll library, which doesn't allow the use of SSL.
They changed libraries and now we have SSL support but, other problems
persist. So, it goes both ways and shows that it really isn't all that hard
to plug new features in if you have developed a framework that allows for
it.

Steve

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:35 AM
To: [EMAIL PROTECTED]
Subject: RE: What I want in CF (was: Learning ASP)


I agree to a certain extent, however, I do not feel that Allaire's efforts
are best spent developing an XML parser for ColdFusion. In my opinion, too
much work needs to be done to the existing code base and functionality.

Perhaps the best of both worlds would be if Allaire picked one parser (say
Xerces) and redistributed that with the server. I think I'd rather have
Allaire point the developers in a direction rather than reinventing the
wheel.

In any case, it is what it is. There are plenty of solid XML parsers out
there that can be incorporated into ColdFusion apps. I would just pick the
one that claims 100% compatibility and let everyone else worry about making
theirs work with yours.

Now, all that said, I wouldn't mind seeing a native XML parser built into
ColdFusion if they fixed everything else first. :)

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

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

sorting a table

[Johnson, Dana]

Hello All:

I was wondering if anybody has a routine or tag that sorts a dynamic table
by clicking the table headers to sort in asc or des order by column

here is what I have









 

p.s not critical just testing

Dana E. Johnson
Sr. Web Developer
CIT
VTF/Technology Financing Services
[EMAIL PROTECTED]
(904) 620-7458


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

Encrypted CF on Linux

[!jeff!]

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

Hey,

has anyone had problems transferring files encrypted in an NT environment 
to a UNIX environment (specifically CF 4.5 on Linux)?

I'm getting the following error when trying to access encrypted files on 
the Linux box.

Error Diagnostic Information
Cannot load template file /blah_blah/admin/exec-setup.cfm
The template file exists, however, it either cannot be opened for reading, 
or it is encrypted and its data has been corrupted
Date/Time: Fri Sep 1 12:12:40 2000
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 216.200.205.77

!j!

The mark of mediocrity is searching for the precedent.

!jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI
   BIGWORDS.com worker#2
[EMAIL PROTECTED]   [EMAIL PROTECTED]
.r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300

--=_83601953==_.ALT
Content-Type: text/html; charset="us-ascii"


Hey,

has anyone had problems transferring files encrypted in an NT environment
to a UNIX environment (specifically CF 4.5 on Linux)?

I'm getting the following error when trying to access encrypted files on
the Linux box.

Error Diagnostic Information
Cannot load template file /blah_blah/admin/exec-setup.cfm 
The template file exists, however, it either cannot be opened for
reading, or it is encrypted and its data has been corrupted 
Date/Time: Fri Sep 1 12:12:40 2000
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 216.200.205.77


!j!

The mark of mediocrity is searching for the precedent.

!jeff! sherwood Director of BIGWORDS.com Web Site
Design / JEDI
 
BIGWORDS.com worker#2
[EMAIL PROTECTED]  
[EMAIL PROTECTED]
.r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300


--=_83601953==_.ALT--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 vs. ASP (was: What I want in CF (was: Learning ASP))

[Peter Theobald]

But you have to admit Superman would kick the Hulk's butt :-)

At 05:53 PM 8/31/00 -0400, Steve Bernard wrote:
>Capability is only as relevant as your need. Instead of creating these
>un-ending threads that don't accomplish anything or answer anyquestions
>why not evaluate needs and resources, compare products based on those
>criteria, and figure out which one fits YOUR needs. You'd think that enough
>pointless tirades on OS, CPU, and development platforms/environments had
>taken place on lists around the world that most would be tired of them by
>now. People should definitely compare information and experiences but, in my
>opinion, you're worse off by blindly taking the opinions of an obviously
>biased group than by digging in and doing your own research. No matter if I
>am the developer, project manager, or client I want to feel that I am going
>down a particular track for the right reasons, not because an anonymous
>listserv message says so. I'm not talking about questions like, "I'm going
>to develop an app that requires  capabilities. Can development
>language 'XYZ' do that?" or "Does product 'XYZ' support COM as well as ASP"
>Those sort of questions obviously belong in a listserv about 'XYZ'. This is
>a technical list so the questions should be at least remotely answerable.
>Just consider the results of going into a listserv on Christianity and
>asking, "Which denomination is the best?"
>
>Steve
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

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

Resolve URL

[!jeff!]

I would like to create a CF_tag that takes a base URL, and a URL relative 
to it, and magically creates a fully qualified URL from the relative one.

has anyone done this?  Is there downloadable code either in CF or in 
regular expression that I could convert?  Are there standards regarding 
resolving URL's that I should be aware of?

I know that CFHTTP does this, but I'm starting with a list of links, not 
from an HTTP request...

j

!j!

The mark of mediocrity is searching for the precedent.

!jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI
   BIGWORDS.com worker#2
[EMAIL PROTECTED]   [EMAIL PROTECTED]
.r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[Peter Theobald]

Paul, why did you set the data in a temporary structure, then copy it to the 
application structure?
Did you intend to put a lock around the application structure?

At 01:26 PM 8/31/00 -0700, paul smith wrote:
>Here's an example:
>
>
>SELECT Class_ID, Class_Name, Pages, NewPages
>FROM YellowPages (nolock)
>
>
> 
> 
>
>
>
>
>
>
>
>
>
>best,  paul
>
>At 10:45 AM 8/31/00 -0400, you wrote:
>> Is there a way to add multiple records into a structure or do I have
>>to make an array of strucutres. Right now I made an aray of strucutures but
>>I want to make sure that is the most logical way to be doing it.
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Which one will take?

[Peter Theobald]

Isn't it nice when instead of getting your literal question answered you get a more 
useful answer instead.

Miro can easily find the answer himself by putting two files in a directory named 
"This.cfm" and "this.cfm" then seeing which one it uses. But the resounding feedback 
he got was 'don't waste your time with this question because it is something that you 
should never do and the answer to the literal question will never be of use'.

At 03:44 PM 8/31/00 -0400, Steve Bernard wrote:
>Isn't it nice when you can't get your question answered, even if the answer
>is simply "I don't know"? ;)
>
>Steve
>
>-Original Message-
>From: Hryckowiak, Miro [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 31, 2000 9:48 AM
>To: '[EMAIL PROTECTED]'
>Subject: RE: Which one will take?
>
>
>Folks,
>
>I'm not doing that. I'm just thinking which one will CF take
>in case both files will resides in the directory - ON UNIX...
>
>Miro.
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: cflocking.. new allaire article

[Benjamin S. Rogers]

The argument against automatic locking sounds like an excuse to me. I've
never understood why they didn't perform automatic locking. Although I
understand the example, I feel it should be up to the user to override the
automatic locking for transactional processing/integrity as this is the
exception and not the rule. After all, isn't this the way SQL functions?

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

>In case someone here isn't subscribed to FusionAuthority News
>Alert:
>
>"Jim Schley, Premier Support, Allaire Corp., has come forth
>with this very important explanation of some of the best
>practices involved with locking shared variables. If you
>don't follow these practices, folks, you may run into some
>unforeseen pitfalls."
>
>http://www.allaire.com/handlers/index.cfm?ID=17318&Method=Full
>
>---
---
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Fusion Authority

[Michael Dinowitz]

It came out and the first part of the article was there. You can get a copy
at www.fusionauthority.com/alert. Next week will have the second part with
the full meat of custom functions. I'll also be asking for submissions of
snippets that people would like to be converted into custom functions.
Actually, I've already devised another way of doing custom functions that's
even more powerful. Give me a little time to write it up (along with a few
dozen other articles).


> Did fusion Authority come out yesterday as planned?  I subsribed yesterday
> afternoon after hearing there will be an article on custom functions in
CF.
> However, I still didn't receive anything from them.  If anyone has a copy
> can you forward it to me (personally) @ [EMAIL PROTECTED]
>
> Russ
>
>
> --

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

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

RE: SQL to Exchange/Outlook?

[Robert Everland]

I know there is a site out there that has a ton of CF stuff on it
and one of them is a way to play with objects in Microsoft Outlook. (anyone
know, now would be the time to mention it) If you could use the Outlook
object I am sure it wouldn't take long to make a query from SQL and add it
in to Exchnage.


Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 4:32 PM
To: [EMAIL PROTECTED]
Subject: SQL to Exchange/Outlook?



Has anyone worked with any gateways or other tools where you could pull data
from MS SQL and have that data be pushed into Exchange/Outlook as contacts,
appointments, to do lists, etc.?

E-mail me off-list at [EMAIL PROTECTED] if you have done any work with
this.

--Doug

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[paul smith]

At 10:35 AM 9/1/00 -0400, you wrote:
>is there any way to dump the whole content of the "GetYPs" query into the
>structure all at once without having to Loop through the query?  something
>like...

Not that I'm aware of.


> 
>
>
>also, what will be the scope of the STTEMP structure, I assume it will be
>the page, unless you specify otherwise (client, server, etc), am I right...

It's page. In my application, this function is executed the first time a 
browsers accesses this website only.  It should be CFLOCKED though.

best,  paul


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: [RE: How to display across a row instead of down?]

[double-down]

use MOD 3  in output

Dan Haley <[EMAIL PROTECTED]> wrote:









#query.field[((variables.i - 1) * variables.num_cols) +
variables.j]#






Dan

-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 11:12 PM
To: [EMAIL PROTECTED]
Subject: How to display across a row instead of down?



I want to display the results of my query in 3 columns instead of one.  I
know the method is something to do with mod3, but I'm dashed if i can
figure it out.

What I want to get is:

[record1] [record2] [record3]
[record4] [record5] [record6]
etc

Can anyone help me please with how to code it?

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



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



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.

Alternative to cf_query_repeater?

[Erika Foster]

I can't use this tag for two reasons.

1. There will be 0-length strings and null values and
2. One of the fields already uses commas and I can't make the delimiter
parameter in the tag work.

So, does anyone else have an alternative to updating a whole bunch of
records in a form with one submit button?

Here's some code from my form page:


 SELECT *
 FROM planning_track, contact_List
 WHERE person=employeeid
 ORDER BY WEEK, last_name




 Untitled





 
  
  
   #gettasks.week#
  
  
  
   #last_name#
   
   #id#
  
  
  
  
   
  
 





Much appreciated,

Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[Rick Osborne]

Robert -

Depends on your data layout.  I use arrays of structures, structures of
arrays, structures of structures, and arrays of arrays, all the time.
Whatever is most logical and most efficient for you to use.

I'm sure if you want to post a small exaple of your data structures that
you'll get a few opinions on how it should be laid out.

-Rick

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 10:46 AM
To: '[EMAIL PROTECTED]'
Subject: Structures, Arrays, Array of Structures


Is there a way to add multiple records into a structure or do I have
to make an array of strucutres. Right now I made an aray of strucutures but
I want to make sure that is the most logical way to be doing it.

Robert Everland III
Web Developer
Dixon Ticonderoga

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

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

timetrouble

[Mark Davies]

#ParseDateTime(2901103022)#

What am I doing wrong?

Mark
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Escaping Pound Signs in a CF Query....

[Rick Osborne]

Mark-

I haven't worked with Access in a while, but IIRC ... (can someone verify
this?)

You can escape a table name or field name with non-alphanumeirc characters
by surrounding it with brackets [].  Seeing as how this particular character
is a hash, you'll probably also have to escape it, too.  Like so:

   SELECT cn.[Cust##] AS CustNum
   FROM [Customer Numbers] cn

(I'm using the table alias to show you that each part of the table name has
to be in its own brackets ([dbname]..[tablename].[fieldname]), just in case
you were wondering.)

This also works well with Excel spreadsheets when used as datasources.
(Those things almost *never* have SQL-compliant field and table names.)

-Rick

P.S. - I think this is the thing which drives me the most crazy when working
with customers.  :)

-Original Message-
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 3:00 PM
To: Cf-Talk
Subject: Escaping Pound Signs in a CF Query


For some strange and utterly inconvenient reason, our former Access Database
guy had created a form field named Cust#.  I imagine this stands for
CustNumber, but CF doesn't seem to agree.  Is there a way to escape a #
(pound sign) so i can query the table?

I've tried doing a "Cust# As CustNum" as well as Cust##.  Nothing seems to
work.

Anyone know of anything?

Thanks In Advance!!

Mark Armendariz
Righteous Design



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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Where can I get custom tag to ZIP files ?

[Jeremy Allen]

You could just use zlib and do your own compression
decompression in a CFX.. its not terribly complex
since I have used it before in PerlScripts and
for some C programming I did :)

zlib is free btw and you can find more examples
of it in use than you can shake a stick at :)

Jeremy Allen
[EMAIL PROTECTED]

-Original Message-
From: lsellers [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 3:49 AM
To: [EMAIL PROTECTED]
Subject: RE: Where can I get custom tag to ZIP files ?




> Hi,
> I am trying to make a script that can zip log files through
> ColdFusion tags.
>
> Do you have any idea where I can get the specialized custom tag like
> CFX_Zip?
>
> Thanks in advanced

Buy Ben Forta's tag or roll your own. Only two options... unless you cf
generate bat files and cfexecute them to use pkzip25.exe.

--min


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Jeremy Allen]

StructDelete(structure, key) :)

If you wanted to clear the structe you COULD





And you are left with a mere shell of
the structure you once had  :)

Or you can use StructClear which clears
out the *data* only.

Jeremy

-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 11:02 AM
To: [EMAIL PROTECTED]
Subject: Re: StructClear


StructClear destroys struct keys.  As for deleting structures altogether,
I'm not sure.  Surely there's got to be a way to unset variables, right?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Stas Newdel <[EMAIL PROTECTED]>
To: CFTalk <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 3:44 AM
Subject: StructClear


>Does StructClear reset keys in a structure to be blank, or does it remove
>the keys? Also, what's a function to get rid of a structure altogether?
>
>Thank you
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Rick Osborne]

Stas-

The StructClear() function completely empties a structure; keys and
everything.  Let's extend this for a second.  Take the following situation:

   
   
   

A structure with 2 keys, right?  Now, you can clear this structure one of
two ways:

   
   
   

There is an important distinction, however.  Remember that structures are
passed (and assigned) by reference.  So, let's assume that foo still has
some data in it, and let's add the following scenario:

   

Now, whether you use StructClear() or StructNew() actually matters!  This is
because brick and foo now point to the *same data*.  Not copies of the data,
but the same data.  To show this, you could now do:

   
   #foo.bat#

This is perfectly valid.  So, as you can see, StructClear() and StructNew()
will now do two very different things.  If you use StructClear():

   

Then you are acting on the reference, you will therefore be clearing out the
brick structure while you are at it:

   #StructCount(brick)#
   

But, it we back up and use StructNew() instead:

   

Then we are now simply overwriting foo's copy of the reference.  So foo gets
a new structure and brick stays intact:

   #StructCount(brick)#
   
   #StructCount(foo)#
   

In this way, you can see that assigning to foo does not affect brick, but
using functions that work on foo will affect brick (because the functions
take a copy of the reference, while assigning overwrites the reference with
a new one).

So, to answer your second function, you can clear a structure any way you
want:

   
   
   
   

This distinction actually has several uses, but it's a bit tricky if you
aren't wary of it.  I've helped many a CF programmer who were tearing their
hair out because they had used one instead of the other.  :)

HTH,
Rick


-Original Message-
From: Stas Newdel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 5:45 PM
To: CFTalk
Subject: StructClear


Does StructClear reset keys in a structure to be blank, or does it remove
the keys? Also, what's a function to get rid of a structure altogether?

Thank you



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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 not letting go of database connection?

[Todd Ashworth]

Oops .. sorry.  I was giving you instructions for Sybase ASA 6.0.3

For 5.5.04, open your DSN properties.  Beside "Database Startup", there is a
button labeled "Options".  Click on that.  In the middle of the next page,
you should see a check box labeled "Autostop database".  Put a check in that
box and see if that helps.

Todd Ashworth

- Original Message -
From: "Boris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 10:15 AM
Subject: FW: CF not letting go of database connection?


| Yes, the database connection on my server remains open even after the
| session has been closed.  I'm looking at my DSN, but the Sybase 5.5.04
| driver doesn't have that option.  I've tried in my CF 4.0 Administrator to
| set the Limit database connection inactive time to 1 minute, that doesn't
| seem to work either.
|
| Boris
|
| -Original Message-
| From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
| Sent: September 1, 2000 7:10 AM
| To: [EMAIL PROTECTED]
| Subject: Re: CF not letting go of database connection?
|
|
| Do you mean that the database engine stays running even after the last
| connection has been closed?
|
| If so, go to your ODBC administrator in your control panel and open the
| properties for the DSN in question.  Under the "Database" tab, you will
have
| 2 checkboxes at the bottom.  One is to automaticly start the database if
it
| isn't running and the other is to shut down the database after the last
| disconnect.  You will want to check the second one.  Note that with this
| option checked, anytime the database is not being queried, the database
| engine will shut down.  This means that it will have to restart every time
a
| new query comes along, which adds about 1 second of overhead (YMMV).
|
| Todd Ashworth
|
|
| - Original Message -
| From: "Boris" <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, August 31, 2000 1:20 PM
| Subject: CF not letting go of database connection?
|
|
| | I have a number CF based pages that once the query is completed with the
| | data presented it will not let go of the database connection to my
Sybase
| | SQL Anywhere database.  Even after the page has been exited.
| |
| | Any suggestion would be appreciated.
| |
| | Boris
|
|
| --
--
| --
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| To Unsubscribe visit
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
| send a message to [EMAIL PROTECTED] with 'unsubscribe' in
| the body.
|
| --

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


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

LouLex CFUG

[Nick McClure]

Last Night the new Louisville/Lexington ColdFusion User Group had our first 
meeting.

We had about 20 people show up to our first meeting and I have already 
spoken to a few people that plan to attend the next meeting.

If there is anybody out there interested in joining the group you can send 
me some email and we will get you on the list.

We are getting ready to start work on the group web site which will be at 
www.LouLexCFUG.com
--
Nick McClure[EMAIL PROTECTED]
Technical Director  859.245.9656
squareFish Mediawww.squareFish.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: getting data from queries as a structure/array

[Rick Osborne]

I have several reasons for not using evaluate:

1. I think it is *very* ugly.
2. I think that if you're using Evaluate() then you're probably not doing
something right, or you haven't thought it through fully.  There are a few
occasions where it is necessary, but not as often as it is used.  (Tie-in
with number 1: I have seen some *nsty* code that used Evaluate() all
over the place.  )
3. It's is *much* slower than pretty much anything else.

Now, I know how much we hard-core geeks love metrics, so I'm going to
provide some for that last statement.  I ran time trials of assigments using
Evaluate() and the equivalent statements without it.  Results and the code
to generate them are below (remember that lower is faster and better):

Struct: 0,78,422,797,4000
Eval: 16,203,1063,2078,10422

Struct: 0,78,391,796,3984
Eval: 31,219,1046,2110,10438

Struct: 16,78,391,782,3984
Eval: 15,203,1016,2078,10375

Struct: 0,79,390,781,4015
Eval: 16,203,1031,2078,10532

Struct: 16,78,407,797,4000
Eval: 15,203,1046,2078,10453

The code:






  
  
  



  




  






  



  
  Struct: #StructTimes#Eval: #EvalTimes#




-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:24 PM
To: [EMAIL PROTECTED]
Subject: RE: getting data from queries as a structure/array


Why would you avoid using Evaluate I can think of
a few reasons but I am interested in hearing your
Reasons :)

Jeremy Allen
[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: IIS "Locking" Files

[Benjamin S. Rogers]

I guess I don't understand exactly what you're getting at. I wasn't
suggesting this was something other than an issue with the way IIS handles
file locking and caching.

The folks who designed WebCam32 built a work around into the WebCam32
software for the file locking issue. It reduces the frequency of the problem
to approximately 1/1000.

Another solution may be to have the image source call a ColdFusion template
that reads and returns the image using the  tag. You should be
able to establish an exclusive lock by placing the  around this.
This may produce access denied errors from WebCam32.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 8:40 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS "Locking" Files


WebCAM isn't the problem.  It is IIS.  WebCAM is uploading a temporary file
and then renaming to the "default" name.  The problem is that the CF page
that I am using to display the images is looking for the "default" name.
The browser access via CF is what is causing the lock to be placed on the
system.  The webcams in question will be in a display booth at a trade show,
and I will not have the ability to take advantage of the "push" feature.
FTP is the way I need to go.

Dave

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 18:37
To: [EMAIL PROTECTED]
Subject: RE: IIS "Locking" Files


What the folks who designed the WebCam32 software intended was for the app
to upload the file with a temporary name and then rename the file. This
avoids the locking issue in most cases.
This works, however, I'd recommend their JavaPushCam applet. This can be
customized to suit your needs fairly well and degrades gracefully on slower
connections. It also precludes the necessity of having to reload the entire
page.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:23 PM
To: Jim McAtee; [EMAIL PROTECTED]
Subject: RE: IIS "Locking" Files


This is a multi-part message in MIME format.
--=_NextPart_000_0052_01C01370.1F8B9480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Re: IIS "Locking" FilesWell, I would, except that I am using the FTP client
builtin to WebCAM32 and it is not as flexible.  I don't want to write a
complete application around this.
DC
  -Original Message-
  From: Jim McAtee [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, August 31, 2000 16:43
  To: [EMAIL PROTECTED]
  Cc: David E. Crawford
  Subject: Re: IIS "Locking" Files


  Dave,
  You might also try a different approach to naming the uploaded files.
  If possible, have your webcam upload the images with a unique filename.
  For example, instead of uploading as "thispic.jpg", append a timestamp,
  as in "thispic1405.jpg".  Your CF template that displays the image could
  do a CFDIRECTORY using a filter of "thispic*.jpg", sort by date
  (descending), and then select the latest image.  Clean out the directory
  as needed.  Definitely a bit more work, but you wouldn't have to disable
  anything in IIS.
  Jim



  -Original Message-
  From: David E. Crawford <[EMAIL PROTECTED]>
  To: CF-Talk <[EMAIL PROTECTED]>
  Date: Thursday, August 31, 2000 6:42 AM
  Subject: IIS "Locking" Files



  >A while back there was some discussion of a registry hack which would
  allow
  >the disabling of the "lock" that IIS places on files during "read"
  >operations.  I understand that it may have a bearing on performance,
  >however, I am in a situation where I am ftp'ng webcam images into a
  >directory, which are then "called" via CFM template.  Unfortunately the
  >browser access to the files appears to be placing an exclusive lock on
  the
  >file, which means the FTP process is failing.
  >
  >Does anyone recall the technique used to defeat this "feature" of IIS?
  >
  >Dave
  >---
  >David E. Crawford
  >Director, Internet Development
  >Yale Security Group, Inc.
  >www.yalesecurity.com


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

Re: IIS "Locking" Files



Well,=20
I would, except that I am using the FTP client builtin to WebCAM32 and =
it is not=20
as flexible.  I don't want to write a complete application around=20
this.
 
DC
 

  -Original Message-From: Jim McAtee=20
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 31, =
2000=20
  16:43To: [EMAIL PROTECTED]Cc: David E.=20
  CrawfordSubject: Re: IIS "Locking" =
Files
  Dave, 
  You might also try a different approach to naming =
the uploaded=20
  files. If possible, have your webcam upload =
the images=20
  with a unique filename. For example, instead =
of=20
  uploading as "thispic.

RE: Lotus Notes

[Moneymaker, Jon S.]

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

We have an application running on Domino Server written in Noteswe
attempted to connect to the notes files via ODBC (which worked)(we used
Lotus' ODBC connector from their site)...HOWEVER(major, however) we
tested a write back to the data from CF and it hosed the record, and had to
be reconstructednot fun.

It worked (for the most part) one way...ONLY.

Lotus Notes is it's own thing.

Jon

-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 4:13 AM
To: '[EMAIL PROTECTED]'
Subject: Lotus Notes


Morning guys,

I have a client with an existing Lotus notes/domino system, Rather than
writing a contacts dB if possible i'd like to use the existing one, does
anyone know if notes is ODBC compliant and if possible could someone point
me to any resources on doing this. Cheers

Stewart



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
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_01C01430.3A5B46A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Lotus Notes



We have an application running on Domino Server =
written in Noteswe attempted to connect to the notes files via ODBC =
(which worked)(we used Lotus' ODBC connector from their =
site)...HOWEVER(major, however) we tested a write back to the data =
from CF and it hosed the record, and had to be reconstructednot =
fun.

It worked (for the most part) one way...ONLY.


Lotus Notes is it's own thing.


Jon


-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]">mailto:Stewart.McGowan@w=
eir-tech.co.uk]
Sent: Friday, September 01, 2000 4:13 AM
To: '[EMAIL PROTECTED]'
Subject: Lotus Notes



Morning guys,


I have a client with an existing Lotus notes/domino =
system, Rather than
writing a contacts dB if possible i'd like to use =
the existing one, does
anyone know if notes is ODBC compliant and if =
possible could someone point
me to any resources on doing this. Cheers


Stewart



---=
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

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_01C01430.3A5B46A0--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Found NT Auth_User -- Need a FULLNAME

[Paul Sizemore]

When I got in this morning, I d/l Lewis's tag (getUserGroups) and started
working with it (I had considered it, but was turned off by the $200 -
didn't see the freeware text, but your app is very nice - good job). Then I
d/l domainUser. Perfect solution. I can't help but think of all the time I
spent learning/working with the other tags (time not wasted, but not exactly
productive!) 

Thank you, and remember,

The Internet is like a bunch of garage sales; You're not guaranteed
anything, but sometimes you find a real treasure.

Paul
-Original Message-
From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 9:02 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Found NT Auth_User -- Need a FULLNAME

I think you'll find a tag on allaire's developer exchange called
CFX_DomainUser which will do this and is also free.




>> I've searched the archives and experimented with several tags, but can
not
>> find how to pull a full name of the user.
> I have the CGI.Auth_User  from the NT Authorization (the employees
>> initials), but now I want their FULLNAME (from NT). How do I get this?
>>
>> Paul

>Well,... if you go to
>http://www.intrafoundation.com/intranethostingtoolkit.zip and download the
>eval zip you'll find a little freeware tag included called
>cfx_getusergroups. In a round about way you can get the fullname from that
>(you'll have to cfloop the query though).

>--min


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

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

Re: can you store a structure in a client var?

[JustinMacCarthy]

You can store a structure in a session variable. Only string values are
allowed in client vars, but if want to store a client structure just convert
it to a wddx packet first

~Justin

- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 4:23 PM
Subject: RE: can you store a structure in a client var?


> Client vars are stored as cookies unless otherwise changed by the
> cfapplication or administrator and I think there are checks to not allow
> this if stored in the registry:-)
>
>
> -Original Message-
> From: Stas Newdel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 1 September 2000 2:45 AM
> To: CFTalk
> Subject: can you store a structure in a client var?
>
>
> I remember that you can't store a structure in either a session or a
client
> var, could anybody please refresh my memory?
>
> Thank you
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Dave Watts]

> Does StructClear reset keys in a structure to be blank, or 
> does it remove the keys? 

It removes keys and values.

> Also, what's a function to get rid of a structure altogether?

I don't think there is one. You could overwrite a structure with a simple
value:


...


One of the nice things about CF is that you don't have to expend much effort
usually to clean up your variables; they'll only last until the page has
been fully executed if they're local variables. If they're in Session or
Application scope, those are themselves structures, so you can use
StructDelete to get rid of your structure:


...


Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: cflocking.. new allaire article

[paul smith]

Instead of yet another article on CFLOCK, and endless
postings on CFLOCKing, why doesn't Allaire write a
parser that checks templates for CFLOCK and include it
in Studio 4.5x?

best,  paul

At 02:15 PM 9/1/00 +0200, you wrote:
>In case someone here isn't subscribed to FusionAuthority News
>Alert:
>
>"Jim Schley, Premier Support, Allaire Corp., has come forth
>with this very important explanation of some of the best
>practices involved with locking shared variables. If you
>don't follow these practices, folks, you may run into some
>unforeseen pitfalls."
>
>http://www.allaire.com/handlers/index.cfm?ID=17318&Method=Full
>
>--
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Structures, Arrays, Array of Structures

[Dave Watts]

> is there any way to dump the whole content of the "GetYPs" 
> query into the structure all at once without having to Loop 
> through the query?

No.

> also, what will be the scope of the STTEMP structure, I 
> assume it will be the page, unless you specify otherwise 
> (client, server, etc), am I right... 

Yes. Keep in mind that you can only store complex data objects in memory
variables, so you wouldn't be able to put it directly within a Client
variable unless you serialized it using CFWDDX into a string.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Illegal operation in CFHTTP

[Gene Kraybill]

What might cause the following occasional error, apparently related to the use of 
CFHTTP to create a query from a text file?
--
Message: Illegal operation in Cold Fusion Extension (CFX)
Detail: You have attempted to refer to an invalid row/column combination of a query. 
This query contains 1 rows. You can call CCFXQuery::GetRowCount to determine 
the number of rows contained within a query.
You can call CCFXQuery::GetColumns to determine the number of columns 
contained within a query.
The error occurred while processing an element with a general identifier of 
(CFHTTP), occupying document position (29:4) to (34:22).

-

Here's the CFHTTP at that spot in the template:



(The file is create dynamically for logging page visits in a Fusebox setting.)

Any ideas?

Gene Kraybill
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: How to display across a row instead of down?

[paul smith]

Here ya go:




#Class_Name# 
#Class_Name# 
   
  
  
 
  
   
  
 
  
  
   



Set MAXROWS equal to an even multiple of 3 (that is, 96 not 99) to get the 
correct alternating row color from one page to the NEXT page.

best,  paul


At 05:12 PM 9/1/00 +1100, you wrote:

>I want to display the results of my query in 3 columns instead of one.  I
>know the method is something to do with mod3, but I'm dashed if i can
>figure it out.
>
>What I want to get is:
>
>[record1] [record2] [record3]
>[record4] [record5] [record6]
>etc
>
>Can anyone help me please with how to code it?
>
>Cheers,
>Mike Kear
>AFP Web Development
>Windsor, NSW, Australia
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

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

RE: can you store a structure in a client var?

[Dave Watts]

> Client vars are stored as cookies unless otherwise changed by 
> the cfapplication or administrator and I think there are checks 
> to not allow this if stored in the registry:-)

Actually, by default, Client variables are stored in the Registry. What's
stored as cookies are the two tokens used to associate a specific browser
with a specific set of Client variables.

You can specify that you want to store Client variables within a big cookie
on the browser, but you have to specify that.

In any case, you can only store strings in Client variables, no matter where
you store them. You'd have to serialize a structure, query or array using
WDDX if you want to store it in a Client variable.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 not letting go of database connection?

[Todd Ashworth]

Nope .. I double checked.  The second option is labeled "Automatically shut
down database after last disconnect."  That would lead me to believe that it
will do just what it says when checked.  If left unchecked, it will leave
the database running.  The first option says "Automatically start the
database if it isn't running."  So, to have the database start by itself and
stay running, check the first box and uncheck the second.  To have the
database start by itself and shut down after the last disconnect, check the
first and check the second.

Now, this is for Sybase.  Are you speaking in reference to SQL Server by any
chance?

Todd Ashworth

- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 11:12 AM
Subject: RE: CF not letting go of database connection?


| I would like to say that you have this information wrong, from memory if
the
| second option is clicked then it maintains the connection. so unchecking
it
| would close it when not being used. And the other one is for disabling the
| DB connection:-)
|
| I think you need to rethink what you said:-)
|
|
| -Original Message-
| From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
| Sent: Saturday, 2 September 2000 12:10 AM
| To: [EMAIL PROTECTED]
| Subject: Re: CF not letting go of database connection?
|
|
| Do you mean that the database engine stays running even after the last
| connection has been closed?
|
| If so, go to your ODBC administrator in your control panel and open the
| properties for the DSN in question.  Under the "Database" tab, you will
have
| 2 checkboxes at the bottom.  One is to automaticly start the database if
it
| isn't running and the other is to shut down the database after the last
| disconnect.  You will want to check the second one.  Note that with this
| option checked, anytime the database is not being queried, the database
| engine will shut down.  This means that it will have to restart every time
a
| new query comes along, which adds about 1 second of overhead (YMMV).
|
| Todd Ashworth
|
|
| - Original Message -
| From: "Boris" <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, August 31, 2000 1:20 PM
| Subject: CF not letting go of database connection?
|
|
| | I have a number CF based pages that once the query is completed with the
| | data presented it will not let go of the database connection to my
Sybase
| | SQL Anywhere database.  Even after the page has been exited.
| |
| | Any suggestion would be appreciated.
| |
| | Boris


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

Re: New and Worried (terminating a session)

[Jamie Keane]

You can specify a session variable's timeout in the  tag (in
fact, you MUST set it).  Session variables can last as long as you want them
to, but bear in mind that they typically reside in memory, so be judicious
about their usage!  As for terminating the session, you can use the
StructClear() function.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: megan sherman <[EMAIL PROTECTED]>
To: cold fusion <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 3:38 AM
Subject: New and Worried (terminating a session)


>Hi all,
>This is proving to be an informative list! I have worked out a lot of
>the cold fusion portion of my latest site. Session variables are still a
>mystery. How do I turn off a session? In other words, if I leave the
>website and come back in an hour, or next day, I want a fresh session.
>Can this be done in applications.cfm with a timer/counter? I think I
>read somewhere that a session can be terminated with javascript.
>Earlier, someone posted the cold fusion script below. Will that
>terminate my session after 30 minutes (or do I have to modify this code
>somewhat?) Any help would be greatly appreciated. BTW, what is the
>philosphy of a "session"? Do customers expect their session to be
>persistant over days?
>Thanks!
>Megan
>
>
>I use this which deletes all client variables if they haven't been
>accessed in 30 minutes:
>
>
>
>
>
> 
> 
> 
> 
> 
>
> 
> 
> 
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: StructClear

[Jamie Keane]

StructClear destroys struct keys.  As for deleting structures altogether,
I'm not sure.  Surely there's got to be a way to unset variables, right?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Stas Newdel <[EMAIL PROTECTED]>
To: CFTalk <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 3:44 AM
Subject: StructClear


>Does StructClear reset keys in a structure to be blank, or does it remove
>the keys? Also, what's a function to get rid of a structure altogether?
>
>Thank you
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Escaping Pound Signs in a CF Query....

[Mark Armendariz]

I gave that a shot last night, to no avail... It just doesnt seem to like
the pound sign(#) in the sql query.  I'm trying to get the new db guy to
change the field name, but it's going to take a while, so i'd like to create
a workaround..

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:04 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Escaping Pound Signs in a CF Query


Yes. Either change it Cust ## or something else like Cust num. This also
applies to using the hex colour codes - eg: ##ff intead of the usual
#ff - within CFOUTPUT. The double pound signs cancel out the usual
CFOUTPUT requirement.

Peter Tilbrook
Internet Applications Developer
Aspect Computing Pty. Ltd.
19-25 Moore Street
Turner, ACT, 2612
AUSTRALIA

http://www.aspect.com.au

Phone: (02) 6247 7677
Fax: (02) 6249 1620
Mobile: 0428 765 020

ACT ColdFusion Users Group - http://203.37.24.198


-Original Message-
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 September 2000 5:00
To: Cf-Talk
Subject: Escaping Pound Signs in a CF Query


For some strange and utterly inconvenient reason, our former Access Database
guy had created a form field named Cust#.  I imagine this stands for
CustNumber, but CF doesn't seem to agree.  Is there a way to escape a #
(pound sign) so i can query the table?

I've tried doing a "Cust# As CustNum" as well as Cust##.  Nothing seems to
work.

Anyone know of anything?

Thanks In Advance!!

Mark Armendariz
Righteous Design



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

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

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