Re: Building and saving a query string

[Jann VanOver]

Remove ALL extra characters using  and
then put  around all characters you want to keep, like
this...



Select * from contacts where 1 
 and company like
'%#Form.company#%'
 and title like
'%#Form.title#%'
 and city like
'%#Form.city#%'
 and state like
'%#Form.state#%'
 and country like
'%#Form.country#%'
 and type_of_industry like
'%#Form.type#%'
 and company_size =
#Form.size#
 and department like
'%#Form.department#%'
 and source_of_contact like
'%#Form.source#%'



On 1/8/03 1:49 PM, "Luis Lebron" <[EMAIL PROTECTED]> wrote:

> I'm using the following code to build and display a query string:\
> 
> Select * from contacts where 1
> and company like
> '%#Form.company#%'
> and title like
> '%#Form.title#%'
> and city like
> '%#Form.city#%'
> and state like
> '%#Form.state#%'
> and country like
> '%#Form.country#%'
> and type_of_industry like
> '%#Form.type#%'
> and company_size
> #Form.size#
> and department like
> '%#Form.department#%'
> and source_of_contact like
> '%#Form.source#%'
> 
> 
> #(myquery)#
> 
> 
> The query string builds and displays correctly.
> For example: 
> Select * from contacts where 1 and company like '%Company 1%' and title like
> '%Title 1%' and type_of_industry like '%Manufacturing%' and company_size
> <250 and department like '%Training%"
> 
> However, when I try to save the query string in the database later it has a
> lot of unneeded spaces and line breaks like so:
> 
> Select * from contacts where 1
> and company like '%Company 1%'
> and title like '%Title 1%'
> 
> 
> 
> and type_of_industry like '%Manufacturing%'
> and company_size <250
> and department like '%Training%'
> 
> Is there any way I can fix this?
> 
> 
> thanks,
> 
> 
> Luis
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Repost: CFLOGIN, Web Server Auth, Timeout and unwanted caching

[Patti G. L. Hall]

I am using web server authentication to authenticate users entering my site.

I am then using cflogin and queries to authorize their access.

I am seeing problems. If I allow a cflogout tag to process it gets rid of
the users roles just fine... But it does not trigger the cflogin tag to run
the authorization queries again.  This seems to be related to the cflogin
tag's idletimeout attribute and maybe a caching behavior that I can see
evidence of, but have no idea exactly how its happening.

I want to match the cflogin idletimeout to my session timeout.  I am setting
some session variables inside the cflogin tag, for site personalization uses
mainly.  If I expire the session variables early then I am finding that the
cflogin tag is never re-activating, thus resetting the session variables...
Even if the user closes their browser and goes through the web server
authentication process again.

Lets say that I decide never to allow the session variables to be cleared
and they only expire naturally ... And lets also assume that I don't use a
cflogout tag and let the login timeout expire naturally.  Then I am still
seeing a problem when the user closes the browser and re-authenticates
through the web browser popup. Using a *different* username and password,
the cflogin tag still does not run and the session variables remain set to
the last entered. Not good.

For sh**s and giggles, I set the cflogin timeout value to 1 second.  This
works.  The cflogin tag *always* runs the code between its [cflogin] and
[/cflogin] tags (pretty much, you've got to be a fast clicker for it not to)
and as such always pickes up the newest and best info.  Great.  But I
shouldn't have to run the cflogin tag every time, should I?  This is why it
seems to me that the cflogin tag is caching the info somehow.  I have known
about the problem with using application authentication and naming your
formfields j_username and j_password.  I ran into that problem months ago.
Yet, since I'm using web auth, that ain't my problem.

One thing to note:  In my code I have a condition that fires when the user's
does NOT pass authorization.  I display a particular template.  This
template always seems to display when it should, regardless of the cflogin
timeout, cflogout tag or what have you.  So, the cflogin tag itself works...
I just can't get the crap in the middle to run when I think it should unless
I set the timeout to 1 second.

Here is a simplified version of my code (original cflogin timeout included).

[!--- Process the login---]
[cflogin idletimeout="86400"]

  [cfif IsDefined( "cflogin" )]
 [!--- Check for user in database.
   Find roles of the authenticated user. ---]
[cfquery name="authorize" datasource="#request.dsn#"]
   ... Stuff ...
[/cfquery]

[cfdump var="#authorize#" label="Authorization"]


[cfif authorize.recordcount neq 0 and authorize.deptCount neq 0]
   [h3]This is where the session variables should be set[/h3]
   [!--- Initialize session variables for personalization and
app security ---]
   [cfset structclear(session)]
   [cfparam name="session.cuserid"
default="#authorize.cuserid#"]
   [cfparam name="session.userfullname"
default="#trim(authorize.userfullname)#"]
   [cfparam name="session.useremail"
default="#authorize.email#"]
   [cfparam name="session.rolename"
default="#authorize.rolename#"]


   [h3]Set User roles[/h3]
   [cfloginuser name="#cflogin.name#"
password="#cflogin.password#" roles="#authorize.roleName#"]

[cfelse]
   [!--- user not found, deny access to site ---]
   [cfinclude template="accessdenied.cfm"]

   [cfabort]

[/cfif]

[cfelse]

[!--- this should never happen ---]
[h4]Authentication data is missing.[/h4]
[cfabort]

[/cfif]

[/cflogin]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[Dick Applebaum]

On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote:

> So does VMWare for Linux run under MacOSX? Now *that* would be a 
> solution :)

VirtualPC emulates a PC and runs on OS X.

Dick

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[John Paul Ashenfelter]

No doubt that it can work. I've seen plenty of projects where the SQL code
could have been written in Access instead of the db du jour :)

But as the standard development environment, general rule of thumb is same,
same, same. For a one-shot consulting gig, well that's not so big a deal.

It all comes down to the complexity of the SQL -- specifically how much
server-specific stuff you need to do. Obscure (or obsfucated) functions
(e.g. MySQL password hash function), crazy things like code pages and
collation orders, queries with linked servers, etc. All that stuff will burn
you. Run-of-the-mill DML, no biggie.

So does VMWare for Linux run under MacOSX? Now *that* would be a solution :)

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 5:24 PM
Subject: RE: Unix database syntactically similar to SQL Server?


> > But wow, do I think this is a bad idea.
> > 
> > Databases are the core of many CF applications -- you
> > should use the same database for development, staging,
> > and production. Would you develop in CF4.5 and deploy
> > to CFMX (or CF5 for that matter)? Would you develop on
> > Windows and deploy to Solaris? (actually, you can do
> > that as long as you remember the COM components won't
> > work and filenames become case-sensitive).
>
> In an ideal world, I agree with you. However, I've actually been pretty
> successful using MS SQL Server as a development platform for Sybase (on
> Solaris) deployment. I did this for an onsite consultation; I copied their
> existing Sybase database to SQL Server on my laptop, wrote several hundred
> stored procedures of middling to high complexity - one of which replaced a
> loop over several hundred queries with a single database interaction,
> reducing average execution time for that page from 15 seconds to less than
1
> second - and they all worked flawlessly on Sybase.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: TEST - will this post make it?

[Dave Carabetta]

> Patti G. L. Hall wrote:
> > I posted a question an hour ago.  It made it to the archives, but it
didn't
> > make it to the list.  Will this one get through?
>
> I am experiencing the same symptoms. Some posts go through, others don't
> but do show up in the archives. I'll just start CC'ing people.

For the longest time, any post I make from my Hotmail account makes it to
the archives, but gets bounced back to my Junk Mail folder. I never receive
an individual e-mail on the list. Maybe this is related?

Michael, does the HoF server look for anything specific in the headers
before accepting it? Is there anything I could provide to help diagnose
this?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[Paul Hastings]

> In an ideal world, I agree with you. However, I've actually been pretty
> successful using MS SQL Server as a development platform for Sybase (on

because sql server is/was son-of-sybase run amok. even access <--> sql
server has some quirks.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Macromedia -- thanks for listening

[Dick Applebaum]

I think all the Mac-heads out there will agree:

Thanks Macromedia Jesse, Sean, Christian, Damon, Phil, Jim, Vern, Ray, 
John, Mike (and all of you who worked behind the scenes to make it 
happen).

You really do listen!

Thanks!

Dick

...bows, and backs out of the room

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[Dick Applebaum]

On Friday, January 10, 2003, at 03:07 PM, Joshua Miller wrote:

> Thanks for the input guys, looking forward to a 100% Mac development
> environment :)
>
>
Um my goal is a 100% Mac Deployment environment %^D>

but I am really happy to have what we have.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: TEST - will this post make it?

[Jochem van Dieten]

Patti G. L. Hall wrote:
> I posted a question an hour ago.  It made it to the archives, but it didn't
> make it to the list.  Will this one get through?

I am experiencing the same symptoms. Some posts go through, others don't 
but do show up in the archives. I'll just start CC'ing people.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Tracking Refferal Pages

[Christian Cantrell]

Another option is to post-process your access logs.  In other words,  
set up a process to parse your access logs at some set interval and  
insert the data (in your case, the just referrer) into a database.   
This works well for extremely high volume servers like those used in ad  
serving.

Christian

On Friday, January 10, 2003, at 05:05 PM, Double Down, Inc. wrote:

> Can anyone suggest a good method for tracking what page bought a  
> surfer to my page? I need to be able to get that information and put  
> it in a DB.
>
> TIA
>
> DDINC
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL Query Help - Access Lookup tables and query output not accurate - not working

[Fregas]

I don't fully undertand what you're doing.  The first two queries, are those
examples of the data inside those tables, or are they views/queries of some
other table.  It seems like all you need is a simple table join.  Perhaps
you could send me the database and cfml off list and I could look at it for
you. You'll have to email me at [EMAIL PROTECTED]

Fregas

- Original Message -
From: "Jason Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 7:03 PM
Subject: SQL Query Help - Access Lookup tables and query output not
accurate - not working


> Hello List -
> I can not get this query down for the life of me. After a wasted
> afternoon - I am hoping ( I know you can) someone will assist me.
>
> I have an access table I am grabbing my information from - table -
> ModuleFeatures
> ModuleFeatures contains Column iModule -WHICH is a lookup to a
> ApplicationModules table
> SELECT [ApplicationModules].[iApplicationModuleID],
> [ApplicationModules].[sModuleName] FROM ApplicationModules;
>
> and it has an iApplication colum - which again is a lookup to a
> Application table -
> SELECT [ApplicationTypes].[iApplicationID],
> [ApplicationTypes].[sApplicationName] FROM ApplicationTypes;
>
> That is the code WITHIN access. Now on coldusion - I run a simple query
> to grab these features -
> 
> SELECT iModule, iApplication, sModuleFeature FROM ModuleFeatures
> ORDER BY iModule, iApplication
> 
>
> And the output is equally as simple -
> 
> #iModule# : within #iApplication#
>
>   #sModuleFeature#
> 
> This outputs perfectly. And the statement above - #iModule# : within
> #iApplication# was for a test. And it outputs correctly. So what it ends
> up with is
> 8: within 2 -
> 8 in Table ApplicationModules = Medical Records
> 2 in Table ApplicationTypes = Financial Applications.
>
> So instead of
> 8: within 2 - I need it to say
> Medical Records: within Financial Applications
>
> When I modified my simple query and alter the query to grab from both
> tables - it threw everything off.
>
> The ONLY working solution is that I can do this... modify the output
> query (shown below )-which does the trick - but is a headache. Not to
> mention - I have to do that with iModule - and there are upwards of 30
> modules. Setting those by hand defeats the purpose of pulling from a
> database.
>
> I know I there is a way to modify my simple query - but going on 3 hours
> of tinkering and can not get it to work right or if I get it working -
> it's not accurate.
>
> Sorry this is long - but I figured the more info - the better someone
> can help me!
> Thanks
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Tracking Refferal Pages

[Bud]

On 1/10/03, Double Down, Inc. penned:
>Can anyone suggest a good method for tracking what page bought a 
>surfer to my page? I need to be able to get that information and put 
>it in a DB.

You could place something like this at the top of every page:









INSERT INTO tracking_table
(Referer, Page_Visited, When_Visited)
VALUES
('#camefrom#', '#cameto#', #CreateODBCDateTime(now())#)



Alternately you could put it in Application.cfm and change



to



That is if you want to grab the entry page also.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Joshua Miller]

That's good to hear - I hope it works in reverse!

