RE: Subdirectories in CustomTags directory?
Coldfusion will use sub directories under the customtags directory, the problem is if I see what you doing correctly is having the same name in some cases. You can't have 2 tags named the same as the one that was found first will be called... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Saturday, 31 March 2001 12:31 AM To: CF-Talk Subject: Subdirectories in CustomTags directory? Hello, Is there a way to call a custom tag that's in a subdirectory of ... \CFUSION\CustomTags ? In other words, I want to organize some custom tags into subdirectories: \CFUSION\CustomTags\Site1\CT1.cfm (+ CT1a.cfm , CT1b,cfm, ...) \CFUSION\CustomTags\Site2\CT2.cfm (+ CT2a.cfm, CT2b.cfm, ...) I have tried this, but apparently, CF won't look in subdirectories of the "CustomTags" directory. Is there a way to get CF to look in them? Alternatively, is there another way to manage custom tags? Thanks, Jamie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SELECT * Queries
Hi all. I've always been told, and read here that using * in SELECT queries is slower than specifying the field names. I just happen to be working on a site now where I have a page with 3 big SELECT queries. One of them with over 100 fields. If I use * in lieu of the field names, the page execution time is reduced from +- 250 milliseconds to +- 185 milliseconds, with the actual query times being cut by about 1/3. Anyone else experience this? The 2 largest queries have no joins, but even the one with a join goes from 50 ms to 35 ms if I use: SELECT L.*,B.* Have I been reading this wrong? I've sure wasted alot of time entering field names into Select queries , not to mention slowing down my apps. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFDIRECTORY
Is it possible to run CFDIRECTORY against a directory on another machine other than the CF server? I can't seem to get it to output. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SELECT * Queries
What Database are you using? I've found nearly no performance problems using * in lieu of specific fields in Access; in many cases it's been quicker by a large margin, not to mention coding it... Perhaps the issue here is when/if the site expands, and is ported to Oracle or Sybase where performance would be a major issue? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com - Original Message - From: "Bud" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Saturday, March 31, 2001 1:37 PM Subject: SELECT * Queries Hi all. I've always been told, and read here that using * in SELECT queries is slower than specifying the field names. I just happen to be working on a site now where I have a page with 3 big SELECT queries. One of them with over 100 fields. If I use * in lieu of the field names, the page execution time is reduced from +- 250 milliseconds to +- 185 milliseconds, with the actual query times being cut by about 1/3. Anyone else experience this? The 2 largest queries have no joins, but even the one with a join goes from 50 ms to 35 ms if I use: SELECT L.*,B.* Have I been reading this wrong? I've sure wasted alot of time entering field names into Select queries , not to mention slowing down my apps. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
I, for one, would love to see more support for Simple Message Board. Tony put a huge amount of effort into the admin of the application, and it paid off. I was able to quickly see which features needed modification, I set up my headers and footers, and I was up and running in short order. There were a couple of modules not yet complete when I downloaded it. It would be great to get them all operational. --John "Benjamin S. Rogers" wrote: Not to discourage you from starting an open source project, but there are already several in the works. Allaire Forums was open sourced and can be found at http://www.forumspot.org. There is also Simple Message Board, which can be found at http://www.simplemessageboard.com/. You may want to investigate these products and consider throwing your effort at one of these products instead of starting a new one. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SELECT * Queries
The warning about wildcards (*) is due to users wanting specific fields yet returning a whole record b/c it's easier to type (which is a huge waste). If you truely do want every piece of information (and will continue to do so in the future ie. even if fields are added) then by all means that's what a wildcard is for. One thing to consider with large queries is the overhead of transmitting the statement itself, if you're getting a small record set with many fields (or a single record) your sql statement can be almost as large as the returned set. This is where stored procedures come in, Access doesn't support them but you can store the query server side and use it's views to mimic very basic sps. I never use Access if I have any choice in the matter, so for the exact syntax to do so you might want to check SWYNK out (http://www.swynk.com) whenver you have to do anything even remotely related to M$ it's a great place to start, so is MSDN (http://msdn.microsoft.com). Even with small queries executed thousands of times daily the transmission of the query can account for a large part of traffice. Without going into a lot of detail, other DBMSs (I use the term loosely in regards to Access ;) with varying degrees of sp support will also optimise/compile the query for added performance benefit. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: March 31, 2001 07:07 To: CF-Talk Subject: RE: SELECT * Queries On 3/31/01, Jonathan Lim penned: Hi Bud, My DBA told me that the * will mean more data has to be transferred from the DB server to your CF server. That's what slows it down. The DB time spent getting the data for * or for a specific field is negligable. We're working with DB2. I understand that if I only needed data for 10 out of 100 fields, then yes it would be quicker to name the fields. But what about when I need the entire record? I read from someone on here that CF had to do an extra call to the database or something. Like once to get the field names and then to query it. In answer to Luke, I'm using Access on this little app I'm building. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to tell if a QUERY UPDATE fails.
I know how to tell if a QUERY SELECT fails -- recordcount() is zero. How do you tell if a QUERY UPDATE or QUERY INSERT fails?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Bud [SMTP:[EMAIL PROTECTED]] Sent: Saturday, March 31, 2001 10:09 AM To: CF-Talk Subject:RE: SELECT * Queries On 3/31/01, Arden Weiss penned: Simple question from my older twin -- what do you do to get these timings -- haven't done it before (obviously). The template execution time and query times are shown when debugging is active. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a QUERY UPDATE fails.
Arden, If the query truly fails, you'll get an error from the DBMS. If "failure" is the query running without affecting any rows, you can check @@rowcount after executing the statement: UPDATE foo SET bar = 1 WHERE id = 2 SELECT @@rowcount This is on SQL Server and Sybase. I'm sure others have similar functionality. Cheers, Seva Petrov -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 31, 2001 10:39 AM To: CF-Talk Subject: How to tell if a QUERY UPDATE fails. I know how to tell if a QUERY SELECT fails -- recordcount() is zero. How do you tell if a QUERY UPDATE or QUERY INSERT fails?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Bud [SMTP:[EMAIL PROTECTED]] Sent: Saturday, March 31, 2001 10:09 AM To: CF-Talk Subject: RE: SELECT * Queries On 3/31/01, Arden Weiss penned: Simple question from my older twin -- what do you do to get these timings -- haven't done it before (obviously). The template execution time and query times are shown when debugging is active. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Variables for shopping cart?
Hi, I'm using a basic client variable, client.adshop, to set a list of Advert Numbers (eg 876,567,987,665) which are later cflooped to query the Database. They're part of a basic shopping cart, and I need to allow the removing of items in that list/variable by the user. Do I need an Array for this (not much experience with arrays) - or else how can I do it? Thanks Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Seeing who's logged in
Not sure I fully understand - could you show me an example bit of code? I'm
still not familiar with structures.
Cheers
Will
Yep, using the application scope just set a var in a struct (their id as
key, now() as value) then clean it up for all entries
dateAdd('n', -session
timeout, now()) and you'll have a pretty good idea of who's logged in
(w/in
the session timeout limit). Just make sure to lock the scope properly, you
can also do this db in the client vars if you want.
-Original Message-
From: Yoshi Melrose [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 16:17
To: CF-Talk
Subject: Re: Seeing who's logged in
Wouldn't session variables work for this? That's what I've used in the
past
for anything that was sensitive to browser sessions. I know they're kinda
flaky sometimes, which is why I try not to use them.
Any other ideas? I'd like to know any other suggestions as well, sounds
like
something I could integrate into one of my own apps.
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 5:29 PM
Subject: Seeing who's logged in
Hi,
On one of my sites users log in, and client.email is set - for the
members-only sections, it then checks to see if client.email is set and
lets
them in (or tells them to login) accordingly. How can I add a "Who's
online" section..to display which users are currently logged in? Because
even if the user closes their browser, won't their token/cfid still be
in
the Database and therefore they'll appear "online" even though they're
not?
Or have I lost the plot...(run out of Red Bull...coffee just doesn't do
it...)
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDIRECTORY
Is it possible to run CFDIRECTORY against a directory on another machine other than the CF server? Perfectly possible as long as you either access it through a mapped drive, or give the server network privileges and use a UNC path. We do it through mapped drives here, since we are leery of letting CF have network privileges. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
I, for one, would love to see more support for Simple Message Board. Tony put a huge amount of effort into the admin of the application, and it paid off. I was able to quickly see which features needed modification, I set up my headers and footers, and I was up and running in short order. There were a couple of modules not yet complete when I downloaded it. It would be great to get them all operational. Wow, thanks. I'm working on two things right now that are kind of tedious. First, I'm fusebox-ing it. And being it's my first fusebox app, you can understand if I take my time. ;p Second, I'm adding multi-language support. All text strings will be one single file for easy translation and you can switch languages on the fly. Also, I've had some help re-writing certain queries for MySQL and identifying areas to rewrite for CFExpress support. That means a completely free os, db, webserver, appserver and forum software package will be available... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
AI!! Fusebox! *covers ears with hands* noo. -Gel -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Wow, thanks. I'm working on two things right now that are kind of tedious. First, I'm fusebox-ing it. And being it's my first fusebox app, you can understand if I take my time. ;p Second, I'm adding multi-language support. All text strings will be one single file for easy translation and you can switch languages on the fly. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
Heehee. I'm not convinced I will leave it like that, though... But I would be interested in hearing what you don't like about the idea... AI!! Fusebox! *covers ears with hands* noo. -Gel -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Wow, thanks. I'm working on two things right now that are kind of tedious. First, I'm fusebox-ing it. And being it's my first fusebox app, you can understand if I take my time. ;p Second, I'm adding multi-language support. All text strings will be one single file for easy translation and you can switch languages on the fly. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Seeing who's logged in
/* in the Application.cfm */
// if user logging struct isn't there, make it so
if (not isDefined('application.user')) {
application.user = structNew() ;
}
// insert user's id and current time (for last access calcs)
structInsert(application.user, session.uuid, now()) ;
/* on the display page */
// run through all the users that are logged in
for (u in application.user) {
// if user's last access is older than their session timeout, remove them
if (dateCompare(application.user[u], dateAdd('n', -20, now()), 'n') lt 1) {
structDelete(application.user, u) ;
// else they might still be logged in, show them as such
}else{
writeOutput(u application.user[u]) ;
}
}
This is only to illustrate the concept, you'll want to do some heavy editing
before you use it: Locking, copying to local vars for display, etc. are all
things to consider. I have no idea the number of users you expect, etc. so
you'll have to decide if this is right for you.
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: March 31, 2001 08:41
To: CF-Talk
Subject: Re: Seeing who's logged in
Not sure I fully understand - could you show me an example bit of code? I'm
still not familiar with structures.
Cheers
Will
Yep, using the application scope just set a var in a struct (their id as
key, now() as value) then clean it up for all entries
dateAdd('n', -session
timeout, now()) and you'll have a pretty good idea of who's logged in
(w/in
the session timeout limit). Just make sure to lock the scope properly, you
can also do this db in the client vars if you want.
-Original Message-
From: Yoshi Melrose [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 16:17
To: CF-Talk
Subject: Re: Seeing who's logged in
Wouldn't session variables work for this? That's what I've used in the
past
for anything that was sensitive to browser sessions. I know they're kinda
flaky sometimes, which is why I try not to use them.
Any other ideas? I'd like to know any other suggestions as well, sounds
like
something I could integrate into one of my own apps.
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 5:29 PM
Subject: Seeing who's logged in
Hi,
On one of my sites users log in, and client.email is set - for the
members-only sections, it then checks to see if client.email is set and
lets
them in (or tells them to login) accordingly. How can I add a "Who's
online" section..to display which users are currently logged in? Because
even if the user closes their browser, won't their token/cfid still be
in
the Database and therefore they'll appear "online" even though they're
not?
Or have I lost the plot...(run out of Red Bull...coffee just doesn't do
it...)
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDIRECTORY
I tried to do it through a mapped drive in a win2k desktop test environment going to a networked win95 machine. While it appeared that CF read the directory, it did not do a simple listing of the information within an output statement. Any thoughts? At 11:42 AM 3/31/2001 -0600, you wrote: Is it possible to run CFDIRECTORY against a directory on another machine other than the CF server? Perfectly possible as long as you either access it through a mapped drive, or give the server network privileges and use a UNC path. We do it through mapped drives here, since we are leery of letting CF have network privileges. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Seeing who's logged in - but a question on application variab les between applications
is it possible to read variables from one application from another...
lets say you had an administrator page that was separate from the main site,
thusly a separate application name, but you wanted to see who was on...
could you actually read the mainsite.appliaction.user struct from the admin
site??
so far, i have used 5-10 min cached database queries to do this... but
wonder about the above... could have other value as well...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-Original Message-
From: Raymond B. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 2:03 PM
To: CF-Talk
Subject: RE: Seeing who's logged in
/* in the Application.cfm */
// if user logging struct isn't there, make it so
if (not isDefined('application.user')) {
application.user = structNew() ;
}
// insert user's id and current time (for last access calcs)
structInsert(application.user, session.uuid, now()) ;
/* on the display page */
// run through all the users that are logged in
for (u in application.user) {
// if user's last access is older than their session
timeout, remove them
if (dateCompare(application.user[u], dateAdd('n', -20,
now()), 'n') lt 1) {
structDelete(application.user, u) ;
// else they might still be logged in, show them as such
}else{
writeOutput(u application.user[u]) ;
}
}
This is only to illustrate the concept, you'll want to do
some heavy editing
before you use it: Locking, copying to local vars for
display, etc. are all
things to consider. I have no idea the number of users you
expect, etc. so
you'll have to decide if this is right for you.
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: March 31, 2001 08:41
To: CF-Talk
Subject: Re: Seeing who's logged in
Not sure I fully understand - could you show me an example
bit of code? I'm
still not familiar with structures.
Cheers
Will
Yep, using the application scope just set a var in a struct
(their id as
key, now() as value) then clean it up for all entries
dateAdd('n', -session
timeout, now()) and you'll have a pretty good idea of
who's logged in
(w/in
the session timeout limit). Just make sure to lock the
scope properly, you
can also do this db in the client vars if you want.
-Original Message-
From: Yoshi Melrose [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 16:17
To: CF-Talk
Subject: Re: Seeing who's logged in
Wouldn't session variables work for this? That's what I've
used in the
past
for anything that was sensitive to browser sessions. I know
they're kinda
flaky sometimes, which is why I try not to use them.
Any other ideas? I'd like to know any other suggestions as
well, sounds
like
something I could integrate into one of my own apps.
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 5:29 PM
Subject: Seeing who's logged in
Hi,
On one of my sites users log in, and client.email is set - for the
members-only sections, it then checks to see if
client.email is set and
lets
them in (or tells them to login) accordingly. How can I
add a "Who's
online" section..to display which users are currently
logged in? Because
even if the user closes their browser, won't their
token/cfid still be
in
the Database and therefore they'll appear "online" even
though they're
not?
Or have I lost the plot...(run out of Red Bull...coffee
just doesn't do
it...)
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Seeing who's logged in - but a question on application variab les between applications
Server scope, or name them all the same application
-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: March 31, 2001 12:38
To: CF-Talk
Subject: RE: Seeing who's logged in - but a question on application
variab les between applications
is it possible to read variables from one application from another...
lets say you had an administrator page that was separate from the main site,
thusly a separate application name, but you wanted to see who was on...
could you actually read the mainsite.appliaction.user struct from the admin
site??
so far, i have used 5-10 min cached database queries to do this... but
wonder about the above... could have other value as well...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-Original Message-
From: Raymond B. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 2:03 PM
To: CF-Talk
Subject: RE: Seeing who's logged in
/* in the Application.cfm */
// if user logging struct isn't there, make it so
if (not isDefined('application.user')) {
application.user = structNew() ;
}
// insert user's id and current time (for last access calcs)
structInsert(application.user, session.uuid, now()) ;
/* on the display page */
// run through all the users that are logged in
for (u in application.user) {
// if user's last access is older than their session
timeout, remove them
if (dateCompare(application.user[u], dateAdd('n', -20,
now()), 'n') lt 1) {
structDelete(application.user, u) ;
// else they might still be logged in, show them as such
}else{
writeOutput(u application.user[u]) ;
}
}
This is only to illustrate the concept, you'll want to do
some heavy editing
before you use it: Locking, copying to local vars for
display, etc. are all
things to consider. I have no idea the number of users you
expect, etc. so
you'll have to decide if this is right for you.
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: March 31, 2001 08:41
To: CF-Talk
Subject: Re: Seeing who's logged in
Not sure I fully understand - could you show me an example
bit of code? I'm
still not familiar with structures.
Cheers
Will
Yep, using the application scope just set a var in a struct
(their id as
key, now() as value) then clean it up for all entries
dateAdd('n', -session
timeout, now()) and you'll have a pretty good idea of
who's logged in
(w/in
the session timeout limit). Just make sure to lock the
scope properly, you
can also do this db in the client vars if you want.
-Original Message-
From: Yoshi Melrose [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 16:17
To: CF-Talk
Subject: Re: Seeing who's logged in
Wouldn't session variables work for this? That's what I've
used in the
past
for anything that was sensitive to browser sessions. I know
they're kinda
flaky sometimes, which is why I try not to use them.
Any other ideas? I'd like to know any other suggestions as
well, sounds
like
something I could integrate into one of my own apps.
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 5:29 PM
Subject: Seeing who's logged in
Hi,
On one of my sites users log in, and client.email is set - for the
members-only sections, it then checks to see if
client.email is set and
lets
them in (or tells them to login) accordingly. How can I
add a "Who's
online" section..to display which users are currently
logged in? Because
even if the user closes their browser, won't their
token/cfid still be
in
the Database and therefore they'll appear "online" even
though they're
not?
Or have I lost the plot...(run out of Red Bull...coffee
just doesn't do
it...)
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Forums
Does anybody know if you can configure Forums to run discussions from multiple sites on a host server? Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
Tony Schreiber wrote: But I would be interested in hearing what you don't like about the idea... My original reaction was similar if not a bit more restrained. My concern is that I don't use fusebox myself and I think that this would limit the usability of SMB because if my lack of familiarity with it. If I use fusebox and SMB doesn't then is implementing SMB into a fusebox site as difficult as implementing a fusebox based SMB into a non-fusebox site? I don't use fusebox. I don't have any plans to learn it and I think that my plans to utilise SMB will therefore stop dead because I don't want to have to learn a development methodology on top of learning to navigate through a new codebase. -- Remember, what we do here might seem like criminal fraud but its not. Its marketing! Scott Adams email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5 Beta 3
Is anybody else out there having trouble installing CF5.0 Beta 3? I get an empty pop up box every time it gets the cfgraph installation. This is the whole reason I downloaded the new beta. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDIRECTORY
Jim Gurfein wrote: I tried to do it through a mapped drive in a win2k desktop test environment going to a networked win95 machine. While it appeared that CF read the directory, it did not do a simple listing of the information within an output statement. Off the top of my head, there are only two things I can remember having problems with on a mapped drive: 1) The DirectoryExists() function doesn't work on it (it finds subdirectories, but doesn't treat the root level of the mapped drive as a directory). So we had code along the lines of if the directory X:\ exists, do a CFDIRECTORY, and the code never executed. We fixed that by dropping a dummy file in there and checking for the existence of the dummy file. 2) If you are using mapped drives on WINx, the computer with the mappings *has* to be logged in (you can't reboot into that press cntrl-alt-delete to log in state we know and love). The mappings are a function of the individual login -- if the computer is not logged into to the account you created the mappings in, ColdFusion can't see them. Those are the two problems we've hit (especially #2 -- the machine will reach a critical mass of errors, reboot itself, but not log in, which gets messy). If I can think of any other issues we've had, I'll let you know. Can you send the code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
zac, I'm not sure, but you may be over-thinking this. Tony's application is simple enough without Fusebox. Coding it in that methodology, believe it or not, would make it even easier for you to modify or troubleshoot, even with no prior exposure to Fusebox. Fusebox is still CFML, after all. If he breaks it out in a consistent manner, the files will be shorter, and the program flow will be more logical and easier to follow. The only differences that might throw you into unfamiliar territory will lie in some of the application-level files. --John zac wrote: Tony Schreiber wrote: But I would be interested in hearing what you don't like about the idea... My original reaction was similar if not a bit more restrained. My concern is that I don't use fusebox myself and I think that this would limit the usability of SMB because if my lack of familiarity with it. If I use fusebox and SMB doesn't then is implementing SMB into a fusebox site as difficult as implementing a fusebox based SMB into a non-fusebox site? I don't use fusebox. I don't have any plans to learn it and I think that my plans to utilise SMB will therefore stop dead because I don't want to have to learn a development methodology on top of learning to navigate through a new codebase. -- Remember, what we do here might seem like criminal fraud but its not. Its marketing! Scott Adams email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Auto Parts Database?
Can anyone on the list point me toward an existing auto parts database schema? Because of the many vehicles they can fit on, different ways that manufacturers refer to them, and the different ways individual parts can be categorized it seems that a database to accommodate them all must be quite complex, perhaps with different tables for different types of parts. Rather than reinvent the wheel I'm hoping someone can help me out here... Regards, Karl Simanonok Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
*whimpers* *mumbles fusebox several times fearfully* ;-P hee hee hee Ok ok..seriously..I share Zac's concerns. Us islanders are just slightly more excitable is all ^_^ . Yes it is CFML, and in some cases it may be easier..but it still adds a further layer of complexity to the message board system, in that you now have to take the time to understand this particular methodology, and make your own changes in keeping with it. So you can't deny that using fusebox specifically DOES add some overhead to modifying the system. It will no longer be the Simplemessageboard.. it will be the Fuseboxed(AIEEE!)simplemessageboard. ^_^ -Gel www.carigamer.com Island Gaming At Its Best!(tm) Coldfusion Powered! -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] zac, I'm not sure, but you may be over-thinking this. Tony's application is simple enough without Fusebox. Coding it in that methodology, believe it or not, would make it even easier for you to modify or troubleshoot, even with no prior exposure to Fusebox. Fusebox is still CFML, after all. If he breaks it out in a consistent manner, the files will be shorter, and the program flow will be more logical and easier to follow. The only differences that might throw you into unfamiliar territory will lie in some of the application-level files. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
John Allred wrote: I'm not sure, but you may be over-thinking this. Tony's application is simple enough without Fusebox. Coding it in that methodology, believe it or not, would make it even easier for you to modify or troubleshoot, even with no prior exposure to Fusebox. Based on what empirical evidence? I've looked over Fusebox and I don't particularly think that the program flow is logical at all. Nor easier to implement. I will say that this is based on a cursory examination of fusebox. If he breaks it out in a consistent manner, the files will be shorter, and the program flow will be more logical and easier to follow. And it will cure male pattern baldness. Check with your physician before use. I'm not trying to be argumentative but this is an assumption is it not? I'm not trying to cast any dispersions on Tony's coding style either but language like yours does tend to sound more like marketing and less like facts. Tony did you consult your current user base before making this move? And if people don't want to use fusebox will you still have the older codebase available for download? -- It is dangerous to be right when the government is wrong. Voltaire email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cold Fusion Sites and the Mac User
Been developing a site with a small shopping cart for a client in Cold Fusion. There's a secure section of the site that only allows certain users to enter and order items... Site runs great locally, plus on several different PC from the server, plus any clients on PCs that have tested it have no trouble. Then I get this phone call..."It's all broke...I'm getting "Object Expected" errors everywhere. What are those? Is the server down?" I tear my hair out testing and retesting and can't find the problem. After two days of frustration, THEN the client tells me "I'm on a Mac, is that a problem?" So, I'm doing stuff like below: My Security Application settings: CFAPPLICATION NAME="SiteSecure" CLIENTMANAGEMENT="Yes" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,40,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,0,40,0)#" CLIENTSTORAGE="registry" SETDOMAINCOOKIES="No" My "LOGIN" code from the login_process page. cfif DoLogin.RecordCount EQ 1 cfset Session.LoggedIn="True" cfset Session.ClientID="#DoLogin.ID cflocation url="home.cfm" addtoken="No" /cfif So, what here does NOT work for a Mac user browsing the site? What can i do to insure that Mac users CAN use this section of the site? If there's a reference out there on a site somewhere concerning this, a pointer to it would be nice. Couldn't really find anything out there on the Allaire site concerning problems with Macs. Thanks! -- Les Mizzell Who Needs Intel? ATHLON INSIDE! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Sites and the Mac User
I found some FORM post data is stored in the memory, If the customer is doing other things the form data doesn't stay. Also, I've only found this to be a problem with IE on a Mac and not Netscape - Original Message - From: "Les Mizzell" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 5:07 PM Subject: Cold Fusion Sites and the Mac User Been developing a site with a small shopping cart for a client in Cold Fusion. There's a secure section of the site that only allows certain users to enter and order items... Site runs great locally, plus on several different PC from the server, plus any clients on PCs that have tested it have no trouble. Then I get this phone call..."It's all broke...I'm getting "Object Expected" errors everywhere. What are those? Is the server down?" I tear my hair out testing and retesting and can't find the problem. After two days of frustration, THEN the client tells me "I'm on a Mac, is that a problem?" So, I'm doing stuff like below: My Security Application settings: CFAPPLICATION NAME="SiteSecure" CLIENTMANAGEMENT="Yes" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,40,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,0,40,0)#" CLIENTSTORAGE="registry" SETDOMAINCOOKIES="No" My "LOGIN" code from the login_process page. cfif DoLogin.RecordCount EQ 1 cfset Session.LoggedIn="True" cfset Session.ClientID="#DoLogin.ID cflocation url="home.cfm" addtoken="No" /cfif So, what here does NOT work for a Mac user browsing the site? What can i do to insure that Mac users CAN use this section of the site? If there's a reference out there on a site somewhere concerning this, a pointer to it would be nice. Couldn't really find anything out there on the Allaire site concerning problems with Macs. Thanks! -- Les Mizzell Who Needs Intel? ATHLON INSIDE! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Sites and the Mac User
Then I get this phone call..."It's all broke...I'm getting "Object Expected" errors everywhere. What are those? Is the server down?" I tear my hair out testing and retesting and can't find the problem. After two days of frustration, THEN the client tells me "I'm on a Mac, is that a problem?" Are you using javascript anywhere? Without further data, I would guess 'Objected expected' refers to a js problem. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
Tony did you consult your current user base before making this move? And if people don't want to use fusebox will you still have the older codebase available for download? Not before, and I honestly wasn't sure that I was going to release it in fusebox, but I felt that I'd try the "method" and see how it worked with SMB. I figured I'd end up with two versions, not that I want that though. As it stands now, if you want see the fusebox version in its current state, it's at http://www.simplemessageboard.com/fusebox/ and it uses the same database as the existing demo forum. I just finished 90% of the rewriting links (and corresponding cfcase index structure), used the cf_bodycontent method for header and footer and started moving a couple queries to cfinclude. The latter will be helpful for the MySQL version. If I have to maintain two versions, it won't really be that hard. My code is pretty self-contained as it is (ie: one page per task) and is in neat chunks that I can move easily... But I've received 2 comments that said "don't do it" and 1 that said "do it"... So, I don't know. If I complete the fusebox version, I'll probably have it available as additional version, rather than a replacement. I'm going to focus on finishing the language part - that's so much more a pain... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
Tony Schreiber wrote: Not before, and I honestly wasn't sure that I was going to release it in fusebox, but I felt that I'd try the "method" and see how it worked with SMB. I figured I'd end up with two versions, not that I want that though. Well speaking as the "guy what wrote it" do you think that anyone seeking to us or modify your code will need to know that much of the fusebox methodology? -- Being dyslexic means never having to say you're surry for spelling mistakes email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDIRECTORY
Simply, I found that I could do this in a full blown server development environment but that the desktop setup does not work... could be permissions. Thanks for all your help! At 05:00 PM 3/31/2001 -0600, you wrote: Jim Gurfein wrote: I tried to do it through a mapped drive in a win2k desktop test environment going to a networked win95 machine. While it appeared that CF read the directory, it did not do a simple listing of the information within an output statement. Off the top of my head, there are only two things I can remember having problems with on a mapped drive: 1) The DirectoryExists() function doesn't work on it (it finds subdirectories, but doesn't treat the root level of the mapped drive as a directory). So we had code along the lines of if the directory X:\ exists, do a CFDIRECTORY, and the code never executed. We fixed that by dropping a dummy file in there and checking for the existence of the dummy file. 2) If you are using mapped drives on WINx, the computer with the mappings *has* to be logged in (you can't reboot into that press cntrl-alt-delete to log in state we know and love). The mappings are a function of the individual login -- if the computer is not logged into to the account you created the mappings in, ColdFusion can't see them. Those are the two problems we've hit (especially #2 -- the machine will reach a critical mass of errors, reboot itself, but not log in, which gets messy). If I can think of any other issues we've had, I'll let you know. Can you send the code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
Not before, and I honestly wasn't sure that I was going to release it in fusebox, but I felt that I'd try the "method" and see how it worked with SMB. I figured I'd end up with two versions, not that I want that though. Well speaking as the "guy what wrote it" do you think that anyone seeking to us or modify your code will need to know that much of the fusebox methodology? Well, not really, assuming you plan to use SMB for its intended purpose. The code most peolpe woudl modify (display code, navigation, etc) is the same whether it's in fusebox or not. The things that fusebox changes the most that I can see so far are the file structure (along with a lot of includes) and the variable scopes. But if you're unhappy with the thread display in SMB, you're going to edit the stuff in thread.cfm or dsp_thread.cfm, either way, it's the same code. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
*claps gleefully* Oooh my we have a live one here! ^_^ *holds little mushroom up to fire* *turns it so it gets nice and toasty evenly* Just to add something, Fusebox doesn't look all that difficult to learn, or implement.. However as this discussion shows, and as Tony himself said, it does take a bit of effort to implement, as he himself has had to spend time learning it. What I want to know, is what are the true benefits to your user base, both current and future. Will the Fusebox specification/format have to change with the introduction of CF5, and later..CF6? And how will this affect something like Fuseboxed(AIEEE!)SimpleMessageBoard which must be a constantly updated application, and keep up with these changes? -Gel -Original Message- From: zac [mailto:[EMAIL PROTECTED]] Based on what empirical evidence? And it will cure male pattern baldness. Check with your physician before use. but language like yours does tend to sound more like marketing and less like facts. Tony did you consult your current user base before making this move? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfwddx action=wddx2cfml question
I have a table of data that was populated by an app not built by me (so I'm starting off at a disadvantage in terms of not knowing everything about it - I'm getting more info to help clear that up). In two of the columns in the table (SQL Server 7), the data has been stored as WDDX packets. So, I'm doing the following to get at them and have a look at the data in a more usable and understandable form: | cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" name="getpacket" maxrows="1" | SELECT T.Col1, T.Col2 | FROM OldDataTable T | /cfquery | | cfwddx action="WDDX2CFML" input="#getpacket.col1" output="col1query" | cfwddx action="WDDX2CFML" input="#getpacket.col2#" output="col2query" | | cfoutput | #col1query.recordcount#br | #col1query.columnlist#br | br | #col2query.recordcount#br | #col2query.columnlist#br | /cfoutput All pretty straightforward, right? Both of the cfwddx tags execute fine and I see the recordcount and columnlist from col1query. However, when it gets to the col2query outputs, I get the following: | Error Diagnostic Information | An error occurred while evaluating the expression: | #col2query.recordcount# | | Error near line 26, column 2. | -- -- | Error resolving parameter COL2QUERY.RECORDCOUNT | | The object RECORDCOUNT is not present in the scope named COL2QUERY. It is likely that you | have misspelled the name of the object you are trying to access. Now, if it was an invalid packet (which it doesn't look like when I just output it to the screen), it would fail the cfwddx call, right? Since it passes it, why can't I access it like a query? Col1query works just fine. Gives me a recordcount, a columnlist, I can loop over records, etc. etc. etc. Thanks in advance for any insight anyone can offer. Let's not even discuss the fact that I'm working on this at 12:35 on April Fools Day ;-) Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Well -- your not the only fool up hacking away... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Evan Lavidor [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 12:36 AM To: CF-Talk Subject:cfwddx action="wddx2cfml" question I have a table of data that was populated by an app not built by me (so I'm starting off at a disadvantage in terms of not knowing everything about it - I'm getting more info to help clear that up). In two of the columns in the table (SQL Server 7), the data has been stored as WDDX packets. So, I'm doing the following to get at them and have a look at the data in a more usable and understandable form: | cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" name="getpacket" maxrows="1" | SELECT T.Col1, T.Col2 | FROM OldDataTable T | /cfquery | | cfwddx action="WDDX2CFML" input="#getpacket.col1" output="col1query" | cfwddx action="WDDX2CFML" input="#getpacket.col2#" output="col2query" | | cfoutput | #col1query.recordcount#br | #col1query.columnlist#br | br | #col2query.recordcount#br | #col2query.columnlist#br | /cfoutput All pretty straightforward, right? Both of the cfwddx tags execute fine and I see the recordcount and columnlist from col1query. However, when it gets to the col2query outputs, I get the following: | Error Diagnostic Information | An error occurred while evaluating the expression: | #col2query.recordcount# | | Error near line 26, column 2. | -- -- | Error resolving parameter COL2QUERY.RECORDCOUNT | | The object RECORDCOUNT is not present in the scope named COL2QUERY. It is likely that you | have misspelled the name of the object you are trying to access. Now, if it was an invalid packet (which it doesn't look like when I just output it to the screen), it would fail the cfwddx call, right? Since it passes it, why can't I access it like a query? Col1query works just fine. Gives me a recordcount, a columnlist, I can loop over records, etc. etc. etc. Thanks in advance for any insight anyone can offer. Let's not even discuss the fact that I'm working on this at 12:35 on April Fools Day ;-) Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
An ignorance question to the masters
Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: An ignorance question to the masters
I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message - From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fwd: CF5 Beta 3
I too am getting that empty box on cfgraph, when I end task on that window, it continues the install and installs Advanced Security ok but the third item fails with the same blank box. Hopefully this is not a preview of the final product. Alex ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
