RE: Truncating Logs

[Rich Wild]

the only thing I could really find (except switching trunc. log on chkpt.
database option TRUE in the db properties) was this  which resizes the size
of the file.


FROM BOL:

DBCC SHRINKFILE (T-SQL)
Shrinks the size of the specified data file or log file for the related
database.

Syntax
DBCC SHRINKFILE 
({file_name | file_id } 
{[, target_size]
|[, {EMPTYFILE | NOTRUNCATE | TRUNCATEONLY}]
}
)

Arguments
file_name 
Is the logical name of the file being shrunk. File names must conform to the
rules for identifiers. For more information, see Using Identifiers. 
file_id 
Is the identification number (ID) of the file to be shrunk. To obtain a file
ID, use the FILE_ID function or search sysfiles in the current database. 
target_size 
Is the desired size for the file in megabytes, expressed as an integer. If
not specified, DBCC SHRINKFILE reduces the size as much as possible. 
If target_size is specified, DBCC SHRINKFILE attempts to shrink the file to
the specified size. Used pages in the part of the file to be freed are
relocated to available free space in the part of the file retained. For
example, if there is a 10-MB data file, a DBCC SHRINKFILE with a target_size
of 8 causes all used pages in the last 2 MB of the file to be reallocated
into any available free slots in the first 8 MB of the file. DBCC SHRINKFILE
does not shrink a file past the size needed to store the data in the file.
For example, if 7 MB of a 10-MB data file is used, a DBCC SHRINKFILE
statement with a target_size of 6 shrinks the file to only 7 MB, not 6 MB. 

EMPTYFILE 
Migrates all data from the specified file to other files in the same
filegroup. Microsoft® SQL Server(tm) no longer allows data to be placed on
the file used with the EMPTYFILE option. This option allows the file to be
dropped using the ALTER DATABASE statement. 
NOTRUNCATE 
Causes the freed file space to be retained in the files. 
When NOTRUNCATE is specified along with target_size, the space freed is not
released to the operating system. The only effect of the DBCC SHRINKFILE is
to relocate used pages from above the target_size line to the front of the
file. When NOTRUNCATE is not specified, all freed file space is returned to
the operating system. 

TRUNCATEONLY 
Causes any unused space in the files to be released to the operating system
and shrinks the file to the last allocated extent, reducing the file size
without moving any data. No attempt is made to relocate rows to unallocated
pages. target_size is ignored when TRUNCATEONLY is used. 

> -Original Message-
> From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 21:06
> To: CF-Talk
> Subject: SQL: Truncating Logs
> 
> 
> Does anyone know the TSQL for truncating a transaction log? 
> Mind sharing?
> 
> TIA,
> Duane
> 
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: SQL Profiler

[David Cummins]

Hi all,

I've been experimenting with using SQL profiler to record unusual SQL events. I
soon found that you could save traces as a SQL file which executes the stored
procedures to start a trace. However, I only had this working once, and now all
it does is save a 0 byte file when I save as SQL. Has it suddenly broken, or
have I mislaid the menu item which does it? Help!

David Cummins

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: HELP: Cold Fusion returns 404 when using POST (solved)

[Joseph DeVore]

-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 7:10 PM
To: Joseph DeVore
Subject: Re: HELP: Cold Fusion returns 404 when using POST


One of those little ironies of life - I found the UrlScan thing shortly
after
sending the email, after spending 4 hours trying to solve it. Argh. I had
actually fixed the problem accidentally by restoring the old IIS state, and
when
I went to reinstall UrlScan I found the log file, complete with denied
posts.
The other machine I installed it on did *not* deny posts by default. I have
no
idea why.

Thanks!

David

Joseph DeVore wrote:
>
> David,
>
> Have you checked to see if you have an URLSCAN.INI file?
> winnt\system32\inetsrv\urlscan\urlscan.ini
>
> If so, you may want to look at [options] and the [Deny Extensions] list.
>
> Also, have you checked that the .CFM application mapping in IIS?
>
> It should point to: cfusion\bin\iscf.dll and not to
> winnt\system32\inetsrv\404.dll
> You may want to check the 'All Verbs' radio button and the Script Engine
> checkbox
>
> HTH,
>
> Joseph DeVore
> VeloxWeb Technologies
>
> -Original Message-
> From: David Cummins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 4:47 PM
> To: CF-Talk
> Subject: HELP: Cold Fusion returns 404 when using POST
>
> Hi all,
>
> We have a server here which we recently ran the IIS 5 lockdown on, and
we're
> not
> sure if this is related, but now all posts to CF pages return 404s! The
same
> pages will execute fine with a get. The site has GET, HEAD, POST and DEBUG
> enabled, so I wouldn't think it would be that. And why a 404? I might
expect
> an
> access forbidden or something, but a 404? We've done a complete CF 5
> reinstall,
> with no luck.
>
> David Cummins
>
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Certification

[Dave Carabetta]

Actually, I was at the CFUG New York meeting the other night and Michael
Dinowitz announced that MM is pushing to have CF MX out by the "summer time"
and further suggested June as a time table. So I don't think August is a bad
time to release a new cert exam, do you?

Regards,
Dave.

- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 07:25 PM
Subject: Re: CF Certification


> Hm.
> "Macromedia's Certification Department is working on a new certification
> exam for the next release of ColdFusion.  We expect to release this exam
> in August 2002. "
>
> So I guess that means that the next relase of CF will be out before or
around August 2002.  I
> thought MM wasn't going to tell us when it was coming out, but ya can't
have an exam without a
> product now can you ;-)
>
> Thanks Ben
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Truncating Logs

[Dave Watts]

> Does anyone know the TSQL for truncating a transaction log?

This should work:

BACKUP LOG mydatabase WITH TRUNCATE_ONLY

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

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[Dave Watts]

> So both the SQL (all statements) and the Query NAME must be 
> IDENTICAL to the cached query?
> 
> I would rather just run a blank (bare-bones SQL statement 
> that returns just one or zero records) because the actual 
> query returns 8,000 records and takes a few seconds to 
> execute.

Yes, both the CFQUERY tag attributes (name, datasource, username, password)
and SQL must be identical.

You can flush all cached queries using the CFOBJECTCACHE tag, however:


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

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Dynamic Images

[list peters]

hi,

Flash would do this quite easily.

Have the 4 images x and y in a database and bring it into flash to display.
Easily create the dynamic images you need..

wont save as bitmap - but you could serve it up dynamically anytime

you could always take a screenshot if desperately need a bitmap a bit
too much..

but flash is great for what you are describing (except making a bitmap)

chad

> Hi All,
>
> I know Generator could do it by as the usual story goes no Budget.
>
> Any How
>
> What I require is the ability to have a base image for example the out
line
> of a Football Pitch
>
> Then the ability to track lets say 4 Round Images around the pitch.
>
> When Happy save the image off as a Bitmap and save the X,Y of the top left
> of eachof the Round Images
>
> Any Ideas?
>
> Cheers
>
> Kev
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: HELP: Cold Fusion returns 404 when using POST

[Joseph DeVore]

David,

Have you checked to see if you have an URLSCAN.INI file?
winnt\system32\inetsrv\urlscan\urlscan.ini

If so, you may want to look at [options] and the [Deny Extensions] list.

Also, have you checked that the .CFM application mapping in IIS?

It should point to: cfusion\bin\iscf.dll and not to
winnt\system32\inetsrv\404.dll
You may want to check the 'All Verbs' radio button and the Script Engine
checkbox

HTH,

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:47 PM
To: CF-Talk
Subject: HELP: Cold Fusion returns 404 when using POST


Hi all,

We have a server here which we recently ran the IIS 5 lockdown on, and we're
not
sure if this is related, but now all posts to CF pages return 404s! The same
pages will execute fine with a get. The site has GET, HEAD, POST and DEBUG
enabled, so I wouldn't think it would be that. And why a 404? I might expect
an
access forbidden or something, but a 404? We've done a complete CF 5
reinstall,
with no luck.

David Cummins


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Target back to parent.

[han peng]

okok.. this is wat i do.. i hav it working to call for a look up.. from
main.. to a child.. then do a query and pass bk my query result to the
parent...


heres the codes.. hope it helps..


--- start of parent-



.
..
  ...
   
BLK/HSE NO.

FLR.

UNIT

 
 
  
  
ST

BLDG

  
  
PD

 
 blahblah..

end of parent---

---start of child---

this only contains how i pass the value bk to parent..

  
  
  

---end of child---

cheers
han
- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 5:47 AM
Subject: RE: Target back to parent.


> Niel out of curiosity.. is your child window modal?  If so, the rules
> are a little bit different.  We've found that the only way to process the
> action page nicely (meaning without a blank window opening for a moment),
is
> to use a hidden IFRAME on the modal window, and set our form's target to
the
> IFrame.
>
> Before we did this (and having proved it again afterwards), we were
getting
> some tough javascript problems to fix (unable to refresh the current page,
> etc.).
>
> Hope that helps.
>
> Shawn Grover
>
>
> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 11, 2002 2:36 PM
> To: CF-Talk
> Subject: Re: Target back to parent.
>
>
> 
> This is frustrating.  What a long day.
>
> Neil
>
> - Original Message -
> From: "Steve Oliver" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 11, 2002 4:05 PM
> Subject: RE: Target back to parent.
>
>
> > That's what I have netscape for.  That's the only thing I like about it,
> > is it's little javascript error log. It catches every javascript error,
> > unlike IE, which sometimes lets them fly on by without doing anything.
> >
> > _
> > steve oliver
> > senior internet developer
> > atnet solutions, inc.
> > http://www.atnetsolutions.com
> >
> >
> > -Original Message-
> > From: Neil H. [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 11, 2002 4:01 PM
> > To: CF-Talk
> > Subject: Re: Target back to parent.
> >
> >
> > Yeah for some reason that bit of code didn't work :(
> >
> > Neil
> >
> > - Original Message -
> > From: "Steve Oliver" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, March 11, 2002 3:51 PM
> > Subject: RE: Target back to parent.
> >
> >
> > > You don't need to send the form variables back to the "mainwindow".
> > >
> > > Just submit the form in the child window, process the data there, then
> > > close it and reload the main window, you will see the changes there
> > upon
> > > reload.
> > >
> > > _
> > > steve oliver
> > > senior internet developer
> > > atnet solutions, inc.
> > > http://www.atnetsolutions.com
> > >
> > >
> > > -Original Message-
> > > From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, March 11, 2002 3:47 PM
> > > To: CF-Talk
> > > Subject: RE: Target back to parent.
> > >
> > >
> > > Sure, just put a form in the child window, that goes to an action page
> > > (in the child window) to update your dbase or whatever.
> > >
> > > Then at the end of the action page. Include this.
> > >
> > > 
> > > opener.location.reload();
> > > wndow.close();
> > > 
> > >
> > >
> > >
> > > _
> > > steve oliver
> > > senior internet developer
> > > atnet solutions, inc.
> > > http://www.atnetsolutions.com
> > >
> > >
> > > -Original Message-
> > > From: Neil H. [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, March 11, 2002 3:43 PM
> > > To: CF-Talk
> > > Subject: Re: Target back to parent.
> > >
> > >
> > > This is strange.  The application I am trying to emulate works like
> > > this:
> > > The child window posts back to itself and then forces the parent to
> > > refresh.
> > > I wonder if you all would have any suggestions on this one?
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> > > 

RE: Let's Check My Plan (WDDX questions)

[Chuck McElwee]

Should work fine.  I assume you're posting a form to a page that can loop
through your form variables to create a structure, then serialize it and
stuff it in a hidden field in page 2 of your multi-part form.  You can also
use the JavaScript WDDX functions to serialize the form elements on the
originating form.  Later pages will deserialize the packet and reconstitute
the variables and values.

The code can get a little tricky when creating the dynamic variables - be
sure to check out the SetVariable function, although I generally opt for the
 type of syntax.  With care you can make this type of
code very modular and tight.

Chuck McElwee
etech solutions inc
www.etechsolutions.com


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 7:42 PM
To: CF-Talk
Subject: Let's Check My Plan (WDDX questions)


I'm building an order entry system --

The order takers will be taking phone orders.

They have a couple of different items they can sell, each of requires fairly
significant amount of data to be collected.  Multiple numbers of each item
can be ordered.

I'm going to build a shopping cart for this system.  I've build shopping
carts before using session variables, but this application runs on clustered
servers, so I'm planning on using WDDX.

I've never worked with WDDX before, so I've got a few questions.

When an item is ordered to my cart, would I just add it first to a local
(unscoped variable) -- an array/structure variable -- then serialize it in
WDDX?I would need to store a dozen or more bits of data for each order.

Each item would get added to the WDDX package the same way?  Or after the
first item is added, would I deserialize the WDDX, dumping everything back
to my local variable, then write the additional cart item to the
array/structure, then serialize it all back to WDDX?

Of course, on check out, I would take all of the WDDX info, deserialize it
and insert it into my database tables.

Am I understanding WDDX correctly and the basic logic of what I need to do?
(I don't want to get deep into this and discover my thinking is all screwed
up.)

H.




__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PHP equivalents of CF list functions

[stas]

Oh man :D I'm tired of these "foreach bla bla bla".

-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]] 

*hmph* people and their ListGetAt(), ListSetAt(), ListDeleteAt(), I
develop in Visual Basic there, and if I want a list processing function?
I build my own so there :-p although in reality compared to other
languages such as C++ Visual Basic delivers a fairly good deal of
functions.  However one reason CF is the tops as far as speed of
development is that a lot of the work is done for you in those
functions.


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CustomTags?

[laszlo]

Same problem here,
any post will be appreciated

laszlo

Randy Adkins wrote:

> Does anyone have a copy of the ThreeSelectsRelated Customtag?
>
> It is no longer in the Macromedia site.
>
> TIA!
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

password changed in advanced security

[Mak Wing Lok]

i'm using advanced security with LDAP, and when i run
the code below to update a users password :



the password is successfully updated or should i said
added into the LDAP, as the user is able to login with
the old and new password now, how can i make the
changes reflected immediately so the user can only
login with the new password and not the old password?
and what caused this paroblem