I'm downloading Sybase for OSX now - stupid DirecWAY only lets me get
100MB a day though, so I have to wait until tomorrow to finish the
download :(

Thanks for the input guys, looking forward to a 100% Mac development
environment :)

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 5:25 PM
To: CF-Talk
Subject: RE: Unix database syntactically similar to SQL Server?


> But wow, do I think this is a bad idea.
> 
> Databases are the core of many CF applications -- you
> should use the same database for development, staging,
> and production. Would you develop in CF4.5 and deploy 
> to CFMX (or CF5 for that matter)? Would you develop on
> Windows and deploy to Solaris? (actually, you can do 
> that as long as you remember the COM components won't 
> work and filenames become case-sensitive).

In an ideal world, I agree with you. However, I've actually been pretty
successful using MS SQL Server as a development platform for Sybase (on
Solaris) deployment. I did this for an onsite consultation; I copied
their existing Sybase database to SQL Server on my laptop, wrote several
hundred stored procedures of middling to high complexity - one of which
replaced a loop over several hundred queries with a single database
interaction, reducing average execution time for that page from 15
seconds to less than 1 second - and they all worked flawlessly on
Sybase.

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Tracking Refferal Pages

[Jeff Garza]

Take a look at the #CGI.HTTP_REFERER# variable...  This will contain the
information (if it is available...)

Then you can put something like this in your Application.cfm or
OnRequestEnd.cfm



INSERT INTO Referers(page, referingpage)
VALUES(
,





Table Design:

Create Table Referers (
recordID int IDENTITY(1,1) NOT NULL,
page varchar(255),
referingpage varchar(255),
theDate smdatetime NOT NULL CONSTRAINT [DF_test_theDate] DEFAULT (getdate())
)

HTH,

Jeff Garza

- Original Message -
From: "Double Down, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 3:05 PM
Subject: Tracking Refferal Pages


Can anyone suggest a good method for tracking what page bought a surfer to
my page? I need to be able to get that information and put it in a DB.

TIA

DDINC

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Dave Watts]

> But wow, do I think this is a bad idea.
> 
> Databases are the core of many CF applications -- you 
> should use the same database for development, staging,
> and production. Would you develop in CF4.5 and deploy 
> to CFMX (or CF5 for that matter)? Would you develop on
> Windows and deploy to Solaris? (actually, you can do 
> that as long as you remember the COM components won't 
> work and filenames become case-sensitive).

In an ideal world, I agree with you. However, I've actually been pretty
successful using MS SQL Server as a development platform for Sybase (on
Solaris) deployment. I did this for an onsite consultation; I copied their
existing Sybase database to SQL Server on my laptop, wrote several hundred
stored procedures of middling to high complexity - one of which replaced a
loop over several hundred queries with a single database interaction,
reducing average execution time for that page from 15 seconds to less than 1
second - and they all worked flawlessly on Sybase.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[Jochem van Dieten]

John Paul Ashenfelter wrote:
> 
> That said, focus on ANSI-standard SQL and do the following:
>   check your datatypes for compliance in both
>   check the case-sensitivity in both (files and dbs)
>   check the functions you use are in both dbs, or write a script to replace
> common substitutions

- complain to your vendor about the ISO-standard SQL functions that are 
not implemented
- write UDF's with the ISO-standard SQL function name for functions that 
are implemented but use a different name/syntax


> or maybe just move production to MySQL or Postgres.

That is not for the weak of heart if you come from MS SQL Server :-)

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Tracking Refferal Pages

[Jason Miller]

On the simple level - I have used the CGI.Refferer variable available - 
you can simply parse in the CGI.Refferer variable and include it in an 
SQL insert or an cfinsert.

You can get pretty creative with the CGI information available an 
inserting it into database.

jay miller

Double Down, Inc. wrote:

>Can anyone suggest a good method for tracking what page bought a surfer to my page? I 
>need to be able to get that information and put it in a DB.
>
>TIA
>
>DDINC
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Tracking Refferal Pages

[Everett, Al]

CGI.HTTP_REFERER should be what you need.

