Re: Deleting a group of records in multiple tables???

[Jochem van Dieten]

Tyler Silcox wrote:

> What's the best way to delete a group based on a list of primary id's 
> from multiple tables?  Right now, I'm testing out the speed on a few 
> selects statements (I figure they'll be a somewhat accurate estimate of 
> time, although I think deletes operate much faster.)


Good databases should have a way to show the query tree and some 
statistics about the estimated time (EXPLAIN is the word to look for in 
the manual). Using that will probably provide more accurate results.


> I grab the user 
> id's in a select statement and then I use "IN" and CF's ValueList() 
> function to select the users in the other tables.  Is there a better way 
> to do this, because right now, it running miserably slow on only 3800 
> records. 


EXISTS is sometimes significantly faster as IN. Also might want to try 
cascading deletes.


> I also need to add one more query and I'd like to put a 
> cftransaction around the cfquery blocks to make sure all my constraints 
> hold up...here's what I have:

Cascading deletes are perfect for that.

Jochem
__
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: Macromedia.com

[Kay Smoljak]

Hey Andy, 

You are not the last CF'er in Perth - I work for PerthWeb and we do
quite a lot of CF.

Kay.
__ 
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd 
Internet Solutions for your business! 
  
Level 9/105 St George's Tc - Perth - Western Australia 
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 
Visit Perth online! : www.perthweb.com.au 

Tools for developers: http://developer.perthweb.com.au 
-- cfx_pwimageproc -- cfx_pwcardcrypt -- cfx_pwtextcrypt --
--   plus WindowsXP-compliant toolbar glyphs -- 
 

"Andy Parry" <[EMAIL PROTECTED]> wrote in message
news:<01c1a9f0$9900dba0$[EMAIL PROTECTED]>...
> Hi
> I am glad you all have plenty of CF work in the US.
> I live in Australia and if any of you have seen the long thread "The 
> Death of Cold Fusion" on the MM CF forums you would know that there is

> virtually no work in Australia for CF-ers. Go to www.seek.com.au and 
> do a search. I live in Perth which is admittedly a bit of a backwater,

> but even in Sydney, a major city, there are no jobs. Perth is 2000 
> miles from Sydney and I think I have the last CF job in Perth. ASP.net

> may be a pile of crap, but it and Java are the clear winners over 
> here. I will have to re-skill, but how will I get experience in J2EE 
> without having the infrastructure to play with ? Sure, I can do 
> Java/JSP already, but how do you experiment with EJB ? I think CF is 
> fantastic, but there are no jobs and almost no-one is using it.
> 
> andy.NET
> (new to group.) 
> 
__
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: Hijacking of CFID/CFTOKEN variables. Help please :)

[Matt Robertson]

Peter,

Take a look at cf_SessionMonger.  It can't be shared via links, even
with cookies turned off.  Downside: you'll have to pass its value via a
url, although I'm playing around with something at a new site that moves
the var into a session variable and carries it around (for a
pre-existing site where I'm dropping a module into the middle of it.

http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347818-2830-
11D4-AA9700508B94F380&method=Full

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com



-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:47 PM
To: CF-Talk
Subject: Hijacking of CFID/CFTOKEN variables. Help please :)


Hi there!

I'm having problems with a "fusebox" application that requires unique 
identification for each client connected. At the moment it appears that
users 
are able to bookmark the applications full URL including the CFID and
CFTOKEN - 
essentially hijacking the settings assigned to a previous client. Not
good.

To prevent this occurring what wouyld be the best solution?

I've considered this:

1. Embedding the main content of the site in a frame that would prevent
a user 
from bookmarking the site with the CFID/CFTOKEN variables embedded. This
would 
force CF to either identify a revisiting client or assign a new
CFID/CFTOKEN 
value. This would also prevent a user from "changing" the CFID/CFTOKEN
values.

2. Somehow dumping the CFID/CFTOKEN and assigning a new one if it
already 
exists. The values are being stored in a datasource.

Any other ideas? I need to sort this out by Monday at the earliest.

Thanks in advance!

Regards,

Peter Tilbrook ([EMAIL PROTECTED])

__
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: ReReplace(NoCase) maximum length

[Don Vawter]

i believe regex in cf limitted to about 20k

- Original Message -
From: "James Sleeman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 10:30 PM
Subject: ReReplace(NoCase) maximum length


> Hi All,
> anybody know if there is a maximum length on the string passed to
> ReReplace(NoCase) ?  Reason I ask is that I am running the following
>
> ReReplaceNoCase(trim(text), "^(.*)$", "\1");
>
> and when the string in text is above a certain length (don't know how
> long exactly) the code fails with an Invalid regular expression message.
>   I cut the offending text in half (it's comign from a database field
>   (the data in the field is fine, all there, all returned in query))
>   and each half goes through just fine, but put em togethor and I get
>   the error.  Hopefully the "designers" won't mind me splitting thier
>   page into two (stupidly long anyway) :-)
>
> ---
> James Sleeman
>
> 
__
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

ReReplace(NoCase) maximum length

[James Sleeman]

Hi All,
anybody know if there is a maximum length on the string passed to 
ReReplace(NoCase) ?  Reason I ask is that I am running the following 

ReReplaceNoCase(trim(text), "^(.*)$", "\1");

and when the string in text is above a certain length (don't know how 
long exactly) the code fails with an Invalid regular expression message.
  I cut the offending text in half (it's comign from a database field 
  (the data in the field is fine, all there, all returned in query)) 
  and each half goes through just fine, but put em togethor and I get 
  the error.  Hopefully the "designers" won't mind me splitting thier 
  page into two (stupidly long anyway) :-) 

---
James Sleeman

__
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 - MS Word outputfrom CF?

[Steve Oliver]

If you create a word document, and save it as an rtf file, then open it
up in notepad, you'll see all the garbled junk like:

{\rtf1\ansi\ansicpg1252\uc1\deff0\stshfdbch0\stshfloch0\stshfhich0\stshf
bi0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\pan
ose 02020603050405020304}Times New Roman;}

Using that, you could make a template file, save it as an rtf, then
paste it into your template, and then place your cfoutputs where you
need to put your data. Once that is done, just output it as a doc file
using cfcontent.



{\rtf1\ansi\ansicpg1252\uc1\ blah blah blah

#myparagraph#

{\fs20\insrsid6363204 \tab \tab \tab
}{\fs20\insrsid6363204\charrsid6363204 
\par }}

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 12:30 AM
To: CF-Talk
Subject: Help - MS Word outputfrom CF?


After the users put in parameters to generate a "quote" and the customer
says
'yes', I need to generate a whole big document, including standard
paragraphs,
and other sections of text inserted based on various aspects of the
sale.

This is now all done by hand in MS Word. I can get all the parts (text
paragraphs),
but how do I then have CF spit out a nicely-formatted text document?

In general, what DO people do about printed reports???!?!?!  I have so
far
only
put a printer-friendly web page out and the user prints it in his
browser.

This is supposed to be a nicely formatted printed document, an actual
legal
contract for the customer to sign. Anyone do this type of thing before?

Thanks!

Ed Gordon
CF Developer
[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

Help - MS Word outputfrom CF?

[Ed Gordon]

After the users put in parameters to generate a "quote" and the customer
says
'yes', I need to generate a whole big document, including standard
paragraphs,
and other sections of text inserted based on various aspects of the sale.

This is now all done by hand in MS Word. I can get all the parts (text
paragraphs),
but how do I then have CF spit out a nicely-formatted text document?

In general, what DO people do about printed reports???!?!?!  I have so far
only
put a printer-friendly web page out and the user prints it in his browser.

This is supposed to be a nicely formatted printed document, an actual legal
contract for the customer to sign. Anyone do this type of thing before?

Thanks!

Ed Gordon
CF Developer
[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: MSSQL and LIMIT

[Mark A. Kruger - CFG]

Steve,

>From my standpoint I have always simply used the order by clause and tra
cked
the max and min of whatever values I am using for ORder by - if someone h
as
a better way (short of a stored proce with a cursor and fetch next) I'd l
ove
to get in on it.

Mark

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:38 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


I thought that this question would of come up at least once in the past,
I guess no one has figured out a way to get rows by rowID or LIMIT with
MSSQL.

Every answer I've seen so far is different, is there a recommended way
to do it?  I'm sure someone out there has needed to get row 20,000
through 20,100 in MSSQL without getting the entire table in a cfquery.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 11:22 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Make the cursor insert into a temp database then pull the data from the
temp database.



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 6:32 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT

I've tried it with a cursor and a stored proc, but that returns 50
recordsets, not 50 rows in one recordset.

I'm guessing that there is no RowID() in MSSQL?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:48 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Well that's pretty cool - I've not seen that syntax. You could do this
wi
th
a Cursor and a stored proc of course.

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:37 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)






__
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: Macromedia.com

[Stephen Collins]

Andy

I have to disagree with you here.

ACIS, who I work for are a CF-specialist web development company based
in Canberra.  Frankly, we have more work for CF and Spectra than we can
do.  We have to put clients off from time to time.  Sure we've seen a
downturn in the last six months, but so has everybody with 11/9, Federal
and State elections in Australia, etc.  But it's definitiely picking up.
The same would seem to go for Sydney where Daemon (one of Sydney's
leading CF studios) is in hiring mode.

I think the CF situation here in Oz is more a case of the CF jobs going
to companies with development teams, rather than jobs for individuals
being advertised.  Also, most of the roles I know of for individuals get
filled on a word-of-mouth basis before going to the jobs section of the
Australian or SMH.

Just my $0.04 (given the exchange rate of AU$1=USD$0.50).

Steve

Stephen Collins, Technical Consultant - ACIS (Australia)
Allaire Certified ColdFusion 5 Developer

 Work : [EMAIL PROTECTED] Personal : [EMAIL PROTECTED]
 ICQ UIN : 56321783   Yahoo! : trib

   Are you building your best Body-for-LIFE?
 www.bodyforlife.com

> -Original Message-
> From: Andy Parry [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, 31 January 2002 11:46 AM
> To: CF-Talk
> Subject: RE: Macromedia.com
> 
> 
> Hi
> I am glad you all have plenty of CF work in the US.
> I live in Australia and if any of you have seen the long 
> thread "The Death
> of Cold Fusion" on the MM CF forums you would know that there 
> is virtually
> no work in Australia for CF-ers. Go to www.seek.com.au and do 
> a search. I
> live in Perth which is admittedly a bit of a backwater, but 
> even in Sydney,
> a major city, there are no jobs. Perth is 2000 miles from 
> Sydney and I think
> I have the last CF job in Perth.
> ASP.net may be a pile of crap, but it and Java are the clear 
> winners over
> here. I will have to re-skill, but how will I get experience 
> in J2EE without
> having the infrastructure to play with ? Sure, I can do 
> Java/JSP already,
> but how do you experiment with EJB ?
> I think CF is fantastic, but there are no jobs and almost 
> no-one is using
> it.
> 
> andy.NET
> (new to group.)

__
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: MSSQL and LIMIT

[Steve Oliver]

I thought that this question would of come up at least once in the past,
I guess no one has figured out a way to get rows by rowID or LIMIT with
MSSQL.

Every answer I've seen so far is different, is there a recommended way
to do it?  I'm sure someone out there has needed to get row 20,000
through 20,100 in MSSQL without getting the entire table in a cfquery.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 11:22 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Make the cursor insert into a temp database then pull the data from the
temp database.



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 6:32 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT

I've tried it with a cursor and a stored proc, but that returns 50
recordsets, not 50 rows in one recordset.

I'm guessing that there is no RowID() in MSSQL?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:48 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Well that's pretty cool - I've not seen that syntax. You could do this
wi
th
a Cursor and a stored proc of course.

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:37 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)





__
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: scripting windows 2000 dns

[Tom Nunamaker]

Jim

I downloaded the BIND 9.2.0 windows package but it didn't have any of
the configuration files

Tom

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 8:26 PM
To: CF-Talk
Subject: Re: scripting windows 2000 dns


If you can use BIND for Win32, life is infinitely simpler.  Just read
and write text files.  The server has a master configuration file, plus
one file per zone.  Once changes are made, use cfexecute to run a
command-line program that controls the DNS server.  You can reload a
single zone, reload all zones, check the server's status, etc.

Win32 binaries of versions 8.3.0 and 9.2.0 can be found at
ftp://ftp.isc.org/isc/bind/contrib/ for anyone interested.

Jim


- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 6:48 PM
Subject: Re: scripting windows 2000 dns


> Yeah we use the CFexecute with the DNS provider.  It works beautifully
>
> Neil
>
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 3:37 PM
> Subject: Re: scripting windows 2000 dns
>
>
> > In addition to cfexecute, you could just use cfobject to interact 
> > with
the
> > DNS provider object. I can't say it would be easy though. You are 
> > going
to
> > have to rely on the docs if you don't know vbs pretty well. I know a
> little,
> > but that code is nasty :)
> >
> > The other possibility if you need to use CF, is just to figure out 
> > how
to
> > recreate the zone files in CF, write them out, create the registry
> entries,
> > then restart the DNS server. The zone files themselves are just 
> > plain text...
> >
> > jon
> > - Original Message -
> > From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, January 31, 2002 2:35 PM
> > Subject: scripting windows 2000 dns
> >
> >
> > > I am trying to use WMI to manage DNS entries in a Windows 2000 DNS
> server.
> > > I have some VBS files that I can do this with from the command 
> > > prompt,
> but
> > > am not sure how to run them with ColdFusion.  Here is a link to 
> > > the
> > article
> > > I am looking at for instructions on how to accomplish this task: 
> > > http://www.iisfaq.com/Articles/319/.  Just trying to automatially
> create,
> > > modify, and delete dns entries with ColdFusion, if anyone knows of