any helps?



__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Is this a bug [here's another: i'm getting pissed]>>>

[Tyler Silcox]

Alrightty then!  I'm getting another error.  This is what I'm trying to do:

// i create the session structures if they do not already exist
if (NOT StructKeyExists(session, "MyStructure")){
session.MyStructure=StructNew();
session.MyStructure.Temp=StructNew();
session.MyStructure.DaRealDeal=ArrayNew(2);
}
// i check the structure for the current FuseAction
if (NOT StructIsEmpty(session.MyStructure.Temp) AND 
StructKeyExists(session.MyStructure.Temp, attributes.FuseAction)){
arrayLen=ArrayLen(session.MyStructure.DaRealDeal) + 1;
session.MyStructure.DaRealDeal[arrayLen][1]=attributes.FuseAction;

session.MyStructure.DaRealDeal[arrayLen][2]=session.MyStructure.Temp[attributes.FuseAction];
}

I'm getting the error: "Error resolving parameter SESSION.RFAS.TEMP", which is being 
thrown when i check MyStructure.Temp (which should be already set up) for the current 
FuseAction.

Am I going crazy or is my server screwing me over, I thought I had structures licked 
(a long time ago) and all of this is completely wiggin me out.  Am I doing something 
wrong?  Is there a better way to see if a structure exists?  All you have to do is 
gimme the word, and I will go and put a bullet in that damn server right now (Win2K 
Server, CF5)...

Tyler Silcox
email | [EMAIL PROTECTED]

- Original Message - 
From: "Tyler Silcox" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 5:21 PM
Subject: Is this a bug (or just a session thing)>>>


I'm trying to get the length of an array set in a session structure and ColdFusion 
just is not playing fair.

This is what I have:

session.MyStructure=StructNew();
session.MyStructure["Temp"]=StructNew();
session.MyStructure["DaRealDeal"]=ArrayNew(1);
#ArrayLen(session.MyStructure["DaRealDeal"])#

and it's throwing me the following error: 

"The expression has requested a variable or an intermediate expression result as a 
simple value, however, the result cannot be converted to a simple value. Simple values 
are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM 
objects are examples of complex values."

But the kooky thing is: it works just fine if I'm using the request scope...who knows->

(ps: everything's locked down correctly, i just gave you the bare-bones version)

Tyler Silcox
email | [EMAIL PROTECTED]



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Fusebox pros and cons

[Jeffry Houser]

  I think he meant Daves.
  There is usually too much client involvement for a well written 
applications to exist.  It is the curse of being the service industry.

At 04:24 PM 3/13/2002 -0600, you wrote:
>What?  well written applications? Or Daves?
>
>-Original Message-
>From: Cary Gordon [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 13, 2002 11:31 AM
>To: CF-Talk
>Subject: RE: Fusebox pros and cons
>
>
>Based on his contributions to this list, I'd guess that there are about a
>dozen...
>
>At 09:11 AM 3/12/2002 -0800, you wrote:
>--- snip ---
> >it is
> >true that any well written CF Application should be logical and structured
> >but there aren't that many Dave Watt's et al in the real CF World,  My
> >sixpence worth.
> >
> >Mike Brunt
> >Sempra Energy
> >213.244.5226
>
>
>
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PHP equivalents of CF list functions

[Gregory Harris]

*hmph* people and their ListGetAt(), ListSetAt(), ListDeleteAt(), I develop
in Visual Basic there, and if I want a list processing function? I build my
own so there :-p although in reality compared to other languages such as C++
Visual Basic delivers a fairly good deal of functions.  However one reason
CF is the tops as far as speed of development is that a lot of the work is
done for you in those functions.



Gregory Harris
[EMAIL PROTECTED]

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:18 PM
To: CF-Talk
Subject: Re: PHP equivalents of CF list functions


For php, I believe that you will need to use the "list" function in
conjunction with a "sort" function. Look up sort in the help file. there is
a new help file on php.net that is done as a .chm






"Success is a journey, not a destination!!"



Doug Brown
- Original Message -
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 11:54 AM
Subject: RE: PHP equivalents of CF list functions


> just go to www.php.net and enter those in the function look up.
>
> -Original Message-
> From: stas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 1:51 PM
> To: CF-Talk
> Subject: PHP equivalents of CF list functions
>
>
> I need to do a bit of PHP development, and I can't believe how much I'm
> spoiled by CF. I have to roll my own for every little thing. Could someone
> post PHP alternatives to functions such as:
>
> listcontains
> find
> valuelist
>
> Anything else that comes to mind.
>
> Thanks!
>
>
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help please

[Nathan Chen]

I think if you have to group by all the fields you select.
try
select ... count(paycatid) as samepaycatid
group by paycatid,employeeid, startdate, enddate



- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 4:10 PM
Subject: Re: SQL help please


> Nope, that doesn't work.
>
> - Original Message -
> From: laszlo <[EMAIL PROTECTED]>
> Date: Wednesday, March 13, 2002 4:06 pm
> Subject: Re: SQL help please
>
> > select ... count(paycatid) as samepaycatid group by paycatid
> >
> > laszlo
> >
> >
> > [EMAIL PROTECTED] wrote:
> >
> > > Anyone?
> > >
> > > Bueller?  Bueller?
> > >
> > > - Original Message -
> > > From: [EMAIL PROTECTED]
> > > Date: Wednesday, March 13, 2002 2:51 pm
> > > Subject: SQL help please
> > >
> > > > Brain not working Must help...
> > > >
> > > > Here's my data set:
> > > >
> > > > employeeid startdate enddate paycatid
> > > > --- --- --- ---
> > > > 936 2002-02-08 2002-02-08 1
> > > > 936 2002-02-11 2002-02-11 1
> > > > 936 2002-02-12 2002-02-12 1
> > > > 936 2002-02-13 2002-02-13 11
> > > > 936 2002-02-14 2002-02-14 1
> > > > 936 2002-02-15 2002-02-15 1
> > > > 936 2002-02-18 2002-02-18 11
> > > > 936 2002-02-19 2002-02-19 11
> > > > 936 2002-02-20 2002-02-20 11
> > > > 936 2002-02-21 2002-02-21 11
> > > > 936 2002-02-22 2002-02-22 11
> > > > 936 2002-02-25 2002-02-25 7
> > > > 936 2002-02-27 2002-02-27 7
> > > >
> > > > What I'm wondering is how do I get something like:
> > > >
> > > > employeeid startdate enddate same paycatid in a row paycatid
> > > > --- --- --- --- --
> > > > 936 2002-02-08 2002-02-12 3 1
> > > > 936 2002-02-13 2002-02-13 1 11
> > > > 936 2002-02-14 2002-02-15 2 1
> > > > 936 2002-02-18 2002-02-22 5 11
> > > > 936 2002-02-25 2002-02-27 2 7
> > > >
> > > > I'm using SQL Server 7.
> > > >
> > > >
> > > >
> > >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Word Doc on Solaris

[Mak Wing Lok]

is it possible to create Word document with CF that
run on Solaris?



__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFPOP unknown exception condition

[Deb Dickerson]

Have you installed the CFPOP Hot fix? TechNote 20371 has full list of hot
fixes.

Deb

> -Original Message-
> From: Owen Leonard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:53 PM
> To: CF-Talk
> Subject: CFPOP unknown exception condition
>
>
> I know I've asked this before, but I'm desperate for a solution
> and need any
> help I can get.  Folks are frequently getting this error when they use our
> web-based email:
>
> Error Diagnostic Information
> unknown exception condition
> unknown error while executing a tag.
>
> The log of the error in the server log looks like this:
>
> Unexpected exception while processing a tag with a general identifier of
> (CFPOP), occupying document position (32:4) to (37:39), while executing
> template file [email.cfm]
>
> ..and the code in question looks like this:
>
>name="Messages"
>attachmentpath="#VARIABLES.AttachDir#"
>server="#VARIABLES.POPserver#"
>timeout="60"
>username="#VARIABLES.Username#"
>password="#VARIABLES.Password#">
>
> I never used to get the error myself, but now it happens EVERY TIME when I
> test it on my local development machine. We're running CF5.  If anyone has
> any advice, I'd be extremely grateful.
>
> --Owen
>
> 
> Athens County Library Services
> http://www.athenscounty.lib.oh.us
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BTAUXDIR Virtual Mapping Macromedia HELP :)

[Deb Dickerson]

I don't know the answer, but if it's CF5, have you tried looking at the
install logs? You can usually find out alot about the installation by
searching through those.

Deb

> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 9:01 AM
> To: CF-Talk
> Subject: Fw: BTAUXDIR Virtual Mapping Macromedia HELP :)
>
>
> This is a repost.  I am hoping someone can answer my question.  I
> don't want
> to open a ticket and pay just to find out how allaire /
> macromedia performs
> an operation.
>
> Neil
>
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 11, 2002 6:16 PM
> Subject: BTAUXDIR Virtual Mapping Macromedia HELP :)
>
>
> > I need to know if the component of CF that adds this mapping
> (btauxdir) to
> > the metabase is using "admin base objects".  I seem to have
> metabase issue
> > and I am working with MS on the issue and I was just trying to find
> programs
> > on the server using these objects.
> >
> > Thanks,
> >
> > Neil
> >
> >
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Let's Check My Plan (WDDX questions)

[Owens, Howard]

I'm building an order entry system -- 

The order takers will be taking phone orders.

They have a couple of different items they can sell, each of requires fairly
significant amount of data to be collected.  Multiple numbers of each item
can be ordered.

I'm going to build a shopping cart for this system.  I've build shopping
carts before using session variables, but this application runs on clustered
servers, so I'm planning on using WDDX.

I've never worked with WDDX before, so I've got a few questions.

When an item is ordered to my cart, would I just add it first to a local
(unscoped variable) -- an array/structure variable -- then serialize it in
WDDX?I would need to store a dozen or more bits of data for each order.

Each item would get added to the WDDX package the same way?  Or after the
first item is added, would I deserialize the WDDX, dumping everything back
to my local variable, then write the additional cart item to the
array/structure, then serialize it all back to WDDX?

Of course, on check out, I would take all of the WDDX info, deserialize it
and insert it into my database tables.

Am I understanding WDDX correctly and the basic logic of what I need to do?
(I don't want to get deep into this and discover my thinking is all screwed
up.)

H.



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_ThreeSelectsRelated

[JAIME HOI]

but the values are generated from DB...so sometimes the value is a
null field (The first field, Box 1,  can never be an empty field, most of
the time its the second field, Box 2,  that is a null field) and so it
cannot be related to the third drop down select, Box 3.  A null field
contains a value too isn't it? Thought its an empty string? 

> -Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 10:13 PM
> To: CF-Talk
> Subject: RE: CF_ThreeSelectsRelated
> 
> 
> Can you be more specific? Are you saying that sometimes have 
> blanks in your
> select boxes? You need a value for each one so the next box 
> can realte to
> the previous one. Does that make sense?
> 
> Ex. (is your data ike this?)
> 
> BOX 1 BOX 2   BOX 3
> aaa   bbb ccc
> ddd   fff
>   hhh iii
> 
> 
> 
> -Original Message-
> From: JAIME HOI [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 2:32 AM
> To: CF-Talk
> Subject: CF_ThreeSelectsRelated
> 
> 
> hi
>I am trying to use this tag...but there's a problem. My 
> Query is like
> this
>   Grp Div Dept
>   GF  ATC
>   MIS IT2
>   MIS IT3
>   GR 1 DIV 1
>   GR 2AC
>Since some of the field values could be empty...esp for 
> the second field
> "DIV", it seems that the custom tag is not able to retrieve 
> the correct Dept
> code out. Anybody know of this workaround?
> 
> 
> Jaime Hoi
> 
> Don't try so hard, the best things come when you least expect them to.
> 
> 
> 
> 
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

HELP: Cold Fusion returns 404 when using POST

[David Cummins]

Hi all,

We have a server here which we recently ran the IIS 5 lockdown on, and we're not
sure if this is related, but now all posts to CF pages return 404s! The same
pages will execute fine with a get. The site has GET, HEAD, POST and DEBUG
enabled, so I wouldn't think it would be that. And why a 404? I might expect an
access forbidden or something, but a 404? We've done a complete CF 5 reinstall,
with no luck.

David Cummins

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Certification

[Bryan Stevenson]

Hm.
"Macromedia's Certification Department is working on a new certification
exam for the next release of ColdFusion.  We expect to release this exam
in August 2002. "

So I guess that means that the next relase of CF will be out before or around August 
2002.  I
thought MM wasn't going to tell us when it was coming out, but ya can't have an exam 
without a
product now can you ;-)

Thanks Ben

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Storyboarding software? - CLARIFICATION

[Douglas Brown]

Blur..uhhh yeah that was what it wa. I thought I was halucinating when I hit 
send/rec :-D



"Success is a journey, not a destination!!"



Doug Brown
- Original Message - 
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 3:21 PM
Subject: RE: Storyboarding software? - CLARIFICATION


> Sorry about the blur of messages - I'm in a hotel and they were apparently
> all queuing up .
> 
> -Original Message-
> From: John Beynon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:21 PM
> To: CF-Talk
> Subject: RE: Storyboarding software? - CLARIFICATION
> 
> 
> http://sourceforge.net/projects/wireframetool/
> 
> It's inbuilt into Adalon (www.synthis.com) for a trial download.
> 
> Jb.
> 
> > -Original Message-
> > From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> > Sent: 13 March 2002 18:22
> > To: CF-Talk
> > Subject: Re: Storyboarding software? - CLARIFICATION
> >
> >
> > Someone posted an app recently that might do what you need,
> > it's like a site/outline skeleton thing...
> >
> > aha, it's called wireframe. I have it downloaded but I can't
> > remember where I got it from.
> >
> > > Should have mentioned 
> > >
> > > We use Visio for navigation, site overview type of
> > storyboarding. Was
> > > thinking more along the lines of page layout/mockup (guess I'm
> > > thinking of more specific page level storyboarding, i.e.,
> > left nav has
> > > these items, ad copy here, articles here, that type of thing).
> > >
> > > Thanks again for your help.
> > > Matt
> > >
> > > On 3/13/2002 11:36 AM, Matt Kornguth <[EMAIL PROTECTED]> wrote:
> > > >Any suggestions on software to use for storyboarding? If
> > not specific
> > > >software for that purpose, what are you using that makes your life
> > > >easier?
> > > >
> > > >Thanks in advance,
> > > >Matt Kornguth
> > > >Web App Developer
> > > >BLR.com
> > > >
> > > >
> > >
> >
> 
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF Certification