> -Original Message-
> From: Double Down, Inc. [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 5:05 PM
> To: CF-Talk
> Subject: Tracking Refferal Pages
> 
> 
> Can anyone suggest a good method for tracking what page 
> bought a surfer to my page? I need to be able to get that 
> information and put it in a DB.
> 
> TIA
> 
> DDINC
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Tracking Refferal Pages

[Double Down, Inc.]

Can anyone suggest a good method for tracking what page bought a surfer to my page? I 
need to be able to get that information and put it in a DB.

TIA

DDINC
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Custom Tag Usage

[Everett, Al]

Where were you when I was looking for exactly this same thing six months
ago?

I'd be interested in seeing how you implemented it.

> -Original Message-
> From: Gaulin, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 5:02 PM
> To: CF-Talk
> Subject: RE: Custom Tag Usage
> 
> 
> Hi
> I hacked something like this together a couple of years ago called
> "CFCalls". It doesn't check for COM usage though, and I wish 
> I had defined
> the database tables better to support more reporting, but it 
> works pretty
> good for what it is.
> 
> It uses perl for parsing, Access as a database, and CF as a 
> front-end for
> browsing.  We refresh the index nightly on our dev box using 
> cfschedule.
> 
> If you're interested I can email it to you. You'll have to 
> tweak the perl a
> little to match your directory structure.
> 
>   Mark
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 4:41 PM
> To: CF-Talk
> Subject: Custom Tag Usage
> 
> 
> Does any one know if there is custom tag that will sift 
> through a website 
> and document and dependencies used in the site, ie. com, 
> custom tags, and 
> cfx tags?
> 
> Brook
> 
> At 04:33 PM 1/10/2003 -0500, you wrote:
> > > doesn't it take around 24-72 hrs for the change to take
> > > effect.. thats what my account is like at mydomain.com
> >
> >No, not when you're using a dynamic DNS provider. That's the 
> whole point of
> >using one.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL Query Help - Access Lookup tables and query output not accurate - not working

[Jason Miller]

Short Version - I realize that is VERY long - but I jsut supplied alot 
of information -
Temporary link online -
http://64.234.202.15/dbindex.cfm

LookUp existing tables - need to be altered on cfquery end  efficiently -

8: within 2 -
8 in Table ApplicationModules = Medical Records
2 in Table ApplicationTypes = Financial Applications.

Simple question is - I am looking for an alternative to having to do this












Jason Miller wrote:

>In Coldusion - I run a simple query 
>to grab these features -
>
>SELECT iModule, iApplication, sModuleFeature FROM ModuleFeatures
>ORDER BY iModule, iApplication
>
>
>And the output is equally as simple -
>
>#iModule# : within #iApplication#
>
>  #sModuleFeature#
>
>This outputs perfectly. And the statement above - #iModule# : within 
>#iApplication# was for a test. And it outputs correctly. So what it ends 
>up with is
>8: within 2 -
>8 in Table ApplicationModules = Medical Records
>2 in Table ApplicationTypes = Financial Applications.
>
>So instead of
>8: within 2 - I need it to say
>Medical Records: within Financial Applications
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Custom Tag Usage

[Gaulin, Mark]

Hi
I hacked something like this together a couple of years ago called
"CFCalls". It doesn't check for COM usage though, and I wish I had defined
the database tables better to support more reporting, but it works pretty
good for what it is.

It uses perl for parsing, Access as a database, and CF as a front-end for
browsing.  We refresh the index nightly on our dev box using cfschedule.

If you're interested I can email it to you. You'll have to tweak the perl a
little to match your directory structure.

Mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 4:41 PM
To: CF-Talk
Subject: Custom Tag Usage


Does any one know if there is custom tag that will sift through a website 
and document and dependencies used in the site, ie. com, custom tags, and 
cfx tags?

Brook

At 04:33 PM 1/10/2003 -0500, you wrote:
> > doesn't it take around 24-72 hrs for the change to take
> > effect.. thats what my account is like at mydomain.com
>
>No, not when you're using a dynamic DNS provider. That's the whole point of
>using one.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[John Paul Ashenfelter]

Joshua,

The answer the question in your subject line is "Sybase". But the real
answer is dependent on what kind of SQL you use. If it's
SELECT/INSERT/UPDATE/DELETE with vanilla data types, you're fine. If you
stick to the ANSI standard, you're probably fine. And the functions are
probably named the same (or at least aliased).

But wow, do I think this is a bad idea.

Databases are the core of many CF applications -- you should use the same
database for development, staging, and production. Would you develop in
CF4.5 and deploy to CFMX (or CF5 for that matter)? Would you develop on
Windows and deploy to Solaris? (actually, you can do that as long as you
remember the COM components won't work and filenames become case-sensitive).

Let's say you use MySQL 3.23.54 as the development db. I've got nothing
against it, but how are you going to write stored procs? If MSSQL is your
production server, you'd want to take advantage of the $$$ you're paying for
it, right? Then why would you throw out stored procs? You'll end up with
forked code that looks like this:


MySQL query

MSSQL query


or something and cause tons of headaches for you -- this is not going to
speed your development efforts!


That said, focus on ANSI-standard SQL and do the following:
  check your datatypes for compliance in both
  check the case-sensitivity in both (files and dbs)
  check the functions you use are in both dbs, or write a script to replace
common substitutions

or maybe just move production to MySQL or Postgres.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 4:36 PM
Subject: Unix database syntactically similar to SQL Server?


> Anyone know what the most syntactically similar RDBMS to SQL Server is
> for Unix/Linux ?
>
> I've setup my CFMXJ2EE / JRun scenario on my Mac, but my application
> uses a SQL Server database. I'd like to install something on the Mac
> that would be pretty similar for a development environment so that I
> don't have to alter code much when moving to the staging server.
>
> Sybase? Postgre? mySQL?
>
> Thanks,
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> 
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to
> 
> [EMAIL PROTECTED]
> 
> *
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[Dick Applebaum]

Sybase_ASE shares common ancestry with SQL-Severe (Freudian typo).

MS and Sybase worked together for a while to develop SQL-Server.

Sybase uses T/SQL and it is very similar to MS T/SQL  (and Sybase wants  
to hear about any differences so they can be made compatible).

You can download a free developer version.

I took a 33 Meg SQL-Server db (about 30 tables) and ported it to  
Sybase_ASE.  The only problems were with a few T/SQL Scalar functions  
(Left, etc).

A neat thing is that Sybase_ASE for the Mac is Rendezvous enabled --  
you can automatically discover & connect to db's on the local network  
(wired or wireless) -- it just burps at you when it finds a db.

I think the developer version allows something like 25 concurrent  
connections.

HTH

Dick

On Friday, January 10, 2003, at 01:36 PM, Joshua Miller wrote:

> Anyone know what the most syntactically similar RDBMS to SQL Server is
> for Unix/Linux ?
>
> I've setup my CFMXJ2EE / JRun scenario on my Mac, but my application
> uses a SQL Server database. I'd like to install something on the Mac
> that would be pretty similar for a development environment so that I
> don't have to alter code much when moving to the staging server.
>
> Sybase? Postgre? mySQL?
>
> Thanks,
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> *** 
> *
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it  
> is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to
> 
> [EMAIL PROTECTED]
> *** 
> *
> *
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SQL Query Help - Access Lookup tables and query output not accurate - not working

[Jason Miller]

Hello List -
I can not get this query down for the life of me. After a wasted 
afternoon - I am hoping ( I know you can) someone will assist me.

I have an access table I am grabbing my information from - table - 
ModuleFeatures
ModuleFeatures contains Column iModule -WHICH is a lookup to a 
ApplicationModules table
SELECT [ApplicationModules].[iApplicationModuleID], 
[ApplicationModules].[sModuleName] FROM ApplicationModules;

and it has an iApplication colum - which again is a lookup to a 
Application table -
SELECT [ApplicationTypes].[iApplicationID], 
[ApplicationTypes].[sApplicationName] FROM ApplicationTypes;

That is the code WITHIN access. Now on coldusion - I run a simple query 
to grab these features -

SELECT iModule, iApplication, sModuleFeature FROM ModuleFeatures
ORDER BY iModule, iApplication


And the output is equally as simple -

#iModule# : within #iApplication#

  #sModuleFeature#

This outputs perfectly. And the statement above - #iModule# : within 
#iApplication# was for a test. And it outputs correctly. So what it ends 
up with is
8: within 2 -
8 in Table ApplicationModules = Medical Records
2 in Table ApplicationTypes = Financial Applications.

So instead of
8: within 2 - I need it to say
Medical Records: within Financial Applications

When I modified my simple query and alter the query to grab from both 
tables - it threw everything off.

The ONLY working solution is that I can do this... modify the output 
query (shown below )-which does the trick - but is a headache. Not to 
mention - I have to do that with iModule - and there are upwards of 30 
modules. Setting those by hand defeats the purpose of pulling from a 
database.

I know I there is a way to modify my simple query - but going on 3 hours 
of tinkering and can not get it to work right or if I get it working - 
it's not accurate.

Sorry this is long - but I figured the more info - the better someone 
can help me!
Thanks












~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

TEST - will this post make it?

[Patti G. L. Hall]

I posted a question an hour ago.  It made it to the archives, but it didn't
make it to the list.  Will this one get through?

-Patti

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: why is this a bad RegEx

[Owens, Howard]

Nevermind ... I see what I did wrong ... had the params reversed.

H.


> -Original Message-
> From: Owens, Howard [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 1:41 PM
> To:   CF-Talk
> Subject:  why is this a bad RegEx
> 
> I'm reading an XML file via CFFile.  I want to find some specified tags
> via
> regex, so I've got this:
> 
> 
[snip]
>   
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

why is this a bad RegEx

[Owens, Howard]

I'm reading an XML file via CFFile.  I want to find some specified tags via
regex, so I've got this:


newtext=xmldoc;
newText=REfindNoCase(newtext, "shl");


I get a bad RegEx error.

If I make the string a "string" then I get no error.  Why would reading the
variable newtext (or I've tried a direct ref to xmldoc) throw an error?

H.


~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Dave Watts]

> Anyone know what the most syntactically similar RDBMS to 
> SQL Server is for Unix/Linux ?
> ...
> Sybase? Postgre? mySQL?

Sybase would be the most syntactically similar. Both use Transact-SQL, and
there are few differences.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Custom Tag Usage

[brook]

Does any one know if there is custom tag that will sift through a website 
and document and dependencies used in the site, ie. com, custom tags, and 
cfx tags?

Brook

At 04:33 PM 1/10/2003 -0500, you wrote:
> > doesn't it take around 24-72 hrs for the change to take
> > effect.. thats what my account is like at mydomain.com
>
>No, not when you're using a dynamic DNS provider. That's the whole point of
>using one.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: setting persistent cookies

[Dave Watts]

> OK I've always thought that to set a persistent cookie 
> (stored on clients machine) all I had to do was use the 
> "expires" attribute in CFCOOKIE like this:
>  expires="never">
> 
> Now when I do that, I NEVER see the cookie show up in my 
> cookie directory and it's not there if I close the browser 
> and re-open it.
> 
> What might I be doing wrong?

It might not like your using the word "Session" as a cookie name. Other than
that, I don't see anything wrong with your CFCOOKIE tag.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT: Dynamic DNS

[Gaulin, Mark]

The delay will be based on the Time To Live (TTL) that is set up for your
domain.  My personal domain is served by DynDNS and the TTL is four hours,
so that is the more or less the longest time it would be wrong.  I have used
"ipconfig /flushdns" (or something like that) to clear my *local* dns cache
and so it picks up the IP change right away.  

On Windows boxes you can download one of many little clients that keep your
IP up-to-date. I use DeeEnEss. It has a setting to figure our your router's
public IP without having to talk too the router itself (I think it goes out
on the web to see what IP the request appears as). Very easy.

Mark

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 4:16 PM
To: CF-Talk
Subject: RE: OT: Dynamic DNS


doesn't it take around 24-72 hrs for the change to take effect.. thats what
my account is like at mydomain.com

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 1:09 PM
To: CF-Talk
Subject: Re: OT: Dynamic DNS


I've used dyndns for this exact purpose in the past.  I ran a Perl  
script on my server which, at a set interval, would wake up and check  
to see if my IP address had changed.  The script was able to query my  
router (Linksys BEFSR41), retrieve the new IP address and post it to  
dyndns.org where my account would be instantly updated.  It worked  
flawlessly for about a year (and still probably would be working if my  
server were still up).

All this was on a Linux server, so I don't know what kind of solutions  
are available for Windows platforms, but all the integration scripts  
were third party, so I'm sure there are plenty of solutions available.

Christian

On Friday, January 10, 2003, at 03:43 PM, Chris Alvarado wrote:

> Hello all,
>
> Sort of an off-topic post I guess, so sorry for that.
>
> However this is the most responsive / helpful list I'm on so here it
> goes.
>
> I have a domain name for myself that my company hosts the DNS for. I am
> looking for a dynamic DNS solution that will allow me to actually host
> the site on my cable access where my IP address may change etc.
>
> Here is the kicker,
>
> I have a router / firewall attached to my cable modem that also has a
> built in switch. That way I can have like 4 machines using my cable
> connection. The IP addresses for each machine as such are NATed and  
> thus
> I have the firewall set to forward all port 80 request (http) to my
> machines NATed address, this works fine except that as far as I can  
> tell
> all of the Dynamic DNS services out there set the IP address to send
> your domain requests to are of the MACHINE running their software,
> whereas the IP address on my network would actually belong to my cable
> modem.
>
> Anyone have any ideas?
>
> Thanks all,
>
> -chris.alvarado
> [ application developer ]
> 4 Guys Interactive, Inc.
> http://www.4guys.com
>
> "We create websites that make you a hero."
>
>
>
> 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Unix database syntactically similar to SQL Server?

[Joshua Miller]

Anyone know what the most syntactically similar RDBMS to SQL Server is
for Unix/Linux ?
 
I've setup my CFMXJ2EE / JRun scenario on my Mac, but my application
uses a SQL Server database. I'd like to install something on the Mac
that would be pretty similar for a development environment so that I
don't have to alter code much when moving to the staging server.
 
Sybase? Postgre? mySQL?
 
Thanks,
 
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net  
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to

[EMAIL PROTECTED]

*
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox problems, need help

[Eric Creese]

OK I think I got it now. Special thanks to everyone out there who took the time to 
help. It is much appreciated.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

setting persistent cookies

[Bryan Stevenson]

Hi All,

OK I've always thought that to set a persistent cookie (stored on clients
machine) all I had to do was use the "expires" attribute in CFCOOKIE like
this:


Now when I do that, I NEVER see the cookie show up in my cookie directory
and it's not there if I close the browser and re-open it.

What might I be doing wrong?

FYI here is my CFAPPLICATION tag for this app:


This is IE 5.5 SP2 on Win2K Professional Server with CF 5

TIA

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT: Dynamic DNS

[Dave Watts]

> doesn't it take around 24-72 hrs for the change to take 
> effect.. thats what my account is like at mydomain.com

No, not when you're using a dynamic DNS provider. That's the whole point of
using one.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT: Dynamic DNS

[Tim Do]

doesn't it take around 24-72 hrs for the change to take effect.. thats what
my account is like at mydomain.com

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 1:09 PM
To: CF-Talk
Subject: Re: OT: Dynamic DNS


I've used dyndns for this exact purpose in the past.  I ran a Perl  
script on my server which, at a set interval, would wake up and check  
to see if my IP address had changed.  The script was able to query my  
router (Linksys BEFSR41), retrieve the new IP address and post it to  
dyndns.org where my account would be instantly updated.  It worked  
flawlessly for about a year (and still probably would be working if my  
server were still up).

All this was on a Linux server, so I don't know what kind of solutions  
are available for Windows platforms, but all the integration scripts  
were third party, so I'm sure there are plenty of solutions available.

Christian

On Friday, January 10, 2003, at 03:43 PM, Chris Alvarado wrote:

> Hello all,
>
> Sort of an off-topic post I guess, so sorry for that.
>
> However this is the most responsive / helpful list I'm on so here it
> goes.
>
> I have a domain name for myself that my company hosts the DNS for. I am
> looking for a dynamic DNS solution that will allow me to actually host
> the site on my cable access where my IP address may change etc.
>
> Here is the kicker,
>
> I have a router / firewall attached to my cable modem that also has a
> built in switch. That way I can have like 4 machines using my cable
> connection. The IP addresses for each machine as such are NATed and  
> thus
> I have the firewall set to forward all port 80 request (http) to my
> machines NATed address, this works fine except that as far as I can  
> tell
> all of the Dynamic DNS services out there set the IP address to send
> your domain requests to are of the MACHINE running their software,
> whereas the IP address on my network would actually belong to my cable
> modem.
>
> Anyone have any ideas?
>
> Thanks all,
>
> -chris.alvarado
> [ application developer ]
> 4 Guys Interactive, Inc.
> http://www.4guys.com
>
> "We create websites that make you a hero."
>
>
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Joshua Miller]

Yes, _almost_ everything gets validated - unless we have a specific
browser requirement we're writing for. Trouble is we get a lot of people
(in the government especially) that use IE4 or NS4 on Windows 95 ...
Makes it tough to use the DOM and CSS properly.

We could just ignore those browsers, but our paying customers might get
miffed.

I've been trying to push browser requirements on all of our web-based
software, but the government is surprisingly stubborn about upgrading to
modern software.

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 3:50 PM
To: CF-Talk
Subject: Re: New Mac Browser


Joshua Miller wrote:
> Personally, I don't think any of us would know what to do if someone 
> made a 100% standards-compliant browser

Nothing different from what we do now. I mean, you do validate what you 
write now, right? So nothing really changes.

Things change when people decide not to bother with non-compliant 
browsers anymore (some have already passed that).

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Mosh Teitelbaum]

Isn't that what ColdFusion is for? 8^)

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 3:53 PM
> To: CF-Talk
> Subject: Re: New Mac Browser
>
>
> On Friday, January 10, 2003, at 12:37 PM, Sean A Corfield wrote:
>
> > If you want to show me something, put it on a web
> > server and send me the URL."... which is how I mostly respond to folks
> > who send me MS Office documents :)
> >
> >
>
> I like that! -- except for those pesky MS-Access documents :)
>
> Dick
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Ryan Kime]

Another to add to the mix:

ThinkFree Office
http://www.thinkfree.com/


-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 2:47 PM
To: CF-Talk
Subject: RE: New Mac Browser


Yeah, OpenOffice.org ... I run it on my Win2K machine and I've installed the
Alpha on MAC and it's going to be nice :)

My employer recently installed Office v.X on my iBook and I hate it. I
haven't had Office on my Macs for a couple years and I didn't miss it at
all. AppleWorks was capable of opening any Word document I received - I
think there were 2 last year. I equally hate AppleWorks, but it came
pre-installed.

I'm anxiously awaiting OpenOffice.org's first 1.0 for OSX!

BTW: I've been running X11 on my Mac for a while - it installs with the
OpenOffice.org alpha release. I'm going to check out the native OSX version.