> > > a
> > better
> > > way to do this then using the VBS files I mentioned then please 
> > > let me
> > know.
> > >
> > > Bernd VanSkiver
> > > [EMAIL PROTECTED]
> > > ColdFusion Developer

__
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: MSSQL and LIMIT

[Joshua Tipton]

Make the cursor insert into a temp database then pull the data from the
temp database.



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 6:32 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT

I've tried it with a cursor and a stored proc, but that returns 50
recordsets, not 50 rows in one recordset.

I'm guessing that there is no RowID() in MSSQL?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:48 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Well that's pretty cool - I've not seen that syntax. You could do this
wi
th
a Cursor and a stored proc of course.

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:37 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)




__
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: WDDX feeds

[Mark A. Kruger - CFG]

Steve,

When using a Stored proc to do this, you would create a persistant cursor
,
then you would create a "temp" table within the proc.  Your logic would
populate the temp table with the desired 50 records and THAT is what you
would return to the calling page. You would use the "FETCH ABSOLUTE n "
(where n is the rownumber)  method and keep track of the current row -
passing it into the sp as one of the parameters and out again as one of t
he
OUTPUT parameters.

Mark

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:17 PM
To: CF-Talk
Subject: RE: WDDX feeds


Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: WDDX feeds

[Mark A. Kruger - CFG]

Steve,

FinWin.com provides Business news from PR News Wire, Business Wire, RT
trader, AP, BTU, Agricultural news, and pre-edited news and proprietary n
ews
from our its news room (7 editors). All the services are provided via WDD
X.
There are tags for use and there is an SDK allowing you to build your own
interface. The SDK is at http://www.finwin.com/dev/onlinesdk . As has bee
n
stated on this list, legally redistributed news is expensive (illegally
re-distributed news is not expensive but it really ticks me off ).
FinWin charges a fee based on usage (which sources and how much traffic),
but it ain't a free feed .

Mark



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:17 PM
To: CF-Talk
Subject: RE: WDDX feeds


Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: Hijacking of CFID/CFTOKEN variables. Help please :)

[Andy Parry]

you could try the "aSession" custom tag.
I have not used it, but it looks like it would do what you require.
Has anyone else tried it ?

andy
__
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: Hijacking of CFID/CFTOKEN variables. Help please :)

[Jared Clinton]

Peter, 

Include some additional information in a cookie about the validity of 
the
current session.
(Such as datetime session started.. ip/useragent) 
Cookies are not stored in bookmarks, as are the cfid and cftoken 
parameters
you mentioned.
Hope this helps.

Jared Clinton.
NEC Business Solutions.

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 February 2002 1:47 PM
To: CF-Talk
Subject: Hijacking of CFID/CFTOKEN variables. Help please :)


Hi there!

I'm having problems with a "fusebox" application that requires unique 
identification for each client connected. At the moment it appears that
users 
are able to bookmark the applications full URL including the CFID and
CFTOKEN - 
essentially hijacking the settings assigned to a previous client. Not 
good.

To prevent this occurring what wouyld be the best solution?

I've considered this:

1. Embedding the main content of the site in a frame that would prevent 
a
user 
from bookmarking the site with the CFID/CFTOKEN variables embedded. 
This
would 
force CF to either identify a revisiting client or assign a new 
CFID/CFTOKEN

value. This would also prevent a user from "changing" the CFID/CFTOKEN
values.

2. Somehow dumping the CFID/CFTOKEN and assigning a new one if it 
already 
exists. The values are being stored in a datasource.

Any other ideas? I need to sort this out by Monday at the earliest.

Thanks in advance!

Regards,

Peter Tilbrook ([EMAIL PROTECTED])

__
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: Conditional statement based on Server Time

[Steve Oliver]

You could either do something like this for 10:30 or less



Or something like this




__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 10:41 PM
To: CF-Talk
Subject: RE: Conditional statement based on Server Time


This is great - How would that hour(Now()) part change if I wanted to
measure it based on hour AND minute?

Mark
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:23 PM
To: CF-Talk
Subject: RE: Conditional statement based on Server Time


Use hour(), it returns the time in 24 hour format, so if it's 10 PM it
will return 22







__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:19 PM
To: CF-Talk
Subject: Conditional statement based on Server Time


How would I write a CFIF statement that redirects based on the time of a
server.

For example:  

  
 
  

Thanks in advance for your help.

Mark



__
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

Hijacking of CFID/CFTOKEN variables. Help please :)

[Peter Tilbrook]

Hi there!

I'm having problems with a "fusebox" application that requires unique 
identification for each client connected. At the moment it appears that users 
are able to bookmark the applications full URL including the CFID and CFTOKEN - 
essentially hijacking the settings assigned to a previous client. Not good.

To prevent this occurring what wouyld be the best solution?

I've considered this:

1. Embedding the main content of the site in a frame that would prevent a user 
from bookmarking the site with the CFID/CFTOKEN variables embedded. This would 
force CF to either identify a revisiting client or assign a new CFID/CFTOKEN 
value. This would also prevent a user from "changing" the CFID/CFTOKEN values.

2. Somehow dumping the CFID/CFTOKEN and assigning a new one if it already 
exists. The values are being stored in a datasource.

Any other ideas? I need to sort this out by Monday at the earliest.

Thanks in advance!

Regards,

Peter Tilbrook ([EMAIL PROTECTED])
__
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: Conditional statement based on Server Time

[Mark Leder]

This is great - How would that hour(Now()) part change if I wanted to
measure it based on hour AND minute?

Mark
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:23 PM
To: CF-Talk
Subject: RE: Conditional statement based on Server Time


Use hour(), it returns the time in 24 hour format, so if it's 10 PM it
will return 22







__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:19 PM
To: CF-Talk
Subject: Conditional statement based on Server Time


How would I write a CFIF statement that redirects based on the time of a
server.

For example:  

  
 
  

Thanks in advance for your help.

Mark


__
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: Conditional statement based on Server Time

[David Hannum \(Ohio University\)]

Mark,

The Now() function returns the server time.  Do this:
#Now()# to see the complete time/date stamp from the
server.


Try this:



Read up on TimeFormat in the Docs.

Dave



- Original Message -
From: "Mark Leder" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 10:19 PM
Subject: Conditional statement based on Server Time


> How would I write a CFIF statement that redirects based on the time of a
> server.
>
> For example:  

>   
>  
>   
>
> Thanks in advance for your help.
>
> Mark
> 
__
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 / SQL 2K / CONNX

[Stephen Hait]

> Does anyone have any experience using SQL 2K and CONNX together and
> then using CF to output the data?

We are using CONNX to access DataFlex data with SQL7. We 
can also set up an ODBC connection to the CONNX-connected 
DataFlex data and access this via CF if needed. I don't know how 
this would differ with VMS data and I'm not sure I am answering 
your specific question.

Stephen

__
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: Conditional statement based on Server Time

[Steve Oliver]

Use hour(), it returns the time in 24 hour format, so if it's 10 PM it
will return 22







__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 10:19 PM
To: CF-Talk
Subject: Conditional statement based on Server Time


How would I write a CFIF statement that redirects based on the time of a
server.

For example:  

  
 
  

Thanks in advance for your help.

Mark

__
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

Conditional statement based on Server Time

[Mark Leder]

How would I write a CFIF statement that redirects based on the time of a
server.

For example:   
  
 
  

Thanks in advance for your help.

Mark
__
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: CFHTTP-->CFFILE

[Steve Oliver]

Try adding addNewLine="No" to your cffile.



I was having that problem when I was writing files after I read them
from disk using cffile, it put double spaces on everyline, and that
fixed it.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 10:06 PM
To: CF-Talk
Subject: CFHTTP-->CFFILE


I wonder if anyone could explain why a file obtained with a CFHTTP get
operation and subsequently written to disk with a CFFILE operation is
double line spaced compared to a browser source.

How to stop it? a REREPLACE against the CFHTTP.FileContent?


--
Regards;