[Ben Forta]

Several of you were discussing it, so I found the official answer for
you ...


Macromedia's Certification Department is working on a new certification
exam for the next release of ColdFusion.  We expect to release this exam
in August 2002. Developers who are getting certified before and up until
the release of the new exam will retain their certification status as a
Macromedia Certified Professional for 12 months after the release of the
new exam. After 12 months, we will ask that the ColdFusion 5 Certified
Developers get re-certified on the new release of ColdFusion.
 
For further information on any Macromedia Certification exam, please
contact [EMAIL PROTECTED]  


And there you have it.

--- Ben

==
Ben Forta - Macromedia Inc.
  E-Mail: [EMAIL PROTECTED]
  Phone:  (248)424-8420
  Fax:(248)424-8421
  Macromedia: http://www.macromedia.com/
  Personal:   http://www.forta.com/




__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Microsoft SQL Server: Buffer Overflows in numerous extended stored procedures

[Jon Hall]

Just posted to Bugtraq...

http://www.appsecinc.com/resources/alerts/mssql/02-.html

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[Owens, Howard]

So both the SQL (all statements) and the Query NAME must be IDENTICAL to the
cached query?

I would rather just run a blank (bare-bones SQL statement that returns just
one or zero records) because the actual query returns 8,000 records and
takes a few seconds to execute.

H.



> -Original Message-
> From: Brian Scandale [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 2:18 PM
> To:   CF-Talk
> Subject:  RE: Question About Query Caching
> 
> Now I'm a bit confused...
> 
> I thought that as long as the query had not expired that cf would return
> the cashed results... regardless of which page called the query...
> particularly if the query name and slq were identical.
> 
> ??? am I getting marauded by a donkey?
> 
> 
> At 01:36 PM 3/13/02 -0800, you wrote:
> >LOL. Oops, yeah I sure did. My bad.
> >
> >J.
> >
> > 
> > 
> >John Wilker
> >Web Applications Consultant, and Author
> >Macromedia Certified ColdFusion Developer
> >President/Founder, Inland Empire CFUG.
> >www.red-omega.com
> > 
> >"more people are killed by donkeys than by airplane crashes each year"
> >
> >
> >-Original Message-
> >From: Bud [mailto:[EMAIL PROTECTED]] 
> >Sent: Wednesday, March 13, 2002 1:27 PM
> >To: CF-Talk
> >Subject: RE: Question About Query Caching
> >
> >
> >On 3/13/02, John Wilker penned:
> >>My idea would be to put a query with the same name on the page that 
> >>updates the database. The new query will overwrite the cached one as 
> >>long as the SQL is different, then the first time some one runs the 
> >>real query it will re cache that one.
> >
> >You mean as long as the SQL is IDENTICAL.
> >-- 
> >
> >Bud Schneehagen - Tropical Web Creations
> >
> >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> >ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]
> >http://www.twcreations.com/ 954.721.3452
> >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Is this a bug (or just a session thing)>>>

[Tyler Silcox]

Thanks for testing that out Jochem, I've never seen anything like it before.
I've struggled for the last several hours on this friggin thing, gave up to
ask you peeps for help, read your message, and refreshed my page and wallah;
it now works fine, after throwing an error 40,000 times from the same code.
It makes me want to break something, then I remember that I can actually get
some work done now, which reminds that I've been struggling with something
that's just plain messed up and me wants to break things all over
again...anyways, thanks for the assistance->

Tyler



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Storyboarding software? - CLARIFICATION

[Mark A. Kruger - CFG]

Sorry about the blur of messages - I'm in a hotel and they were apparently
all queuing up .

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:21 PM
To: CF-Talk
Subject: RE: Storyboarding software? - CLARIFICATION


http://sourceforge.net/projects/wireframetool/

It's inbuilt into Adalon (www.synthis.com) for a trial download.

Jb.

> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 18:22
> To: CF-Talk
> Subject: Re: Storyboarding software? - CLARIFICATION
>
>
> Someone posted an app recently that might do what you need,
> it's like a site/outline skeleton thing...
>
> aha, it's called wireframe. I have it downloaded but I can't
> remember where I got it from.
>
> > Should have mentioned 
> >
> > We use Visio for navigation, site overview type of
> storyboarding. Was
> > thinking more along the lines of page layout/mockup (guess I'm
> > thinking of more specific page level storyboarding, i.e.,
> left nav has
> > these items, ad copy here, articles here, that type of thing).
> >
> > Thanks again for your help.
> > Matt
> >
> > On 3/13/2002 11:36 AM, Matt Kornguth <[EMAIL PROTECTED]> wrote:
> > >Any suggestions on software to use for storyboarding? If
> not specific
> > >software for that purpose, what are you using that makes your life
> > >easier?
> > >
> > >Thanks in advance,
> > >Matt Kornguth
> > >Web App Developer
> > >BLR.com
> > >
> > >
> >
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help please

[ksuh]

Nope, that doesn't work.

- Original Message -
From: laszlo <[EMAIL PROTECTED]>
Date: Wednesday, March 13, 2002 4:06 pm
Subject: Re: SQL help please

> select ... count(paycatid) as samepaycatid group by paycatid
> 
> laszlo
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> > Anyone?
> >
> > Bueller?  Bueller?
> >
> > - Original Message -
> > From: [EMAIL PROTECTED]
> > Date: Wednesday, March 13, 2002 2:51 pm
> > Subject: SQL help please
> >
> > > Brain not working Must help...
> > >
> > > Here's my data set:
> > >
> > > employeeid startdate enddate paycatid
> > > --- --- --- ---
> > > 936 2002-02-08 2002-02-08 1
> > > 936 2002-02-11 2002-02-11 1
> > > 936 2002-02-12 2002-02-12 1
> > > 936 2002-02-13 2002-02-13 11
> > > 936 2002-02-14 2002-02-14 1
> > > 936 2002-02-15 2002-02-15 1
> > > 936 2002-02-18 2002-02-18 11
> > > 936 2002-02-19 2002-02-19 11
> > > 936 2002-02-20 2002-02-20 11
> > > 936 2002-02-21 2002-02-21 11
> > > 936 2002-02-22 2002-02-22 11
> > > 936 2002-02-25 2002-02-25 7
> > > 936 2002-02-27 2002-02-27 7
> > >
> > > What I'm wondering is how do I get something like:
> > >
> > > employeeid startdate enddate same paycatid in a row paycatid
> > > --- --- --- --- --
> > > 936 2002-02-08 2002-02-12 3 1
> > > 936 2002-02-13 2002-02-13 1 11
> > > 936 2002-02-14 2002-02-15 2 1
> > > 936 2002-02-18 2002-02-22 5 11
> > > 936 2002-02-25 2002-02-27 2 7
> > >
> > > I'm using SQL Server 7.
> > >
> > >
> > >
> > 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ] RE: cached query

[Mark A. Kruger - CFG]

Updating the welcome query will not work because it does not return a result
set.



-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:28 PM
To: CF-Talk
Subject: [Re:] RE: cached query


In the home page home.index, i have a query like this


   select * from Welcome



In the update admin page welcomeupdate.cfm for this table, i
have a update query like this:


  update Welcome
  set message = '#form.welcomemsg#',
  dateedited = #CreateODBCDateTime(Now())#


so what i should do is to put cachedwithin="#createtimespan(0,0,0,0)#"
 in the UpdateMessage query in the welcomeupdate.cfm and each time
the query update the database the cached query "getWelcome" in the
home.index will be updated instantly, is that correct ?

thanks a lot


On Wed, 13 Mar 2002 21:31:16 -
John Beynon wrote:

>Immediately after you've updated the data, use a query with
>cachedwithin="#createtimespan(0,0,0,0)#" to update the data...then
it will
>be recached on the home page using the 2 days or whatever setting
you want.
>
>John.
>
>> -Original Message-
>> From: FARRAH NG [mailto:[EMAIL PROTECTED]]
>> Sent: 13 March 2002 21:34
>> To: CF-Talk
>> Subject: cached query
>>
>>
>> hi all,
>> i have built a website for a client where the home page is
>> totally dynamics ( the cfm file has almost 10 queries
>> accessing 10 different tables in order to populate the page).
>>  Now the client is complaining about the slow load time.
>> they told me they don't need to have the home page accessing
>> the database everytime the page is loaded since a lot of the
>> info in the page is not changed that frequently.  I am
>> thinking of using the CACHEDWITHIN with some of the CFQUERY
>> in the page, like CACHEDWITHIN 2 days.  What i am worrying
>> about is if the client update the data within those 2 days,
>> the home page will not
>> be able to display the lastest info.  Is there a way to
>> refresh all the cached query once the client update the
>> database, so all the
>> cached queries will also be updated instantly without waiting
>> for the CACHEDWITHIN to expire.
>>
>> Anyone has any idea is very welcomed to suggest.
>>
>> thank
>>
>>
>>
>> --
>> 
>> Global Internet phone calls, voicemail, fax, e-mail and
>> instant messaging. Sign-up today at http://www.hotvoice.com
>>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ] RE: cached query

[Mark A. Kruger - CFG]

John,

Are you saying that using createtimespan to set a 0 value expires the cache
for that query?  If that works, its a neat trick I was unaware of.

Mark

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:26 PM
To: CF-Talk
Subject: RE: ] RE: cached query


No after your

> 
>   update Welcome
>   set message = '#form.welcomemsg#',
>   dateedited = #CreateODBCDateTime(Now())#
> 

Do (all in your welcomeupdate.cfm)

>  datasource="testingDB">
>select * from Welcome
> 

The select expires the cache and then when the next person hits the home
page it will be recached for two days

John.