Thanks,

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net [EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If you
are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and advise
us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 3:28 PM
To: CF-Talk
Subject: Re: New Mac Browser


On Friday, January 10, 2003, at 07:55 AM, Adrocknaphobia Jones wrote:

> If all they want is MS independence, then they should be working on an

> office competitor.
>
>

One of the rumored products that Apple is working on is iOffice a 
rewrite of AppleWorks for OS X,

I think that AppleWorks and MSWorks were written by many of the same 
programmers (though working for different companies, at the time).

Anyway, that should handle the needs of many users.

Also, Apple announced X11 for OS X

http://www.apple.com/macosx/x11/

I read somewhere that there is an open-source, MSOffice-compatible 
product that runs under X11 on other platforms -- so this is another 
possibility.

HTH

Dick



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox problems, need help

[Eric Creese]

Ok I am getting somewhere now. I can pass the values. Ok here is the second part of 
the puzzle. When I come back to this form to edit the users task preferences how do 
you get their current value to show up in the text box? For instance, I checked the 
ALL box and stored a 1 in my corresponding database bit field. Now I come pack to this 
page and I want to see the ALL box checked already based on the data from the database.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Dynamic DNS

[Matthew Small]

You are incorrect in that thinking.  TZO.com does my dynamic ip address
forwarding and I have the exact setup you just told me about.  I have a
web server running on one of my machines behind my NAT and I have the
router configured to send all port 80 traffic to that one machine. TZO's
software figures out the routable IP that your router uses for WAN
traffic and forwards your domain traffic to that IP, which of course
points to your router.

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Chris Alvarado [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 3:44 PM
To: CF-Talk
Subject: OT: Dynamic DNS

Hello all,

Sort of an off-topic post I guess, so sorry for that.

However this is the most responsive / helpful list I'm on so here it
goes.

I have a domain name for myself that my company hosts the DNS for. I am
looking for a dynamic DNS solution that will allow me to actually host
the site on my cable access where my IP address may change etc.

Here is the kicker,

I have a router / firewall attached to my cable modem that also has a
built in switch. That way I can have like 4 machines using my cable
connection. The IP addresses for each machine as such are NATed and thus
I have the firewall set to forward all port 80 request (http) to my
machines NATed address, this works fine except that as far as I can tell
all of the Dynamic DNS services out there set the IP address to send
your domain requests to are of the MACHINE running their software,
whereas the IP address on my network would actually belong to my cable
modem.

Anyone have any ideas?

Thanks all,

-chris.alvarado
[ application developer ]
4 Guys Interactive, Inc.
http://www.4guys.com 

"We create websites that make you a hero."




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: Dynamic DNS

[Christian Cantrell]

I've used dyndns for this exact purpose in the past.  I ran a Perl  
script on my server which, at a set interval, would wake up and check  
to see if my IP address had changed.  The script was able to query my  
router (Linksys BEFSR41), retrieve the new IP address and post it to  
dyndns.org where my account would be instantly updated.  It worked  
flawlessly for about a year (and still probably would be working if my  
server were still up).

All this was on a Linux server, so I don't know what kind of solutions  
are available for Windows platforms, but all the integration scripts  
were third party, so I'm sure there are plenty of solutions available.

Christian

On Friday, January 10, 2003, at 03:43 PM, Chris Alvarado wrote:

> Hello all,
>
> Sort of an off-topic post I guess, so sorry for that.
>
> However this is the most responsive / helpful list I'm on so here it
> goes.
>
> I have a domain name for myself that my company hosts the DNS for. I am
> looking for a dynamic DNS solution that will allow me to actually host
> the site on my cable access where my IP address may change etc.
>
> Here is the kicker,
>
> I have a router / firewall attached to my cable modem that also has a
> built in switch. That way I can have like 4 machines using my cable
> connection. The IP addresses for each machine as such are NATed and  
> thus
> I have the firewall set to forward all port 80 request (http) to my
> machines NATed address, this works fine except that as far as I can  
> tell
> all of the Dynamic DNS services out there set the IP address to send
> your domain requests to are of the MACHINE running their software,
> whereas the IP address on my network would actually belong to my cable
> modem.
>
> Anyone have any ideas?
>
> Thanks all,
>
> -chris.alvarado
> [ application developer ]
> 4 Guys Interactive, Inc.
> http://www.4guys.com
>
> "We create websites that make you a hero."
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Jochem van Dieten]

Joshua Miller wrote:
> Personally, I don't think any of us would know what to do if someone
> made a 100% standards-compliant browser

Nothing different from what we do now. I mean, you do validate what you 
write now, right? So nothing really changes.

Things change when people decide not to bother with non-compliant 
browsers anymore (some have already passed that).

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Dick Applebaum]

On Friday, January 10, 2003, at 12:37 PM, Sean A Corfield wrote:

> If you want to show me something, put it on a web
> server and send me the URL."... which is how I mostly respond to folks
> who send me MS Office documents :)
>
>

I like that! -- except for those pesky MS-Access documents :)

Dick

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Help with a query.

[Dina Hess]

Just for the record, EXISTS can be used in Access, too.

Joe, I think the SQL statement Samuel provided would be your best bet for performance. 
In fact, it's probably safe to say that a JOIN will generally perform better than 
EXISTS and EXISTS will generally perform better than IN.

~Dina
  - Original Message - 
  From: Dina Hess 
  To: CF-Talk 
  Sent: Friday, January 10, 2003 2:07 PM
  Subject: Re: Help with a query.


  If you're using SQL Server, you could rewrite your query like this:

  SELECT s.shopperID
  FROM tblShopper s
  WHERE NOT EXISTS (SELECT * FROM tblorder o where o.shopperID = s.shopperID)

  ~Dina



  - Original Message - 
From: Eric Creese 
To: CF-Talk 
Sent: Friday, January 10, 2003 10:15 AM
Subject: Help with a query.


I would do the following

SELECT tblShopper.shopperID
FROM tblShopper
WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)

Not sure what DB your using but using a NOT and or a DISTINCT can slow 
performance. Also your distinct appeared to be in the wrong place, I am guessing the 
tblShopper.shopperid is unique so a DISTINCT there will not help you, however using it 
in the subquery makes sense since a sopper could have multiple orders. Truthfully 
though you could eliminate it from the subquery as well.

  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Checkbox problems, need help

[Luce, Greg]

Eric, I must've missed a post. Explain your problem a little.

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 2:39 PM
To: CF-Talk
Subject: Checkbox problems, need help


I am a little confused on this. Where do I set the CFPARAM? Is it in the
action page. Also when I check the box and pass to the action page the form
outputs a 0 for the value when I was expecting a 1

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Joshua Miller]

Yeah, OpenOffice.org ... I run it on my Win2K machine and I've installed
the Alpha on MAC and it's going to be nice :)

My employer recently installed Office v.X on my iBook and I hate it. I
haven't had Office on my Macs for a couple years and I didn't miss it at
all. AppleWorks was capable of opening any Word document I received - I
think there were 2 last year. I equally hate AppleWorks, but it came
pre-installed.

I'm anxiously awaiting OpenOffice.org's first 1.0 for OSX!

BTW: I've been running X11 on my Mac for a while - it installs with the
OpenOffice.org alpha release. I'm going to check out the native OSX
version.

Thanks,

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 3:28 PM
To: CF-Talk
Subject: Re: New Mac Browser


On Friday, January 10, 2003, at 07:55 AM, Adrocknaphobia Jones wrote:

> If all they want is MS independence, then they should be working on an

> office competitor.
>
>

One of the rumored products that Apple is working on is iOffice a 
rewrite of AppleWorks for OS X,

I think that AppleWorks and MSWorks were written by many of the same 
programmers (though working for different companies, at the time).

Anyway, that should handle the needs of many users.

Also, Apple announced X11 for OS X

http://www.apple.com/macosx/x11/

I read somewhere that there is an open-source, MSOffice-compatible 
product that runs under X11 on other platforms -- so this is another 
possibility.

HTH

Dick


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: Dynamic DNS

[Chris Alvarado]

Hello all,

Sort of an off-topic post I guess, so sorry for that.

However this is the most responsive / helpful list I'm on so here it
goes.

I have a domain name for myself that my company hosts the DNS for. I am
looking for a dynamic DNS solution that will allow me to actually host
the site on my cable access where my IP address may change etc.

Here is the kicker,

I have a router / firewall attached to my cable modem that also has a
built in switch. That way I can have like 4 machines using my cable
connection. The IP addresses for each machine as such are NATed and thus
I have the firewall set to forward all port 80 request (http) to my
machines NATed address, this works fine except that as far as I can tell
all of the Dynamic DNS services out there set the IP address to send
your domain requests to are of the MACHINE running their software,
whereas the IP address on my network would actually belong to my cable
modem.

Anyone have any ideas?

Thanks all,

-chris.alvarado
[ application developer ]
4 Guys Interactive, Inc.
http://www.4guys.com 

"We create websites that make you a hero."



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[John Paul Ashenfelter]

>
> I read somewhere that there is an open-source, MSOffice-compatible
> product that runs under X11 on other platforms -- so this is another
> possibility.
>

OpenOffice.org has the final beta for Mac out.

> HTH
>
> Dick
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox problems, need help

[Eric Creese]

I am a little confused on this. Where do I set the CFPARAM? Is it in the action page. 
Also when I check the box and pass to the action page the form outputs a 0 for the 
value when I was expecting a 1
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Sean A Corfield]

On Friday, Jan 10, 2003, at 08:42 US/Pacific, Drew Harris wrote:
> http://www.apple.com/keynote/
> http://www.apple.com/ical/
> http://www.apple.com/macosx/jaguar/mail.html
>
> Looks to me like they already are headed that way.

Well, you can certainly survive on a Mac without MS Office... until 
someone sends you a Word document or an Excel spreadsheet... But then 
Scott McNealy said some years back (something like) "I'm trying to ban 
email attachments. If you want to show me something, put it on a web 
server and send me the URL."... which is how I mostly respond to folks 
who send me MS Office documents :)

p.s. don't forget the integration between iCal, Mail and iSync, Address 
Book, iChat, Safari - they all work together as a well-integrated suite.

Sean

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox problems, need help

[Eric Creese]

The extra view_DB was A typo when I was composing the email
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Case Sensitive SQL JOIN

[John Paul Ashenfelter]

There's several ways to do this. A decent starting point is here:

http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

Basically, the options are:

play with collation order and collation functions/clauses (or change the
collation of the database)
use binary comparisons which *are* case sensitive

I think the second is probably easier. Something like
SELECT *
FROM a INNER JOIN b ON (CAST(a.id as binary(255))=CAST(b.id as binary(255)))
or maybe with a checksum which *may* be faster
FROM a INNER JOIN b ON (BINARY_CHECKSUM(a.id)=BINARY_CHECKSUM(b.id))

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 3:10 PM
Subject: Case Sensitive SQL JOIN


> Hi All,
>
> Using SQLServer2k, is there a way to do a case sensitive join? *my
> SQLServer2k server is setup not to be case sensitive.
>
> The reason I ask is because I am pulling data from an external data feed
> that has a unique identifier that is case sensitive.
>
> Its a very large query and I need to perform this function in the SQL?
>
> Duane
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Case Sensitive SQL JOIN

[ksuh]

Yes.

convert(varbinary, 'a') = convert(varbinary, 'A')

- Original Message -
From: Duane Boudreau <[EMAIL PROTECTED]>
Date: Friday, January 10, 2003 1:10 pm
Subject: Case Sensitive SQL JOIN

> Hi All,
> 
> Using SQLServer2k, is there a way to do a case sensitive join? *my
> SQLServer2k server is setup not to be case sensitive.
> 
> The reason I ask is because I am pulling data from an external 
> data feed
> that has a unique identifier that is case sensitive.
> 
> Its a very large query and I need to perform this function in the SQL?
> 
> Duane
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFLOGIN, Web Server Auth, Timeout and unwanted caching

[Patti G. L. Hall]

I am using web server authentication to authenticate users entering my site.

I am then using cflogin and queries to authorize their access.

I am seeing problems. If I allow a cflogout tag to process it gets rid of
the users roles just fine... But it does not trigger the cflogin tag to run
the authorization queries again.  This seems to be related to the cflogin
tag's idletimeout attribute and maybe a caching behavior that I can see
evidence of, but have no idea exactly how its happening.

I want to match the cflogin idletimeout to my session timeout.  I am setting
some session variables inside the cflogin tag, for site personalization uses
mainly.  If I expire the session variables early then I am finding that the
cflogin tag is never re-activating, thus resetting the session variables...
Even if the user closes their browser and goes through the web server
authentication process again.

Lets say that I decide never to allow the session variables to be cleared
and they only expire naturally ... And lets also assume that I don't use a
cflogout tag and let the login timeout expire naturally.  Then I am still
seeing a problem when the user closes the browser and re-authenticates
through the web browser popup. Using a *different* username and password,
the cflogin tag still does not run and the session variables remain set to
the last entered.  Not good.

For shits and giggles, I set the cflogin timeout value to 1 second.  This
works.  The cflogin tag *always* runs the code between its  and
 tags (pretty much, you've got to be a fast clicker for it not to)
and as such always pickes up the newest and best info.  Great.  But I
shouldn't have to run the cflogin tag every time, should I?  This is why it
seems to me that the cflogin tag is caching the info somehow.  I have known
about the problem with using application authentication and naming your
formfields j_username and j_password.  I ran into that problem months ago.
Yet, since I'm using web auth, that ain't my problem.

One thing to note:  In my code I have a condition that fires when the user's
does NOT pass authorization.  I display a particular template.  This
template always seems to display when it should, regardless of the cflogin
timeout, cflogout tag or what have you.  So, the cflogin tag itself works...
I just can't get the crap in the middle to run when I think it should unless
I set the timeout to 1 second.

Here is a simplified version of my code (original cflogin timeout included).





  
 

... Stuff ...




This is where the session variables should be set







Set User roles










Authentication data is missing.
Try to reload the page or contact the site administrator.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Dick Applebaum]