Richard Meredith-Hardy
-
[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

CFHTTP-->CFFILE

[Richard Meredith-Hardy]

I wonder if anyone could explain why a file obtained with a CFHTTP get
operation and subsequently written to disk with a CFFILE operation is
double line spaced compared to a browser source.

How to stop it? a REREPLACE against the CFHTTP.FileContent?


--
Regards;

Richard Meredith-Hardy
-
[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: Help with a list of dates

[Jason Larson]

Thanks just what I was looking for!

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:14 PM
To: CF-Talk
Subject: RE: Help with a list of dates
















 
 
 
 




#dates_list#





-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 9:04 PM
To: CF-Talk
Subject: Help with a list of dates


Alright heres my problem:

I have two dates: 
Startdate: 1/12/02 
Enddate: 1/15/02

How do I use cf to build a list of dates from the startdate to the
endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).

Does anybody have any resources or code snippets that might shed some
light on this.

Thanks
Jason

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 




__
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: Help with a list of dates

[Steve Oliver]

Alright, I just made a UDF for that /me loves udf's :)

This will output the list of dates in a list.

#dateRange("02/02/02","02/10/02")#


function dateRange(sDate, eDate){
nDate = sDate;
dateList = "";

while(datediff("d",eDate,nDate) NEQ 0) {
nDate = dateAdd("d",1,nDate);
dateList = listAppend(dateList, nDate);
}
Return dateList;
}



__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 9:17 PM
To: CF-Talk
Subject: RE: Help with a list of dates


You could do something like this


dateList = "";

sDate = startdate;
eDate = enddate;

while (datediff("d",sDate,eDate) NEQ 0) {
listAppend(dateList, dateAdd("d",1,sDate));
}


Or something along that line



__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 9:04 PM
To: CF-Talk
Subject: Help with a list of dates


Alright heres my problem:

I have two dates: 
Startdate: 1/12/02 
Enddate: 1/15/02

How do I use cf to build a list of dates from the startdate to the
endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).

Does anybody have any resources or code snippets that might shed some
light on this.

Thanks
Jason

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 




__
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: scripting windows 2000 dns

[Jim McAtee]

If you can use BIND for Win32, life is infinitely simpler.  Just read and
write text files.  The server has a master configuration file, plus one file
per zone.  Once changes are made, use cfexecute to run a command-line
program that controls the DNS server.  You can reload a single zone, reload
all zones, check the server's status, etc.

Win32 binaries of versions 8.3.0 and 9.2.0 can be found at
ftp://ftp.isc.org/isc/bind/contrib/ for anyone interested.

Jim


- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 6:48 PM
Subject: Re: scripting windows 2000 dns


> Yeah we use the CFexecute with the DNS provider.  It works beautifully
>
> Neil
>
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 3:37 PM
> Subject: Re: scripting windows 2000 dns
>
>
> > In addition to cfexecute, you could just use cfobject to interact with
the
> > DNS provider object. I can't say it would be easy though. You are going
to
> > have to rely on the docs if you don't know vbs pretty well. I know a
> little,
> > but that code is nasty :)
> >
> > The other possibility if you need to use CF, is just to figure out how
to
> > recreate the zone files in CF, write them out, create the registry
> entries,
> > then restart the DNS server. The zone files themselves are just plain
> > text...
> >
> > jon
> > - Original Message -
> > From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, January 31, 2002 2:35 PM
> > Subject: scripting windows 2000 dns
> >
> >
> > > I am trying to use WMI to manage DNS entries in a Windows 2000 DNS
> server.
> > > I have some VBS files that I can do this with from the command prompt,
> but
> > > am not sure how to run them with ColdFusion.  Here is a link to the
> > article
> > > I am looking at for instructions on how to accomplish this task:
> > > http://www.iisfaq.com/Articles/319/.  Just trying to automatially
> create,
> > > modify, and delete dns entries with ColdFusion, if anyone knows of a
> > better
> > > way to do this then using the VBS files I mentioned then please let me
> > know.
> > >
> > > Bernd VanSkiver
> > > [EMAIL PROTECTED]
> > > ColdFusion Developer
__
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 with a list of dates

[Steve Oliver]

You could do something like this


dateList = "";

sDate = startdate;
eDate = enddate;

while (datediff("d",sDate,eDate) NEQ 0) {
listAppend(dateList, dateAdd("d",1,sDate));
}


Or something along that line



__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 9:04 PM
To: CF-Talk
Subject: Help with a list of dates


Alright heres my problem:

I have two dates: 
Startdate: 1/12/02 
Enddate: 1/15/02

How do I use cf to build a list of dates from the startdate to the
endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).

Does anybody have any resources or code snippets that might shed some
light on this.

Thanks
Jason

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 



__
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: Help with a list of dates

[Ben Forta]

 
 
 
 




#dates_list#





-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 9:04 PM
To: CF-Talk
Subject: Help with a list of dates


Alright heres my problem:

I have two dates: 
Startdate: 1/12/02 
Enddate: 1/15/02

How do I use cf to build a list of dates from the startdate to the
endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).

Does anybody have any resources or code snippets that might shed some
light on this.

Thanks
Jason

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 



__
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 with a list of dates

[Andy Parry]

try this








#dateadd("d",i,start)#



or something along those lines anyway...
HTH
andy

> I have two dates: 
> Startdate: 1/12/02 
> Enddate: 1/15/02
> 
> How do I use cf to build a list of dates from the startdate to the
> endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).
__
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

Help with a list of dates

[Jason Larson]

Alright heres my problem:

I have two dates: 
Startdate: 1/12/02 
Enddate: 1/15/02

How do I use cf to build a list of dates from the startdate to the
endate like i.e. (1/12/02,1/13/02,1/14/02,1/15/02).

Does anybody have any resources or code snippets that might shed some
light on this.

Thanks
Jason

Thanks,
Jason Larson
[EMAIL PROTECTED]

"You think the Cubs have sore arms? What about the fans in left field?" 
 
 


__
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: WDDX feeds

[David Hannum \(Ohio University\)]

Beware - moreover is free for nonprofits and personal home pages.  Anything
else is BIG bucks!

Dave


- Original Message -
From: "Joseph DeVore" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 8:12 PM
Subject: RE: WDDX feeds


> Check out moreover:
> http://w.moreover.com/
>
>
>
> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 5:05 PM
> To: CF-Talk
> Subject: WDDX feeds
>
>
> Anyone know of any sites that serves WDDX news?  I have one now but it
> grabs news from several different sites, I was looking for a major news
> site that served them if possible.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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: scripting windows 2000 dns

[Neil H.]

Yeah we use the CFexecute with the DNS provider.  It works beautifully

Neil

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 3:37 PM
Subject: Re: scripting windows 2000 dns


> In addition to cfexecute, you could just use cfobject to interact with the
> DNS provider object. I can't say it would be easy though. You are going to
> have to rely on the docs if you don't know vbs pretty well. I know a
little,
> but that code is nasty :)
>
> The other possibility if you need to use CF, is just to figure out how to
> recreate the zone files in CF, write them out, create the registry
entries,
> then restart the DNS server. The zone files themselves are just plain
> text...
>
> jon
> - Original Message -
> From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 2:35 PM
> Subject: scripting windows 2000 dns
>
>
> > I am trying to use WMI to manage DNS entries in a Windows 2000 DNS
server.
> > I have some VBS files that I can do this with from the command prompt,
but
> > am not sure how to run them with ColdFusion.  Here is a link to the
> article
> > I am looking at for instructions on how to accomplish this task:
> > http://www.iisfaq.com/Articles/319/.  Just trying to automatially
create,
> > modify, and delete dns entries with ColdFusion, if anyone knows of a
> better
> > way to do this then using the VBS files I mentioned then please let me
> know.
> >
> > Bernd VanSkiver
> > [EMAIL PROTECTED]
> > ColdFusion Developer
> >
>
> 
__
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: CFPARAM Question

[Ben Forta]

No,  writes the variable only if it does not exist, so the
second  will never get executed. What you have is essentially
this:


 


 


--- Ben



-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 11:06 AM
To: CF-Talk
Subject: CFPARAM Question


Do subsequent CFPARAMS of the same variable overwrite each other? I
thought so, but they don't seem to.



 later ...



If I check for foo it's still "bar" instead of "boo"...

Is there a way to duplicate my intended behavior another way?

Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange


__
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: CFPARAM Question

[Bryan Stevenson]

Nope it would not overwrite.

CFPARAM works like this:

If the variable does not exist it will create it and set whatever default value you 
specify.  So
when the second CFPARAM is called it will NOT create the var and a set a value because 
it already
exists.

To reset the var use CFSET in place of the second CFPARAM in your example

HTH

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

- Original Message -
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 8:05 AM
Subject: CFPARAM Question


> Do subsequent CFPARAMS of the same variable overwrite each other? I
> thought so, but they don't seem to.
>
> 
>
> . later ...
>
> 
>
> If I check for foo it's still "bar" instead of "boo"...
>
> Is there a way to duplicate my intended behavior another way?
>
> Tony Schreiber, Senior Partner  Man and Machine, Limited
> mailto:[EMAIL PROTECTED]   http://www.technocraft.com
>
> http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
> http://www.digitacamera.com __DigitA Camera Scripts and Tips
> http://www.linklabexchange.com _Miata Link ECU Data Exchange
>
> 
__
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: Macromedia.com

[Matt Brown, Community Manager]

Tom Forbes wrote:
> 
> This is not a one year old rumor. It was posted today at
> http://finance.yahoo.com/mp#macr and quite a few shares were BOUGHT in
> speculation of the MS involvement.

I can post that Japan just bombed our fleet at Pearl Harbor. You can go
buy a tin hat and a shotgun or you can check to see if the news is true. 

Your call.
_

Matt Brown   Community Manager - Macromedia, Inc.  
__
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: Macromedia.com

[Matt Brown, Community Manager]

"Larry C. Lyons" wrote:
> 
> Matt,
> 
> I posted a copy of your comments to F**kedCompany.com

Ah. It was you... Well I am sort of a celebrity here now.. LOL.

Thanks for letting me know. We aren't supposed to be up there and
identified as MM employees so knowing how it got there is good if anyone
asks me and no one has. 
_

Matt Brown   Community Manager - Macromedia, 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: WDDX feeds

[Andy Parry]

7am.com does XML

http://www.7am.com/subsproducts/Options.htm#feed

HTH
__
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: WDDX feeds

[Steve Oliver]

Joseph,

Yes they do have a wddx section, and I found that earlier, but I was
hoping there might be Another mainstream site like ABC, or NBC that
serves XML, RDF, or WDDX feeds.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 8:23 PM
To: CF-Talk
Subject: RE: WDDX feeds


they have a wddx section (or had if not anymore)


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:17 PM
To: CF-Talk
Subject: RE: WDDX feeds


Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: WDDX feeds

[Joseph DeVore]

they have a wddx section (or had if not anymore)


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:17 PM
To: CF-Talk
Subject: RE: WDDX feeds


Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: WDDX feeds

[Steve Oliver]

Yeah that's the site that I found earlier, I was hoping there might be
another site that serves WDDX news.

Or, since it's not hard to parse RDF's, does anyone know of any sites
that serves those, besides the typical Linux sites?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 8:13 PM
To: CF-Talk
Subject: RE: WDDX feeds


Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: another quick regular expression question

[Steve Oliver]

Brent, Try this :)



(.*?)","\1")>

#test#

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 8:09 PM
To: CF-Talk
Subject: RE: another quick regular expression question


Hi Steve,

Won't the .* pick up the  part?

-Brent

> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:31 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> An easier way to do that would be something like
>
> "(.*?)"
>
> That will get everything between the two titles no matter what it may
> be.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 7:28 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> Hi,
>
> Use this regex:
>
>  "[[:space:]]*[[:alnum:][:punct:]]*[[:space:]]*">
> 
>
> Don't forget the NoCase, or else it won't match asdf
>
> -Brent
>
> > -Original Message-
> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 31, 2002 4:15 PM
> > To: CF-Talk
> > Subject: another quick regular expression question
> >
> >
> > Hi
> >
> > Can anyone explain why this regex does not match every
> > title?(i'm using it
> > in cfstuido on a directory of html and cfml files)
> >
> > <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
> >
> > It will not match untitled for example what am
> > I doing wrong?
> >
> > Thanks in advance
> >
> > Kola
> >
>
> 

__
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: WDDX feeds

[Joseph DeVore]

Check out moreover:
http://w.moreover.com/



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 5:05 PM
To: CF-Talk
Subject: WDDX feeds


Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: another quick regular expression question

[Steve Oliver]

It doesn't really matter, He's using CFStudio to find some
title

So either way will work.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 8:09 PM
To: CF-Talk
Subject: RE: another quick regular expression question


Hi Steve,

Won't the .* pick up the  part?

-Brent

> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:31 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> An easier way to do that would be something like
>
> "(.*?)"
>
> That will get everything between the two titles no matter what it may
> be.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 7:28 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> Hi,
>
> Use this regex:
>
>  "[[:space:]]*[[:alnum:][:punct:]]*[[:space:]]*">
> 
>
> Don't forget the NoCase, or else it won't match asdf
>
> -Brent
>
> > -Original Message-
> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 31, 2002 4:15 PM
> > To: CF-Talk
> > Subject: another quick regular expression question
> >
> >
> > Hi
> >
> > Can anyone explain why this regex does not match every
> > title?(i'm using it
> > in cfstuido on a directory of html and cfml files)
> >
> > <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
> >
> > It will not match untitled for example what am
> > I doing wrong?
> >
> > Thanks in advance
> >
> > Kola
> >
>
> 

__
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

WDDX feeds

[Steve Oliver]

Anyone know of any sites that serves WDDX news?  I have one now but it
grabs news from several different sites, I was looking for a major news
site that served them if possible.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: another quick regular expression question

[Brent Goldman]

Hi Steve,

Won't the .* pick up the  part?

-Brent

> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:31 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> An easier way to do that would be something like
>
> "(.*?)"
>
> That will get everything between the two titles no matter what it may
> be.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 7:28 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> Hi,
>
> Use this regex:
>
>  "[[:space:]]*[[:alnum:][:punct:]]*[[:space:]]*">
> 
>
> Don't forget the NoCase, or else it won't match asdf
>
> -Brent
>
> > -Original Message-
> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 31, 2002 4:15 PM
> > To: CF-Talk
> > Subject: another quick regular expression question
> >
> >
> > Hi
> >
> > Can anyone explain why this regex does not match every
> > title?(i'm using it
> > in cfstuido on a directory of html and cfml files)
> >
> > <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
> >
> > It will not match untitled for example what am
> > I doing wrong?
> >
> > Thanks in advance
> >
> > Kola
> >
>
> 
__
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: another quick regular expression question

[Brent Goldman]

> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:31 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> An easier way to do that would be something like
>
> "(.*?)"
>
> That will get everything between the two titles no matter what it may
> be.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 7:28 PM
> To: CF-Talk
> Subject: RE: another quick regular expression question
>
>
> Hi,
>
> Use this regex:
>
>  "[[:space:]]*[[:alnum:][:punct:]]*[[:space:]]*">
> 
>
> Don't forget the NoCase, or else it won't match asdf
>
> -Brent
>
> > -Original Message-
> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 31, 2002 4:15 PM
> > To: CF-Talk
> > Subject: another quick regular expression question
> >
> >
> > Hi
> >
> > Can anyone explain why this regex does not match every
> > title?(i'm using it
> > in cfstuido on a directory of html and cfml files)
> >
> > <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
> >
> > It will not match untitled for example what am
> > I doing wrong?
> >
> > Thanks in advance
> >
> > Kola
> >
>
> 
__
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: The darndest time w/ Cookies. Actually form checking.

[Steve Oliver]

Keyword "older"

None of the new software will allow you to set a cookie if you redirect
by the "Location:" header, or a  tag.

Therefore just use a meta tag, or a javascript redirect.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:10 PM
To: CF-Talk
Subject: Re: The darndest time w/ Cookies. Actually form checking.


On Thu, 31 Jan 2002 16:03:09 -0500, "Christopher Olive"
<[EMAIL PROTECTED]> wrote:

>actually, parameterexists() is deprecated in favor of isdefined().
>
>and as another side note, whoever said to do a CFLOCATION after the
>CFCOOKIE is incorrect.  doing that sends a 302 "Resource Moved" header,
>so the pages never complete.  that'll prevent a cookie from being set.

Actually the page "completes" just fine, it's just that if a page has
a status header of 302 and a location var in the header then cookies
are supposed to be not sent and ignored by the browser. "Supposed to
be" being the operative phrase.

The older versions of Website Pro used to ignore this standard and
returned cookies just fine with a 302.

--min

__
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: Session Swapping" incident

[Andy Parry]

Hi,
Yes we had all kinds of problems. Once we ditched client variables and
cookies, moved to using (locked) session variables only (URL token passing)
the problems went away. We were sure that some proxies were not permitting
the creation of unique sessions. Don't really know the reason why, but it
was nice when the problem went away :)

andy

> > Has anyone else had bad experiences with proxies/firewalls and session
> > variables swapping?
> >
> > Thanks again
> >
> > Chris.
__
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: another quick regular expression question

[Steve Oliver]

An easier way to do that would be something like

"(.*?)"

That will get everything between the two titles no matter what it may
be.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:28 PM
To: CF-Talk
Subject: RE: another quick regular expression question


Hi,

Use this regex:




Don't forget the NoCase, or else it won't match asdf

-Brent

> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:15 PM
> To: CF-Talk
> Subject: another quick regular expression question
>
>
> Hi
>
> Can anyone explain why this regex does not match every
> title?(i'm using it
> in cfstuido on a directory of html and cfml files)
>
> <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
>
> It will not match untitled for example what am
> I doing wrong?
>
> Thanks in advance
>
> Kola
> 

__
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: another quick regular expression question

[Brent Goldman]

Hi,

Use this regex:




Don't forget the NoCase, or else it won't match asdf

-Brent

> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 4:15 PM
> To: CF-Talk
> Subject: another quick regular expression question
>
>
> Hi
>
> Can anyone explain why this regex does not match every
> title?(i'm using it
> in cfstuido on a directory of html and cfml files)
>
> <[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*
>
> It will not match untitled for example what am
> I doing wrong?
>
> Thanks in advance
>
> Kola
> 
__
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: The darndest time w/ Cookies. Actually form checking.

[Lewis Sellers]

On Thu, 31 Jan 2002 16:03:09 -0500, "Christopher Olive"
<[EMAIL PROTECTED]> wrote:

>actually, parameterexists() is deprecated in favor of isdefined().
>
>and as another side note, whoever said to do a CFLOCATION after the
>CFCOOKIE is incorrect.  doing that sends a 302 "Resource Moved" header,
>so the pages never complete.  that'll prevent a cookie from being set.

Actually the page "completes" just fine, it's just that if a page has
a status header of 302 and a location var in the header then cookies
are supposed to be not sent and ignored by the browser. "Supposed to
be" being the operative phrase.

The older versions of Website Pro used to ignore this standard and
returned cookies just fine with a 302.

--min
__
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

another quick regular expression question

[Kola Oyedeji]

Hi

Can anyone explain why this regex does not match every title?(i'm using it
in cfstuido on a directory of html and cfml files)

<[ ]*title[ ]*>[ ]*[[:alpha:]]*[[:punct:]]*[ ]*

It will not match untitled for example what am I doing wrong?

Thanks in advance

Kola
__
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: The darndest time w/ Cookies. Actually form checking.

[Bryan Love]

how do you know it's not setting?

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may 
have
peace'..."
- Thomas Paine, The American Crisis



-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 11:23 AM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I am having the hardest time setting a cookie.  I think it is actually 
in
testing for the form field.  
 
Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie
 
Here is the code for setting the cookie.
 

 
 
 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 
 
The form field looks like this
 Remember Me
 
I have tried everything I can think of.   I have read 3 diferent 
examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes 
w/
cfstudio, and not on a real live server?  I know that some things do 
not
function properly on this version of the server software, but I don't 
know
which things.
 
Thanks
 
Chris Luksha
IS/Web Programmer
Helmers Publishing, Inc.
Publishers of
Desktop Engineering and
Supply Chain Systems Magazines
(603)924-9631 ext. 267
[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: is NOW() the time at the server, or time at the browser?

[Ben Forta]

Now() is server time. All CFML functions execute on the server, not the
client.

--- Ben


-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 6:54 PM
To: CF-Talk
Subject: is NOW() the time at the server, or time at the browser?


Thursday, January 31, 2002, 6:51:15 PM
Hello all,


I need to make an ifthen statement based on time. If it is before
6:00am, then go here, else go here.

But it needs to be the time at the server. If I use NOW(), what the heck
time is that?? Server time, or browser time?


   


Best regards,
 Jeff Fongemie  mailto:[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

is NOW() the time at the server, or time at the browser?

[Jeff Fongemie]

Thursday, January 31, 2002, 6:51:15 PM
Hello all,


I need to make an ifthen statement based on time. If it is before
6:00am, then go here, else go here.

But it needs to be the time at the server. If I use NOW(), what the
heck time is that?? Server time, or browser time?


   


Best regards,
 Jeff Fongemie  mailto:[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

Please help with output of Binaries

[Julia Green]

I set up an Access table with checkboxes and yes/no capacity.  My email
and resulting form work and produce Yeses and Nos next to the checkbox
subject with this code...

On Email List?  #IIf(isdefined("form.Vol_E"), DE('Yes'), DE('No'))#

But my problem is I set up a search form, whose code is beneath my
signature, and I have tried reich2a.Vol_E etc, and when I use the code
above, it produces all yesses even if some of the checkboxes are
unchecked.  Now I have results that when I add a record by a form, the
ones I check have a 0 next to them, and unchecked have nothing -- but
the old records (the ones I haven't added in the table), have 1 for yes
and 0 for no next to the checkbox out put.

Does this make sense?  Code for search.cfm and search2.cfm is below...
I am trying ideally to get output of yeses and nos, but 1s and 0s from
the ones I submit will do.

search2.cfm




  SELECT *
  FROM Email9d
  WHERE Firstname='#FORM.txtFirstName#' AND
Lastname='#FORM.txtLastName#' OR Phone='#FORM.Phone#'




Search Results for Submissions


SEARCH RESULTS FOR SUBMISSION



Timestamp: #Timestamp#

ID: #ID#

CODE: #CODE#

First Name:  #Firstname#

Last Name: #Lastname#

Home Telephone: #Phone#

Work Telephone: #WORK_PHONE#

Mobile Phone: #MOBILE_PHONE#

Misc Phone: #MISC_PHONE#

Home Address:
Address: #Address1# #Address2#

City/State/ZipCode: #City# #State# #Zip#

Work Address:
Address: #WORK_MAIL#

City/State/ZipCode: #WORK_CITY# #WORK_STATE# #WORK_ZIP#

Email: #Email#
Email2: #Email2#
Comments: #COMMENTS#
Occupation: #OCCUPATION#
Occupation: #AFFILIATION#
County Assigned: #CountyAssigned#

Additional Information:
On Email List?  #Vol_E#
Would like to Contribute Now:  #Vol_M#
Your Vote for Reich?: #Vol_V#
Would like to Contribute Sometime:  #Vol_T#
Reception or House Party:  #Vol_HP#
Arrange to Attend or Speak at an Event:  #Vol_S#
A Business that can offer resources?: #Vol_CORP#
Additional Information for Volunteering:
Political Organizing?:  #Exp_PolOrg#
Campus Organizing?:   #Exp_Student#
Expertise in Specific Issues?:   #Exp_Issues#
Computer Expertise?:   #Exp_Technology#
General Communications, Media:  #Exp_PR#
Fundraising, Development:   #Exp_FR#
Scheduling:   #Exp_Sched#









search.cfm



Search Engines for Submissions

SEARCH FOR SUBMISSION


Please enter supporter's first and last name, and home phone.

First Name:


Last Name:


Main Phone:







=
Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box 279, Watertown MA  02471-0279
Email:  [EMAIL PROTECTED]
http://www.juliagreen.com
Phone:  617-926-3413
Fax:  617-812-5935

__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
__
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

ANN: Macromedia Designer - Developer Portal goes live

[Matt Brown]

ANN: Macromedia Designer - Developer Portal goes live

Hey all. I wanted to announce the release of our Designer Developer Center 
on Macromedia.com. The DesDev center is the place where we are going to be 
posting all our articles and tips and tutorials and technotes and so on, 
both from Macromedia sources and from out in the community as well. This is 
our first release and as our content engines start to move and we collect 
more content to put on the site, we will be moving to weekly updates.

Come take a look at http://www.macromedia.com/desdev

There are two sides of the DesDev portal, one for Designers that highlights 
Dreamweaver and Flash and creating graphics and interfaces; the visual 
things that you do with our software. And there will be a Developer side 
that concentates on ColdFusion, JRun and UltraDev and the code and 
applications that you might build. You should look at both and browse 
through some of the articles.

I would even say that you might want to start with my column, Logged_In 
where I talk a little bit about extensions or John Dowdell's JD's Forum 
where he asks you questions about your perception of Flash security. Some 
of the other features are:

- Template Tips (Dreamweaver)
- Using Shared Libraries (Macromedia Flash)
- Creating a Simple Custom Object (Dreamweaver)
- Quick Tips Using Dreamweaver and Fireworks
- Extension Reviews (Macromedia Flash, Dreamweaver)
- ColdFusion Advanced Custom Tag Syntax (ColdFusion)
- Writing Maintainable Code (ColdFusion)
- What's So Great About User Defined Functions? (ColdFusion)
- Using Custom Functions Within Custom Tags (ColdFusion)
- Nuts & Bolts: About Objects (Flash Developer Helen Triola)
- Getting Started with JRun Server Tags (JRun)
- Using the Oracle Implementation of the Pooled Connection Interface
(JRun)
- Creating a Reusable Server Behavior (Dreamweaver UltraDev)
- How to Use JavaBeans in Dreamweaver UltraDev 4.0 (Dreamweaver
UltraDev)
- Extension Reviews (Dreamweaver UltraDev, ColdFusion)

Hope you enjoy it!

_

Matt Brown   Community Manager
Macromedia  (650) 481-4525   [EMAIL PROTECTED]

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: MSSQL and LIMIT

[Steve Oliver]

I've tried it with a cursor and a stored proc, but that returns 50
recordsets, not 50 rows in one recordset.

I'm guessing that there is no RowID() in MSSQL?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:48 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Well that's pretty cool - I've not seen that syntax. You could do this
wi
th
a Cursor and a stored proc of course.

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:37 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)


__
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: RTF editor to embed in webform

[Jill Robin Pascua]

Hi - 

Does anyone know of a product that's similar to the
HTML WYSIWYG editors that you can embed in a webform
but instead converts text into RTF?  

- JR

__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
__
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

ANN: Community Manager for ColdFusion Position

[Matt Brown]

Community Manager, ColdFusion
Job#: 1203HS
Location: San Francisco, CA

Applicants can send their resumes to mailto:[EMAIL PROTECTED] or apply 
via the web site at
.

Summary
The Community Manager is responsible for managing the community and
creating technical content on Macromedia.com. The community manager has
four functions: managing the leveraged community of Team Macromedia
evangelists, securing and funneling content for publication on the
Designer and Developer center on Macromedia.com, writing technical
content for publication on Macromedia.com, and performing evangelical
duties.

Responsibilities
 >  Build the community into a competitive advantage for Macromedia.
 > Identify, recruit, and manage a team of volunteer external evangelists
(Team Macromedia) to support Macromedia's community efforts in the
online forums.
 >  Work with the external evangelists to produce no less than 2
technical articles per month per evangelist.
 > Monitor Macromedia's product forums and interface with other
departments at Macromedia to ensure a consistent and high level of
service.
 > Write and produce no less than 2 technical articles per month.
 > Write and produce no less than 2 marketing/community articles per
month.
 > Support marketing and communications initiatives by leveraging
external evangelists, including arranging for Team Macromedia members to
speak at major industry events, attending local UG events, interfacing
with major customers in the field for the development of case studies.
 > Create and maintain relationships with leaders, experts, authors in
the ColdFusion community.
 > Perform evangelical duties such as monitoring and posting in forums,
speaking at events and user groups, Macromedia's user conferences, and
on an as-needed basis.
 > Create community initiatives such as contests, outreach efforts, event
participation to increase the level of activity of the Flash community.
 > Liaise with product groups to support marketing and business
initiatives and provide feedback on developer acceptance of new
technologies
 > Provide weekly statistics and reports that characterize the growth,
status, and dynamism of the community.
 > Gather, analyze and communicate information, strategies, messages, and
weaknesses about competitive and complementary products.
 > Recruit, manage, and administer Team Macromedia evangelists.
 > Content and technical edits of Team Macromedia submissions.
 > Report on activity in the community.
 > Coordinate with the other Community Managers.
 > Work with the developer relations management to establish tiered
programs for 3rd party evangelists.

Requirements
 > 4+ years experience in building applications using ColdFusion.
 > Technical proficiency in application-building technologies such as
ASP, JSP, and PHP.
 > Experience with building rich application user interfaces with
Macromedia Flash .
 > Excellent verbal and written communications skills, public speaking
experience preferred.
 > Working knowledge of Macromedia Software tools and servers.
 > Must have a passion for ColdFusion and a desire to build the
ColdFusion Community.
 > In-depth knowledge of web application development required.
 > Strong people management skills.
 > Ability to work in a team environment and create and foster strong
relationships.
 > Ability to learn new technologies quickly.

Ideal
 >  Current profile in the ColdFusion community a plus.
_

Matt Brown   Community Manager
Macromedia  (650) 481-4525   [EMAIL PROTECTED]

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: MSSQL and LIMIT

[Mark A. Kruger - CFG]

Well that's pretty cool - I've not seen that syntax. You could do this wi
th
a Cursor and a stored proc of course.

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:37 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)

__
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: MSSQL and LIMIT

[Steve Oliver]

Hmmm, that could work, but that's pretty sloppy when dups come to play,
I'm guessing that no one knows of a way to do it by row number?

In mysql I just put:
SELECT *
FROM table
LIMIT 2000, 2050

Why doesn't cfquery have a startrow attribute?


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:25 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)
__
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: MSSQL and LIMIT

[Mark A. Kruger - CFG]

Ok - then you need to track the name and the where clause becomes

WHERE  NAME > '#myStoredName#'

 this is a bit trickier because you could have duplicate names.  So you
might have to futz with your WHERE clause a bit (adding an OR condition
etc.)

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:13 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


That would work if I ordered by Identity, but I need it ordered by name.

If I order by Identity then get the top 50 the name order will be all
screwed up.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:09 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Steve,

You use the WHERE clause to drill.  For example, if you order by an
ident
ity
field, you could track the minimum and maximum value then where becomes

WHERE userid > #mySavedMaxId#

First time through it would be "> 0" (top 50), then the next time
through
 it
would  "> 50" (or some other number from that postion), next time
through
 it
would be " > 100" ... etc.

Mark

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:59 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Um, that would just retrieve rows 1 through 50, I need something like
rows 2000 through 2050

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:56 PM
To: CF-Talk
Subject: Re: MSSQL and LIMIT


SELECT TOP 50 column
FROM table

- Original Message -
From: Steve Oliver <[EMAIL PROTECTED]>
Date: Thursday, January 31, 2002 2:48 pm
Subject: MSSQL and LIMIT

> I am doing a query on a rather large table, lets say there are 2000
0
> rows, and I want to display them on a page, 50 rows at a time,

> startingfrom row 200.
>

> I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't


> seem to
> have anything like that.  I tried a stored procedure to use a curso
r,
> but that returns 50 recordsets, instead of 50 rows in one recordset
.
>

> The way I see it done time and time again is to retrieve all records
> with cfquery, then limit the output with cfoutput's startrow and
> maxrows, or cfloop's startrow and endrow.
>

> But that would cause the entire query to be retrieved each and
> everytime, which seems just plain stupid to me.
>

> The database is updated regularly, so cacheing isn't an option.

>

> Does anyone else have a better way to do this?
>

> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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?sideb
ar=lists
>




__
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: MSSQL and LIMIT

[Steve Oliver]

That would work if I ordered by Identity, but I need it ordered by name.

If I order by Identity then get the top 50 the name order will be all
screwed up.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 7:09 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Steve,

You use the WHERE clause to drill.  For example, if you order by an
ident
ity
field, you could track the minimum and maximum value then where becomes

WHERE userid > #mySavedMaxId#

First time through it would be "> 0" (top 50), then the next time
through
 it
would  "> 50" (or some other number from that postion), next time
through
 it
would be " > 100" ... etc.

Mark

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:59 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Um, that would just retrieve rows 1 through 50, I need something like
rows 2000 through 2050

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:56 PM
To: CF-Talk
Subject: Re: MSSQL and LIMIT


SELECT TOP 50 column
FROM table

- Original Message -
From: Steve Oliver <[EMAIL PROTECTED]>
Date: Thursday, January 31, 2002 2:48 pm
Subject: MSSQL and LIMIT

> I am doing a query on a rather large table, lets say there are 2000
0
> rows, and I want to display them on a page, 50 rows at a time,

> startingfrom row 200.
>

> I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't


> seem to
> have anything like that.  I tried a stored procedure to use a curso
r,
> but that returns 50 recordsets, instead of 50 rows in one recordset
.
>

> The way I see it done time and time again is to retrieve all records
> with cfquery, then limit the output with cfoutput's startrow and
> maxrows, or cfloop's startrow and endrow.
>

> But that would cause the entire query to be retrieved each and
> everytime, which seems just plain stupid to me.
>

> The database is updated regularly, so cacheing isn't an option.

>

> Does anyone else have a better way to do this?
>

> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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?sideb
ar=lists
>



__
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: isnumeric trouble

[Michael Ross]

Thank you,

¯--
Kicking selfs ass so that I start paying attention more

¯---
thanks a lot..


>>> [EMAIL PROTECTED] 01/31/02 04:54PM >>>
I am shooting in the dark here .. could the ' quotes around it be giv
ing you
fits?

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com 
SiteDirector - Commerce Builder



> This is frustrating.  I am checking to make sure a value is numeric
  when
I use NOt isnumeric it runs through the query and it accepts letters.
  If I
take it away it won't go through the query.  Almost like its backward
s.
Plus it thinks of numbers and letters are the same.  Am I doing somet
hing
wrong?
>
> 
> 
> 
> 
> 
> 
> DELETE
> FROM tblshopping_cart
> WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#
> 
> UPDATE tblshopping_cart
> SET QUANTITY_S = '#LISTGETAT(Q, variables.STEP)#'
> WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#
> 
> 
> 
> 
> 
> 
> 
> 
_
_
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
 

__
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: MSSQL and LIMIT

[Mark A. Kruger - CFG]

Steve,

You use the WHERE clause to drill.  For example, if you order by an ident
ity
field, you could track the minimum and maximum value then where becomes

WHERE userid > #mySavedMaxId#

First time through it would be "> 0" (top 50), then the next time through
 it
would  "> 50" (or some other number from that postion), next time through
 it
would be " > 100" ... etc.

Mark

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:59 PM
To: CF-Talk
Subject: RE: MSSQL and LIMIT


Um, that would just retrieve rows 1 through 50, I need something like
rows 2000 through 2050

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:56 PM
To: CF-Talk
Subject: Re: MSSQL and LIMIT


SELECT TOP 50 column
FROM table

- Original Message -
From: Steve Oliver <[EMAIL PROTECTED]>
Date: Thursday, January 31, 2002 2:48 pm
Subject: MSSQL and LIMIT

> I am doing a query on a rather large table, lets say there are 2000
0
> rows, and I want to display them on a page, 50 rows at a time,

> startingfrom row 200.
>

> I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't


> seem to
> have anything like that.  I tried a stored procedure to use a curso
r,
> but that returns 50 recordsets, instead of 50 rows in one recordset
.
>

> The way I see it done time and time again is to retrieve all records
> with cfquery, then limit the output with cfoutput's startrow and
> maxrows, or cfloop's startrow and endrow.
>

> But that would cause the entire query to be retrieved each and
> everytime, which seems just plain stupid to me.
>

> The database is updated regularly, so cacheing isn't an option.

>

> Does anyone else have a better way to do this?
>

> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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?sideb
ar=lists
>


__
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: MSSQL and LIMIT

[Steve Oliver]

Um, that would just retrieve rows 1 through 50, I need something like
rows 2000 through 2050

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 4:56 PM
To: CF-Talk
Subject: Re: MSSQL and LIMIT


SELECT TOP 50 column
FROM table

- Original Message -
From: Steve Oliver <[EMAIL PROTECTED]>
Date: Thursday, January 31, 2002 2:48 pm
Subject: MSSQL and LIMIT

> I am doing a query on a rather large table, lets say there are 2000
0
> rows, and I want to display them on a page, 50 rows at a time, 

> startingfrom row 200.
> 

> I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't
 

> seem to
> have anything like that.  I tried a stored procedure to use a curso
r,
> but that returns 50 recordsets, instead of 50 rows in one recordset
.
> 

> The way I see it done time and time again is to retrieve all records
> with cfquery, then limit the output with cfoutput's startrow and
> maxrows, or cfloop's startrow and endrow.
> 

> But that would cause the entire query to be retrieved each and
> everytime, which seems just plain stupid to me.
> 

> The database is updated regularly, so cacheing isn't an option.

> 

> Does anyone else have a better way to do this?
> 

> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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?sideb
ar=lists
> 

__
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: MSSQL and LIMIT

[Mark A. Kruger - CFG]

Have you experimented with the TOP keyword?  AS in

SELECT TOP 50 name,address,phone,
FROMTheTable
WHERE   ..

-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:48 PM
To: CF-Talk
Subject: MSSQL and LIMIT


I am doing a query on a rather large table, lets say there are 2
rows, and I want to display them on a page, 50 rows at a time, starting
from row 200.

I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't seem to
have anything like that.  I tried a stored procedure to use a cursor,
but that returns 50 recordsets, instead of 50 rows in one recordset.

The way I see it done time and time again is to retrieve all records
with cfquery, then limit the output with cfoutput's startrow and
maxrows, or cfloop's startrow and endrow.

But that would cause the entire query to be retrieved each and
everytime, which seems just plain stupid to me.

The database is updated regularly, so cacheing isn't an option.

Does anyone else have a better way to do this?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: MSSQL and LIMIT

[ksuh]

SELECT TOP 50 column
FROM table

- Original Message -
From: Steve Oliver <[EMAIL PROTECTED]>
Date: Thursday, January 31, 2002 2:48 pm
Subject: MSSQL and LIMIT

> I am doing a query on a rather large table, lets say there are 2000
0
> rows, and I want to display them on a page, 50 rows at a time, 

> startingfrom row 200.
> 

> I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't
 

> seem to
> have anything like that.  I tried a stored procedure to use a curso
r,
> but that returns 50 recordsets, instead of 50 rows in one recordset
.
> 

> The way I see it done time and time again is to retrieve all records
> with cfquery, then limit the output with cfoutput's startrow and
> maxrows, or cfloop's startrow and endrow.
> 

> But that would cause the entire query to be retrieved each and
> everytime, which seems just plain stupid to me.
> 

> The database is updated regularly, so cacheing isn't an option.

> 

> Does anyone else have a better way to do this?
> 

> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.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?sideb
ar=lists
> 
__
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: isnumeric trouble

[Paul Giesenhagen]

I am shooting in the dark here .. could the ' quotes around it be giving you
fits?

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder



> This is frustrating.  I am checking to make sure a value is numeric.  when
I use NOt isnumeric it runs through the query and it accepts letters.  If I
take it away it won't go through the query.  Almost like its backwards.
Plus it thinks of numbers and letters are the same.  Am I doing something
wrong?
>
> 
> 
> 
> 
> 
> 
> DELETE
> FROM tblshopping_cart
> WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#
> 
> UPDATE tblshopping_cart
> SET QUANTITY_S = '#LISTGETAT(Q, variables.STEP)#'
> WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#
> 
> 
> 
> 
> 
> 
> 
> 
__
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: isnumeric trouble

[Christopher Olive]

remove the single quotes.  you're checking to see if the string "T" is
numeric.

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:49 PM
To: CF-Talk
Subject: isnumeric trouble


This is frustrating.  I am checking to make sure a value is numeric.
when I use NOt isnumeric it runs through the query and it accepts
letters.  If I take it away it won't go through the query.  Almost like
its backwards.  Plus it thinks of numbers and letters are the same.  Am
I doing something wrong?







DELETE
FROM tblshopping_cart
WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#

UPDATE tblshopping_cart
SET QUANTITY_S = '#LISTGETAT(Q,
variables.STEP)#'
WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#








__
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

isnumeric trouble

[Michael Ross]

This is frustrating.  I am checking to make sure a value is numeric.  when I use NOt 
isnumeric it runs through the query and it accepts letters.  If I take it away it 
won't go through the query.  Almost like its backwards.  Plus it thinks of numbers and 
letters are the same.  Am I doing something wrong?







DELETE
FROM tblshopping_cart
WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#

UPDATE tblshopping_cart
SET QUANTITY_S = '#LISTGETAT(Q, variables.STEP)#'
WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX#







__
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: Session Swapping" incident

[Dimo Michailov]

Chris:

I just stumbled upon your thread about "identities" sharing. We have 
*EXACTLY* the same problem here, we run a CF-based forum application for 
  maybe 1000-2000 users that are usually within the same company network 
and we have occasionally reports for mixed identities. Usually they 
happen when people post a message to a thread - they click "POST", it is 
stored correctly in the DB but as soon as the next page loads they seem 
to be a different user that is using the system as the same time.

We have all the things you mentioned in place - session variables 
strictly locked, etc. but never figured it out. Of course, the incidence 
of these problems is not that high and the priority is still relatively low.

What makes you think that proxies/firewalls are the reason this might be 
happening? Can you share more information on what you've discovered so far?


Let me know if I can help with something in resolving this.

Thanks,
Dimo

Chris Bohill wrote:

> Thanks to everyone who gave their views and advice regarding this 
> problem I posted yesterday. The more we investigate, the more we feel 
> that is down to the proxy settings of the problem users below. 
> 
> Has anyone else had bad experiences with proxies/firewalls and session 
> variables swapping?
> 
> Thanks again
> 
> Chris.
> 
> -Original Message-
> From: Chris Bohill 
> Sent: 28 January 2002 15:04
> To: CF-Talk
> Subject: Session Swapping" incident
> 
> 
> We are developing an web based application, and have recently been 
> experiencing a number of "Session swapping" incidents. On two occasions 
> a user has been navigating the system, only to "Swap" sessions with 
> another user, who (we are not 100% sure) may also be viewing the site at 
> 
> the same time. 
> 
> Because a lot of the site is user-profile based, the user can tell 
> straight away that they have "Swapped". The user in question returned to 
> 
> the welcome page, but another users name and details were there. This 
> other user was in the same building but different floors, so they may 
> have been on the same network.
> 
> For this to happen is pretty awkward, as much of the data is of a 
> sensitive nature, but we feel we have done as much as we can to reduce 
> the chance of this happening.
> 
> We have locked all session variables and only refer to them as local 
> variables on pages that need them. see below:
> 
> 
> 
> 
> 
> 
> When writing to a Session Variable we again use cflock, with type set to 
> 
> "Exclusive".
> 
> All Session variables are locked when created on the Application page, 
> and are set to "Exclusive".
> 
> When the user logs out of the system we use the following code to kill 
> all the session variables:
> 
>  scope="SESSION">
>   
>   
> 
> 
> StructDelete(Session, "VarOne");
> StructDelete(Session, "VarTwo");
> StructClear(Session);
> 
> 
> 
> Are there known issues with session variables or is there something 
> vital that we are missing? 
> Is there something we should be doing on the Administrator to protect 
> "session swapping"? 
> 
> For this to happen, even once is not acceptable to our client, so it is 
> essential that we resolve this issue. Speed is an important issue with 
> this application so using single thread sessions would not be a 
> straightforward solution for us.
> 
> Any responses would be greatly appreciated.
> 
> 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

MSSQL and LIMIT

[Steve Oliver]

I am doing a query on a rather large table, lets say there are 2
rows, and I want to display them on a page, 50 rows at a time, starting
from row 200.

I know in MySQL I can just do a Limit 200,50. But MSSQL doesn't seem to
have anything like that.  I tried a stored procedure to use a cursor,
but that returns 50 recordsets, instead of 50 rows in one recordset.

The way I see it done time and time again is to retrieve all records
with cfquery, then limit the output with cfoutput's startrow and
maxrows, or cfloop's startrow and endrow.

But that would cause the entire query to be retrieved each and
everytime, which seems just plain stupid to me.

The database is updated regularly, so cacheing isn't an option.

Does anyone else have a better way to do this?

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.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: The darndest time w/ Cookies. Actually form checking.

[Christopher Olive]

whoops.  i suppose that "not" he had in there would throw off my
correction.

sorry to all involved.

(stupid illiteracy...)

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:16 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


Did anyone say that?



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:03 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


actually, parameterexists() is deprecated in favor of isdefined().

and as another side note, whoever said to do a CFLOCATION after the
CFCOOKIE is incorrect.  doing that sends a 302 "Resource Moved" header,
so the pages never complete.  that'll prevent a cookie from being set.

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:54 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


Chris,

I'm not quite sure what error you are having (am I missing
something from
the post???)...but if the problem is with the JavaScript alert not
coming
up, try using ParameterExists(...) rather than IsDefined(...).

HTH,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't
seen
the first posting in over an hour and I got a bounceback message from
the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually
in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent
examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes
w/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't
know
which things.

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: CF and ADA Priority 1

[Dimo Michailov]

Micheal:

The JavaScript popup windows are not ADA Priority 1 Compliant (from 
Section 508). The reason why they are not compliant is that the screen 
reader (which some blind people for instance would use) cannot read 
these popups. I would show this information on a different page instead 
where the reader can translate it.

Hope this helps,
Dimo

Tangorre, Michael T. wrote:

> I have a bunch of CF code I need to make ADA Priority 1 Compliant, are JAVA
> Popups compliant? ANyone know a workaround if not?
> 
> Thanks,
> 
> 
__
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: The darndest time w/ Cookies. Actually form checking.

[Kreig Zimmerman]

As an aside...

..if the application design causes you to be unable to stop doing a
CFLOCATION after the CFCOOKIE, you can always send a CFHEADER to do the page
refresh to the CFLOCATION URL (same thing as including a meta refresh tag,
only more likely to work); or embed a Javascript, such as
location.href='wherever.html', instead in the page (not in a function, but
as flat JS).

Just wanted to make you aware of the quick-fix options!

__
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: executing a dts...

[Simon Horwith]

you need to install enterprise manager on the machine running CF. 
and
have network access and proper permissions on the machine running SQL 
Server
in order to make the CF Comet code work.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion 5 Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 4:23 PM
To: CF-Talk
Subject: executing a dts...


 I'm trying to get a dts to run on my sql server 7 box. I use the 