> -Original Message-
> From: FARRAH NG [mailto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 22:28
> To: CF-Talk
> Subject: [Re:] RE: cached query
>
>
> In the home page home.index, i have a query like this
>
>  datasource="testingDB">
>select * from Welcome
> 
>
>
> In the update admin page welcomeupdate.cfm for this table, i
> have a update query like this:
>
> 
>   update Welcome
>   set message = '#form.welcomemsg#',
>   dateedited = #CreateODBCDateTime(Now())#
> 
>
> so what i should do is to put
> cachedwithin="#createtimespan(0,0,0,0)#"
>  in the UpdateMessage query in the welcomeupdate.cfm and each
> time the query update the database the cached query
> "getWelcome" in the home.index will be updated instantly, is
> that correct ?
>
> thanks a lot
>
>
> On Wed, 13 Mar 2002 21:31:16 -
> John Beynon wrote:
>
> >Immediately after you've updated the data, use a query with
> >cachedwithin="#createtimespan(0,0,0,0)#" to update the data...then
> it will
> >be recached on the home page using the 2 days or whatever setting
> you want.
> >
> >John.
> >
> >> -Original Message-
> >> From: FARRAH NG [mailto:[EMAIL PROTECTED]]
> >> Sent: 13 March 2002 21:34
> >> To: CF-Talk
> >> Subject: cached query
> >>
> >>
> >> hi all,
> >> i have built a website for a client where the home page is
> >> totally dynamics ( the cfm file has almost 10 queries
> >> accessing 10 different tables in order to populate the page).
> >>  Now the client is complaining about the slow load time.
> >> they told me they don't need to have the home page accessing
> >> the database everytime the page is loaded since a lot of the
> >> info in the page is not changed that frequently.  I am
> >> thinking of using the CACHEDWITHIN with some of the CFQUERY
> >> in the page, like CACHEDWITHIN 2 days.  What i am worrying
> >> about is if the client update the data within those 2 days,
> >> the home page will not
> >> be able to display the lastest info.  Is there a way to
> >> refresh all the cached query once the client update the
> >> database, so all the
> >> cached queries will also be updated instantly without waiting
> >> for the CACHEDWITHIN to expire.
> >>
> >> Anyone has any idea is very welcomed to suggest.
> >>
> >> thank
> >>
> >>
> >>
> >> --
> >> 
> >> Global Internet phone calls, voicemail, fax, e-mail and
> >> instant messaging. Sign-up today at http://www.hotvoice.com
> >>
> >
>

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Sprectra (WAS: KILL THE BROADVIEW!)

[Mark A. Kruger - CFG]

That can't do that yet without engendering the ire (pissing off) all those
folks who spent a lot of money on it in the first place.

Mark

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 11:59 AM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


Too bad they won't give it out for free. If you have a product that you
won't support and you don't sell it anymore, why not give it away? I would
love a free copy of Spectra, heck that would let me give some support to the
spectra source site.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:59 PM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


You're right, here is the URL. http://spectrasource.macromedia.com

Mike Brunt
Sempra Energy
213.244.5226

"A complex system that does not work is invariably found to have evolved
from a simpler system that worked just fine. "


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:20 AM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


  Sort of.  There aren't any new versions of it coming out; but it is still
available.  I think it was said that it was left to the 'community source'
model of support?
  I guess that means that it's not dead, they just stopped feeding it.

At 11:15 AM 3/13/2002 -0600, you wrote:
>Isn't Spectra dead?
>
> >>> [EMAIL PROTECTED] 03/13/02 09:11AM >>>
>Yes perhaps they should try Spectra.
>
>Mike Brunt
>Sempra Energy
>213.244.5226
>
>"A complex system that does not work is invariably found to have evolved
>from a simpler system that worked just fine. "
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 13, 2002 8:58 AM
>To: CF-Talk
>Subject: KILL THE BROADVIEW!
>
>
>Arrg!!  Someone please rewrite the Macromedia site in something
>besides Broadview!!  It is so stinking slow!  I can't even view the
>darn CF upgrade pricing list without waiting for 2 minutes
>
>
>
>



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cached query

[Mark A. Kruger - CFG]

Farrah,

Ok - well you are going from no caching to caching for 2 days?   Keep this
in mind.  If you have a page that is served 50 times a minute and you cache
for just one minute - you have gone from 3500 queries an hour to a mere 60.
Even a little moderate caching can have benefits. Why don't you try caching
for a 10 minutes (a max of 6 queries an hour) use a URL.Refresh parameter to
allow the user immediate access to the query data - like below:



...your regular query code



AND #bogusVar# = #bogusVar#





When the client types in the URL with "refresh=true" they can see the update
to the page - and they will know that will be there for everyone inside of
10 minutes.

-Mark



-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 3:34 PM
To: CF-Talk
Subject: cached query


hi all,
i have built a website for a client where the home page is totally
dynamics ( the cfm file has almost 10 queries accessing 10 different
tables in order to populate the page).  Now the client is complaining
about the slow load time.  they told me they don't need to have the
home page accessing the database everytime the page is loaded since a
lot of the info in the page is not changed that frequently.  I am
thinking of using the CACHEDWITHIN with some of the CFQUERY in the
page, like CACHEDWITHIN 2 days.  What i am worrying about is if the
client update the data within those 2 days, the home page will not
be able to display the lastest info.  Is there a way to refresh all
the cached query once the client update the database, so all the
cached queries will also be updated instantly without waiting for the
CACHEDWITHIN to expire.

Anyone has any idea is very welcomed to suggest.

thank



--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Fusebox pros and cons

[Mark A. Kruger - CFG]

What?  well written applications? Or Daves?

-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 11:31 AM
To: CF-Talk
Subject: RE: Fusebox pros and cons


Based on his contributions to this list, I'd guess that there are about a
dozen...

At 09:11 AM 3/12/2002 -0800, you wrote:
--- snip ---
>it is
>true that any well written CF Application should be logical and structured
>but there aren't that many Dave Watt's et al in the real CF World,  My
>sixpence worth.
>
>Mike Brunt
>Sempra Energy
>213.244.5226


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A Verity SQL Combo Question - Can this be sped up?

[Mark A. Kruger - CFG]

Excellent!  Thanks for the tips.  Dave - thanks for the link on CFComet

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 11:03 AM
To: CF-Talk
Subject: RE: A Verity SQL Combo Question - Can this be sped up?


You need have MS Index Server installed. For NT it comes with the option
pack, not sure about 2000. Once installed you have the standard MMC
interface to specify which directories to index, and that's it. Don't have
to reindex like you do with Verity it's handled for you.
You need to set up full-text in SQL Server and then specify the catalogs you
have set up within the database you want to use it in, then you can write
sql statements combining tables and catalogs. Good info on doing this on MS
site e.g.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnduwon/htm
l/d5dbsearch.asp

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 14:40
To: CF-Talk
Subject: RE: A Verity SQL Combo Question - Can this be sped up?


Kevan,

Could you give a short summary of how one uses MS indexing?  I'd be very
interested. Thanks!

Mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 3:29 AM
To: CF-Talk
Subject: RE: A Verity SQL Combo Question - Can this be sped up?


Could try using MS indexing instead of Verity, I've found it better anyway.

-Original Message-
From: Mallory Woods [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2002 16:13
To: CF-Talk
Subject: A Verity SQL Combo Question - Can this be sped up?


Greetings all..


We have an interesting verity search/SQL search issue and I was
wondering if anyone has any hints on how this possibly could be sped
up..

Ok.. some background..

The Keyword search is done in verity and its fast by itself..

The other searches are fast and are regular SQL.. when they are both
combined they take a long time..

Here's what happens..

The Verity search returns the Keys which are equal to the ID field in
the SQL DB..  if the keyword field is not blank then it add the keys in
to the main query example query..

--
SELECT EPSTable.posting_date, agency_, office_, classcod_, subject_,
solnbr_, epsid,
(select top 1 par_id from par where
rfpnumber=replace(epstable.solnbr_,'-','') and (rfpnumber is not null or
rfpnumber<>'' or rfpnumber<>'N/A')) parid
FROM  EPSTable
WHERE
(1 = 1)
AND EPSTable.epsid IN
(13913,11967,15428,15407,15057,15036,18538,14881,19636,18330,9411,16568,
7593,19812,19391,17230,16774,10795,13469,6393,11616,11293,18112,16529,15
461,15090,13871,11925,10778,9032,17558,16233,13893,13310,13069,11947,107
79,9771,8907,7441,2676,16772,12398,10547,7974,5239,4158,20497,20400,2039
9,20051,19996,19804,19640,19610,19299,18582,18300,18299,18291,18258,1812
3,18075,17862,17738,17111,17026,17014,16993,16982,16846)

AND CLASSCOD_ = '10'
ORDER BY POSTING_DATE
--

As you can see it returns a whole lot of Keys which are included in the
query.. this slows the whole query down..  We have the DB indexed and
have tried other things to speed this up.. any suggestions on getting
this going faster?

Thanks in advance..

Mallory Woods
INPUT Inc












__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help please

[laszlo]

select ... count(paycatid) as samepaycatid group by paycatid

laszlo


[EMAIL PROTECTED] wrote:

> Anyone?
>
> Bueller?  Bueller?
>
> - Original Message -
> From: [EMAIL PROTECTED]
> Date: Wednesday, March 13, 2002 2:51 pm
> Subject: SQL help please
>
> > Brain not working Must help...
> >
> > Here's my data set:
> >
> > employeeid startdate enddate paycatid
> > --- --- --- ---
> > 936 2002-02-08 2002-02-08 1
> > 936 2002-02-11 2002-02-11 1
> > 936 2002-02-12 2002-02-12 1
> > 936 2002-02-13 2002-02-13 11
> > 936 2002-02-14 2002-02-14 1
> > 936 2002-02-15 2002-02-15 1
> > 936 2002-02-18 2002-02-18 11
> > 936 2002-02-19 2002-02-19 11
> > 936 2002-02-20 2002-02-20 11
> > 936 2002-02-21 2002-02-21 11
> > 936 2002-02-22 2002-02-22 11
> > 936 2002-02-25 2002-02-25 7
> > 936 2002-02-27 2002-02-27 7
> >
> > What I'm wondering is how do I get something like:
> >
> > employeeid startdate enddate same paycatid in a row paycatid
> > --- --- --- --- --
> > 936 2002-02-08 2002-02-12 3 1
> > 936 2002-02-13 2002-02-13 1 11
> > 936 2002-02-14 2002-02-15 2 1
> > 936 2002-02-18 2002-02-22 5 11
> > 936 2002-02-25 2002-02-27 2 7
> >
> > I'm using SQL Server 7.
> >
> >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Contracts

[David Schmidt]

LMAO!!!


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 2:58 PM
Subject: Re: Contracts


> Try this one:
>
>
> I _ promise to pay you on time and fairly and squarely for
> the eminent work you do for me o beloved Cold Fusion programmer.
>
> Signed 
> Print name: 
>
> (Place thumb print and notary seal to right)
>
>
> Hope it helps.
>
> - Original Message -
> From: "Brian Thornton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 13, 2002 2:37 PM
> Subject: Re: Contracts
>
>
> > Eric or anyone else, Do you happen to have a contract template I could
> use?
> > I would like to see what everyone else is using.
> > - Original Message -
> > From: "Carlisle, Eric" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 13, 2002 4:03 PM
> > Subject: RE: Contracts
> >
> >
> > > I'm not as formal, but a discovery phase of the project is useful in
> > > establishing scope.
> > >
> > > -Original Message-
> > > From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, March 13, 2002 4:02 PM
> > > To: CF-Talk
> > > Subject: Contracts
> > >
> > >
> > > Question: I use a scope of work for starting contract work. What does
> > > everyone else use?
> > >
> > > Thanks,
> > > Brian
> > >
> > >
> > >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Is this a bug (or just a session thing)>>>

[Jochem van Dieten]

Tyler Silcox wrote:
> I'm trying to get the length of an array set in a session structure and ColdFusion 
>just is not playing fair.
> 
> This is what I have:
> 
> session.MyStructure=StructNew();
> session.MyStructure["Temp"]=StructNew();
> session.MyStructure["DaRealDeal"]=ArrayNew(1);
> #ArrayLen(session.MyStructure["DaRealDeal"])#
> 
> and it's throwing me the following error: 




session.MyStructure=StructNew();
session.MyStructure["Temp"]=StructNew();
session.MyStructure["DaRealDeal"]=ArrayNew(1);
Writeoutput(ArrayLen(session.MyStructure["DaRealDeal"]));



This code (copy-paste) does not throw any error for me, it simply returns 0.
CF 4.5.1 SP2 on WinNT4 SP6a

Jochem


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Date query problem

[Ray Bujarski]

First I set the date to a valid odbc date, which I did an output to test 
and I get {d '2002-03-08'}
  

When I use this query, I get "invalid column name" which tells me it is 
interpreting the date incorrectly.

 SELECT RID
 FROM Reports
 WHERE report_date = #thisdate#
 and
 alias_name = '#cgi.auth_user#'

So I tried putting ticks around the date, then I get

 : SQL command not properly ended
 SQL = "SELECT RID FROM Reports WHERE report_date = '{d 
'2002-03-08'}' and alias_name = 'rayb'"

Can somebody please help with my query problem?


Ray Bujarski
858-845-7669
858-636-9900 pgr
[EMAIL PROTECTED]

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help please

[ksuh]

Anyone?

Bueller?  Bueller?

- Original Message -
From: [EMAIL PROTECTED]
Date: Wednesday, March 13, 2002 2:51 pm
Subject: SQL help please

> Brain not working Must help...
> 
> Here's my data set:
> 
> employeeid startdate enddate paycatid 
> --- --- --- --- 
> 936 2002-02-08 2002-02-08 1
> 936 2002-02-11 2002-02-11 1
> 936 2002-02-12 2002-02-12 1
> 936 2002-02-13 2002-02-13 11
> 936 2002-02-14 2002-02-14 1
> 936 2002-02-15 2002-02-15 1
> 936 2002-02-18 2002-02-18 11
> 936 2002-02-19 2002-02-19 11
> 936 2002-02-20 2002-02-20 11
> 936 2002-02-21 2002-02-21 11
> 936 2002-02-22 2002-02-22 11
> 936 2002-02-25 2002-02-25 7
> 936 2002-02-27 2002-02-27 7
> 
> What I'm wondering is how do I get something like:
> 
> employeeid startdate enddate same paycatid in a row paycatid
> --- --- --- --- --
> 936 2002-02-08 2002-02-12 3 1
> 936 2002-02-13 2002-02-13 1 11
> 936 2002-02-14 2002-02-15 2 1
> 936 2002-02-18 2002-02-22 5 11
> 936 2002-02-25 2002-02-27 2 7
> 
> I'm using SQL Server 7.
> 
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Contracts

[one]

Try this one:


I _ promise to pay you on time and fairly and squarely for
the eminent work you do for me o beloved Cold Fusion programmer.

Signed 
Print name: 

(Place thumb print and notary seal to right)


Hope it helps.

- Original Message -
From: "Brian Thornton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 2:37 PM
Subject: Re: Contracts


> Eric or anyone else, Do you happen to have a contract template I could
use?
> I would like to see what everyone else is using.
> - Original Message -
> From: "Carlisle, Eric" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 13, 2002 4:03 PM
> Subject: RE: Contracts
>
>
> > I'm not as formal, but a discovery phase of the project is useful in
> > establishing scope.
> >
> > -Original Message-
> > From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 13, 2002 4:02 PM
> > To: CF-Talk
> > Subject: Contracts
> >
> >
> > Question: I use a scope of work for starting contract work. What does
> > everyone else use?
> >
> > Thanks,
> > Brian
> >
> >
> >
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cached query

[Sharon Diorio]

This is why I tend to "cache" queries by putting them into application and session 
scope.  It gives me much more granular control over when something changes.  The 
downside is dealing with locks.


SELECT stuff
FROM table





Then in the application.cfm, I'll copy it to REQUEST scope for ease of use:




For output:

#stuff#


Although, I'm far more likely to put commonly accessed information into structures, 
but I'm a bit of a structure freak that way.

Sharon
- Original Message - 
From: "FARRAH NG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 4:33 PM
Subject: cached query


> hi all,
> i have built a website for a client where the home page is totally
> dynamics ( the cfm file has almost 10 queries accessing 10 different
> tables in order to populate the page).  Now the client is complaining
> about the slow load time.  they told me they don't need to have the
> home page accessing the database everytime the page is loaded since a
> lot of the info in the page is not changed that frequently.  I am
> thinking of using the CACHEDWITHIN with some of the CFQUERY in the
> page, like CACHEDWITHIN 2 days.  What i am worrying about is if the
> client update the data within those 2 days, the home page will not
> be able to display the lastest info.  Is there a way to refresh all
> the cached query once the client update the database, so all the
> cached queries will also be updated instantly without waiting for the
> CACHEDWITHIN to expire.
> 
> Anyone has any idea is very welcomed to suggest.
> 
> thank
> 
> 
> 
> --
> Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
> Sign-up today at http://www.hotvoice.com
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Contracts

[Brian Thornton]

Eric or anyone else, Do you happen to have a contract template I could use?
I would like to see what everyone else is using.
- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 4:03 PM
Subject: RE: Contracts


> I'm not as formal, but a discovery phase of the project is useful in
> establishing scope.
>
> -Original Message-
> From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 4:02 PM
> To: CF-Talk
> Subject: Contracts
>
>
> Question: I use a scope of work for starting contract work. What does
> everyone else use?
>
> Thanks,
> Brian
>
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ] RE: cached query

[John Beynon]

No after your 

> 
>   update Welcome
>   set message = '#form.welcomemsg#',
>   dateedited = #CreateODBCDateTime(Now())#
> 

Do (all in your welcomeupdate.cfm)

>  datasource="testingDB">
>select * from Welcome
> 

The select expires the cache and then when the next person hits the home
page it will be recached for two days

John.