On Friday, January 10, 2003, at 07:55 AM, Adrocknaphobia Jones wrote:

> If all they want is MS independence, then they should be working on an
> office competitor.
>
>

One of the rumored products that Apple is working on is iOffice a 
rewrite of AppleWorks for OS X,

I think that AppleWorks and MSWorks were written by many of the same 
programmers (though working for different companies, at the time).

Anyway, that should handle the needs of many users.

Also, Apple announced X11 for OS X

http://www.apple.com/macosx/x11/

I read somewhere that there is an open-source, MSOffice-compatible 
product that runs under X11 on other platforms -- so this is another 
possibility.

HTH

Dick

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Adrocknaphobia Jones]

Yeah, but we're so damn close to not having to worry about browser
differences with ie6, ns7 and mozilla. (atleast closer than ever before)
This beta release throws a big wrench into it. I think Apple needs to be
careful, and put out a browser that renders exactly like the
competition. With such a small user base, companies may just say 'screw
it' we're not going to design sites for Safari.

Still the idea of all browsers meeting all of wc3s DOM and CSS standards
seems like wishful thinking.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 2:34 PM
To: CF-Talk
Subject: RE: New Mac Browser

Personally, I don't think any of us would know what to do if someone
made a 100% standards-compliant browser ... We've been so used to
hacking around this or that or working around some limitation that we'd
probably all spontaneously combust.

What's the point of this massive standards effort if companies don't
build to the specs? If sovereign nations can impose rules like "No
nuclear weapons or we'll bomb you" then it doesn't seem a far stretch to
imagine a union of companies that actually ENFORCES some level of
standards-compliance.

Honestly, if no one goes by the rules, should we really call them
"standards"?

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Fregas [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 11:32 AM
To: CF-Talk
Subject: Re: New Mac Browser


Actually they did create a "PowerPoint" type slide show app.  So it
seems maybe that is the direction they're going.  First a browser, then
a presentation app, all they need is a good spreadsheet and word
processor.

Personally, I'll root for anything that gives MS competition, even
though I love IE and .NET.  But I agree with the consensus here: Mac
better get with the standards program when the app goes from beta to
final or this developer will be giving their browser the finger.

Fregas

- Original Message -
From: "Adrocknaphobia Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 9:55 AM
Subject: RE: New Mac Browser


> Not to veer off a standards debate, but why do you think Apple is 
> getting into the browser wars? I'm mostly surprised as it looks to be 
> more trouble that it's worth for Apple.
>
> If all they want is MS independence, then they should be working on an

> office competitor.
>
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
>
>
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 8:33 AM
> To: CF-Talk
> Subject: Re: New Mac Browser
>
> Dick Applebaum wrote:
> >
> > Do you know of any browsers on any platform that conform to all the 
> > standards?
>
> Scroll up in this thread and read my first response.
>
> The point is not that support for HTML/CSS/DOM in Safari is better or 
> worse as in the offerings of the competition. I don't know if it is 
> (but
>
> I would like to know).
> The point is that I find it bizarre that the official test suite does 
> not render due to a minor bug. To me, that means they didn't use the 
> official test suite, which makes me worry about how committed they
> *really* are to producing a standards compliant browser. Because at 
> the same time some salesdroid has put the following text online: "Rest

> assured, Safari renders Web pages properly according to the latest 
> Internet standards."
>
> Jochem
>
>
> 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseo

Re: Checkbox problems, need help

[Christian Cantrell]

One problem is that you are looking at "form.VIEW_DB" in both of your  
if statements in your action page.  I think you meant to use  
form.VIEW_DB in one and form.view_All in the other.

See if that helps.

Christian

On Friday, January 10, 2003, at 12:26 PM, [EMAIL PROTECTED] wrote:

> I have a form where a user can select which types of tasks can be  
> viewed. These tasks are all check boxes. When I click on the check box  
> and submit to the processing page the value zero appears for all  
> checkboxes regardless if they are checked or not. I have tried a few  
> things and have not pinned it down yet. Included is a portion of the  
> code and if anyone could help it would be appreciated.
>
> 
>  cellspacing="1">
>   
>   View Task Types
>   
>    ALL:
>   
>   checked>
>   
>   
>   
>   DB:
>   
>   checked>
>   
>   
>   
>   
>   
> 
>  value="Submit">
> 
>
> ACTION PAGE (I am just outputing the variables that I am passing at  
> this point)
>
> 
>   
> 
>   
> 
>
> 
>   
> 
>   
> 
>
> ALL: #vALL#
> DB: #vDB#
>
>
> 
> Get your own free email account from
> http://www.popmail.com
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Help with a query.

[Dina Hess]

If you're using SQL Server, you could rewrite your query like this:

SELECT s.shopperID
FROM tblShopper s
WHERE NOT EXISTS (SELECT * FROM tblorder o where o.shopperID = s.shopperID)

~Dina



- Original Message - 
  From: Eric Creese 
  To: CF-Talk 
  Sent: Friday, January 10, 2003 10:15 AM
  Subject: Help with a query.


  I would do the following

  SELECT tblShopper.shopperID
  FROM tblShopper
  WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)

  Not sure what DB your using but using a NOT and or a DISTINCT can slow performance. 
Also your distinct appeared to be in the wrong place, I am guessing the 
tblShopper.shopperid is unique so a DISTINCT there will not help you, however using it 
in the subquery makes sense since a sopper could have multiple orders. Truthfully 
though you could eliminate it from the subquery as well.
  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Case Sensitive SQL JOIN

[Duane Boudreau]

Hi All,

Using SQLServer2k, is there a way to do a case sensitive join? *my
SQLServer2k server is setup not to be case sensitive.

The reason I ask is because I am pulling data from an external data feed
that has a unique identifier that is case sensitive.

Its a very large query and I need to perform this function in the SQL?

Duane


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Help with a query.

[Samuel R. Neff]

At 12:15 PM 1/10/2003, you wrote:
>I would do the following
>
>SELECT tblShopper.shopperID
>FROM tblShopper
>WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)

Didn't catch the original post, but you could probably to the above more 
efficiently with an outer join

SELECT S.ShopperID
FROM tblShopper S LEFT JOIN tblOrder O on S.shopperID=O.shopperID
WHERE O.orderID IS NULL

which retrieves all shoppers that do not have any orders--if that's not the 
goal here then please ignore.

HTH,

Sam

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Hosting and CFSchedule

[Paris Lundis]

you can always schedule a remote request from another box you have to 
request the URL :)

I do that for redundancy sake across boxes locally and remotely...  
also works nicely to centralize all events in one place...

-paris

Paris Lundis
Founder
Areaindex, L.L.C.
http://www.areaindex.com
http://www.pubcrawler.com
412-292-3135
[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: Thane Sherrington <[EMAIL PROTECTED]>
Date: Fri, 10 Jan 2003 14:09:18 -0400
Subject: Hosting and CFSchedule

> Can anyone recommend a good host that allows one to run CFSCHEDULE
> tasks 
> every 15 minutes or so?  I'm on CrystalTech, and while I really
> recommend 
> them, they only allow scheduled tasks every hour.
> 
> T
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX: Caching files

[Dave Watts]

> But there is no way to turn on Trusted Cache for sepecific 
> directories i.e. websites on the server..
> 
> It either runs for all, or it doesn't run at all...?

Yes, that's correct, for CFMX Professional and Enterprise. Typically, you'd
only use this setting on production servers, where people shouldn't be
monkeying around with changing individual files anyway. In my experience,
this setting does provide a worthwhile performance improvement.

If you use CFMX for J2EE, though, I imagine that you could set up separate
instances of CFMX for separate virtual servers, and configure trusted cache
for each as appropriate.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Help with a query.

[Eric Creese]

I would do the following

SELECT tblShopper.shopperID
FROM tblShopper
WHERE shopperID NOT IN (SELECT DISTINCT tblOrder.shopperid FROM tblorder)

Not sure what DB your using but using a NOT and or a DISTINCT can slow performance. 
Also your distinct appeared to be in the wrong place, I am guessing the 
tblShopper.shopperid is unique so a DISTINCT there will not help you, however using it 
in the subquery makes sense since a sopper could have multiple orders. Truthfully 
though you could eliminate it from the subquery as well.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Joshua Miller]

Personally, I don't think any of us would know what to do if someone
made a 100% standards-compliant browser ... We've been so used to
hacking around this or that or working around some limitation that we'd
probably all spontaneously combust.

What's the point of this massive standards effort if companies don't
build to the specs? If sovereign nations can impose rules like "No
nuclear weapons or we'll bomb you" then it doesn't seem a far stretch to
imagine a union of companies that actually ENFORCES some level of
standards-compliance.

Honestly, if no one goes by the rules, should we really call them
"standards"?

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Fregas [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 11:32 AM
To: CF-Talk
Subject: Re: New Mac Browser


Actually they did create a "PowerPoint" type slide show app.  So it
seems maybe that is the direction they're going.  First a browser, then
a presentation app, all they need is a good spreadsheet and word
processor.

Personally, I'll root for anything that gives MS competition, even
though I love IE and .NET.  But I agree with the consensus here: Mac
better get with the standards program when the app goes from beta to
final or this developer will be giving their browser the finger.

Fregas

- Original Message -
From: "Adrocknaphobia Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 9:55 AM
Subject: RE: New Mac Browser


> Not to veer off a standards debate, but why do you think Apple is 
> getting into the browser wars? I'm mostly surprised as it looks to be 
> more trouble that it's worth for Apple.
>
> If all they want is MS independence, then they should be working on an

> office competitor.
>
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
>
>
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 8:33 AM
> To: CF-Talk
> Subject: Re: New Mac Browser
>
> Dick Applebaum wrote:
> >
> > Do you know of any browsers on any platform that conform to all the 
> > standards?
>
> Scroll up in this thread and read my first response.
>
> The point is not that support for HTML/CSS/DOM in Safari is better or 
> worse as in the offerings of the competition. I don't know if it is 
> (but
>
> I would like to know).
> The point is that I find it bizarre that the official test suite does 
> not render due to a minor bug. To me, that means they didn't use the 
> official test suite, which makes me worry about how committed they
> *really* are to producing a standards compliant browser. Because at 
> the same time some salesdroid has put the following text online: "Rest

> assured, Safari renders Web pages properly according to the latest 
> Internet standards."
>
> Jochem
>
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Type 4 vs Type 2 DB2 drivers (was: Re: CF-Talk: Digest every 6 ho urs)

[Dave Watts]

> The better performance of Type 4 drivers is mainly when 
> compared to using a Type 1 driver. I can imagine Type 2 
> being faster as Type 4 because you can implement certain 
> features, such as a connection pool, on a lower layer 
> so if you have both CF MX and BlueDragon running on one 
> system they can share a connection pool. But unless you 
> are moving massive amounts of data around, the difference 
> in processing speed of normal queries should be marginal. 
> If you have a query taking 100 ms, of which 80 ms in the 
> database and 20 ms in the JDBC layer, a 50% faster JDBC 
> layer will only result in a 10% faster query.

For most deployments I've seen, this wouldn't be an issue, since you
wouldn't be running multiple app servers on a single machine. I'd be happy
to shave 10 ms off of every query running on a production server, though.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: trigger problem SOLVED

[Richard Meredith-Hardy]

Nobody replied, but I found a solution.

INSERTED is effectively a temporary table.  You have to loop over this
table with a cursor 

Not an ideal solution, but in this case I am dealing with only a small
number (1-5) of inserts each time, so there is no noticeable overhead.

Richard Meredith-Hardy wrote:
> 
> Dear all
> 
> Rather than looping over a list to insert multiple log rows, it occurred
> to me that I could have a 'dummy' column in the master table so one
> inserts all logs at once thus:
> 
> UPDATE Mymaster SET mydummy = 4 WHERE mykey IN(5l,67,21)
> 
> and then have a trigger in the 'Mymaster' table which lets SQL Server
> actually insert the row in the log in its own time thus:
> 
> FOR UPDATE
> AS
> IF UPDATE(mydummy)
> INSERT INTO [dbo].[mylog]
> (mykey,mydummy)
> SELECT mykey, mydummy FROM INSERTED
> 
> This works fine if there is only one value in the IN() clause but fails
> if there is more than one; "Subquery returned more than 1 value"
> 
> I had slightly assumed triggers work on a row by row basis, but this
> would suggest they might not.  I am sure there is a simple way around
> this.  Can anyone help please?
> 
> (this is CF5 by the way)
> 
> --
> Regards;
> 
> Richard Meredith-Hardy
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Hosting and CFSchedule

[Thane Sherrington]

Can anyone recommend a good host that allows one to run CFSCHEDULE tasks 
every 15 minutes or so?  I'm on CrystalTech, and while I really recommend 
them, they only allow scheduled tasks every hour.

T

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Structure in a structure

[Dave Watts]

> Call it a rookie attempt at trying to create classes in 
> Cookie Fusion.  

Mmm, Cookie Fusion. That sounds like a product I'd come up with!

> For example, a "Customer" contains information on people 
> and companies. Companies contains information on People. 
> Invoices & Orders contain information on customers, people 
> and items. Etc.

If you're using CFMX, you might consider using CFCs for this. But even if
you don't, you might try to clearly describe the relationships between
people, customers, companies, invoices and orders. For example, I'm not sure
from reading the above description, how people, customers and companies are
related. If a customer "has a" person, and a company "has a" person, why
would a customer "have a" company?

You can place one structure within another, also.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: client mangement in MX eliminates embedded form validation

[Dave Watts]

> Where can I find more about header information and how it 
> affects pages?

I neglected to answer this question in my reply, so here goes. You can read
the HTTP specification for this information, or if you'd like something a
little less dry, O'Reilly has both an HTTP pocket reference and "HTTP: The
Definitive Guide", which I saw in the bookstore last night - it looked
pretty good.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox problems, need help

[ecreese]

I have a form where a user can select which types of tasks can be viewed. These tasks 
are all check boxes. When I click on the check box and submit to the processing page 
the value zero appears for all checkboxes regardless if they are checked or not. I 
have tried a few things and have not pinned it down yet. Included is a portion of the 
code and if anyone could help it would be appreciated.



 
View Task Types

 ALL:





DB:











ACTION PAGE (I am just outputing the variables that I am passing at this point)













ALL: #vALL#
DB: #vDB#



Get your own free email account from
http://www.popmail.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX Cert Study Guide in 1969!!!

[Brian Simmons]

Ah, Amazon, that's pretty funny.

CFMX Exam Buster has been available since mid-December[2002 :) ].