example
from cfcomet, however since I actually have my sql server on a seperate
machine, how can I access the com object? I'm just lost...

Marcus


__
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: Get a random record, but not too random?

[Steve Oliver]

You are adding an additional step in the query.

 
SELECT *
FROM coverpics
WHERE coverid = #Randomset#


All I can think of with lists is to set a session variable of the last
Randomset, then use ListFind and ListDeleteAt to remove that number from
the list, before you get your randomset variable.

An array would probably be easier for that though.


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 31, 2002 3:40 PM
To: CF-Talk
Subject: Get a random record, but not too random?


Thursday, January 31, 2002, 3:32:59 PM
Hello cf-talk,

  I've got a layout that displays a random set of images on each page.

  I have one to many DB setup, with image sets, and images
  respectively. I first find a random set, then get the images for
  that set. It works like this:


SELECT coverid
FROM coverpicsets






 
SELECT *
FROM coverpics
WHERE coverid=(SELECT *
   FROM coverpicsets
   WHERE coverid = #Randomset#)


#one# #two# #three# #four#



What I'm trying to do is have the random set, choose a set, but
exclude set that was used on the previous page. I've tried setting the
"randomset" as a parameter, and using it in an cfif statement, as in
cfif randomset exists, then run the query exluding that random set, if
not then just run the normal above query. However, it
is not keeping random set from page to page.

Am I going about this is the right way?


Best regards,
 Jeff Fongemie  mailto:[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

executing a dts...

[Marcus]

 I'm trying to get a dts to run on my sql server 7 box. I use the example
from cfcomet, however since I actually have my sql server on a seperate
machine, how can I access the com object? I'm just lost...

Marcus

__
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: The darndest time w/ Cookies. Actually form checking.

[David Schmidt]

Did anyone say that?



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 1:03 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


actually, parameterexists() is deprecated in favor of isdefined().

and as another side note, whoever said to do a CFLOCATION after the
CFCOOKIE is incorrect.  doing that sends a 302 "Resource Moved" header,
so the pages never complete.  that'll prevent a cookie from being set.

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:54 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


Chris,

I'm not quite sure what error you are having (am I missing
something from
the post???)...but if the problem is with the JavaScript alert not
coming
up, try using ParameterExists(...) rather than IsDefined(...).

HTH,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't
seen
the first posting in over an hour and I got a bounceback message from
the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually
in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent
examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes
w/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't
know
which things.

Thanks




__
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

anyone using myODBC 3.51?

[Matt Robertson]

Is anyone using the newly released mySQL myODBC drivers?  Any 
comments/good/bad experiences if so?  I've got it running on a dev 
server, but thats it.

--Matt--

__
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: The darndest time w/ Cookies. Actually form checking.

[Paul Giesenhagen]

I do this alot:



and then refresh them elsewhere:


you can set content=".1" for pretty fast refresh rate.

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder


> It wouls seem the cflocation could be the key here.  What is my way
> around
> this?
> I remember somewhere there being a way to send user to another page via
> javascript.  Anyone remember this?  Can I pass the session.sendmeto
> variable
> I created?
>
> Here is the full code for that section
>
>
> 
> 
> 
>
> 
> 
>  EXPIRES="NEVER">
> 
>
> 
> 
> 
> 
> 
> 
> 
> 
>  url="#getfilefrompath(getbasetemplatepath())#?message=#urlencodedfor
> mat(mess
> age)#" ADDTOKEN="no">
> 
>
>
>
> -Original Message-
> From: David Schmidt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 3:55 PM
> To: CF-Talk
> Subject: RE: The darndest time w/ Cookies. Actually form checking.
> Importance: High
>
>
> Chris,
>
> Make sure you do not do any cflocation's after you set your cookie.
> This
>  is
> a pretty common mistake, particulary with authentication routines.
> Cooki
> es
> are only set when the browser receives the completed page.
>
> David Schmidt
>
>
> -Original Message-
> From: Chris Luksha [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 12:39 PM
> To: CF-Talk
> Subject: The darndest time w/ Cookies. Actually form checking.
>
>
> I apologize if this ends up getting posted a couple times.   I haven't
> se
> en
> the first posting in over an hour and I got a bounceback message from
> the
> second attempt.  So here is the third...
>
> I am having the hardest time setting a cookie.  I think it is actually
> in
> testing for the form field.
>
> Simple login application.
> -User comes to page
> -gets authorized
> -If "remember me" is checked, set a cookie
>
> Here is the code for setting the cookie.
>
> 
>  
>
>  
>  
>   alert("Hey set a cookie will you!")
>For testing of course
>  
>  
>
> The form field looks like this
>  face="Tahoma"> Remember Me
>
> I have tried everything I can think of.   I have read 3 diferent
> examples
>  of
> this exact thing.  Could it be that I am using the cf4.5 svr that comes
> w
> /
> cfstudio, and not on a real live server?  I know that some things do
> not
> function properly on this version of the server software, but I don't
> kno
> w
> which things.
>
> 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: scripting windows 2000 dns

[Bernd VanSkiver]

I had thought about writing the files with CF instead of using the scripting
object, but to me there seems like less of a chance of something going wrong
with using the WMI instead of writing the files (hopefully correct), editing
the registry and then restarting the service.  With the script object all of
this gets done for me, don't think the DNS service even needs to get reset.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 2:37 PM
Subject: Re: scripting windows 2000 dns


> In addition to cfexecute, you could just use cfobject to interact with the
> DNS provider object. I can't say it would be easy though. You are going to
> have to rely on the docs if you don't know vbs pretty well. I know a
little,
> but that code is nasty :)
>
> The other possibility if you need to use CF, is just to figure out how to
> recreate the zone files in CF, write them out, create the registry
entries,
> then restart the DNS server. The zone files themselves are just plain
> text...
>
> jon
> - Original Message -
> From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 2:35 PM
> Subject: scripting windows 2000 dns
>
>
> > I am trying to use WMI to manage DNS entries in a Windows 2000 DNS
server.
> > I have some VBS files that I can do this with from the command prompt,
but
> > am not sure how to run them with ColdFusion.  Here is a link to the
> article
> > I am looking at for instructions on how to accomplish this task:
> > http://www.iisfaq.com/Articles/319/.  Just trying to automatially
create,
> > modify, and delete dns entries with ColdFusion, if anyone knows of a
> better
> > way to do this then using the VBS files I mentioned then please let me
> know.
> >
> > Bernd VanSkiver
> > [EMAIL PROTECTED]
> > ColdFusion Developer
> >
> 
__
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: The darndest time w/ Cookies. Actually form checking.

[Christopher Olive]

actually, parameterexists() is deprecated in favor of isdefined().

and as another side note, whoever said to do a CFLOCATION after the
CFCOOKIE is incorrect.  doing that sends a 302 "Resource Moved" header,
so the pages never complete.  that'll prevent a cookie from being set.

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:54 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.


Chris,

I'm not quite sure what error you are having (am I missing
something from
the post???)...but if the problem is with the JavaScript alert not
coming
up, try using ParameterExists(...) rather than IsDefined(...).

HTH,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't
seen
the first posting in over an hour and I got a bounceback message from
the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually
in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent
examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes
w/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't
know
which things.

Thanks



__
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: The darndest time w/ Cookies. Actually form checking.

[Chris Luksha]

It wouls seem the cflocation could be the key here.  What is my way 
around
this?
I remember somewhere there being a way to send user to another page via
javascript.  Anyone remember this?  Can I pass the session.sendmeto 
variable
I created?

Here is the full code for that section
























-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:55 PM
To: CF-Talk
Subject: RE: The darndest time w/ Cookies. Actually form checking.
Importance: High


Chris,

Make sure you do not do any cflocation's after you set your cookie.  
This
 is
a pretty common mistake, particulary with authentication routines.  
Cooki
es
are only set when the browser receives the completed page.

David Schmidt


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 12:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't 
se
en
the first posting in over an hour and I got a bounceback message from 
the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually 
in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent 
examples
 of
this exact thing.  Could it be that I am using the cf4.5 svr that comes 
w
/
cfstudio, and not on a real live server?  I know that some things do 
not
function properly on this version of the server software, but I don't 
kno
w
which things.

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: Get a random record, but not too random?

[Valerie L. Criswell]

I forgot to mention that you'll want to use an application var to store that
ID so that it persists for you.

~Val

- Original Message -
From: "Jeff Fongemie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 3:40 PM
Subject: Get a random record, but not too random?