> -Original Message-
> From: FARRAH NG [mailto:[EMAIL PROTECTED]] 
> Sent: 13 March 2002 22:28
> To: CF-Talk
> Subject: [Re:] RE: cached query
> 
> 
> In the home page home.index, i have a query like this
> 
>  datasource="testingDB">
>select * from Welcome
> 
> 
> 
> In the update admin page welcomeupdate.cfm for this table, i 
> have a update query like this:
> 
> 
>   update Welcome
>   set message = '#form.welcomemsg#',
>   dateedited = #CreateODBCDateTime(Now())#
> 
> 
> so what i should do is to put 
> cachedwithin="#createtimespan(0,0,0,0)#" 
>  in the UpdateMessage query in the welcomeupdate.cfm and each 
> time the query update the database the cached query 
> "getWelcome" in the home.index will be updated instantly, is 
> that correct ?
> 
> thanks a lot
> 
> 
> On Wed, 13 Mar 2002 21:31:16 -
> John Beynon wrote:
> 
> >Immediately after you've updated the data, use a query with 
> >cachedwithin="#createtimespan(0,0,0,0)#" to update the data...then
> it will
> >be recached on the home page using the 2 days or whatever setting
> you want.
> >
> >John.
> >
> >> -Original Message-
> >> From: FARRAH NG [mailto:[EMAIL PROTECTED]]
> >> Sent: 13 March 2002 21:34
> >> To: CF-Talk
> >> Subject: cached query
> >> 
> >> 
> >> hi all,
> >> i have built a website for a client where the home page is
> >> totally dynamics ( the cfm file has almost 10 queries 
> >> accessing 10 different tables in order to populate the page). 
> >>  Now the client is complaining about the slow load time.  
> >> they told me they don't need to have the home page accessing 
> >> the database everytime the page is loaded since a lot of the 
> >> info in the page is not changed that frequently.  I am 
> >> thinking of using the CACHEDWITHIN with some of the CFQUERY 
> >> in the page, like CACHEDWITHIN 2 days.  What i am worrying 
> >> about is if the client update the data within those 2 days, 
> >> the home page will not 
> >> be able to display the lastest info.  Is there a way to 
> >> refresh all the cached query once the client update the 
> >> database, so all the 
> >> cached queries will also be updated instantly without waiting 
> >> for the CACHEDWITHIN to expire. 
> >> 
> >> Anyone has any idea is very welcomed to suggest.
> >> 
> >> thank
> >> 
> >> 
> >> 
> >> --
> >> 
> >> Global Internet phone calls, voicemail, fax, e-mail and
> >> instant messaging. Sign-up today at http://www.hotvoice.com 
> >> 
> >
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

[Re:] RE: cached query

[FARRAH NG]

In the home page home.index, i have a query like this


   select * from Welcome



In the update admin page welcomeupdate.cfm for this table, i 
have a update query like this:


  update Welcome
  set message = '#form.welcomemsg#',
  dateedited = #CreateODBCDateTime(Now())#


so what i should do is to put cachedwithin="#createtimespan(0,0,0,0)#" 
 in the UpdateMessage query in the welcomeupdate.cfm and each time
the query update the database the cached query "getWelcome" in the
home.index will be updated instantly, is that correct ?

thanks a lot


On Wed, 13 Mar 2002 21:31:16 -
John Beynon wrote:

>Immediately after you've updated the data, use a query with
>cachedwithin="#createtimespan(0,0,0,0)#" to update the data...then 
it will
>be recached on the home page using the 2 days or whatever setting 
you want.
>
>John.
>
>> -Original Message-
>> From: FARRAH NG [mailto:[EMAIL PROTECTED]] 
>> Sent: 13 March 2002 21:34
>> To: CF-Talk
>> Subject: cached query
>> 
>> 
>> hi all,
>> i have built a website for a client where the home page is 
>> totally dynamics ( the cfm file has almost 10 queries 
>> accessing 10 different tables in order to populate the page). 
>>  Now the client is complaining about the slow load time.  
>> they told me they don't need to have the home page accessing 
>> the database everytime the page is loaded since a lot of the 
>> info in the page is not changed that frequently.  I am 
>> thinking of using the CACHEDWITHIN with some of the CFQUERY 
>> in the page, like CACHEDWITHIN 2 days.  What i am worrying 
>> about is if the client update the data within those 2 days, 
>> the home page will not 
>> be able to display the lastest info.  Is there a way to 
>> refresh all the cached query once the client update the 
>> database, so all the 
>> cached queries will also be updated instantly without waiting 
>> for the CACHEDWITHIN to expire. 
>> 
>> Anyone has any idea is very welcomed to suggest.
>> 
>> thank
>> 
>> 
>> 
>> --
>> 
>> Global Internet phone calls, voicemail, fax, e-mail and 
>> instant messaging. Sign-up today at http://www.hotvoice.com 
>> 
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: MAX function problem

[S R]

Thanks, it worked. I've been staring at the screen too long and I had the 
sql statement backwards.

Thanks again.

Sal

>From: <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: MAX function problem
>Date: Wed, 13 Mar 2002 14:22:04 -0800
>
>Try:
>
>
>SELECT MAX(ID) as MAXID
>FROM ContactInfo
>
>
>
>
>Regards,
>Pardeep.
>
>
>- Original Message -
>From: "S R" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, March 13, 2002 2:08 PM
>Subject: MAX function problem
>
>
> > I keep getting an error resolving parameter MAXID when I do the 
>following
> >
> > 
> > SELECT MAX(ID) FROM ContactInfo AS MAXID
> > 
> >
> > 
> >
> > I've also tried
> >
> > 
> > 
> > 
> >
> > with the same error resulting.
> >
> > Sal
> >
> > _
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
>
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[Brian Scandale]

Now I'm a bit confused...

I thought that as long as the query had not expired that cf would return the cashed 
results... regardless of which page called the query... particularly if the query name 
and slq were identical.

??? am I getting marauded by a donkey?


At 01:36 PM 3/13/02 -0800, you wrote:
>LOL. Oops, yeah I sure did. My bad.
>
>J.
>
> 
> 
>John Wilker
>Web Applications Consultant, and Author
>Macromedia Certified ColdFusion Developer
>President/Founder, Inland Empire CFUG.
>www.red-omega.com
> 
>"more people are killed by donkeys than by airplane crashes each year"
>
>
>-Original Message-
>From: Bud [mailto:[EMAIL PROTECTED]] 
>Sent: Wednesday, March 13, 2002 1:27 PM
>To: CF-Talk
>Subject: RE: Question About Query Caching
>
>
>On 3/13/02, John Wilker penned:
>>My idea would be to put a query with the same name on the page that 
>>updates the database. The new query will overwrite the cached one as 
>>long as the SQL is different, then the first time some one runs the 
>>real query it will re cache that one.
>
>You mean as long as the SQL is IDENTICAL.
>-- 
>
>Bud Schneehagen - Tropical Web Creations
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED]
>http://www.twcreations.com/ 954.721.3452
>
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Is this a bug (or just a session thing)>>>

[Tyler Silcox]

I'm trying to get the length of an array set in a session structure and ColdFusion 
just is not playing fair.

This is what I have:

session.MyStructure=StructNew();
session.MyStructure["Temp"]=StructNew();
session.MyStructure["DaRealDeal"]=ArrayNew(1);
#ArrayLen(session.MyStructure["DaRealDeal"])#

and it's throwing me the following error: 

"The expression has requested a variable or an intermediate expression result as a 
simple value, however, the result cannot be converted to a simple value. Simple values 
are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM 
objects are examples of complex values."

But the kooky thing is: it works just fine if I'm using the request scope...who knows->