It has has 11 exams, topic exams, random exams, ability to save/print exams,
and over 750 questions to help you study for the real Macromedia ColdFusion
MX certification test.  You can download a demo, which includes one full
test at: http://www.centrasoft.com

Thanks,
Brian

--
Brian Simmons
[EMAIL PROTECTED]
The ultimate ColdFusion MX Certification Exam testing tool:
Check out CFMX Exam Buster at: http://www.centrasoft.com

>> Subject: CFMX Cert Study Guide in 1969!!!
>> From: Adrian Lynch <[EMAIL PROTECTED]>
>> Date: Fri, 10 Jan 2003 11:24:05 -
>> Thread:
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=204
49&forumid=4#103234
>>
>> Well it feels like I've been waiting since then!
>
> -Original Message-
> From: Gary W. Sullivan II [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2003 05:52
> To: CF-Talk
> Subject: CFMX Cert Study Guide in 1969!!!
>
>
> http://www.amazon.com/exec/obidos/tg/detail/-/0321180585

> Sometimes I just love Amazon :-)


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: MS SQL obdc data source timeout settings

[Smith, Matthew P -CONT(DYN)]

Thanks so much, John.  Exactly what I was looking for.

Matt


-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 10:23 AM
To: CF-Talk
Subject: Re: MS SQL obdc data source timeout settings

Under CF5, a timeout of "0" meant a permanent (no timeout) database
connection -- don't know for sure if this holds under CFMX, but since you're
on CF5, that's the problem.

But if you're working on a nightly backup, I wouldn't rely on the connection
timeout. If the db is unavailable during the backup, your site isn't really
available either (at least the db portions). You could use xp_cmdshell to
stop the coldfusion server (ensuring that there are no remaining cf db
connections) and then run the backup and restart the cf server all in T-SQL
(assuming appropriate permissions, etc.) Depends on the size of the
backup -- but shouldn't be more than 5 minutes. Of course, that's a long
time on a 24x7 site.

But honestly, SQL 2000 can backup a database while it is in use. Backups can
fail if you're creating/deleting database files or shrink commands, but just
having an active connection isn't a dealkiller. I'm running one right now on
a reporting database (2.5 GB) while a couple of huge reports are running (11
table joins, including composite keys of text fields -- don't ask) and it's
working fine. There are 34 connections, 5 users, and about 8 running/runable
tasks.  And I'm doing sp_who, etc to check these things while the backup is
running.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: site-wide error handler

[Mahmut Basaran]

Hi All,

I'm sorry for the confusion, I was trying to setup a site-wide error handler
in cf administration. I did but it doesn't work. This is what did:

1) made a template called handleOurErrors.cfm in /sitewide
2) put /sitewide/handleOurErrors.cfm in cfadmin -> settings -> sitewide box
3) call a bad template to see the results.

The code in handleOurErrors.cfm is:

"Something is wrong, blah blah."

#error.variablesHere#


Problem is, cf doesn't like it. It says "error occured in site-wide
handler".  After noticing that problem, I added a  tag to the errorhandler
template. But this time, it doesn't process any coldfusion except displaying
the error.variables.

Any ideas?


- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 8:24 AM
Subject: RE: site-wide error handler


> > I think that is different to what Mahmut is looking for
> >
> > Look in the /wwwroot/WEB_INF/web.xml
> > where you can specify handlers
> > eg
> > 
> > 500
> >
> > /WEB-INF/exception/java/lang/Exception.cfm
> > 
>
> I think that's also different from what Mahmut is looking for!
>
> Within the CF Administrator, you can specify a site-wide error handler on
> the Settings page. That's not the same as changing the path to default
error
> handlers in the web.xml file. The files specified in web.xml will be used
if
> there's an error in your site-wide error handler, or if you don't specify
a
> site-wide error handler in the CF Administrator and don't catch the error
> with CFERROR or exception handling.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: client mangement in MX eliminates embedded form validation

[Dave Watts]

> I see that much more time info is being passed to the 
> header when clientmanagement is enabled. Wonder what 
> it is that causes the caching behavior? (Had the same 
> thing happen with Netscape, too.)

Out of curiosity, do you have your client variable repository configured to
disable global client variable updates? I have a suspicion that if you
enable that option, it may stop telling the browser not to cache pages.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Rendering HTML formatting in Table CF4

[Dave Watts]

> I have an Access memo field storing paragraphs. I have CF 
> outputting the field. I want to have some formatting in 
> the output (eg. a hyperlink, Bold or Italics). I did this 
> locally (CF MX) with the function URLDecode.
> 
> However, my ISP server is CF 4.0 and it won't render. 
> Could someone suggest a work around for me until they 
> upgrade?

It sounds to me like you're not storing literal HTML formatting instructions
in your data, but rather escaped HTML. Why not just store unescaped HTML?

If that's not an option, you might use a custom tag to perform the
unescaping for you. Someone might have already done this, or you might have
to write your own. Basically, this custom tag would find each escape
character sequence and replace it with the matching literal HTML character. 

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Type 4 vs Type 2 DB2 drivers (was: Re: CF-Talk: Digest every 6 ho urs)

[Jochem van Dieten]

Dave Watts wrote:
> 
> That's very interesting. In general, most of the things I'd heard in the
> past with regard to other databases recommended the use of Type 4 drivers
> because they'd provide better performance by not having to talk to a
> middleware layer. I'd assume that the IBM folks know best when it comes to
> DB2, though.

The better performance of Type 4 drivers is mainly when compared to 
using a Type 1 driver.
I can imagine Type 2 being faster as Type 4 because you can implement 
certain features, such as a connection pool, on a lower layer so if you 
have both CF MX and BlueDragon running on one system they can share a 
connection pool. But unless you are moving massive amounts of data 
around, the difference in processing speed of normal queries should be 
marginal. If you have a query taking 100 ms, of which 80 ms in the 
database and 20 ms in the JDBC layer, a 50% faster JDBC layer will only 
result in a 10% faster query.

The reason for the popularity of Type 4 drivers is that they are 
portable. They only depend on the presence of a JRE, which is pretty 
much guaranteed when working with Java. A Type 2 driver is written in a 
combination of Java and C, so you just have to be lucky there is one 
available for you when running Mac OS or some other less common platform.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: client mangement in MX eliminates embedded form validation

[Dave Watts]

> Thanks so much, Dave! After quick test, using the 
> cfheader seems to solve the problem. Man, I've been 
> pulling my hair out about this and now it's as 
> easy as adding one line of code!
> 
> I see that much more time info is being passed to the 
> header when clientmanagement is enabled. Wonder what 
> it is that causes the caching behavior? (Had the same 
> thing happen with Netscape, too.)

You're welcome! I haven't looked at the headers myself lately, but I imagine
that it might be setting an If-Modified-Since header or something along
those lines.

> Any downside to doing the cfheader for cache control 
> you recommended?

I'm sure there is, if you use it globally, but I haven't run into any
specific problems yet. A very good friend of mine had a similar problem with
a production server he has to maintain, and I made the same suggestion to
him. He put it into Application.cfm (he didn't have time to put it in the
appropriate scripts) and so far hasn't had any problem yet, and it's been
there in a production environment for almost two weeks.

If it weren't for that friend of mine, I wouldn't have thought of
recommending this to you, so he deserves some of the thanks as well!

> Thanks again!
> (Your help has encouraged me to try to come to the 
> Fig Leaf summer conference again this year! :)

Excellent! I hope to see you there!

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Drew Harris]

http://www.apple.com/keynote/
http://www.apple.com/ical/
http://www.apple.com/macosx/jaguar/mail.html

Looks to me like they already are headed that way.

-Drew


On 1/10/03 9:55 AM, "Adrocknaphobia Jones" <[EMAIL PROTECTED]> wrote:

> If all they want is MS independence, then they should be working on an
> office competitor.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: New Mac Browser

[Fregas]

Actually they did create a "PowerPoint" type slide show app.  So it seems
maybe that is the direction they're going.  First a browser, then a
presentation app, all they need is a good spreadsheet and word processor.

Personally, I'll root for anything that gives MS competition, even though I
love IE and .NET.  But I agree with the consensus here: Mac better get with
the standards program when the app goes from beta to final or this developer
will be giving their browser the finger.

Fregas

- Original Message -
From: "Adrocknaphobia Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 9:55 AM
Subject: RE: New Mac Browser


> Not to veer off a standards debate, but why do you think Apple is
> getting into the browser wars? I'm mostly surprised as it looks to be
> more trouble that it's worth for Apple.
>
> If all they want is MS independence, then they should be working on an
> office competitor.
>
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
>
>
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 8:33 AM
> To: CF-Talk
> Subject: Re: New Mac Browser
>
> Dick Applebaum wrote:
> >
> > Do you know of any browsers on any platform that conform to all the
> > standards?
>
> Scroll up in this thread and read my first response.
>
> The point is not that support for HTML/CSS/DOM in Safari is better or
> worse as in the offerings of the competition. I don't know if it is (but
>
> I would like to know).
> The point is that I find it bizarre that the official test suite does
> not render due to a minor bug. To me, that means they didn't use the
> official test suite, which makes me worry about how committed they
> *really* are to producing a standards compliant browser. Because at the
> same time some salesdroid has put the following text online: "Rest
> assured, Safari renders Web pages properly according to the latest
> Internet standards."
>
> Jochem
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX Performance

[Dave Watts]

> > > This is CFMX Pro, not any of the J2EE versions.
> >
> > That doesn't make any significant difference for your 
> > purposes, I don't think.
> 
> According to what I have read, CFMX for J2EE has been 
> optimized to perform better and scale better than CFMX 
> Standalone -- especially for multiple-CPU systems (you 
> pay more, you get more -- fair enough!).

I've heard the same thing, but haven't really seen any good, thorough
explanations about what's exactly different. In any case, I don't think it
would make any difference for the test run by the original poster.

> But the performance test seems to bear (or is that bare) 
> this out.

No, it's "bear" - you were right to begin with.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: MS SQL obdc data source timeout settings

[John Paul Ashenfelter]