> Thursday, January 31, 2002, 3:32:59 PM
> Hello cf-talk,
>
>   I've got a layout that displays a random set of images on each page.
>
>   I have one to many DB setup, with image sets, and images
>   respectively. I first find a random set, then get the images for
>   that set. It works like this:
>
> 
> SELECT coverid
> FROM coverpicsets
> 
>
> 
> 
> 
>
> 
> SELECT *
> FROM coverpics
> WHERE coverid=(SELECT *
>FROM coverpicsets
>WHERE coverid = #Randomset#)
> 
>
> #one# #two# #three# #four#
>
>
>
> What I'm trying to do is have the random set, choose a set, but
> exclude set that was used on the previous page. I've tried setting the
> "randomset" as a parameter, and using it in an cfif statement, as in
> cfif randomset exists, then run the query exluding that random set, if
> not then just run the normal above query. However, it
> is not keeping random set from page to page.
>
> Am I going about this is the right way?
>
>
> Best regards,
>  Jeff Fongemie  mailto:[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: The darndest time w/ Cookies. Actually form checking.

[David Grabbe]

Chris,

I'm not quite sure what error you are having (am I missing something from
the post???)...but if the problem is with the JavaScript alert not coming
up, try using ParameterExists(...) rather than IsDefined(...).

HTH,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't seen
the first posting in over an hour and I got a bounceback message from the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes w/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't know
which things.

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: The darndest time w/ Cookies. Actually form checking.

[Andrew Tyrone]

> -Original Message-
> From: Chris Luksha [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 3:39 PM
> To: CF-Talk
>
> Subject: The darndest time w/ Cookies. Actually form checking.
> I am having the hardest time setting a cookie.  I think it is actually in
> testing for the form field.
>
> Simple login application.
> -User comes to page
> -gets authorized
> -If "remember me" is checked, set a cookie
>
> Here is the code for setting the cookie.
>
> 
>  
>
>  
>  
>   alert("Hey set a cookie will you!")
>For testing of course
>  
>  
>
> The form field looks like this
>  face="Tahoma"> Remember Me

The problem here looks to be this line:



You can fix this a few different ways:


...


(this is called short-circuit evaluation; the second condition in the cfif
will only be checked if the form variable is defined)

OR (my personal perference)









Andy
__
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: Get a random record, but not too random?

[Valerie L. Criswell]

What if you write the ID of the previous set into a variable, then either
deny that set from within the next query, or simply test to see if it picked
the same one and if so, redo the query until it retrieves a set that does
not match the previous.  Does that make sense?  Did I understand the
question?

HTH!

~Val

- Original Message -
From: "Jeff Fongemie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 3:40 PM
Subject: Get a random record, but not too random?


> Thursday, January 31, 2002, 3:32:59 PM
> Hello cf-talk,
>
>   I've got a layout that displays a random set of images on each page.
>
>   I have one to many DB setup, with image sets, and images
>   respectively. I first find a random set, then get the images for
>   that set. It works like this:
>
> 
> SELECT coverid
> FROM coverpicsets
> 
>
> 
> 
> 
>
> 
> SELECT *
> FROM coverpics
> WHERE coverid=(SELECT *
>FROM coverpicsets
>WHERE coverid = #Randomset#)
> 
>
> #one# #two# #three# #four#
>
>
>
> What I'm trying to do is have the random set, choose a set, but
> exclude set that was used on the previous page. I've tried setting the
> "randomset" as a parameter, and using it in an cfif statement, as in
> cfif randomset exists, then run the query exluding that random set, if
> not then just run the normal above query. However, it
> is not keeping random set from page to page.
>
> Am I going about this is the right way?
>
>
> Best regards,
>  Jeff Fongemie  mailto:[EMAIL PROTECTED]
> 
__
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: The darndest time w/ Cookies. Actually form checking.

[David Schmidt]

Chris,

Make sure you do not do any cflocation's after you set your cookie.  This
 is
a pretty common mistake, particulary with authentication routines.  Cooki
es
are only set when the browser receives the completed page.

David Schmidt


-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 12:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.


I apologize if this ends up getting posted a couple times.   I haven't se
en
the first posting in over an hour and I got a bounceback message from the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually in
testing for the form field.

Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie

Here is the code for setting the cookie.


 

 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 

The form field looks like this
 Remember Me

I have tried everything I can think of.   I have read 3 diferent examples
 of
this exact thing.  Could it be that I am using the cf4.5 svr that comes w
/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't kno
w
which things.

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: CFPARAM Question

[Cantrell, Adam]

> Is there a way to duplicate my intended behavior another way?

Yes, don't use cfparam in the second instance, use a condition.





That will, in essence, param the variable to "boo" if the variable hadn't
been touched since the initial param.



> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 31, 2002 10:06 AM
> To: CF-Talk
> Subject: CFPARAM Question
> 
> 
> Do subsequent CFPARAMS of the same variable overwrite each other? I
> thought so, but they don't seem to.
> 
> 
> 
> .. later ...
> 
> 
> 
> If I check for foo it's still "bar" instead of "boo"...
> 
> Is there a way to duplicate my intended behavior another way?
> 
> Tony Schreiber, Senior Partner  Man and 
> Machine, Limited
> mailto:[EMAIL PROTECTED]   
> http://www.technocraft.com
> 
> http://www.simplemessageboard.com ___Free Forum Software for 
> Cold Fusion
> http://www.is300.net ___The Enthusiast's Home of the 
> Lexus IS300
> http://www.digitacamera.com __DigitA Camera 
> Scripts and Tips
> http://www.linklabexchange.com _Miata Link ECU 
> Data Exchange
> 
__
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

The darndest time w/ Cookies. Actually form checking.

[Chris Luksha]

I apologize if this ends up getting posted a couple times.   I haven't seen
the first posting in over an hour and I got a bounceback message from the
second attempt.  So here is the third...

I am having the hardest time setting a cookie.  I think it is actually in
testing for the form field.  
 
Simple login application.
-User comes to page
-gets authorized
-If "remember me" is checked, set a cookie
 
Here is the code for setting the cookie.
 

 
 
 
 
  alert("Hey set a cookie will you!")
   For testing of course
 
 
 
The form field looks like this
 Remember Me
 
I have tried everything I can think of.   I have read 3 diferent examples of
this exact thing.  Could it be that I am using the cf4.5 svr that comes w/
cfstudio, and not on a real live server?  I know that some things do not
function properly on this version of the server software, but I don't know
which things.
 
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

Get a random record, but not too random?

[Jeff Fongemie]

Thursday, January 31, 2002, 3:32:59 PM
Hello cf-talk,

  I've got a layout that displays a random set of images on each page.

  I have one to many DB setup, with image sets, and images
  respectively. I first find a random set, then get the images for
  that set. It works like this:


SELECT coverid
FROM coverpicsets






 
SELECT *
FROM coverpics
WHERE coverid=(SELECT *
   FROM coverpicsets
   WHERE coverid = #Randomset#)


#one# #two# #three# #four#



What I'm trying to do is have the random set, choose a set, but
exclude set that was used on the previous page. I've tried setting the
"randomset" as a parameter, and using it in an cfif statement, as in
cfif randomset exists, then run the query exluding that random set, if
not then just run the normal above query. However, it
is not keeping random set from page to page.

Am I going about this is the right way?


Best regards,
 Jeff Fongemie  mailto:[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: scripting windows 2000 dns

[Jon Hall]

In addition to cfexecute, you could just use cfobject to interact with the
DNS provider object. I can't say it would be easy though. You are going to
have to rely on the docs if you don't know vbs pretty well. I know a little,
but that code is nasty :)

The other possibility if you need to use CF, is just to figure out how to
recreate the zone files in CF, write them out, create the registry entries,
then restart the DNS server. The zone files themselves are just plain
text...

jon
- Original Message -
From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 2:35 PM
Subject: scripting windows 2000 dns


> I am trying to use WMI to manage DNS entries in a Windows 2000 DNS server.
> I have some VBS files that I can do this with from the command prompt, but
> am not sure how to run them with ColdFusion.  Here is a link to the
article
> I am looking at for instructions on how to accomplish this task:
> http://www.iisfaq.com/Articles/319/.  Just trying to automatially create,
> modify, and delete dns entries with ColdFusion, if anyone knows of a
better
> way to do this then using the VBS files I mentioned then please let me
know.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> 
__
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: scripting windows 2000 dns

[Bernd VanSkiver]

That is exactly what I needed to do...thanx.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 1:55 PM
Subject: RE: scripting windows 2000 dns


> > I am trying to use WMI to manage DNS entries in a Windows
> > 2000 DNS server. I have some VBS files that I can do this
> > with from the command prompt, but am not sure how to run
> > them with ColdFusion. Here is a link to the article I am
> > looking at for instructions on how to accomplish this task:
> > http://www.iisfaq.com/Articles/319/. Just trying to
> > automatially create, modify, and delete dns entries with
> > ColdFusion, if anyone knows of a better way to do this
> > then using the VBS files I mentioned then please let me
> > know.
>
> In the examples, the VBScript files are called using cscript.exe, which is
> the command-line Windows Script Host interface. You should be able to
invoke
> those command-line calls using CFEXECUTE. Since the scripts accept
username
> and password attributes, you shouldn't have any problems running them,
since
> the scripts will use that authentication information instead of the CF
> Service's authentication information.
>
> 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: CF Studio 5.0 and net shares

[Dave Watts]

> I'm using Studio 5.0 for the first time over a DSL powered 
> VPN. For the most part, it works fine.  
> 
> It does have one annoying side effect. Whenever I blur then 
> refocus Studio, the file resource tab (a shared network 
> directory) refreshes. It takes a few minutes to read perhaps 
> a directory of 40-50 files. In the meantime, Studio can't be 
> used. I don't know why it's so sluggish. Running dir from
> a command prompt (Windows 2000) takes just a second or two 
> in comparison.
> 
> Is RDS the way to fix this? How about an app that handles 
> this better, perhaps textpad?

In general, browsing files from a command prompt is going to be faster than
any GUI. However, you might be able to speed up CF Studio. There's an option
in the General portion of the Settings dialog labeled "Dynamically refresh
local file list". Clear that checkbox, and see if that makes a difference.

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: CFPARAM Question

[Mark A. Kruger - CFG]

CF Param is working as it's supposed to.  CFPARAM encapsulates the follow
ing
logic:


Your first cfparam does this

IF ( NOT IsDefined('foo') ) {   foo  = bar; }

Your second one does this.

IF ( NOT IsDefined('foo') ) {   foo  = boo; }


The first one executes and defines foo and assigns it the value "bar".


The second IF does trigger because Foo IS defined. You use cfparam to
either predifine a varialble to avoid a page error (as in when you are
populating form
fields with their own submitted values) and/or to set a default value in 
the
case where
a variable has not yet been assigned.

Mark


-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:06 AM
To: CF-Talk
Subject: CFPARAM Question


Do subsequent CFPARAMS of the same variable overwrite each other? I
thought so, but they don't seem to.



. later ...



If I check for foo it's still "bar" instead of "boo"...

Is there a way to duplicate my intended behavior another way?

Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange

__
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