(ps: everything's locked down correctly, i just gave you the bare-bones version)

Tyler Silcox
email | [EMAIL PROTECTED]


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: MAX function problem

[one]

Try:


SELECT MAX(ID) as MAXID
FROM ContactInfo




Regards,
Pardeep.


- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 2:08 PM
Subject: MAX function problem


> I keep getting an error resolving parameter MAXID when I do the following
>
> 
> SELECT MAX(ID) FROM ContactInfo AS MAXID
> 
>
> 
>
> I've also tried
>
> 
> 
> 
>
> with the same error resulting.
>
> Sal
>
> _
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MAX function problem

[Jason Larson]

Try:


SELECT MAX(ID) AS MAXID FROM ContactInfo 


Thanks,
Jason Larson
"You think the Cubs have sore arms? What about the fans in left field?" 
 
 

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 3:08 PM
To: CF-Talk
Subject: MAX function problem

I keep getting an error resolving parameter MAXID when I do the
following


SELECT MAX(ID) FROM ContactInfo AS MAXID




I've also tried





with the same error resulting.

Sal

_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

MAX function problem

[S R]

I keep getting an error resolving parameter MAXID when I do the following


SELECT MAX(ID) FROM ContactInfo AS MAXID




I've also tried





with the same error resulting.

Sal

_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL help please

[ksuh]

Brain not working Must help...

Here's my data set:

employeeid startdate enddate paycatid 
--- --- --- --- 
936 2002-02-08 2002-02-08 1
936 2002-02-11 2002-02-11 1
936 2002-02-12 2002-02-12 1
936 2002-02-13 2002-02-13 11
936 2002-02-14 2002-02-14 1
936 2002-02-15 2002-02-15 1
936 2002-02-18 2002-02-18 11
936 2002-02-19 2002-02-19 11
936 2002-02-20 2002-02-20 11
936 2002-02-21 2002-02-21 11
936 2002-02-22 2002-02-22 11
936 2002-02-25 2002-02-25 7
936 2002-02-27 2002-02-27 7

What I'm wondering is how do I get something like:

employeeid startdate enddate same paycatid in a row paycatid
--- --- --- --- --
936 2002-02-08 2002-02-12 3 1
936 2002-02-13 2002-02-13 1 11
936 2002-02-14 2002-02-15 2 1
936 2002-02-18 2002-02-22 5 11
936 2002-02-25 2002-02-27 2 7

I'm using SQL Server 7.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Slighlty OT: Exporting my "Code Sweeper" Settings

[t nelson]

Hi All,

Sorry for the OT post but, I wanted to know if there is a way to export my 
"Code Sweeper" settings from CF Studio? I spent a while getting my settings 
just the way I wanted them on my Home PC but now I would like to take those 
with me to use at work. Sure I could sit at my PC at work and do it all over 
again but there must be an easier way. I know that you can export registery 
files and go about it that way, but when I browsed through the CF Folder in 
my registry, I could not find a file which said "Code Sweeper". If it helps 
I am currently using CF Studio 4.5.2 on a win2k box.

Any ideas out there?

Thanks in advance,

Nelson


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFGRID problem driving me nuts

[JamesEdmunds]

Can you show me the action page?
--James Edmunds


David Green wrote:

> Hello List
>
> Having problem with all my cfgrids.  They worked before under cf 4.5,  I think they 
>broke under cf5 but not sure exactly when the quit working.
>
>  It appears that am not getting a form fields from the grids but I do get the value 
>from the input box text.  on the action page I get unresolved on 
>#idplist.idp#  This is happening on all our cfgrids.  Can you 
>see anything wrong with code or is there some patch or something I need to load.
>All this stuff worked fine for a couple of years :(
>
> Thanks for the help
> David
>
> 
>
>  
>
> query="IDPPICK" insert="No" delete="No" sort="Yes" font="Arial" fontsize="12" 
>bold="No" italic="No" autowidth="true" appendkey="No" highlighthref="No" 
>griddataalign="LEFT" gridlines="No" rowheight="12" rowheaders="Yes" 
>rowheaderalign="LEFT" rowheaderitalic="No" rowheaderbold="No" colheaders="Yes" 
>colheaderalign="LEFT" colheaderfontsize="14" colheaderitalic="Yes" 
>colheaderbold="Yes" bgcolor="##00" selectmode="ROW" maxrows="1" 
>picturebar="Yes" selectcolor="##808080">
>
> width="90" font="Arial" fontsize="12" bold="No" italic="No" select="No" display="Yes" 
>headerfont="Arial" headerfontsize="12" headerbold="Yes" headeritalic="Yes" >
>
>  
> 
>
> David Green
> System Analyst
> G & B Technologies Inc
> 661 948-5678
> [EMAIL PROTECTED]
>
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cached query

[John Beynon]

Immediately after you've updated the data, use a query with
cachedwithin="#createtimespan(0,0,0,0)#" to update the data...then it will
be recached on the home page using the 2 days or whatever setting you want.

John.

> -Original Message-
> From: FARRAH NG [mailto:[EMAIL PROTECTED]] 
> Sent: 13 March 2002 21:34
> To: CF-Talk
> Subject: cached query
> 
> 
> hi all,
> i have built a website for a client where the home page is 
> totally dynamics ( the cfm file has almost 10 queries 
> accessing 10 different tables in order to populate the page). 
>  Now the client is complaining about the slow load time.  
> they told me they don't need to have the home page accessing 
> the database everytime the page is loaded since a lot of the 
> info in the page is not changed that frequently.  I am 
> thinking of using the CACHEDWITHIN with some of the CFQUERY 
> in the page, like CACHEDWITHIN 2 days.  What i am worrying 
> about is if the client update the data within those 2 days, 
> the home page will not 
> be able to display the lastest info.  Is there a way to 
> refresh all the cached query once the client update the 
> database, so all the 
> cached queries will also be updated instantly without waiting 
> for the CACHEDWITHIN to expire. 
> 
> Anyone has any idea is very welcomed to suggest.
> 
> thank
> 
> 
> 
> --
> 
> Global Internet phone calls, voicemail, fax, e-mail and 
> instant messaging. Sign-up today at http://www.hotvoice.com 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[John Wilker]

LOL. Oops, yeah I sure did. My bad.

J.

 
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
"more people are killed by donkeys than by airplane crashes each year"


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 1:27 PM
To: CF-Talk
Subject: RE: Question About Query Caching


On 3/13/02, John Wilker penned:
>My idea would be to put a query with the same name on the page that 
>updates the database. The new query will overwrite the cached one as 
>long as the SQL is different, then the first time some one runs the 
>real query it will re cache that one.

You mean as long as the SQL is IDENTICAL.
-- 

Bud Schneehagen - Tropical Web Creations

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

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cached query

[FARRAH NG]

hi all,
i have built a website for a client where the home page is totally
dynamics ( the cfm file has almost 10 queries accessing 10 different
tables in order to populate the page).  Now the client is complaining
about the slow load time.  they told me they don't need to have the
home page accessing the database everytime the page is loaded since a
lot of the info in the page is not changed that frequently.  I am 
thinking of using the CACHEDWITHIN with some of the CFQUERY in the
page, like CACHEDWITHIN 2 days.  What i am worrying about is if the
client update the data within those 2 days, the home page will not 
be able to display the lastest info.  Is there a way to refresh all
the cached query once the client update the database, so all the 
cached queries will also be updated instantly without waiting for the
CACHEDWITHIN to expire. 

Anyone has any idea is very welcomed to suggest.

thank



--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[Bud]

On 3/13/02, John Wilker penned:
>My idea would be to put a query with the same name on the page that
>updates the database. The new query will overwrite the cached one as
>long as the SQL is different, then the first time some one runs the real
>query it will re cache that one.

You mean as long as the SQL is IDENTICAL.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL getting stuck in the SPOOL directory

[one]

:)

This is what I've been doing. Unfortunately its not solving the root
problem, and since I have no ideal why one email would get stuck, its tuff
to find a solution.

Any idea what might cause one email to block the whole list?

Thanks.


- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 1:18 PM
Subject: RE: CFMAIL getting stuck in the SPOOL directory


> That is weird. But Dan is right, you'll still need to stop the service
> to delete the file. Before you do though either copy it somewhere or
> open it, and see if you can see what is wrong with it? If it's 22k then
> it should be sent or moved to the error directory.
>
> J.
>
> John Wilker
> Web Applications Consultant, and Author
> Macromedia Certified ColdFusion Developer
> President/Founder, Inland Empire CFUG.
> www.red-omega.com
>
> "more people are killed by donkeys than by airplane crashes each year"
>
>
> -Original Message-
> From: Dan Phillips [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 1:11 PM
> To: CF-Talk
> Subject: RE: CFMAIL getting stuck in the SPOOL directory
>
>
> You will have to stop the CF application service, then you can delete
> the file.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 4:19 PM
> To: CF-Talk
> Subject: Re: CFMAIL getting stuck in the SPOOL directory
>
>
> Actually its not 0KB in size, its 22KB and when I try to delete it, I
> get a msg that says
>
> "Cannot delete 11F0: There has been a sharing violation. The source or
> destination file may be in use."
>
> Any idea what could be causing this?
>
> Thanks.
>
>
> - Original Message -
> From: "John Wilker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 13, 2002 12:47 PM
> Subject: RE: CFMAIL getting stuck in the SPOOL directory
>
>
> > The one file is probably 0k in size right? It's a common bug in
> > ColdFusion. You could put a script in place that will look in the
> > spool dir for 0k files, then stop the service and delete the file real
>
> > quick, then restart the service. Not ideal but the service should only
>
> > be off a second.
> >
> > J.
> >
> > John Wilker
> > Web Applications Consultant, and Author
> > Macromedia Certified ColdFusion Developer
> > President/Founder, Inland Empire CFUG.
> > www.red-omega.com
> >
> > "more people are killed by donkeys than by airplane crashes each year"
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 13, 2002 12:45 PM
> > To: CF-Talk
> > Subject: Re: CFMAIL getting stuck in the SPOOL directory
> >
> >
> > Hi, I'm having problems with the top email in the SPOOL directory
> > blocking all other emails in that directory. So if there are 100
> > emails, 99 are being blocked because the top one is not processing.
> >
> > Then I have to switch off the CF server, and delete the top file,
> > restart the server only to find the problem has occured again a little
>
> > further down the list.
> >
> > Any idea what could be causing this problem? And are there any
> > solutions?
> >
> > Thanks.
> >
> >
> >
>
>
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL getting stuck in the SPOOL directory

[John Wilker]

That is weird. But Dan is right, you'll still need to stop the service
to delete the file. Before you do though either copy it somewhere or
open it, and see if you can see what is wrong with it? If it's 22k then
it should be sent or moved to the error directory.

J. 
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
"more people are killed by donkeys than by airplane crashes each year"


-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 1:11 PM
To: CF-Talk
Subject: RE: CFMAIL getting stuck in the SPOOL directory


You will have to stop the CF application service, then you can delete
the file.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:19 PM
To: CF-Talk
Subject: Re: CFMAIL getting stuck in the SPOOL directory


Actually its not 0KB in size, its 22KB and when I try to delete it, I
get a msg that says

"Cannot delete 11F0: There has been a sharing violation. The source or
destination file may be in use."

Any idea what could be causing this?

Thanks.


- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 12:47 PM
Subject: RE: CFMAIL getting stuck in the SPOOL directory


> The one file is probably 0k in size right? It's a common bug in 
> ColdFusion. You could put a script in place that will look in the 
> spool dir for 0k files, then stop the service and delete the file real

> quick, then restart the service. Not ideal but the service should only

> be off a second.
>
> J.
>
> John Wilker
> Web Applications Consultant, and Author
> Macromedia Certified ColdFusion Developer
> President/Founder, Inland Empire CFUG.
> www.red-omega.com
>
> "more people are killed by donkeys than by airplane crashes each year"
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:45 PM
> To: CF-Talk
> Subject: Re: CFMAIL getting stuck in the SPOOL directory
>
>
> Hi, I'm having problems with the top email in the SPOOL directory 
> blocking all other emails in that directory. So if there are 100 
> emails, 99 are being blocked because the top one is not processing.
>
> Then I have to switch off the CF server, and delete the top file, 
> restart the server only to find the problem has occured again a little

> further down the list.
>
> Any idea what could be causing this problem? And are there any 
> solutions?
>
> Thanks.
>
>
>


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL getting stuck in the SPOOL directory

[Dan Phillips]

You will have to stop the CF application service, then you can delete the
file.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:19 PM
To: CF-Talk
Subject: Re: CFMAIL getting stuck in the SPOOL directory


Actually its not 0KB in size, its 22KB and when I try to delete it, I get a
msg that says

"Cannot delete 11F0: There has been a sharing violation. The source or
destination file may be in use."

Any idea what could be causing this?

Thanks.


- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 12:47 PM
Subject: RE: CFMAIL getting stuck in the SPOOL directory


> The one file is probably 0k in size right? It's a common bug in
> ColdFusion. You could put a script in place that will look in the spool
> dir for 0k files, then stop the service and delete the file real quick,
> then restart the service. Not ideal but the service should only be off a
> second.
>
> J.
>
> John Wilker
> Web Applications Consultant, and Author
> Macromedia Certified ColdFusion Developer
> President/Founder, Inland Empire CFUG.
> www.red-omega.com
>
> "more people are killed by donkeys than by airplane crashes each year"
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:45 PM
> To: CF-Talk
> Subject: Re: CFMAIL getting stuck in the SPOOL directory
>
>
> Hi, I'm having problems with the top email in the SPOOL directory
> blocking all other emails in that directory. So if there are 100 emails,
> 99 are being blocked because the top one is not processing.
>
> Then I have to switch off the CF server, and delete the top file,
> restart the server only to find the problem has occured again a little
> further down the list.
>
> Any idea what could be causing this problem? And are there any
> solutions?
>
> Thanks.
>
>
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL getting stuck in the SPOOL directory

[one]

Actually its not 0KB in size, its 22KB and when I try to delete it, I get a
msg that says

"Cannot delete 11F0: There has been a sharing violation. The source or
destination file may be in use."

Any idea what could be causing this?

Thanks.


- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 12:47 PM
Subject: RE: CFMAIL getting stuck in the SPOOL directory


> The one file is probably 0k in size right? It's a common bug in
> ColdFusion. You could put a script in place that will look in the spool
> dir for 0k files, then stop the service and delete the file real quick,
> then restart the service. Not ideal but the service should only be off a
> second.
>
> J.
>
> John Wilker
> Web Applications Consultant, and Author
> Macromedia Certified ColdFusion Developer
> President/Founder, Inland Empire CFUG.
> www.red-omega.com
>
> "more people are killed by donkeys than by airplane crashes each year"
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:45 PM
> To: CF-Talk
> Subject: Re: CFMAIL getting stuck in the SPOOL directory
>
>
> Hi, I'm having problems with the top email in the SPOOL directory
> blocking all other emails in that directory. So if there are 100 emails,
> 99 are being blocked because the top one is not processing.
>
> Then I have to switch off the CF server, and delete the top file,
> restart the server only to find the problem has occured again a little
> further down the list.
>
> Any idea what could be causing this problem? And are there any
> solutions?
>
> Thanks.
>
>
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL: Truncating Logs

[Duane Boudreau]

Does anyone know the TSQL for truncating a transaction log? Mind sharing?

TIA,
Duane


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Contracts

[Jeffry Houser]

  [EMAIL PROTECTED]

At 04:01 PM 3/13/2002 -0500, you wrote:
>Question: I use a scope of work for starting contract work. What does 
>everyone else use?
>
>Thanks,
>Brian
>
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Contracts

[Carlisle, Eric]

I'm not as formal, but a discovery phase of the project is useful in
establishing scope.

-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 4:02 PM
To: CF-Talk
Subject: Contracts


Question: I use a scope of work for starting contract work. What does
everyone else use? 

Thanks,
Brian


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Contracts

[Brian Thornton]

Question: I use a scope of work for starting contract work. What does everyone else 
use? 

Thanks,
Brian

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Sprectra (WAS: KILL THE BROADVIEW!)

[Neil Clark]

You can get the free version on the disk as I said!


- Original Message -
From: "Rick Walters" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 8:17 PM
Subject: Re: Sprectra (WAS: KILL THE BROADVIEW!)


> I don't think anyone doubted there would be patch releases to Spectra.
> If I have been reading this thread correctly, those of us who do not
> already have Spectra don't plan to buy a copy anytime soon.  However, if
> it were handed out to developers, we would certainly help support it.
> :)
>
>
> Good Fortune,
> Richard Walters,
> Webmaster, Davita Laboratory Services
> [EMAIL PROTECTED]
> (800) 604-5227 x 3525
>
> >>> [EMAIL PROTECTED] 03/13/02 03:03PM >>>
> Hi Guys and Gals.,
>
> Contrary to popular belief, Macromedia Spectra will be having one more
> release in the future - 1.5.2.  This will allow it to run on the next
> release of ColdFusion - ColdFusion MX(Neo).Neo will allow you to
> still
> use the core features of the Spectra model via ColdFusion Components.
> I
> can only tell you what I know and what is not under NDA anymore
> (Raymond
> Campden is your man to ask, but I think he is neck deep in Neo
> development!)
>
> But remember you can get a development copy of Spectra for single user
> use
> off your ColdFusion Studio CD (it is on the 4.5 disk, I will have to
> check
> the 5 disk) So if you want to help improve the model, you still can
> via
> http://spectrasource.macromedia.com
>
> Laters
>
> Neil
>
>
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL getting stuck in the SPOOL directory

[John Wilker]

The one file is probably 0k in size right? It's a common bug in
ColdFusion. You could put a script in place that will look in the spool
dir for 0k files, then stop the service and delete the file real quick,
then restart the service. Not ideal but the service should only be off a
second.

J. 
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
"more people are killed by donkeys than by airplane crashes each year"


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 12:45 PM
To: CF-Talk
Subject: Re: CFMAIL getting stuck in the SPOOL directory


Hi, I'm having problems with the top email in the SPOOL directory
blocking all other emails in that directory. So if there are 100 emails,
99 are being blocked because the top one is not processing.

Then I have to switch off the CF server, and delete the top file,
restart the server only to find the problem has occured again a little
further down the list.

Any idea what could be causing this problem? And are there any
solutions?

Thanks.


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL getting stuck in the SPOOL directory

[one]

Hi, I'm having problems with the top email in the SPOOL directory blocking
all other emails in that directory. So if there are 100 emails, 99 are being
blocked because the top one is not processing.

Then I have to switch off the CF server, and delete the top file, restart
the server only to find the problem has occured again a little further down
the list.

Any idea what could be causing this problem? And are there any solutions?

Thanks.

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Sprectra (WAS: KILL THE BROADVIEW!)

[Rick Walters]

I don't think anyone doubted there would be patch releases to Spectra. 
If I have been reading this thread correctly, those of us who do not
already have Spectra don't plan to buy a copy anytime soon.  However, if
it were handed out to developers, we would certainly help support it. 
:)


Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525

>>> [EMAIL PROTECTED] 03/13/02 03:03PM >>>
Hi Guys and Gals.,

Contrary to popular belief, Macromedia Spectra will be having one more
release in the future - 1.5.2.  This will allow it to run on the next
release of ColdFusion - ColdFusion MX(Neo).Neo will allow you to
still
use the core features of the Spectra model via ColdFusion Components.  
I
can only tell you what I know and what is not under NDA anymore
(Raymond
Campden is your man to ask, but I think he is neck deep in Neo
development!)

But remember you can get a development copy of Spectra for single user
use
off your ColdFusion Studio CD (it is on the 4.5 disk, I will have to
check
the 5 disk) So if you want to help improve the model, you still can
via
http://spectrasource.macromedia.com 

Laters

Neil



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: PHP equivalents of CF list functions

[Douglas Brown]

For php, I believe that you will need to use the "list" function in conjunction with a 
"sort" function. Look up sort in the help file. there is a new help file on php.net 
that is done as a .chm






"Success is a journey, not a destination!!"



Doug Brown
- Original Message - 
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 11:54 AM
Subject: RE: PHP equivalents of CF list functions


> just go to www.php.net and enter those in the function look up.
> 
> -Original Message-
> From: stas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 1:51 PM
> To: CF-Talk
> Subject: PHP equivalents of CF list functions
> 
> 
> I need to do a bit of PHP development, and I can't believe how much I'm
> spoiled by CF. I have to roll my own for every little thing. Could someone
> post PHP alternatives to functions such as:
> 
> listcontains
> find
> valuelist
> 
> Anything else that comes to mind.
> 
> Thanks!
> 
> 
> 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: KILL THE BROADVIEW!