Under CF5, a timeout of "0" meant a permanent (no timeout) database
connection -- don't know for sure if this holds under CFMX, but since you're
on CF5, that's the problem.

But if you're working on a nightly backup, I wouldn't rely on the connection
timeout. If the db is unavailable during the backup, your site isn't really
available either (at least the db portions). You could use xp_cmdshell to
stop the coldfusion server (ensuring that there are no remaining cf db
connections) and then run the backup and restart the cf server all in T-SQL
(assuming appropriate permissions, etc.) Depends on the size of the
backup -- but shouldn't be more than 5 minutes. Of course, that's a long
time on a 24x7 site.

But honestly, SQL 2000 can backup a database while it is in use. Backups can
fail if you're creating/deleting database files or shrink commands, but just
having an active connection isn't a dealkiller. I'm running one right now on
a reporting database (2.5 GB) while a couple of huge reports are running (11
table joins, including composite keys of text fields -- don't ask) and it's
working fine. There are 34 connections, 5 users, and about 8 running/runable
tasks.  And I'm doing sp_who, etc to check these things while the backup is
running.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Smith, Matthew P -CONT(DYN)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 9:18 AM
Subject: MS SQL obdc data source timeout settings


> A couple of questions regarding connection timeout settings for a MS SQL
2K
> obdc data source:
>
> While trying to run a backup job on the db, the job said that it was
unable
> to go into single-user mode because of the cf connection.  This was
without
> any activity on the site, and profiler shows that the CF account was
> maintaining the connection.  After checking the data source settings in cf
> administrator, I noticed that the connection timeout was set to 0 minutes
> for several of the data sources.
>
> So, would having the connection timeout set to 0 cause CF to maintain the
> connection indefinitely?
>
> What is the recommended setting for connection timeout?  This is a
> low-to-medium traffic intranet site.
>
> Also, this is for a CF5 server. Are the recommended settings different for
> CF MX?
>
> Thanks,
> Matthew P. Smith
> Web Developer, Object Oriented
> Naval Education & Training Professional
> Development & Technology Center
> (NETPDTC)
> (850)452-1001 ext. 1245
> [EMAIL PROTECTED]
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Matt Liotta]

Cringely writes on this very subject at
http://www.pbs.org/cringely/pulpit/pulpit20030109.html.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

> -Original Message-
> From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-
> [EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 10:54 AM
> To: CF-Talk
> Subject: RE: New Mac Browser
> 
> What would be the point?  Mac Office is THE biggest selling Office
tool
> and
> is way advanced, it would take far far too long for it happen in any
shape
> or form and I am sure the MS/Apple partnership through stock would
prevent
> a
> move... I dont think they are getting in on the browser wars, I just
think
> they are finally developing a browser for the Mac which will operate
as
> expected.
> 
> -Original Message-
> From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2003 15:55
> To: CF-Talk
> Subject: RE: New Mac Browser
> 
> 
> Not to veer off a standards debate, but why do you think Apple is
> getting into the browser wars? I'm mostly surprised as it looks to be
> more trouble that it's worth for Apple.
> 
> If all they want is MS independence, then they should be working on an
> office competitor.
> 
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
> 
> 
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 8:33 AM
> To: CF-Talk
> Subject: Re: New Mac Browser
> 
> Dick Applebaum wrote:
> >
> > Do you know of any browsers on any platform that conform to all the
> > standards?
> 
> Scroll up in this thread and read my first response.
> 
> The point is not that support for HTML/CSS/DOM in Safari is better or
> worse as in the offerings of the competition. I don't know if it is
(but
> 
> I would like to know).
> The point is that I find it bizarre that the official test suite does
> not render due to a minor bug. To me, that means they didn't use the
> official test suite, which makes me worry about how committed they
> *really* are to producing a standards compliant browser. Because at
the
> same time some salesdroid has put the following text online: "Rest
> assured, Safari renders Web pages properly according to the latest
> Internet standards."
> 
> Jochem
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: site-wide error handler

[Dave Watts]

> I think that is different to what Mahmut is looking for
> 
> Look in the /wwwroot/WEB_INF/web.xml
> where you can specify handlers
> eg
> 
>   500
>   
> /WEB-INF/exception/java/lang/Exception.cfm
>   

I think that's also different from what Mahmut is looking for!

Within the CF Administrator, you can specify a site-wide error handler on
the Settings page. That's not the same as changing the path to default error
handlers in the web.xml file. The files specified in web.xml will be used if
there's an error in your site-wide error handler, or if you don't specify a
site-wide error handler in the CF Administrator and don't catch the error
with CFERROR or exception handling.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: site-wide error handler

[E. Keith Dodd]

Tim
You're right, the Diagnostics doesn't give the offending template--as it did
in CF5. Interestingly, it gives the line number, but not the template.
Wonder if this is a KNOWN ISSUE? Makes the information a tad limited!

I hadn't noticed until just tried to make an error, as I also get the
template from:
Template: #CFError.Template#

(I find the standard error messages on MX much less valuable than on
previous versions, especially those involving a query.)

Keith

- Original Message -
From: "Tim Do" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 10:54 AM
Subject: RE: site-wide error handler


> Does your #CFError.Diagnostics# in the email show what included template
> that the error occurred in?  I just get this:
>
> ColdFusion was unable to determine the value of the parameter. This
problem
> is very likely due to the fact that either:
>
> You have misspelled the parameter name, or
> You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or
CFTABLE
> tag.
>
> The error occurred while processing an element with a general identifier
of
> (#billID#), occupying document position (77:79) to (77:86).
>
>
> -Original Message-
> From: E. Keith Dodd [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 7:45 AM
> To: CF-Talk
> Subject: Re: site-wide error handler
>
>
> Mahmut
>
> I have site-wide error on all my sites, MX included.
> Not sure what you have, but here is what I do:
> 1. In Application.cfm:
> 
> 2. Then on ErrorTemplate:
> a. Just a general statement that there has been some error and that email
is
> being sent to the webmaster.
> b. Include a CFMail (I use html as know it will be acceptable to me) to
send
> me an automatic email message about the error:
>
>[EMAIL PROTECTED]
>   subject="My site Error Message"
>   type="HTML">
>   An error was recorded on The Site's website:
>   
>   1. Error:
>   #CFError.Diagnostics#
>   
>   
>   Date/Time: #CFError.DateTime#
>   Template: #CFError.Template#
>   QueryString: #CFError.QueryString#
>   Ref: #CFError.HttpReferer#
>   Browser: #CFError.Browser#
>   Remote: #CFError.RemoteAddress#
>   
>   Time: #DateFormat(Now(),"m/d/yy")# : #TimeFormat(Now(),"h:mm tt")#
>  
>
> That way, the user gets a user-friendly message and I get an informative
> email.
>
> Hope this helps.
>
> E. Keith Dodd
> Wings of Eagles Services
> www.wingserv.com
>


-
[This E-mail scanned for viruses by declude AntiVirus Software]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX for J2EE (JRun)

[John Paul Ashenfelter]

While I can't attest specifically from the CF world, I can chime in (some)
from the Java world
-- I did some work on a pretty large WebSphere 4.0 project, IBM recommended
we use the Merant
Client/Server layer for the database (Type 2) instead of the pure Type 4
drivers that as a Java
programmer you'd expect. Database was MS SQL-Server 2000, so one could argue
that the real
problem was the poor (beta at the time) Type 4 JDBC drivers for SQL
Server but they also
vetoed JTurbo from New Atlanta, which IMHO is very stable and fast.

Of course it may also be one of those "we'll only support you if you use
what we know" sort of
situations. Sometimes hard to tell. But it sure was a royal PIA to configure
the servers w/ the
Merant product and hook it up to WS, instead of just dropping in JDBC Type 4
drivers.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 11:04 AM
Subject: RE: CFMX for J2EE (JRun)


> > We just moved to CFMX for J2EE with jrun and now we can not
> > browse our sites by their dns names, we're fine browsing by
> > ip address. I suspect this is a Jrun config problem since
> > CFMX looks ok. I've looked at all of the docs but can not
> > find any steps to fix this. Has anyone else experienced this?
> > Any suggestions to resolve this?
>
> This sounds like a problem with your web server and/or DNS. You should
> probably follow the standard processes for determining whether DNS names
> resolve properly to the correct IP addresses - ping the name, for example,
> or query the nameserver using nslookup.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Ryan Kime]

>If all they want is MS independence, then they should be working on an
office competitor.

If they stay on the Konqueror track then stay tuned. ;)


K Office


-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 9:55 AM
To: CF-Talk
Subject: RE: New Mac Browser


Not to veer off a standards debate, but why do you think Apple is getting
into the browser wars? I'm mostly surprised as it looks to be more trouble
that it's worth for Apple.

If all they want is MS independence, then they should be working on an
office competitor.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 8:33 AM
To: CF-Talk
Subject: Re: New Mac Browser

Dick Applebaum wrote:
> 
> Do you know of any browsers on any platform that conform to all the
> standards?

Scroll up in this thread and read my first response.

The point is not that support for HTML/CSS/DOM in Safari is better or 
worse as in the offerings of the competition. I don't know if it is (but

I would like to know).
The point is that I find it bizarre that the official test suite does 
not render due to a minor bug. To me, that means they didn't use the 
official test suite, which makes me worry about how committed they 
*really* are to producing a standards compliant browser. Because at the 
same time some salesdroid has put the following text online: "Rest 
assured, Safari renders Web pages properly according to the latest 
Internet standards."

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Robertson-Ravo, Neil (RX)]

ooh, I bet MS are scared... I can here the sobbing from Redmond here

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2003 16:11
To: CF-Talk
Subject: RE: New Mac Browser


>If all they want is MS independence, then they should be working on an
office competitor.

If they stay on the Konqueror track then stay tuned. ;)


K Office


-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 9:55 AM
To: CF-Talk
Subject: RE: New Mac Browser


Not to veer off a standards debate, but why do you think Apple is getting
into the browser wars? I'm mostly surprised as it looks to be more trouble
that it's worth for Apple.

If all they want is MS independence, then they should be working on an
office competitor.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 8:33 AM
To: CF-Talk
Subject: Re: New Mac Browser

Dick Applebaum wrote:
> 
> Do you know of any browsers on any platform that conform to all the
> standards?

Scroll up in this thread and read my first response.

The point is not that support for HTML/CSS/DOM in Safari is better or 
worse as in the offerings of the competition. I don't know if it is (but

I would like to know).
The point is that I find it bizarre that the official test suite does 
not render due to a minor bug. To me, that means they didn't use the 
official test suite, which makes me worry about how committed they 
*really* are to producing a standards compliant browser. Because at the 
same time some salesdroid has put the following text online: "Rest 
assured, Safari renders Web pages properly according to the latest 
Internet standards."

Jochem




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Robert Everland]

I have to agree with this one, we use a few macs here and Internet explorer
is flaky at its best. I have a case right now where IE will just stop
working with going through a Microsoft Proxy, installed Mozilla on it and it
works perfectly.

Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 10:54 AM
To: CF-Talk
Subject: RE: New Mac Browser


What would be the point?  Mac Office is THE biggest selling Office tool and
is way advanced, it would take far far too long for it happen in any shape
or form and I am sure the MS/Apple partnership through stock would prevent a
move... I dont think they are getting in on the browser wars, I just think
they are finally developing a browser for the Mac which will operate as
expected.

-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2003 15:55
To: CF-Talk
Subject: RE: New Mac Browser


Not to veer off a standards debate, but why do you think Apple is getting
into the browser wars? I'm mostly surprised as it looks to be more trouble
that it's worth for Apple.

If all they want is MS independence, then they should be working on an
office competitor.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 8:33 AM
To: CF-Talk
Subject: Re: New Mac Browser

Dick Applebaum wrote:
> 
> Do you know of any browsers on any platform that conform to all the
> standards?

Scroll up in this thread and read my first response.

The point is not that support for HTML/CSS/DOM in Safari is better or 
worse as in the offerings of the competition. I don't know if it is (but

I would like to know).
The point is that I find it bizarre that the official test suite does 
not render due to a minor bug. To me, that means they didn't use the 
official test suite, which makes me worry about how committed they 
*really* are to producing a standards compliant browser. Because at the 
same time some salesdroid has put the following text online: "Rest 
assured, Safari renders Web pages properly according to the latest 
Internet standards."

Jochem




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Type 4 vs Type 2 DB2 drivers (was: Re: CF-Talk: Digest every 6 ho urs)

