Re: ColdFusion, IIS and Virtual Directories
Make sure IUSR_ has the necessary privileges within the physical directory that the IIS virtual directory points to. If it contains only static content such as html or graphics, I believe Read permission is all you need. Jim - Original Message - From: "John Kivus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 8:57 PM Subject: ColdFusion, IIS and Virtual Directories > I recently started administering a ColdFusion Server with Windows 2000 > Advanced Server using IIS to deliver webpages, after being primarily a > developer for the past couple of years. I am having a real problem > working with virtual directories due to IIS and Windows 2000 security > features working so closely together. I can run CFM pages from websites > I set-up as long as there are no virtual directories, but when I set-up > a virtual directory to another place on the server, I get a password > prompt on any CF page I try, but on none of the other pages (htm and > css, etc...). Any ideas? > > - John Kivus __ 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
ColdFusion, IIS and Virtual Directories
I recently started administering a ColdFusion Server with Windows 2000 Advanced Server using IIS to deliver webpages, after being primarily a developer for the past couple of years. I am having a real problem working with virtual directories due to IIS and Windows 2000 security features working so closely together. I can run CFM pages from websites I set-up as long as there are no virtual directories, but when I set-up a virtual directory to another place on the server, I get a password prompt on any CF page I try, but on none of the other pages (htm and css, etc...). Any ideas? - John Kivus 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: Developers Exchange... How *could* they!?
At least they haven't made the site compatible with Netscape 6 yet, so you could load the site in NS6 and then go on a magnifying glass hunting expedition :) jon Matt Robertson wrote: > For two days now I've been doing searches on the Developers Exchange and > getting regular one- to two-second responses. I just searched for > ''ColdFusion'' and got back 374 results in just under 3 seconds. > > I'm shocked and outraged. I no longer have the time to go to the water > cooler, doze off or chat with the ladies in the next office while > waiting for search results. This has completely fouled up my workflow. > > How could Macromedia do this to all of their loyal CF developers, and me > in particular??? > __ 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: Developers Exchange... How *could* they!?
Sons a bitches!! That's it, I'm going to throttle my bandwidth down to 56k JUST to feel nolstagic! :) -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 5:25 PM To: CF-Talk Subject: Developers Exchange... How *could* they!? For two days now I've been doing searches on the Developers Exchange and getting regular one- to two-second responses. I just searched for ''ColdFusion'' and got back 374 results in just under 3 seconds. I'm shocked and outraged. I no longer have the time to go to the wat er cooler, doze off or chat with the ladies in the next office while waiting for search results. This has completely fouled up my workflo w. How could Macromedia do this to all of their loyal CF developers, and me in particular??? ;D --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.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 __ 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: Developers Exchange... How *could* they!?
I think they're still using jsp :) - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 2:24 AM Subject: Developers Exchange... How *could* they!? > For two days now I've been doing searches on the Developers Exchange and > getting regular one- to two-second responses. I just searched for > ''ColdFusion'' and got back 374 results in just under 3 seconds. > > I'm shocked and outraged. I no longer have the time to go to the water > cooler, doze off or chat with the ladies in the next office while > waiting for search results. This has completely fouled up my workflow. > > How could Macromedia do this to all of their loyal CF developers, and me > in particular??? > > ;D > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.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
Developers Exchange... How *could* they!?
For two days now I've been doing searches on the Developers Exchange and getting regular one- to two-second responses. I just searched for ''ColdFusion'' and got back 374 results in just under 3 seconds. I'm shocked and outraged. I no longer have the time to go to the water cooler, doze off or chat with the ladies in the next office while waiting for search results. This has completely fouled up my workflow. How could Macromedia do this to all of their loyal CF developers, and me in particular??? ;D --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.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
OT: Mailing lists for Visual Basic
I know this one has come up before, but anyone know a list for visual basic with roughly the same traffic as this one? Thanks! Gregory Harris [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: problems with storedproc [great sp attached]
Dear Jochem, how are you? :) > Are you running query analyser through ODBC? I really don't know.. :( > BTW, you should change the name of the variable you are passing. SQL is > a reserved word. I tried to change all variables, didn't work. I'm attaching the complete stored procedure- it is a GREAT sp by Tony Rogerson, you should check into it, it's for PAGING result set. maybe we can solve it like this... CREATE PROCEDURE page_query @sql varchar(4000), @start_row int, @rows_required int AS BEGIN /*** Tony Rogerson [EMAIL PROTECTED] Allows the paging of a SQL Server result set. @sql is the sql statement to execute. @start_row is the starting row number @rows_required is the number of rows to return from @start_row Note: This uses openquery, therefore, your local server should have the 'data access' option set to true (sp_serveroption) Example: page_query 'SELECT * FROM dbname.dbo.tablename ORDER BY name', 10, 20 / DECLARE @execsql nvarchar(4000) SET @execsql = N' SET NOCOUNT ON' + ' SELECT RowID = IDENTITY( int, 1, 1 ), *' + ' INTO #T' + ' FROM OPENQUERY( ' + HOST_NAME() + ',''' + REPLACE( @sql, , ) + ''' )' + ' SET NOCOUNT OFF' + ' SELECT *' + ' FROM #T' + ' WHERE RowID BETWEEN ' + CAST( @start_row AS varchar(10) ) + ' AND ' + CAST( @start_row + (@rows_required-1) AS varchar(10) ) EXEC sp_executesql @execsql __ 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: cfif in cfset
You could roll your own, which lets you eliminate the need for DE(). It's
about 45% faster in my tests using CF5. Without the DE() functions used in
the IIf(), the difference is a lot less.
The way this function operates is less flexible that CF's built-in IIf(),
since you couldn't do something like IIff(IsDefined(myvariable), myvariable,
"")).
function IIff(arg0, arg1, arg2) {
if (arg0) return arg1;
return arg2;
}
Over #NumberFormat(iterations)# iterations:
IIf() with DE() = #NumberFormat(time1)#
IIff() = #NumberFormat(time2)#
Jim
- Original Message -
From: "Aaron Rouse" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 3:10 PM
Subject: Re: cfif in cfset
> I know the DE() function which is commonly used with IIF is resource
> intensive. I once stripped out a sizeable amount of IIF() functions from
a
> page and put in CFIF tags in place and picked up a noticeable amount in
the
> load times. In a lot of cases the IIF() is used, people could have used
> CFIF.
>
> Snipe -
>
>
> - Original Message -
> From: "Nick McClure" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, March 02, 2002 3:46 PM
> Subject: Re: cfif in cfset
>
>
> > You know, I don't know the answer to that question. I use it often
enough,
> > and I don't notice a problem.
> >
> > It is the only thing that you can use accomplish the problem.
> >
> > You could write a function and use cfscript to take care of it for you.
> >
> > At 11:40 PM 3/2/2002 +0200, you wrote:
> > >Nick,
> > >
> > > > You want to use IIF
> > >
> > >I've heard it's resource intensive, true?
__
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: problems with storedproc
Jason Davis wrote:
> I tried also running inside a
>
>
> mystoredprodure 'param1',param2,param3
>
>
> still, same error. the weirdset thing is that exactly the same code
> ("mystoredprodure 'param1',param2,param3") work perfectly
> in query analazyer (sql enterprise manager)
Are you running query analyser through ODBC?
BTW, you should change the name of the variable you are passing. SQL is
a reserved word. Maybe MS SQL Server doesn't think so (just like Access
doesn't think Date is a reserved word), but it is. And if the ODBC
driver is a bit more strict, you have a problem (just like using date
with OLE DB and Access works, but not with ODBC).
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: problems with storedproc
Nopee :( tried to change sp name, nothing. really really weird. and it's an awesome sp I can't live without. .. - Original Message - From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 12:51 AM Subject: Re: problems with storedproc > Doesnt make much sense does it? What about using "query_result" I know > each version of CF has had different reserved words, not sure if "query" > is one of them. Thats about the end of my thoughts. > > > > "Success is a journey, not a destination!!" > > > > Doug Brown > - Original Message - > From: "Jason Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, March 02, 2002 2:42 PM > Subject: Re: problems with storedproc > > > > Douglas, > > > > I also tried replacing the #run_query# with a varchar directly. > > also look at my other post, where I tried to put the entire sp > (including > > parameters) > > run from a , didn't work. > > and it works great in query analayzer! > > > > weird. > > > > - Original Message - > > From: "Douglas Brown" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, March 03, 2002 12:36 AM > > Subject: Re: problems with storedproc > > > > > > > Well since you are using an "IN" have you tested if #run_query# is > > > defined? That is the only thing I can think of that would give a "" > > > value in your code. > > > > > > > > > "Success is a journey, not a destination!!" > > > > > > > > > > > > Doug Brown > > > - Original Message - > > > From: "Jason Davis" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Saturday, March 02, 2002 12:53 PM > > > Subject: problems with storedproc > > > > > > > > > > I'm using something simple like this tored procedure: > > > > > > > > > > > > > > > > > > dbvarname="@sql" > > > > value="'#Run_Query#'" null="No"> > > > > > > > > > > > > And getting a weird error: > > > > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty > object > > > > > > > or column names. Use a single space if necessary. > > > > > > > > > > > > > > > > > > __ 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: problems with storedproc
Doesnt make much sense does it? What about using "query_result" I know each version of CF has had different reserved words, not sure if "query" is one of them. Thats about the end of my thoughts. "Success is a journey, not a destination!!" Doug Brown - Original Message - From: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 2:42 PM Subject: Re: problems with storedproc > Douglas, > > I also tried replacing the #run_query# with a varchar directly. > also look at my other post, where I tried to put the entire sp (including > parameters) > run from a , didn't work. > and it works great in query analayzer! > > weird. > > - Original Message - > From: "Douglas Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, March 03, 2002 12:36 AM > Subject: Re: problems with storedproc > > > > Well since you are using an "IN" have you tested if #run_query# is > > defined? That is the only thing I can think of that would give a "" > > value in your code. > > > > > > "Success is a journey, not a destination!!" > > > > > > > > Doug Brown > > - Original Message - > > From: "Jason Davis" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, March 02, 2002 12:53 PM > > Subject: problems with storedproc > > > > > > > I'm using something simple like this tored procedure: > > > > > > > > > > > > > dbvarname="@sql" > > > value="'#Run_Query#'" null="No"> > > > > > > > > > And getting a weird error: > > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > > > > > or column names. Use a single space if necessary. > > > > > > > > > > > > __ 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: problems with storedproc
Douglas, I also tried replacing the #run_query# with a varchar directly. also look at my other post, where I tried to put the entire sp (including parameters) run from a , didn't work. and it works great in query analayzer! weird. - Original Message - From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 12:36 AM Subject: Re: problems with storedproc > Well since you are using an "IN" have you tested if #run_query# is > defined? That is the only thing I can think of that would give a "" > value in your code. > > > "Success is a journey, not a destination!!" > > > > Doug Brown > - Original Message - > From: "Jason Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, March 02, 2002 12:53 PM > Subject: problems with storedproc > > > > I'm using something simple like this tored procedure: > > > > > > > > dbvarname="@sql" > > value="'#Run_Query#'" null="No"> > > > > > > And getting a weird error: > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > > > or column names. Use a single space if necessary. > > > > > > > __ 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: problems with storedproc
Well since you are using an "IN" have you tested if #run_query# is defined? That is the only thing I can think of that would give a "" value in your code. "Success is a journey, not a destination!!" Doug Brown - Original Message - From: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 12:53 PM Subject: problems with storedproc > I'm using something simple like this tored procedure: > > > > value="'#Run_Query#'" null="No"> > > > And getting a weird error: > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > or column names. Use a single space if necessary. > > > __ 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: problems with storedproc
I tried also running inside a
mystoredprodure 'param1',param2,param3
still, same error. the weirdset thing is that exactly the same code
("mystoredprodure 'param1',param2,param3") work perfectly
in query analazyer (sql enterprise manager)
help?
- Original Message -
From: "Jason Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 03, 2002 12:17 AM
Subject: Re: problems with storedproc
> Yes it is, anyhow I tried without it and it gave same error.
>
>
> > It looks to me like you have ' ' in your value="'#Run_Query#'" is that
> > needed?
> >
> >
> >
> >
> > "Success is a journey, not a destination!!"
> >
> >
> >
> > Doug Brown
> > - Original Message -
> > From: "Jason Davis" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Saturday, March 02, 2002 12:53 PM
> > Subject: problems with storedproc
> >
> >
> > > I'm using something simple like this tored procedure:
> > >
> > >
> > >
> > > > dbvarname="@sql"
> > > value="'#Run_Query#'" null="No">
> > >
> > >
> > > And getting a weird error:
> > >
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object
> >
> > > or column names. Use a single space if necessary.
> > >
> > >
> > >
> >
>
__
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: problems with storedproc
Yes it is, anyhow I tried without it and it gave same error. > It looks to me like you have ' ' in your value="'#Run_Query#'" is that > needed? > > > > > "Success is a journey, not a destination!!" > > > > Doug Brown > - Original Message - > From: "Jason Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, March 02, 2002 12:53 PM > Subject: problems with storedproc > > > > I'm using something simple like this tored procedure: > > > > > > > > dbvarname="@sql" > > value="'#Run_Query#'" null="No"> > > > > > > And getting a weird error: > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > > > or column names. Use a single space if necessary. > > > > > > > __ 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: cfif in cfset
I know the DE() function which is commonly used with IIF is resource intensive. I once stripped out a sizeable amount of IIF() functions from a page and put in CFIF tags in place and picked up a noticeable amount in the load times. In a lot of cases the IIF() is used, people could have used CFIF. Snipe - - Original Message - From: "Nick McClure" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 3:46 PM Subject: Re: cfif in cfset > You know, I don't know the answer to that question. I use it often enough, > and I don't notice a problem. > > It is the only thing that you can use accomplish the problem. > > You could write a function and use cfscript to take care of it for you. > > At 11:40 PM 3/2/2002 +0200, you wrote: > >Nick, > > > > > You want to use IIF > > > >I've heard it's resource intensive, true? > __ 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: problems with storedproc
It looks to me like you have ' ' in your value="'#Run_Query#'" is that needed? "Success is a journey, not a destination!!" Doug Brown - Original Message - From: "Jason Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 12:53 PM Subject: problems with storedproc > I'm using something simple like this tored procedure: > > > > value="'#Run_Query#'" null="No"> > > > And getting a weird error: > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > or column names. Use a single space if necessary. > > > __ 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: cfif in cfset
You know, I don't know the answer to that question. I use it often enough, and I don't notice a problem. It is the only thing that you can use accomplish the problem. You could write a function and use cfscript to take care of it for you. At 11:40 PM 3/2/2002 +0200, you wrote: >Nick, > > > You want to use IIF > >I've heard it's resource intensive, true? __ 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: cfif in cfset
Nick, > You want to use IIF I've heard it's resource intensive, true? - Original Message - From: "Nick McClure" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> > > syntax: > > > > At 11:16 PM 3/2/2002 +0200, you wrote: > >I'm using CF 4.5, how can I perform something like this? > > > > > > > >without needing to do: > > > > > > > > > > > > > > > > > > > > > > > > > __ 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: cfif in cfset
You want to use IIF syntax: At 11:16 PM 3/2/2002 +0200, you wrote: >I'm using CF 4.5, how can I perform something like this? > > > >without needing to do: > > > > > > > > > > > > __ 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
cfif in cfset
I'm using CF 4.5, how can I perform something like this? without needing to do: __ 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
problems with storedproc
I'm using something simple like this tored procedure: And getting a weird error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary. __ 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: Refreshing parent window on close
You could do: ... In IE, you can ditch the and tags and just write the
Re: Refreshing parent window on close
Thanks Shawn. I found the following works well, but only when I manually close the pop-up window. How can I get it to refresh the parent, and close the popup, right after a cfquery? (in case I didn't make myself clear, it'll be after a form-submit - so perhaps there's a JScript function I could use that ties in with the form?) Will - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> Newsgroups: gradwell.lists.cftalk Sent: Saturday, March 02, 2002 6:58 PM Subject: RE: Refreshing parent window on close > In the popup window's onClose event (or onUnload... I can never > remember > which), enter this line: > > self.opener.refresh(); > > Or, alternately, self.opener.location='originalPageURL.cfm'; > > Hope that helps. > > Shawn Grover > > -Original Message- > From: W Luke [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 02, 2002 11:50 AM > To: CF-Talk > Subject: Refreshing parent window on close > > > Hi, > > On one page I'm doing at the moment, there's a bunch of - in a > certain instance it will produce a button which, when pressed, will pop > up a > window. After the user has done what they need to do in the > popped-up-window, I need it to close and for the original parent window > to > be refreshed. > > Any ideas how? > > Thanks > > Will > > --- > "A woman drove me to drink and I didn't even have the decency to thank > her." --W.C. Fields > > > __ 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: Refreshing parent window on close
In the popup window's onClose event (or onUnload... I can never remember which), enter this line: self.opener.refresh(); Or, alternately, self.opener.location='originalPageURL.cfm'; Hope that helps. Shawn Grover -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 11:50 AM To: CF-Talk Subject: Refreshing parent window on close Hi, On one page I'm doing at the moment, there's a bunch of - in a certain instance it will produce a button which, when pressed, will pop up a window. After the user has done what they need to do in the popped-up-window, I need it to close and for the original parent window to be refreshed. Any ideas how? Thanks Will --- "A woman drove me to drink and I didn't even have the decency to thank her." --W.C. Fields __ 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
Refreshing parent window on close
Hi, On one page I'm doing at the moment, there's a bunch of - in a certain instance it will produce a button which, when pressed, will pop up a window. After the user has done what they need to do in the popped-up-window, I need it to close and for the original parent window to be refreshed. Any ideas how? Thanks Will --- "A woman drove me to drink and I didn't even have the decency to thank her." --W.C. Fields __ 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: Regular Expression Help
just do a udf and create your array and then check that the value of the words you are replacing (length). If they are less than 4 char then they should be removed. Hope that makes sense. "Success is a journey, not a destination!!" Doug Brown - Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 4:28 AM Subject: Re: Regular Expression Help > On Sat, 2002-03-02 at 10:10, Jared Stark wrote: > > Hello all. I am trying to write a simple search engine, and would like > > to replace certain commonly used prepositions from the search string > > such as 'a','the','for', etc... > > > > I have an array of the prepositions that I would like to remove, however > > the problem I have is that it is removing them when they are subsets of > > other words, for example 'them' would become 'm' when removing 'the', > > 'bag' would become 'bg' when removing 'a', etc... > > > > I'm not an expert at regular expression, but I'm assuming it is possible > > to remove only those instances where the prepositions are stand-alone > > and not subsets of other words. Could someone render me some > > assistance? > > If you want to use regular expressions to do it, easiest way would be to > use the character class for whitespace before and after your > preposition. > > However don't underestimate the power of the CF list processing > functions, think of your search term as a list seperated by whitespace > and you can use any of the CF list functions. > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfhttp pressure
[EMAIL PROTECTED] wrote: > >> >> >> >> >> >> >> >> >> >> > > What if i'm using 4.5, is there an alternative for cfsavecontent? cf_bodycontent from the Developers Exchange. Jochem __ 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 pressure
Jochem, > > > > > > > > > > What if i'm using 4.5, is there an alternative for cfsavecontent? __ 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: cfhttp pressure
Dave, > Honestly, though, I'd recommend doing this whole process in something other > than CF, in this case. I'd rewrite the generate.cfm page in another > language, since this is the only script you're running to build your > generated HTML. CF isn't really designed to do this sort of thing well - > it's really good for doing on-demand work, but not especially good at > performing bulk processing. There are lots of alternatives that would work > better for this individual task. Can you suggest any alternative? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL goes straight to UNDELIVERABLE
Check that the TO and FROM address are valid email addresses... your mail serve might be rejecting ones that don't have it.. To check, go into the undeliv folder and open up a few of the messages.. If you see most of them have bad email addresses, just check before you create the message - and skip it if you don't have a valid address. At 02:40 AM 3/2/2002 -0800, you wrote: >Anyone have any idea on why a lot of emails are going within Cold Fusion >straight from the SPOOL folder to the UNDELIVR folder. > >I don't know if its a problem in Cold Fusion or the email server. >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: Displaying Please wait message during a process
On Sat, 2002-03-02 at 04:11, Mark Leder wrote: > I have a template that I want to display "Please wait" text, then > go > through a CFIndex Process, with a "complete" message when done. > This > is displayed in a pop-up window. I find that when the CF process > > starts, the window goes blank until the process is done, then > displays all the text. I've tried a CFFlush on the "please wait" > > prior to the process, but then the process hangs. I've also > tried > wrapped CFSilent around the process, to no avail. > > What's the right way to do this? CFFLUSH should do the job, but remember some browsers won't display anything until thier buffer is full. The way to do this before CFFLUSH existed was to put an intermediate page in, lets say your long process happens on a form submission - you make the process look like SUBMIT FORM => "PLEASE WAIT" Page => Process Form where you submit the form to the please wait page, which includes a hidden form to pass the data on to the real processing. In the onload of the please wait page you submit the form. Thus the please wait page will hang about on screen until the processing returns it's data. __ 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: Regular Expression Help
On Sat, 2002-03-02 at 10:10, Jared Stark wrote: > Hello all. I am trying to write a simple search engine, and would like > to replace certain commonly used prepositions from the search string > such as 'a','the','for', etc... > > I have an array of the prepositions that I would like to remove, however > the problem I have is that it is removing them when they are subsets of > other words, for example 'them' would become 'm' when removing 'the', > 'bag' would become 'bg' when removing 'a', etc... > > I'm not an expert at regular expression, but I'm assuming it is possible > to remove only those instances where the prepositions are stand-alone > and not subsets of other words. Could someone render me some > assistance? If you want to use regular expressions to do it, easiest way would be to use the character class for whitespace before and after your preposition. However don't underestimate the power of the CF list processing functions, think of your search term as a list seperated by whitespace and you can use any of the CF list functions. __ 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: Attaching CSS style sheet
the tag should always appear in the section of the generated HTML document, unless your application.cfm also includes this section, putting the in there would cause it to appear outside the section. i.e it's makes for bad HTML. On Sat, 2002-03-02 at 10:06, WebMaster wrote: > What's the problem with referencing the stylesheet in the application.cfm > file? I have done this on several websites and never seen a problem before. > > Here's the code I use: > > > > Is there an issue with doing it this way? > __ 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
Running Excel Web Queries Cause Browser Caching Problems?
Hi Guys! I have this strange problem: after running an Excel Web Query to a Cold Fusion template on a server, some browsers refuse to not cache certain pages on that server. First I mucked up my laptop, then I mucked up the Development Server, now the Production Server is mucked up. Thanks to my inattentiveness on the matter, some of our clients are logging on to our application from mult-user pcs and seeing the previous users personalization! At first I was distracted by the way Excel cf authenticates - on our application a wddx cookie is set containing some personal information after a simple login. So I concentrated on getting the Excel Web Query to send the proper name and password. I successfully developed a custom tag that just needs to be placed where you want the link to show and creates an iqy file which automatically opens in Excel and sends all form and url data needed to query the same page you are on. The only thing Excel asks for is your password. Beautiful, huh? But, basking in my success, I am now able to see what happens on servers which many people are using. Couple of questions: 1) How do I find out what header info Excel is sending to my Cold Fusion server? I inserted the custom tag at the bottom of the developer's version of the site wide error handler, which just cf dumps all the structures that exist on the Cold Fusion server, and ran the web query to there, but I can't see any differences. The http user agent is Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461), but that isn't any different than the browser. Even the cf token and cf id are the same! 2) How do I get the browser cache on certain machines to work normally again? I have scads of no-cache header tags, uuids in my url, etc., my these are just work-arounds. The underlying problem still remains. Thanx Dave __ 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: What are these, headers?
Hi Guys! I have this strange problem: after running an Excel Web Query to a Cold Fusion template on a server, some browsers refuse to not cache certain pages on that server. First I mucked up my laptop, then I mucked up the Development Server, now the Production Server is mucked up. Thanks to my inattentiveness on the matter, some of our clients are logging on to our application from mult-user pcs and seeing the previous users personalization! At first I was distracted by the way Excel cf authenticates - on our application a wddx cookie is set containing some personal information after a simple login. So I concentrated on getting the Excel Web Query to send the proper name and password. I successfully developed a custom tag that just needs to be placed where you want the link to show and creates an iqy file which automatically opens in Excel and sends all form and url data needed to query the same page you are on. The only thing Excel asks for is your password. Beautiful, huh? But, basking in my success, I am now able to see what happens on servers which many people are using. Couple of questions: 1) How do I find out what header info Excel is sending to my Cold Fusion server? I inserted the custom tag at the bottom of the developer's version of the site wide error handler, which just cf dumps all the structures that exist on the Cold Fusion server, and ran the web query to there, but I can't see any differences. The http user agent is Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461), but that isn't any different than the browser. Even the cf token and cf id are the same! 2) How do I get the browser cache on certain machines to work normally again? I have scads of no-cache header tags, uuids in my url, etc., my these are just work-arounds. The underlying problem still remains. Thanx Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL goes straight to UNDELIVERABLE
[EMAIL PROTECTED] wrote: > Anyone have any idea on why a lot of emails are going within Cold Fusion > straight from the SPOOL folder to the UNDELIVR folder. > > I don't know if its a problem in Cold Fusion or the email server. What is in your mail.log? Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL goes straight to UNDELIVERABLE
Anyone have any idea on why a lot of emails are going within Cold Fusion straight from the SPOOL folder to the UNDELIVR folder. I don't know if its a problem in Cold Fusion or the email server. 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