[John Dowdell]

At 8:57 AM 3/13/2, [EMAIL PROTECTED] wrote:
> Arrg!!  Someone please rewrite the Macromedia site in
> something besides Broadview!!  It is so stinking slow!  I
> can't even view the darn CF upgrade pricing list without
> waiting for 2 minutes

Sorry for the current delay. If anything, Macromedia's original systems
definitely show the advantages of using ColdFusion ;-)

Here's a post from Jeremy on the subject. We've already got the merger of
the two sites, and some new web applications have already moved over to CF,
but the real shift will happen atop Neo, so we're still a little away from
fully updating the site yet.



> date: Sun, 27 Jan 2002 16:08:24 -0500
> from: Jeremy Allaire <[EMAIL PROTECTED]>
> Subject: Macromedia.com
> To: CF-Talk <[EMAIL PROTECTED]>
>
> Hi-
>
> I saw the post about a person having problems downloading something
> on the site.
>
> We have a planned outage this and next weekends in order to switch
> offsite hosting providers -- our current provider went out of business.
>
> We're also taking the coming months to re-build the site from scratch
> on our next releases of ColdFusion, Flash and Dreamweaver.
>
> We'd love your feedback on features for the site.
>
> Thanks,
>
> Jeremy




jd



John Dowdell, Macromedia Tech Support, San Francisco CA US
Search technotes: http://www.macromedia.com/support/search/
Offlist email risks capture by the spam filters. I may not see your
email if it's not on the list. Private one-on-one email options are
available via Priority Access: http://www.macromedia.com/support/


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: popUp Window trouble

[Conrad Classen]

OK, then use 2 var's to hold ref's to both windows, each with their own
Function call.


-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]] 
Sent: 13 March 2002 09:17 PM
To: CF-Talk
Subject: RE: popUp Window trouble


Thanks Conrad, 

I'll see what this info might do to help. 

One thing you mention I don't want to do. I don't want the child window
to close when the parent window access a different URL. The info in the
child window can still be necessary to the user.

As far as different definitions goes... EVEN clicking the same Detail
popsUp a New Instance of the Detail.

My original question is at the bottom of this post... and still very
much a mystery.


At 02:14 AM 3/13/02 +0200, you wrote:
>If the created window has different definitions, a new instance of the 
>window will be created. Using the same variable ref container for both 
>will cause the first instances reference to be
>lost as well. Also, it would also be better to close any children
>windows that may happen to 
>be open when the current window is closed or references a different
URL.
>
>Try the following
>
>
>
>
>
>
>
>
>Help
>
>DETAILS>
>
>
>
>Conrad
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: 12 March 2002 08:18 PM
>To: CF-Talk
>Subject: RE: popUp Window trouble
>
>
>Steve,
>
>It does work. It uses the same window for all the Help instances but 
>every instance of Details opens a new window.
>
>Anybody else have an idea?
>
>thanks,
>Brian
>
>At 03:43 AM 3/12/02 -0500, you wrote:
>>That looks like it should work...
>>
>>window.open('url', 'windowName', 'properties');
>>
>>The only thing I noticed is the name is pretty long, 
>>"theDetailWindow",
>
>>not sure if it matters but you could try using a shorter name.
>>
>>Other then that I noticed you have the href set in the link.  When I
>>use a link to popup a window with the onclick even I usually set the 
>>href to "#" or "javascript:void(0)"
>>
>>_
>>steve oliver
>>senior internet developer
>>atnet solutions, inc.
>>http://www.atnetsolutions.com
>>
>>
>>-Original Message-
>>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, March 12, 2002 3:00 AM
>>To: CF-Talk
>>Subject: popUp Window trouble
>>
>>
>>One of my popUps always uses the same window for display... as
>>expected. The other always generates a new window... (which clutters 
>>the desktop and uses resources). Both are called from the same page.
>>
>>I have a header that always has a help button in it. It calls help.cfm
>>which pops up a help window with the contents of #Client.HelpIs#. If I

>>navigate to a new page and press help, the old help window repopulates

>>with New help info.
>>
>>Another page has a list of items each with a button for "Details" by
>>each lineitem. Every press of the detail button brings up a new 
>>DetailWindow, ...even If I press the SAME Detail button. I am looking 
>>for all details to use the same window.
>>
>>As far as I can tell it is identical code... so I'm at a adjust this.
>>
>>The code:
>>
>>
>>
>>
>>
>>
>>
>>Help
>>
>>DETAILS>
>>
>>
>>
>>As it so happens... the href= is of no consequence... i can put
>>anything in there... it's the popUp('page' that counts.
>>
>>Anybody know how I might start trying to fix this?
>>
>>thanks,
>>Brian


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[John Wilker]

My idea would be to put a query with the same name on the page that
updates the database. The new query will overwrite the cached one as
long as the SQL is different, then the first time some one runs the real
query it will re cache that one.

J. 
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
"more people are killed by donkeys than by airplane crashes each year"


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 11:46 AM
To: CF-Talk
Subject: Question About Query Caching


Let's say I have a query that is cached ...

Let's say a user adds a new item to the table called in the query.

Now we all know that so long as the query is cached, the new item won't
show up in the output.

But what if I want it to show up right away?  Is there a way to dump the
current cache as soon as a new item is inserted, so that the query is
re-cached the next time it is run with the new data included?

I think I need to cache this query because it won't change too often,
but it returns, right now, 8,000 rows, so even cached it's a little on
the slow side.

H.



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Question About Query Caching

[Chip Griffin]

You can run the query with the cache set to 0 minutes:

cachedwithin= "#CreateTimeSpan(0,0,0,0)#"

-Original Message-
But what if I want it to show up right away?  Is there a way to dump the
current cache as soon as a new item is inserted, so that the query is
re-cached the next time it is run with the new data included?



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Sprectra (WAS: KILL THE BROADVIEW!)

[Neil Clark]

Hi Guys and Gals.,

Contrary to popular belief, Macromedia Spectra will be having one more
release in the future - 1.5.2.  This will allow it to run on the next
release of ColdFusion - ColdFusion MX(Neo).Neo will allow you to still
use the core features of the Spectra model via ColdFusion Components.   I
can only tell you what I know and what is not under NDA anymore (Raymond
Campden is your man to ask, but I think he is neck deep in Neo development!)

But remember you can get a development copy of Spectra for single user use
off your ColdFusion Studio CD (it is on the 4.5 disk, I will have to check
the 5 disk) So if you want to help improve the model, you still can via
http://spectrasource.macromedia.com

Laters

Neil


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Question About Query Caching

[Owens, Howard]

Let's say I have a query that is cached ...

Let's say a user adds a new item to the table called in the query.

Now we all know that so long as the query is cached, the new item won't show
up in the output.

But what if I want it to show up right away?  Is there a way to dump the
current cache as soon as a new item is inserted, so that the query is
re-cached the next time it is run with the new data included?

I think I need to cache this query because it won't change too often, but it
returns, right now, 8,000 rows, so even cached it's a little on the slow
side.

H.


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PHP equivalents of CF list functions

[Clint Tredway]

just go to www.php.net and enter those in the function look up.

-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 1:51 PM
To: CF-Talk
Subject: PHP equivalents of CF list functions


I need to do a bit of PHP development, and I can't believe how much I'm
spoiled by CF. I have to roll my own for every little thing. Could someone
post PHP alternatives to functions such as:

listcontains
find
valuelist

Anything else that comes to mind.

Thanks!



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

PHP equivalents of CF list functions

[stas]

I need to do a bit of PHP development, and I can't believe how much I'm
spoiled by CF. I have to roll my own for every little thing. Could someone
post PHP alternatives to functions such as:

listcontains
find
valuelist

Anything else that comes to mind.

Thanks!


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: popUp Window trouble

[Brian Scandale]

Thanks Conrad, 

I'll see what this info might do to help. 

One thing you mention I don't want to do. I don't want the child window to close when 
the parent window access a different URL. The info in the child window can still be 
necessary to the user.

As far as different definitions goes... EVEN clicking the same Detail popsUp a New 
Instance of the Detail.

My original question is at the bottom of this post... and still very much a mystery.


At 02:14 AM 3/13/02 +0200, you wrote:
>If the created window has different definitions, a new instance of the
>window will be created.
>Using the same variable ref container for both will cause the first
>instances reference to be
>lost as well. Also, it would also be better to close any children
>windows that may happen to 
>be open when the current window is closed or references a different URL.
>
>Try the following
>
>
>
>
>
>
>
>
>Help
>
>DETAILS>
>
>
>
>Conrad
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]] 
>Sent: 12 March 2002 08:18 PM
>To: CF-Talk
>Subject: RE: popUp Window trouble
>
>
>Steve,
>
>It does work. It uses the same window for all the Help instances but
>every instance of Details opens a new window.
>
>Anybody else have an idea?
>
>thanks,
>Brian
>
>At 03:43 AM 3/12/02 -0500, you wrote:
>>That looks like it should work...
>>
>>window.open('url', 'windowName', 'properties');
>>
>>The only thing I noticed is the name is pretty long, "theDetailWindow",
>
>>not sure if it matters but you could try using a shorter name.
>>
>>Other then that I noticed you have the href set in the link.  When I 
>>use a link to popup a window with the onclick even I usually set the 
>>href to "#" or "javascript:void(0)"
>>
>>_
>>steve oliver
>>senior internet developer
>>atnet solutions, inc.
>>http://www.atnetsolutions.com
>>
>>
>>-Original Message-
>>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, March 12, 2002 3:00 AM
>>To: CF-Talk
>>Subject: popUp Window trouble
>>
>>
>>One of my popUps always uses the same window for display... as 
>>expected. The other always generates a new window... (which clutters 
>>the desktop and uses resources). Both are called from the same page.
>>
>>I have a header that always has a help button in it. It calls help.cfm 
>>which pops up a help window with the contents of #Client.HelpIs#. If I 
>>navigate to a new page and press help, the old help window repopulates 
>>with New help info.
>>
>>Another page has a list of items each with a button for "Details" by 
>>each lineitem. Every press of the detail button brings up a new 
>>DetailWindow, ...even If I press the SAME Detail button. I am looking 
>>for all details to use the same window.
>>
>>As far as I can tell it is identical code... so I'm at a adjust this.
>>
>>The code:
>>
>>
>>
>>
>>
>>
>>
>>Help
>>
>>DETAILS>
>>
>>
>>
>>As it so happens... the href= is of no consequence... i can put 
>>anything in there... it's the popUp('page' that counts.
>>
>>Anybody know how I might start trying to fix this?
>>
>>thanks,
>>Brian

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Sprectra (WAS: KILL THE BROADVIEW!)

[Sharon Diorio]

They don't give it away for free, because believe it or not, there are still some 
people willing to pay for it.

Sharon
- Original Message - 
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 12:58 PM
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


> Too bad they won't give it out for free. If you have a product that you
> won't support and you don't sell it anymore, why not give it away? I would
> love a free copy of Spectra, heck that would let me give some support to the
> spectra source site.
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 12:59 PM
> To: CF-Talk
> Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)
> 
> 
> You're right, here is the URL. http://spectrasource.macromedia.com
> 
> Mike Brunt
> Sempra Energy
> 213.244.5226
> 
> "A complex system that does not work is invariably found to have evolved
> from a simpler system that worked just fine. "
> 
> 
> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 9:20 AM
> To: CF-Talk
> Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)
> 
> 
>   Sort of.  There aren't any new versions of it coming out; but it is still
> available.  I think it was said that it was left to the 'community source'
> model of support?
>   I guess that means that it's not dead, they just stopped feeding it.
> 
> At 11:15 AM 3/13/2002 -0600, you wrote:
> >Isn't Spectra dead?
> >
> > >>> [EMAIL PROTECTED] 03/13/02 09:11AM >>>
> >Yes perhaps they should try Spectra.
> >
> >Mike Brunt
> >Sempra Energy
> >213.244.5226
> >
> >"A complex system that does not work is invariably found to have evolved
> >from a simpler system that worked just fine. "
> >
> >
> >-Original Message-
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, March 13, 2002 8:58 AM
> >To: CF-Talk
> >Subject: KILL THE BROADVIEW!
> >
> >
> >Arrg!!  Someone please rewrite the Macromedia site in something
> >besides Broadview!!  It is so stinking slow!  I can't even view the
> >darn CF upgrade pricing list without waiting for 2 minutes
> >
> >
> >
> >
> 
> 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[phumes1]

I have the below code in one of my templates. Once the code below executes
and takes me back to the previous page how can I do a refresh?

window.history.back("refresh")"; ?









+---+ 

Philip Humeniuk
[EMAIL PROTECTED]

Hagar, how will I know when it's time to get married?
One day you'll wake up with the definite feeling that it's the time.
Then what should I do?
Go back to sleep until the feeling goes away!
++


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFTREE becomes invisible in IE 6.0

[laszlo]

I have a CFTREE (CF 4.51), works fine (kind of).
When I load the page in IE 6.0, it looks OK,
but as soon as I move the mouse over it,
it beomes invisible.
I can still click on the nodes, and the scrollbars,
the they become visible again.
Any ideas???
TIA,
laszlo


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Fusebox pros and cons

[Jeffry Houser]

  ROTFL!
  Not everyone can know everything.
  Just because someone doesn't know everything doesn't mean that are 
creating bad or malformed applications.
  I bet even Dave doesn't know everything.  ( That's why he hired Simon, 
right? )


At 09:30 AM 3/13/2002 -0800, you wrote:
>Based on his contributions to this list, I'd guess that there are about a
>dozen...
>
>At 09:11 AM 3/12/2002 -0800, you wrote:
>--- snip ---
> >it is
> >true that any well written CF Application should be logical and structured
> >but there aren't that many Dave Watt's et al in the real CF World,  My
> >sixpence worth.
> >
> >Mike Brunt
> >Sempra Energy
> >213.244.5226
>
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: String replace...

[Mike Bruce]

How about




#filename#

Michael Bruce

- Original Message -
From: "phumes1" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 12:26 PM
Subject: Re: String replace...