[Dave Watts]

> > I don't have anything helpful to offer, so pardon me 
> > in advance for asking, but why would you want to use 
> > a Type 2 driver if you have a working Type 4 driver?
> 
> And I'm certainly no expert in this area, but here is how 
> it was explained to me by one of our DB2 people:
> 
> JDBC Type 2 drivers are a combination of Java code and 
> native code and therefore are more efficient and provide 
> top performance. JDBC Type 4 drivers are pure Java and 
> allow direct connection to the database (presumably without 
> having to have DB2 Connect installed) but are not as efficient. 
> This position is pretty much supported by this article: 
> 
> http://www7b.software.ibm.com/dmdd/library/techarticle/0203zik
> opoulos/0203zikopoulos.html

That's very interesting. In general, most of the things I'd heard in the
past with regard to other databases recommended the use of Type 4 drivers
because they'd provide better performance by not having to talk to a
middleware layer. I'd assume that the IBM folks know best when it comes to
DB2, though.

Has anyone heard similar things with regard to other database platforms? I'd
be very interested in hearing more on this topic.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Robertson-Ravo, Neil (RX)]

What would be the point?  Mac Office is THE biggest selling Office tool and
is way advanced, it would take far far too long for it happen in any shape
or form and I am sure the MS/Apple partnership through stock would prevent a
move... I dont think they are getting in on the browser wars, I just think
they are finally developing a browser for the Mac which will operate as
expected.

-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2003 15:55
To: CF-Talk
Subject: RE: New Mac Browser


Not to veer off a standards debate, but why do you think Apple is
getting into the browser wars? I'm mostly surprised as it looks to be
more trouble that it's worth for Apple.

If all they want is MS independence, then they should be working on an
office competitor.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 8:33 AM
To: CF-Talk
Subject: Re: New Mac Browser

Dick Applebaum wrote:
> 
> Do you know of any browsers on any platform that conform to all the 
> standards?

Scroll up in this thread and read my first response.

The point is not that support for HTML/CSS/DOM in Safari is better or 
worse as in the offerings of the competition. I don't know if it is (but

I would like to know).
The point is that I find it bizarre that the official test suite does 
not render due to a minor bug. To me, that means they didn't use the 
official test suite, which makes me worry about how committed they 
*really* are to producing a standards compliant browser. Because at the 
same time some salesdroid has put the following text online: "Rest 
assured, Safari renders Web pages properly according to the latest 
Internet standards."

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Adding All to cfselect

[John Paul Ashenfelter]

One more, slighly strange suggestion, is to add the option value to the CF
query object using the query manipulation functions (queryAddRow, etc). Then
just use the adjusted query in CFSELECT. A little work on this approach
let's you position the default at the beginning if that's a requirement.
Probably more of a "stupid CF trick" since simply adding the HTML 
works just fine :)

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Luis Lebron" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 12:24 PM
Subject: RE: Adding All to cfselect


> In my case I added
>
> All
>
>
> to make it the default option.
>
> thanks,
>
> Luis
>
> -Original Message-
> From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 10:00 AM
> To: CF-Talk
> Subject: RE: Adding All to cfselect
>
>
> You can manually include any options you want between the start and end
tags
> as in:
>
> 
> All
> 
>
> Unfortunately, these manually added options will only appear at the bottom
> of the list.
>
> Alternatively, you can use JavaScript to add items to the list once the
code
> is received by the client.  However, not all browsers... blah blah blah.
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 625-9191
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
>
> > -Original Message-
> > From: Luis Lebron [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 09, 2003 10:43 AM
> > To: CF-Talk
> > Subject: Adding All to cfselect
> >
> >
> > I want to use cfselect to dynamically generate select boxes,
> > however I also
> > need to have an "All" option as part of the select. Is there any
> > easy way to
> > do this other than adding "All" to the database field?
> >
> >
> > thanks,
> >
> > Luis R. Lebron
> > Project Manager
> > Sigmatech, Inc
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX for J2EE (JRun)

[Dave Watts]

> We just moved to CFMX for J2EE with jrun and now we can not 
> browse our sites by their dns names, we're fine browsing by 
> ip address. I suspect this is a Jrun config problem since 
> CFMX looks ok. I've looked at all of the docs but can not 
> find any steps to fix this. Has anyone else experienced this? 
> Any suggestions to resolve this?

This sounds like a problem with your web server and/or DNS. You should
probably follow the standard processes for determining whether DNS names
resolve properly to the correct IP addresses - ping the name, for example,
or query the nameserver using nslookup.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: site-wide error handler

[webguy]

I think that is different to what Mahmut is looking for

Look in the /wwwroot/WEB_INF/web.xml
where you can specify handlers
eg

500
/WEB-INF/exception/java/lang/Exception.cfm


wg

> -Original Message-
> From: E. Keith Dodd [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2003 15:45
> To: CF-Talk
> Subject: Re: site-wide error handler
>
>
> Mahmut
>
> I have site-wide error on all my sites, MX included.
> Not sure what you have, but here is what I do:
> 1. In Application.cfm:
> 
> 2. Then on ErrorTemplate:
> a. Just a general statement that there has been some error and
> that email is
> being sent to the webmaster.
> b. Include a CFMail (I use html as know it will be acceptable to
> me) to send
> me an automatic email message about the error:
>
>[EMAIL PROTECTED]
>   subject="My site Error Message"
>   type="HTML">
>   An error was recorded on The Site's website:
>   
>   1. Error:
>   #CFError.Diagnostics#
>   
>   
>   Date/Time: #CFError.DateTime#
>   Template: #CFError.Template#
>   QueryString: #CFError.QueryString#
>   Ref: #CFError.HttpReferer#
>   Browser: #CFError.Browser#
>   Remote: #CFError.RemoteAddress#
>   
>   Time: #DateFormat(Now(),"m/d/yy")# : #TimeFormat(Now(),"h:mm tt")#
>  
>
> That way, the user gets a user-friendly message and I get an informative
> email.
>
> Hope this helps.
>
> E. Keith Dodd
> Wings of Eagles Services
> www.wingserv.com
>
> - Original Message -
> From: "Mahmut Basaran" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, January 10, 2003 8:17 PM
> Subject: site-wide error handler
>
>
> > Hi All,
> >
> > I'm trying to implement a site-wide error handler. Although it
> works with
> a static page (an error occured etc..), I had no luck with
> putting cf logic
> into the error handler (cfmail).
> >
> > Has anyone successfuly implemented this in cf mx ?
> >
> > Thank you,
> >
> > Mahmut
> >
> >
>
>
> -
> [This E-mail scanned for viruses by declude AntiVirus Software]
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX for J2EE (JRun)

[webguy]

have you looked at these ?

http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/connector
s8.jsp#1124974

http://www.macromedia.com/v1/handlers/index.cfm?ID=23407&Method=Full&PageCal
l=/support/index.cfm

http://www.macromedia.com/v1/handlers/index.cfm?ID=23390&Method=Full&PageCal
l=/support/index.cfm


WG

> -Original Message-
> From: Steven Lynch [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2003 14:56
> To: CF-Talk
> Subject: CFMX for J2EE (JRun)
>
>
> We just moved to CFMX for J2EE with jrun and now we can not
> browse our sites by their dns names, we're fine browsing by ip
> address. I suspect this is a Jrun config problem since CFMX looks
> ok. I've looked at all of the docs but can not find any steps to
> fix this. Has anyone else experienced this? Any suggestions to
> resolve this?
> Steve
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: site-wide error handler

[Tim Do]

Does your #CFError.Diagnostics# in the email show what included template
that the error occurred in?  I just get this:

ColdFusion was unable to determine the value of the parameter. This problem
is very likely due to the fact that either: 

You have misspelled the parameter name, or 
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE
tag.

The error occurred while processing an element with a general identifier of
(#billID#), occupying document position (77:79) to (77:86).


-Original Message-
From: E. Keith Dodd [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 7:45 AM
To: CF-Talk
Subject: Re: site-wide error handler


Mahmut

I have site-wide error on all my sites, MX included.
Not sure what you have, but here is what I do:
1. In Application.cfm:

2. Then on ErrorTemplate:
a. Just a general statement that there has been some error and that email is
being sent to the webmaster.
b. Include a CFMail (I use html as know it will be acceptable to me) to send
me an automatic email message about the error:


  An error was recorded on The Site's website:
  
  1. Error:
  #CFError.Diagnostics#
  
  
  Date/Time: #CFError.DateTime#
  Template: #CFError.Template#
  QueryString: #CFError.QueryString#
  Ref: #CFError.HttpReferer#
  Browser: #CFError.Browser#
  Remote: #CFError.RemoteAddress#
  
  Time: #DateFormat(Now(),"m/d/yy")# : #TimeFormat(Now(),"h:mm tt")#
 

That way, the user gets a user-friendly message and I get an informative
email.

Hope this helps.

E. Keith Dodd
Wings of Eagles Services
www.wingserv.com

- Original Message -
From: "Mahmut Basaran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 8:17 PM
Subject: site-wide error handler


> Hi All,
>
> I'm trying to implement a site-wide error handler. Although it works with
a static page (an error occured etc..), I had no luck with putting cf logic
into the error handler (cfmail).
>
> Has anyone successfuly implemented this in cf mx ?
>
> Thank you,
>
> Mahmut
>
>


-
[This E-mail scanned for viruses by declude AntiVirus Software]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Mac Browser

[Adrocknaphobia Jones]

Not to veer off a standards debate, but why do you think Apple is
getting into the browser wars? I'm mostly surprised as it looks to be
more trouble that it's worth for Apple.

If all they want is MS independence, then they should be working on an
office competitor.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 10, 2003 8:33 AM
To: CF-Talk
Subject: Re: New Mac Browser

Dick Applebaum wrote:
> 
> Do you know of any browsers on any platform that conform to all the 
> standards?

Scroll up in this thread and read my first response.

The point is not that support for HTML/CSS/DOM in Safari is better or 
worse as in the offerings of the competition. I don't know if it is (but

I would like to know).
The point is that I find it bizarre that the official test suite does 
not render due to a minor bug. To me, that means they didn't use the 
official test suite, which makes me worry about how committed they 
*really* are to producing a standards compliant browser. Because at the 
same time some salesdroid has put the following text online: "Rest 
assured, Safari renders Web pages properly according to the latest 
Internet standards."

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: site-wide error handler

[E. Keith Dodd]

Mahmut

I have site-wide error on all my sites, MX included.
Not sure what you have, but here is what I do:
1. In Application.cfm:

2. Then on ErrorTemplate:
a. Just a general statement that there has been some error and that email is
being sent to the webmaster.
b. Include a CFMail (I use html as know it will be acceptable to me) to send
me an automatic email message about the error:


  An error was recorded on The Site's website:
  
  1. Error:
  #CFError.Diagnostics#
  
  
  Date/Time: #CFError.DateTime#
  Template: #CFError.Template#
  QueryString: #CFError.QueryString#
  Ref: #CFError.HttpReferer#
  Browser: #CFError.Browser#
  Remote: #CFError.RemoteAddress#
  
  Time: #DateFormat(Now(),"m/d/yy")# : #TimeFormat(Now(),"h:mm tt")#
 

That way, the user gets a user-friendly message and I get an informative
email.

Hope this helps.

E. Keith Dodd
Wings of Eagles Services
www.wingserv.com

- Original Message -
From: "Mahmut Basaran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 8:17 PM
Subject: site-wide error handler


> Hi All,
>
> I'm trying to implement a site-wide error handler. Although it works with
a static page (an error occured etc..), I had no luck with putting cf logic
into the error handler (cfmail).
>
> Has anyone successfuly implemented this in cf mx ?
>
> Thank you,
>
> Mahmut
>
>


-
[This E-mail scanned for viruses by declude AntiVirus Software]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: parent - child relations

[webguy]

Although I believe that there are lots of reason why you should do this in
the db (outlined in my last mail regarding this) , if you are using XML and
you want to do calculations, its very easy in XSLT or using the cf XML
functions ..

for example to sum up subtotals in invoices

the xPath function

sum(/customer/invoice/subtotal) does the trick

WG

> Although xml is the proper way to display data, I need to calculate data.
> I'm still working on it. If I come up with anything (hopefully)
> I'm going to
> post it to the forums.
>
> Thanks everyone,
> Mahmut

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4