> Hi,
>
> The URL.filename below outputs "d:\books\deleteme\test"
>
>  "\"),"\")>
>
> I would like to replace the above so my output result is
"d:\books\deleteme"
>
> I need to strip out anything after the last "\"
>
>
>
>
>
>
>
+---
+
>
> Philip Humeniuk
> [EMAIL PROTECTED]
>
> Hagar, how will I know when it's time to get married?
> One day you'll wake up with the definite feeling that it's the time.
> Then what should I do?
> Go back to sleep until the feeling goes away!
>
+---
-+
>
>
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFGRID problem driving me nuts

[David Green]

Hello List

Having problem with all my cfgrids.  They worked before under cf 4.5,  I think they 
broke under cf5 but not sure exactly when the quit working.   

 It appears that am not getting a form fields from the grids but I do get the value 
from the input box text.  on the action page I get unresolved on 
#idplist.idp#  This is happening on all our cfgrids.  Can you see 
anything wrong with code or is there some patch or something I need to load.All 
this stuff worked fine for a couple of years :(

Thanks for the help
David




 


 
  

  







David Green
System Analyst
G & B Technologies Inc
661 948-5678
[EMAIL PROTECTED]



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Storyboarding software? - CLARIFICATION

[John Beynon]

http://sourceforge.net/projects/wireframetool/

It's inbuilt into Adalon (www.synthis.com) for a trial download.

Jb.

> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]] 
> Sent: 13 March 2002 18:22
> To: CF-Talk
> Subject: Re: Storyboarding software? - CLARIFICATION
> 
> 
> Someone posted an app recently that might do what you need, 
> it's like a site/outline skeleton thing...
> 
> aha, it's called wireframe. I have it downloaded but I can't 
> remember where I got it from.
> 
> > Should have mentioned 
> >
> > We use Visio for navigation, site overview type of 
> storyboarding. Was 
> > thinking more along the lines of page layout/mockup (guess I'm 
> > thinking of more specific page level storyboarding, i.e., 
> left nav has 
> > these items, ad copy here, articles here, that type of thing).
> >
> > Thanks again for your help.
> > Matt
> >
> > On 3/13/2002 11:36 AM, Matt Kornguth <[EMAIL PROTECTED]> wrote:
> > >Any suggestions on software to use for storyboarding? If 
> not specific 
> > >software for that purpose, what are you using that makes your life 
> > >easier?
> > >
> > >Thanks in advance,
> > >Matt Kornguth
> > >Web App Developer
> > >BLR.com
> > >
> > >
> > 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Storyboarding software? - CLARIFICATION

[Tony Schreiber]

Someone posted an app recently that might do what you need, it's like a
site/outline skeleton thing...

aha, it's called wireframe. I have it downloaded but I can't remember
where I got it from.

> Should have mentioned 
>
> We use Visio for navigation, site overview type of storyboarding. Was thinking more 
>along the lines of page layout/mockup (guess I'm thinking of more specific page level 
>storyboarding, i.e., left nav has these items, ad copy here, articles here, that type 
>of thing).
>
> Thanks again for your help.
> Matt
>
> On 3/13/2002 11:36 AM, Matt Kornguth <[EMAIL PROTECTED]> wrote:
> >Any suggestions on software to use for storyboarding? If not specific
> >software for that purpose, what are you using that makes your life
> >easier?
> >
> >Thanks in advance,
> >Matt Kornguth
> >Web App Developer
> >BLR.com
> >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFPOP unknown exception condition

[Plane, Nathaniel]

CFPOP has been flakey since its conception.  For some people it seems to
work perfectly where as others have nothing but problems with it.
Attachments and funky MIME types in a message can do this, if attachments
aren't a huge concern in your application I would sudgest turning them off.
You may also want to think 3rd party for this as well, there are quite a few
options out there, one inparticular i know of is at www.stoneagesoftware.com
in the freebies section (shameless plug).. It doesn't support attachments,
and it isnt the end all be all, but it cleans a lot of problems the original
CFPOP has, the java source is also included so ya can tweak it if need be.
Other than that, there are again quite a few commercial products out there
but from my experience with them they have a lot of the same issues, you may
want to take a step back and re-evaluate your approach, if possible in your
environment, you may be able to write a module for your email server to
automatically populate the contents of email into a database or to a flat
file that you can read in (with exchange for example, i know both are
possible)..

Hope that helps,

Nat

-Original Message-
From: Owen Leonard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:53 PM
To: CF-Talk
Subject: CFPOP unknown exception condition


I know I've asked this before, but I'm desperate for a solution and need any
help I can get.  Folks are frequently getting this error when they use our
web-based email:

Error Diagnostic Information
unknown exception condition
unknown error while executing a tag.

The log of the error in the server log looks like this:

Unexpected exception while processing a tag with a general identifier of
(CFPOP), occupying document position (32:4) to (37:39), while executing
template file [email.cfm]

.and the code in question looks like this:

   

I never used to get the error myself, but now it happens EVERY TIME when I
test it on my local development machine. We're running CF5.  If anyone has
any advice, I'd be extremely grateful.

--Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: A Verity SQL Combo Question - Can this be sped up?

[Al Musella, DPM]

   Not sure if this would apply to your case, but what I do in a situation 
like that is to create a custom field with the information that you want 
displayed.. and add that to the verity index ..for example,






  

  

   



then when you run your search on the verity collection, just display the 
custom1 field  this avoids the trip back to the database..
Al







>We have an interesting verity search/SQL search issue and I was
>wondering if anyone has any hints on how this possibly could be sped
>up..
>
>Ok.. some background..
>
>The Keyword search is done in verity and its fast by itself..
>
>The other searches are fast and are regular SQL.. when they are both
>combined they take a long time..
>
>Here's what happens..
>
>The Verity search returns the Keys which are equal to the ID field in
>the SQL DB..  if the keyword field is not blank then it add the keys in
>to the main query example query..
>
>--
>SELECT EPSTable.posting_date, agency_, office_, classcod_, subject_,
>solnbr_, epsid,
>(select top 1 par_id from par where
>rfpnumber=replace(epstable.solnbr_,'-','') and (rfpnumber is not null or
>rfpnumber<>'' or rfpnumber<>'N/A')) parid
>FROM  EPSTable
>WHERE
>(1 = 1)
>AND EPSTable.epsid IN
>(13913,11967,15428,15407,15057,15036,18538,14881,19636,18330,9411,16568,
>7593,19812,19391,17230,16774,10795,13469,6393,11616,11293,18112,16529,15
>461,15090,13871,11925,10778,9032,17558,16233,13893,13310,13069,11947,107
>79,9771,8907,7441,2676,16772,12398,10547,7974,5239,4158,20497,20400,2039
>9,20051,19996,19804,19640,19610,19299,18582,18300,18299,18291,18258,1812
>3,18075,17862,17738,17111,17026,17014,16993,16982,16846)
>
>AND CLASSCOD_ = '10'
>ORDER BY POSTING_DATE

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Sprectra (WAS: KILL THE BROADVIEW!)

[Robert Everland]

Too bad they won't give it out for free. If you have a product that you
won't support and you don't sell it anymore, why not give it away? I would
love a free copy of Spectra, heck that would let me give some support to the
spectra source site.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:59 PM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


You're right, here is the URL. http://spectrasource.macromedia.com

Mike Brunt
Sempra Energy
213.244.5226

"A complex system that does not work is invariably found to have evolved
from a simpler system that worked just fine. "  


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:20 AM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


  Sort of.  There aren't any new versions of it coming out; but it is still 
available.  I think it was said that it was left to the 'community source' 
model of support?
  I guess that means that it's not dead, they just stopped feeding it.

At 11:15 AM 3/13/2002 -0600, you wrote:
>Isn't Spectra dead?
>
> >>> [EMAIL PROTECTED] 03/13/02 09:11AM >>>
>Yes perhaps they should try Spectra.
>
>Mike Brunt
>Sempra Energy
>213.244.5226
>
>"A complex system that does not work is invariably found to have evolved
>from a simpler system that worked just fine. "
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 13, 2002 8:58 AM
>To: CF-Talk
>Subject: KILL THE BROADVIEW!
>
>
>Arrg!!  Someone please rewrite the Macromedia site in something
>besides Broadview!!  It is so stinking slow!  I can't even view the
>darn CF upgrade pricing list without waiting for 2 minutes
>
>
>
>


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: KILL THE BROADVIEW!

[VAN VLIET, SCOTT E (SBCSI)]

BroadVision Feedback:

http://www.broadvision.com/OneToOne/SessionMgr/company/contact_us.jsp?BV_Ses
sionID=0976102180.1016042337&BV_EngineID=cccdadcehhfiikkcefecefedghh
dfjl.0&channelRuleset=Company+Channels&channelName=Contact+Us&programName=Br
oadVision+Contact+Information&programRuleset=Contact+Us+Programs&com.broadvi
sion.session.new=Yes

(What a nice big URL, eh?!)

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  


 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 8:58 AM
To: CF-Talk
Subject: KILL THE BROADVIEW!


Arrg!!  Someone please rewrite the Macromedia site in something 
besides Broadview!!  It is so stinking slow!  I can't even view the 
darn CF upgrade pricing list without waiting for 2 minutes


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Sprectra (WAS: KILL THE BROADVIEW!)

[Brunt, Michael]

You're right, here is the URL. http://spectrasource.macromedia.com

Mike Brunt
Sempra Energy
213.244.5226

"A complex system that does not work is invariably found to have evolved
from a simpler system that worked just fine. "  


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:20 AM
To: CF-Talk
Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!)


  Sort of.  There aren't any new versions of it coming out; but it is still 
available.  I think it was said that it was left to the 'community source' 
model of support?
  I guess that means that it's not dead, they just stopped feeding it.

At 11:15 AM 3/13/2002 -0600, you wrote:
>Isn't Spectra dead?
>
> >>> [EMAIL PROTECTED] 03/13/02 09:11AM >>>
>Yes perhaps they should try Spectra.
>
>Mike Brunt
>Sempra Energy
>213.244.5226
>
>"A complex system that does not work is invariably found to have evolved
>from a simpler system that worked just fine. "
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 13, 2002 8:58 AM
>To: CF-Talk
>Subject: KILL THE BROADVIEW!
>
>
>Arrg!!  Someone please rewrite the Macromedia site in something
>besides Broadview!!  It is so stinking slow!  I can't even view the
>darn CF upgrade pricing list without waiting for 2 minutes
>
>
>
>

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFPOP unknown exception condition

[Owen Leonard]

I know I've asked this before, but I'm desperate for a solution and need any
help I can get.  Folks are frequently getting this error when they use our
web-based email:

Error Diagnostic Information
unknown exception condition
unknown error while executing a tag.

The log of the error in the server log looks like this:

Unexpected exception while processing a tag with a general identifier of
(CFPOP), occupying document position (32:4) to (37:39), while executing
template file [email.cfm]

..and the code in question looks like this:

   

I never used to get the error myself, but now it happens EVERY TIME when I
test it on my local development machine. We're running CF5.  If anyone has
any advice, I'd be extremely grateful.

--Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Statement question

[Chip Harlan]

you can't really, since adding the ID field will un-distinct two rows.

I'd add a field to the query just as a flag, and then  through
the query, and if two entries are the same, set the flag to 1. Then you
can do a query of a query to get the unflagged entries, something like:


SELECT field1, field2, 0 AS duplicate



last1 = "";
last2 = "";
for (i=1;i LTE query.recordcount;i=i+1) {
if (query.field1[i] EQ last1 AND query.field2[i] EQ
last2) {
query.duplicate[i] = 1;
}
last1 = query.field1[i];
last2 = query.field2[i];
}



SELECT *
FROM query
WHERE duplicate = 0


Not the speediest of processes, but it'll get the job done.

HTH

p.s. why doesn't cfscript support "i++" and "i .= 1" syntax yet???
argh!!

-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 11:45 AM
To: CF-Talk
Subject: SQL Statement question


Hello all,
I have a question about a sql statement I am trying to do.

I am using the select distinct column1, column2 from table

This is working correctly. The problem is when I want to output the
results I need the ID column.  How would I do this?  I do not want to
distinct that column since some are the same.

Thanks.

Joel



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Storyboarding software? - CLARIFICATION

[Matt Kornguth]

Should have mentioned 

We use Visio for navigation, site overview type of storyboarding. Was thinking more 
along the lines of page layout/mockup (guess I'm thinking of more specific page level 
storyboarding, i.e., left nav has these items, ad copy here, articles here, that type 
of thing).

Thanks again for your help.
Matt

On 3/13/2002 11:36 AM, Matt Kornguth <[EMAIL PROTECTED]> wrote:
>Any suggestions on software to use for storyboarding? If not specific 
>software for that purpose, what are you using that makes your life 
>easier?
>
>Thanks in advance,
>Matt Kornguth
>Web App Developer
>BLR.com
>
>
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Fusebox pros and cons

[Cary Gordon]

Based on his contributions to this list, I'd guess that there are about a 
dozen...

At 09:11 AM 3/12/2002 -0800, you wrote:
--- snip ---
>it is
>true that any well written CF Application should be logical and structured
>but there aren't that many Dave Watt's et al in the real CF World,  My
>sixpence worth.
>
>Mike Brunt
>Sempra Energy
>213.244.5226

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: RE: KILL THE BROADVIEW!

[ksuh]

Hey, we want an improvement in speed :)

- Original Message -
From: "Brunt, Michael" <[EMAIL PROTECTED]>
Date: Wednesday, March 13, 2002 10:11 am
Subject: RE: KILL THE BROADVIEW!

> Yes perhaps they should try Spectra.
> 
> Mike Brunt
> Sempra Energy
> 213.244.5226
> 
> "A complex system that does not work is invariably found to have 
> evolvedfrom a simpler system that worked just fine. "  
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 13, 2002 8:58 AM
> To: CF-Talk
> Subject: KILL THE BROADVIEW!
> 
> 
> Arrg!!  Someone please rewrite the Macromedia site in 
> something 
> besides Broadview!!  It is so stinking slow!  I can't even view 
> the 
> darn CF upgrade pricing list without waiting for 2 minutes
> 
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists