mySQL / ODBC / Windows problem

[Neil Clark =TMM=]

OK, problem 

I am running an app which states it supports mySQL, but I am getting
error on only one page where an update occurs.  The code is encrypted so
I cannot see what and where it is at the mo.

I am running : 

Windows 2000 Server SP2 [SRP1]
IIS 5
ColdFusion 5 Enterprise Edition
mySQl 3.23.49
myODBC 2.50.39

The makers of the system suggested that I use the Merant Drivers, but I
am on WINDOWS! - I know there are drivers for the Windows system, but I
am unsure on what version to use.

Anyone have experience with this?

Neil


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[Craig Dudley]

What ???

XPHOME is NOT, I repeat, NOT based on Windows98

It is based on the same NT core as XP Pro and Windows 2k before that.

Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you can
read instructions correctly), it has a smaller memory footprint than IIS and
theoretically is more secure as well, so WHY on earth would you want IIS? 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 11:18 PM
To: CF-Talk
Subject: RE: web server for XP home?

Yes.

XP Home = Windows 9x.
XP Pro = NTx/2K Workstation.
NET = NTx/2000 Server

That's it.

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




-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:48 PM
To: CF-Talk
Subject: RE: web server for XP home?


you cannot join a domain with XP Home? Are you sure about this? 

On Tue, 26 Mar 2002, Tyler M. Fitch wrote:

> Robert,
> 
> I'm chiming in here after the storm has settled, but I'd like to add a
> feature between XP Home and XP Pro that you get for your $100.
> 
> The ability to join a domain.
> 
> If you're at home and you're just you then save the $100 and get XP
> Home, run Apache for the webserver.  It will work.  If you're in a
> corporate environment or you have a nice home network with an actual
> domain not just a workgroup then you'll want XP Pro.
> 
> Cheers,
> 
> t
> 
> **
> Tyler M. Fitch
> Certified Advanced ColdFusion 5 Developer
> http://isitedesign.com
> ** 
> 
> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, March 26, 2002 8:40 AM
> To: CF-Talk
> Subject: RE: web server for XP home?
> 
> 
>   Well then why not just not install it. I see what you're saying
> about security, but if they are a home user and they don't need it, they
> probably wouldn't even know how to install it. It sucks that when I want
> a new computer now, I will have get professional and pay $100 just to
> get IIS.
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 11:42 AM
> To: CF-Talk
> Subject: RE: web server for XP home?
> 
> 
> > I do find it unforgiveable that Microsoft didn't include IIS
> > in XP Home, it is very shortsighted on their part.
> 
> I feel exactly the opposite. I think it would be unforgivable if
> Microsoft put a web server in a home OS. If you want to run a web
> server, you can always get one, but the vast majority of home users -
> and end-users in general - neither need to run a web server nor want to.
> Nor would they understand the potential security implications of doing
> so.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
> 


__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Another cfexecute question

[Jochem van Dieten]

Shawn McKee wrote:
> Is there any way, other than reading an output file, to get a return code
> from a command executed with cfexecute?

Wrap it in cfsavecontent.

Jochem

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[Mark Smyth]

to be honest craig its probably because most people are familiar with IIS,
but apache sounds good to me

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 09:11
To: CF-Talk
Subject: RE: web server for XP home?


What ???

XPHOME is NOT, I repeat, NOT based on Windows98

It is based on the same NT core as XP Pro and Windows 2k before that.

Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you can
read instructions correctly), it has a smaller memory footprint than IIS and
theoretically is more secure as well, so WHY on earth would you want IIS? 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 11:18 PM
To: CF-Talk
Subject: RE: web server for XP home?

Yes.

XP Home = Windows 9x.
XP Pro = NTx/2K Workstation.
NET = NTx/2000 Server

That's it.

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




-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:48 PM
To: CF-Talk
Subject: RE: web server for XP home?


you cannot join a domain with XP Home? Are you sure about this? 

On Tue, 26 Mar 2002, Tyler M. Fitch wrote:

> Robert,
> 
> I'm chiming in here after the storm has settled, but I'd like to add a
> feature between XP Home and XP Pro that you get for your $100.
> 
> The ability to join a domain.
> 
> If you're at home and you're just you then save the $100 and get XP
> Home, run Apache for the webserver.  It will work.  If you're in a
> corporate environment or you have a nice home network with an actual
> domain not just a workgroup then you'll want XP Pro.
> 
> Cheers,
> 
> t
> 
> **
> Tyler M. Fitch
> Certified Advanced ColdFusion 5 Developer
> http://isitedesign.com
> ** 
> 
> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, March 26, 2002 8:40 AM
> To: CF-Talk
> Subject: RE: web server for XP home?
> 
> 
>   Well then why not just not install it. I see what you're saying
> about security, but if they are a home user and they don't need it, they
> probably wouldn't even know how to install it. It sucks that when I want
> a new computer now, I will have get professional and pay $100 just to
> get IIS.
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 11:42 AM
> To: CF-Talk
> Subject: RE: web server for XP home?
> 
> 
> > I do find it unforgiveable that Microsoft didn't include IIS
> > in XP Home, it is very shortsighted on their part.
> 
> I feel exactly the opposite. I think it would be unforgivable if
> Microsoft put a web server in a home OS. If you want to run a web
> server, you can always get one, but the vast majority of home users -
> and end-users in general - neither need to run a web server nor want to.
> Nor would they understand the potential security implications of doing
> so.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
> 



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL lisence headaches

[Jochem van Dieten]

Ian Lurie wrote:
> Thought of that, but no stored procs, no triggers, no OLAP, and not nearly
> the performance for database-side UDFs, either.

Firebird http://firebird.sourceforge.net/
PostgreSQL   http://www.postgresql.org/
SAPDBhttp://www.sapdb.org/

Plenty of options available.

Jochem

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: mySQL / ODBC / Windows problem

[Jochem van Dieten]

Neil Clark =TMM= wrote:
> OK, problem 
> 
> I am running an app which states it supports mySQL, but I am getting
> error on only one page where an update occurs.  The code is encrypted so
> I cannot see what and where it is at the mo.

If the error is in the SQL you should be able to see what is happening 
in the db log files.

Jochem


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Locale functions and XP

[Tristram Charnley]

Heres a challenge...

I've used the steps outlined in MM's Technote 22404  to get CF5's lscurrency
format to work correctly on XP Pro but without success. The technique seems
to be for W2000 servers only.

Does anyone know how to force CF Server to use the msvcrt.dll in the
cfusion\bin directory rather than XP's system wide dll?

Tristram Charnley
---
[EMAIL PROTECTED]
Allaire Certified ColdFusion Developer





__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Run EXE File

[romulogomes]

How can i run an exe file in the server with a CFM page?

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Run EXE File

[James Maltby]

Use 

E.g.




HTH

J

-Original Message-
From: romulogomes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 09:31
To: CF-Talk
Subject: Run EXE File


How can i run an exe file in the server with a CFM page?


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Run SHELL

[romulogomes]

Can I use cfexecute to run a linux shell file?

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Run SHELL

[James Maltby]

As far as I am aware cfexecute only runs on NT and UNIX platforms - whether
that means Linux I dunno - worth a try I guess - you can use the optional
ARGUMENTS syntax to pass command-line arguments to a program, elements of
the ARGUMENTS array is copied into a corresponding array of exec() arguments
on UNIX.

Dunno if this helps...

J

-Original Message-
From: romulogomes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 10:03
To: CF-Talk
Subject: Run SHELL


Can I use cfexecute to run a linux shell file?


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[Dave Watts]

> > XP Home = Windows 9x.
> > XP Pro = NTx/2K Workstation.
> > NET = NTx/2000 Server
>
> What ???
> 
> XPHOME is NOT, I repeat, NOT based on Windows98
> 
> It is based on the same NT core as XP Pro and Windows 2k 
> before that.

I think that Scott's simply trying to draw an analogy. XP Home fills the
same niche as Windows 95/98/ME did - a home computer operating system, not
really designed for office use. XP Home apparently doesn't let you join a
domain, which is a pretty big part of office use.

> Btw, Apache runs like a DREAM on xp, it's free, easy to 
> set up (if you can read instructions correctly), it has 
> a smaller memory footprint than IIS and theoretically is 
> more secure as well, so WHY on earth would you want IIS? 

Personally, I need to work against IIS sometimes, which is why I run Windows
2000 Server for development. There are a lot of things in IIS that aren't in
Apache, although for most CF development, Apache will do nicely.

On my personal machine, I haven't found Apache to have a smaller memory
footprint than IIS, either.

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

__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFID/Token/Registry - Easy question

[Tony_Petruzzi]

the main reason you don't want to use the registry is because this could
corrupt your registry file. If that happens then server goes bye-bye. But
the most strongest argument is that client variables are used to share CF
information in a clustered environment. If you have several CF servers
clustered together and all of them are storing the client information in
their own registry, then how are is one CF going to get the client
information from another? They can't. Trust, believe me when I tell you,
setup a data source EXCLUSIVELY for you client information and ALWAYS use
it.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 5:26 PM
To: CF-Talk
Subject: RE: CFID/Token/Registry - Easy question


Why not the registry. With a limited user base of 6K users, is there a risk
involved with using the registry?

CC


 

Tony_Petruzzi

@sheriff.org To: CF-Talk
<[EMAIL PROTECTED]>   
 cc:

03/26/02 Subject: RE: CFID/Token - Easy
question   
03:38 PM

Please

respond to

cf-talk

 

 





first off should be using a datasource to store your client variables in
NOT
the registry. with that said, I usually put my setting to 7 days.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:36 PM
To: CF-Talk
Subject: CFID/Token - Easy question


What interval should you have your cfadministrator clear out the client
variable entries stored in the system registry for CFID/Token ? Right now
its set to 90 days which seems a bit long, meaning, if I log into the
application again I will be using the existing CFID/Token unless 90 days
pass before next logon. I would think you would want like a 12 hour
setting? That way if a person longs into your application the next day you
will get a new CFID/Token or is it best to have 1 person carrying around
the same CFID/Token indefinitely, assuming they logged in at least 4 times
per year under the 3 month interval?

Thanks for your input
CC




__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Run SHELL

[Stephen Galligan]

Romulogomes,

Yup you can use it to run a shell script or any other program you wish.

Here you can run a shell script called myscript




Here you can use it to call GREP




If the request doesn't have the correct privileges to run that program it
simply returns an error page.

[EMAIL PROTECTED] is a good source of info.  There is a guy there
Jesse Nolle who knows his onions.

Stephen
-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 13:07
To: CF-Talk
Subject: RE: Run SHELL


As far as I am aware cfexecute only runs on NT and UNIX platforms - whether
that means Linux I dunno - worth a try I guess - you can use the optional
ARGUMENTS syntax to pass command-line arguments to a program, elements of
the ARGUMENTS array is copied into a corresponding array of exec() arguments
on UNIX.

Dunno if this helps...

J

-Original Message-
From: romulogomes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 10:03
To: CF-Talk
Subject: Run SHELL


Can I use cfexecute to run a linux shell file?



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL lisence headaches

[Tony_Petruzzi]

version 4 of mySQL supports stored procedures. don't know if they have
trigger support yet. PostgreSQL i believe does.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 6:29 PM
To: CF-Talk
Subject: Re: SQL lisence headaches


until you need stored procs and triggers ;-)

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

- Original Message -
From: "Cary Gordon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 3:27 PM
Subject: RE: SQL lisence headaches


> We are migrating almost everything to MySQL (CF/Apache) on Linux.  We
don't
> need no stinkin processor licenses.
>
> At 02:12 PM 3/26/2002 -0800, you wrote:
> >Any opinions out there on running SQL on a single proc machine? Is it
worth
> >it? I've got a site that'll likely get 40,000+ visits in 1-2 months...
> >
> >-Original Message-
> >From: Robert Everland [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, March 26, 2002 2:06 PM
> >To: CF-Talk
> >Subject: RE: SQL lisence headaches
> >
> >
> >Do not buy a cal with it becuase you will need to buy a cal for every web
> >visitor you have, and since you will never know how many vistors you get
> >you'll end up being in violation of it. You can get a one processor
license
> >as long as you limit the processors in SQL. HTH
> >
> >Robert Everland III
> >Dixon Ticonderoga
> >Web Developer Extraordinaire
> >
> >-Original Message-
> >From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, March 26, 2002 5:03 PM
> >To: CF-Talk
> >Subject: OT: SQL lisence headaches
> >
> >
> >Hi all,
> >
> >Can someone out there explain Microsoft's SQL license scheme? I have a
> >freakin' law degree and I can't figure it out.
> >
> >Do I need to buy a 2-processor license for a dual-proc web server? Or is
a
> >CAL license enough?
> >
> >I guess I'm wondering if my ColdFusion box counts as one CAL, or whether
> >every web visitor counts as one user...
> >
> >Ian
> >
> >Portent Interactive
> >Using Process, Design and Content to create great web sites since 1995
> >Consulting, design, development, measurement
> >http://www.portentinteractive.com
> >
> >
> >
> >
> 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL lisence headaches

[Tony_Petruzzi]

I run a small search engine on CF and MSSQL server. Runs fast as hell. Just
need to know how to write good storedprocedures for performance. Like
anything, if you don't optimize it for speed, it will run dog slow.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 7:04 PM
To: CF-Talk
Subject: RE: SQL lisence headaches


On 3/26/02, Ian Lurie penned:
>Any opinions out there on running SQL on a single proc machine? Is it worth
>it? I've got a site that'll likely get 40,000+ visits in 1-2 months...

I've got 2000 running on a single PIII 833 MZ processor with 512 MB 
RAM. About 15 databases thus far, doing probably twice that many 
visitors in a month for the sites using those databases. No problems.
-- 

Bud Schneehagen - Tropical Web Creations

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

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: mySQL / ODBC / Windows problem

[Neil Clark =TMM=]

Where are the db.log files?  For mySQL or ColdFusion (if the latter, I
know where they are!)

Sorry, I am not a mySQL man.

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF 5 Support for Oracle 9i

[Chris Norloff]

We've always used Oracle Native Drivers (comes with CF).  They've worked well except 
for one version (8.1.6.2.1) that had memory leaks.

Chris Norloff

-- Original Message --
from: "Kris Pilles" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 26 Mar 2002 15:34:35 -0500

>Speaking of oracle... Anyone have any suggesstions for the best way for
>use to hook up with a unix based oracle DB.  I see they have microsoft
>odbc for oracle but I wasn't sure if that was the best method???
>
>-Original Message-
>From: Deborah Curley [mailto:[EMAIL PROTECTED]] 
>Sent: Tuesday, March 26, 2002 3:31 PM
>To: CF-Talk
>Subject: CF 5 Support for Oracle 9i
>
>
>Hi All,
>My company is interested in upgrading some of our Oracle 8.x databases
>to 
>9i. I don't see any mention of ColdFusion 5 support for 9i and just
>wanted 
>to get the official word on whether or not it is supported. If it is 
>supported are there any known issues?
>
>TIA!
>Deb
>
>
>_
>Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp.
>
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ColdFusion Listener?

[Kris Pilles]

I was curious if there is anyway to have a listener of sorts via
coldfusion.  I basically want a dynamic form of mine to verify each
field against the server as the user submits the data.  I see this done
a lot with applets and with oracle but I haven't seen anything like this
with Coldfusion?  Is it possible...if so have an example I can look at?

Thanks

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Directory War Stories

[Voris, Jim]

I would like to be able to leverage directory services (ldap, e-directory,
active directory, etc) in my cf application.

I'm curious what people have done, page level permissions basis to take
advantage of a directory.

Jim
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

HTML to PDF

[Jille Floridor]

Hi list,

anyone got some advice/hints on how to create a pdf from a html/cfm
template? I know there are various custom tags, but the server is running on
RedHat Linux, so that excludes many of them.. I've seen some java based
tags, but none of those did the job properly (adding images seems to be
difficult).

So, any ideas?

Jille

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[Jeffry Houser]

At 09:10 AM 3/27/2002 +, you wrote:

>Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you can
>read instructions correctly), it has a smaller memory footprint than IIS and
>theoretically is more secure as well, so WHY on earth would you want IIS?

  ( To set up a development identical to the live machine which you have no 
control over? )



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Anyone from Orlando not in the CFUG?

[Robert Everland]

I am co chair for our ColdFusion User Group here in Orlando, FL and
I just want to make sure that I have everyone in the Orlando area signed up
for our User Group. I am trying to get more user participation so that we
can network and get to know each other. If you're interested in joining us
go to www.cforlando.com and sign up as a member. We have monthly meetings
and we will be starting something new called CF_Beer. We will all meet up
once every couple of weeks for drinks, talking, and getting to know each
other without having to have a formal meeting or speaker. Email me off list
if you have any questions.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Raymond Camden]

As a general follow up to this - anyone NOT in a CFUG is _really_
missing out on a wonderful exprerience. I encourage everyone not
attending a CFUG to go to http://www.macromedia.com/v1/usergroups/ and
see if a UG is in your area.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, March 27, 2002 9:19 AM
> To: CF-Talk
> Subject: Anyone from Orlando not in the CFUG?
> 
> 
>   I am co chair for our ColdFusion User Group here in 
> Orlando, FL and
> I just want to make sure that I have everyone in the Orlando 
> area signed up
> for our User Group. I am trying to get more user 
> participation so that we
> can network and get to know each other. If you're interested 
> in joining us
> go to www.cforlando.com and sign up as a member. We have 
> monthly meetings
> and we will be starting something new called CF_Beer. We will 
> all meet up
> once every couple of weeks for drinks, talking, and getting 
> to know each
> other without having to have a formal meeting or speaker. 
> Email me off list
> if you have any questions.
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Jeffry Houser]

  : whine, whine, whine:   All three Connecticut ones went DOA in the past 
year.

  A quick search of the link below, Connecticut isn't even listed ( usually 
it is between Colorado and Delaware )

  It also looks like there are no Macromedia user groups in Idaho, Maine, 
Mississippi, New Hampshire, North Dakota, South Dakota, and West Virginia.

At 09:26 AM 3/27/2002 -0500, you wrote:
>As a general follow up to this - anyone NOT in a CFUG is _really_
>missing out on a wonderful exprerience. I encourage everyone not
>attending a CFUG to go to http://www.macromedia.com/v1/usergroups/ and
>see if a UG is in your area.
>
>===
>Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
>Email: [EMAIL PROTECTED]
>Yahoo IM : morpheus
>
>"My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 27, 2002 9:19 AM
> > To: CF-Talk
> > Subject: Anyone from Orlando not in the CFUG?
> >
> >
> >   I am co chair for our ColdFusion User Group here in
> > Orlando, FL and
> > I just want to make sure that I have everyone in the Orlando
> > area signed up
> > for our User Group. I am trying to get more user
> > participation so that we
> > can network and get to know each other. If you're interested
> > in joining us
> > go to www.cforlando.com and sign up as a member. We have
> > monthly meetings
> > and we will be starting something new called CF_Beer. We will
> > all meet up
> > once every couple of weeks for drinks, talking, and getting
> > to know each
> > other without having to have a formal meeting or speaker.
> > Email me off list
> > if you have any questions.
> >
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Raymond Camden]

Then I'd consider this an opportunity. ;) When I was launching the one
here in Virginia, I got a _lot_ of help from Macromedia, and this was
before I worked for the company. If you don't have a CFUG in your area,
simply contact us and we can help you launch it. The person in charge of
the CFUGs is _very_ helpful.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, March 27, 2002 9:30 AM
> To: CF-Talk
> Subject: RE: Anyone from Orlando not in the CFUG?
> 
> 
>   : whine, whine, whine:   All three Connecticut ones went 
> DOA in the past 
> year.
> 
>   A quick search of the link below, Connecticut isn't even 
> listed ( usually 
> it is between Colorado and Delaware )
> 
>   It also looks like there are no Macromedia user groups in 
> Idaho, Maine, 
> Mississippi, New Hampshire, North Dakota, South Dakota, and 
> West Virginia.
> 
> At 09:26 AM 3/27/2002 -0500, you wrote:
> >As a general follow up to this - anyone NOT in a CFUG is _really_
> >missing out on a wonderful exprerience. I encourage everyone not
> >attending a CFUG to go to 
> http://www.macromedia.com/v1/usergroups/ and
> >see if a UG is in your area.
> >

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Defroster

[G]

My friend was asking me earlier today about an application called
"Defroster". Says he thought it was a CF to ASP converter program?

Does anyone have any information on this? I'd never heard of it.

Thanks!

Brian

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Developers Tool. Comment Engine.

[Zac Spitzer]

David Schmidt wrote:

>I know this is html post, but here is the link again.  Perhaps it will work
>this time.
>
>http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D6
>-83FE00508B94F85A
>
sigh, yet another good reason why people shouldn't use UUID's for ID & 
urls, they convey no useful
information and they are also 10 times too long!

z


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Execute a file on another server.

[romulogomes]

I have Cold Fusion runing on a Windows NT server and i have to execute a shell 
in a unix server using Cold Fusion. Does anyone know how to do it?

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Rick Walters]

No really,

Orlando's CFUG really is quite good.  I have moved about quite a lot as
a contractor and have seen more than a few alternatives.  It is pleasant
to report that Orlando's group remains more interested in coding than
marketing.  

While it is important that CFUG's help promote CF as "the" solution of
choice for local business, I think that having a knowegeable and
talented pool of local developers is the best way to increase the use of
Cold Fusion in area businesses.  Orlando's group is all about answering
questions and not selling services (like some others I've seen and won't
spotlight).  

Oh, don't get me wrong, there are other good groups out there.  I just
wanted to chime in and further encourage Orlando Developers to come to
the meetings.  

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

>>> [EMAIL PROTECTED] 03/27/02 09:30AM >>>
  : whine, whine, whine:   All three Connecticut ones went DOA in the
past 
year.

  A quick search of the link below, Connecticut isn't even listed (
usually 
it is between Colorado and Delaware )

  It also looks like there are no Macromedia user groups in Idaho,
Maine, 
Mississippi, New Hampshire, North Dakota, South Dakota, and West
Virginia.

At 09:26 AM 3/27/2002 -0500, you wrote:
>As a general follow up to this - anyone NOT in a CFUG is _really_
>missing out on a wonderful exprerience. I encourage everyone not
>attending a CFUG to go to http://www.macromedia.com/v1/usergroups/
and
>see if a UG is in your area.
>
>===
>Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
>Email: [EMAIL PROTECTED] 
>Yahoo IM : morpheus
>
>"My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]] 
> > Sent: Wednesday, March 27, 2002 9:19 AM
> > To: CF-Talk
> > Subject: Anyone from Orlando not in the CFUG?
> >
> >
> >   I am co chair for our ColdFusion User Group here in
> > Orlando, FL and
> > I just want to make sure that I have everyone in the Orlando
> > area signed up
> > for our User Group. I am trying to get more user
> > participation so that we
> > can network and get to know each other. If you're interested
> > in joining us
> > go to www.cforlando.com and sign up as a member. We have
> > monthly meetings
> > and we will be starting something new called CF_Beer. We will
> > all meet up
> > once every couple of weeks for drinks, talking, and getting
> > to know each
> > other without having to have a formal meeting or speaker.
> > Email me off list
> > if you have any questions.
> >
>
>

__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Developers Tool. Comment Engine.

[Rich Wild]

> sigh, yet another good reason why people shouldn't use UUID's 
> for ID & 
> urls, they convey no useful
> information and they are also 10 times too long!


just to help:

http://www.funjunkie.co.uk/link.cfm

converts:
http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D6
-83FE00508B94F85

into: http://www.funjunkie.co.uk/link.cfm?Z5WDZAZK 

credit where its due: http://www.makeashorterlink.com came up with this idea
first and I made a version in CF

very simple, very useful. Helps immensely with this outlook wrapping stuff.

> -Original Message-
> From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
> Sent: 27 March 2002 14:55
> To: CF-Talk
> Subject: Re: Developers Tool. Comment Engine.
> 
> 
> David Schmidt wrote:
> 
> >I know this is html post, but here is the link again.  
> Perhaps it will work
> >this time.
> >
> >http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8
> D8DE0-40A6-11D6
> >-83FE00508B94F85A
> >
> sigh, yet another good reason why people shouldn't use UUID's 
> for ID & 
> urls, they convey no useful
> information and they are also 10 times too long!
> 
> z
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Developers Tool. Comment Engine.

[David Schmidt]

Actually, I believe the problem here is that a "-" is interpreted by an
editor (even an email editor like Outlook) as a hyphen just being used to
break up a set of syllables. Perhaps they should think about replacing the
"-" with a "_" when creating UUID's.  After all, then you could use them for
directory names, urls, or whatever you wanted.

Dave



>>http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11
D6-83FE00508B94F85A

sigh, yet another good reason why people shouldn't use UUID's for ID &
urls, they convey no useful
information and they are also 10 times too long!




__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Developers Tool. Comment Engine.

[Ramin Surya]

That is not because of uuid.
Outlook does that all the time.

-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:55 AM
To: CF-Talk
Subject: Re: Developers Tool. Comment Engine.


David Schmidt wrote:

>I know this is html post, but here is the link again.  Perhaps it will work
>this time.
>
>http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D6
>-83FE00508B94F85A
>
sigh, yet another good reason why people shouldn't use UUID's for ID & 
urls, they convey no useful
information and they are also 10 times too long!

z



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFFILE reads whole file into 1 var?

[Ed Gordon]

CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:Increasing wrapping length in Outlook (was: Developers Tool. Comment Engine.)

[Angel Stewart]

Just set the length of wrapping in Outlook to more than 80 characters
and you'll be fine when pasting URLS.

Options> Mail Format>Internet Format

And go to Plain text Options and increase from 76 to ...well..whatever
you like. There is an upper limit though.
And it does make your emails look a bit odd.

-Gel

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Tony_Petruzzi]

this one of my BIGGEST dislikes about CF. Whenever you read a file, it put
the entire file into a variable. There is no way to "open" and file and read
one line at a time. So if you have a 35 meg file and just want to read the
last line, CF would throw the entire 35 meg file into memory and that could
take a while on your server and bring it down. Hopefully with NEO there will
be away around this with JAVA.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:37 AM
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfinput focus

[Tony_Petruzzi]

anyone know of a hack to make it so that when cfinput throw a JavaScript
alert because a requirement isn't met that it will do a focus event to the
offending form field?

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Execute a file on another server.

[Alex]

More info. You have not given any information so we could answer your
question. If you could open up a shell on a remote server everyone would
be waking up to an empty or rooted box. 

On Wed, 27 Mar 2002, romulogomes wrote:

> I have Cold Fusion runing on a Windows NT server and i have to execute a shell 
> in a unix server using Cold Fusion. Does anyone know how to do it?
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Jille Floridor]

There is a custom (java) tag that reads the file line per line. I don't
remember how the tag is called, but you'd probably find it if you check the
developers exchange.

Jille

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 maart 2002 16:37
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Mike Townend]

If its somethink like a csv then you can setup a Datasource in CF to
look at the file and then just call the file via CFQuery If it's a
csv then you could use CFX_CSVToQuery tag which will convert the file to
a Query Object...

Failing that Look for a cfx tag or write a COM object to handle the file
so that you know its being processed line by line

HTH



-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]] 
Sent: 27 March 2002 15:37
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in
the traditional fashion? I had to parse thru the file looking for CR's
and CFLOOP thru the logic. Seems strange, but if that's the way we must
do it, when in Poughkeepsie, do as the... nevermind... how do YOU
process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE reads whole file into 1 var?

[Paul Giesenhagen]

I may not understand how that works, but I can't see anyway around not
opening the whole file first.  How would cold fusion or any other
application be able to find the last line if it didn't open the whole file
first.

I would like to see where you can pass various "delimiters" that would allow
you to quickly see line by line or item by item whatever the case may be.
But however you look at it, you would have to open the whole file to find
parts of it ...

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



> this one of my BIGGEST dislikes about CF. Whenever you read a file, it put
> the entire file into a variable. There is no way to "open" and file and
read
> one line at a time. So if you have a 35 meg file and just want to read the
> last line, CF would throw the entire 35 meg file into memory and that
could
> take a while on your server and bring it down. Hopefully with NEO there
will
> be away around this with JAVA.
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
>
>
> -Original Message-
> From: Ed Gordon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 27, 2002 10:37 AM
> To: CF-Talk
> Subject: CFFILE reads whole file into 1 var?
>
>
> CFFILE READs whole file into 1 var?
> Is there a limit on the size of the contents of that file?
> Is there an alternative way to read and process one record at a time in
the
> traditional fashion? I had to parse thru the file looking for CR's and
> CFLOOP thru the logic. Seems strange, but if that's the way we
> must do it, when in Poughkeepsie, do as the... nevermind... how do
> YOU process each record in a flat file?
>
> Thanks In Advance
>
> Ed Gordon
> Weekdays: Software Developer
> Weekends: Fighting Crime as Chicken Man
>
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Raymond Camden]

There is also a UDF for this at www.cflib.org.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Jille Floridor [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, March 27, 2002 10:40 AM
> To: CF-Talk
> Subject: RE: CFFILE reads whole file into 1 var?
> 
> 
> There is a custom (java) tag that reads the file line per 
> line. I don't
> remember how the tag is called, but you'd probably find it if 
> you check the
> developers exchange.
> 
> Jille
> 
> -Original Message-
> From: Ed Gordon [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 27 maart 2002 16:37
> To: CF-Talk
> Subject: CFFILE reads whole file into 1 var?
> 
> 
> CFFILE READs whole file into 1 var?
> Is there a limit on the size of the contents of that file?
> Is there an alternative way to read and process one record at 
> a time in the
> traditional fashion? I had to parse thru the file looking for CR's and
> CFLOOP thru the logic. Seems strange, but if that's the way we
> must do it, when in Poughkeepsie, do as the... nevermind... how do
> YOU process each record in a flat file?
> 
> Thanks In Advance
> 
> Ed Gordon
> Weekdays: Software Developer
> Weekends: Fighting Crime as Chicken Man
> 
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
> 
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Increasing wrapping length in Outlook (was: Developers Tool. Comment Engine.)

[David Schmidt]

You mean, more odd than usual right?

Dave (King of Odd Email) Schmidt


-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 7:37 AM
To: CF-Talk
Subject: RE:Increasing wrapping length in Outlook (was: Developers Tool.
Comment Engine.)


Just set the length of wrapping in Outlook to more than 80 characters
and you'll be fine when pasting URLS.

Options> Mail Format>Internet Format

And go to Plain text Options and increase from 76 to ...well..whatever
you like. There is an upper limit though.
And it does make your emails look a bit odd.

-Gel


__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Distributing MS Access

[Paul Giesenhagen]

Does anyone know about the licensing with MS Access and sending an MS Access
db with your application.  It has always been my understanding that this is
fine to do.

Does anyone know for sure?

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

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE reads whole file into 1 var?

[Joseph Thompson]

Streams :-)  C (and I assume Java) can read a file one character at a time.


> I may not understand how that works, but I can't see anyway around not
> opening the whole file first.  

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Distributing MS Access

[Shawn Regan]

Yes, it is fine to do. MS even has a Access viewer only program that is ok
distribute.

Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 7:52 AM
To: CF-Talk
Subject: Distributing MS Access


Does anyone know about the licensing with MS Access and sending an MS Access
db with your application.  It has always been my understanding that this is
fine to do.

Does anyone know for sure?

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


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Shawn Regan]

You could always read the file into a temp var then put it into an array by
linefeed and return carriage. There you go no java custom tag.

Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: Jille Floridor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 7:40 AM
To: CF-Talk
Subject: RE: CFFILE reads whole file into 1 var?


There is a custom (java) tag that reads the file line per line. I don't
remember how the tag is called, but you'd probably find it if you check the
developers exchange.

Jille

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 maart 2002 16:37
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anyone from Orlando not in the CFUG?

[Hatton Humphrey]

I tried to get a CFUG up and going here in Buffalo and we actually had 
an orgianization meeting scheduled and it then fell through.  I'll agree 
that a CFUG is a wonderful thing... I'm still subscribed to the email 
list for the D/FW group.

The problem here (when we tried to get one started in Buffalo) was time.

Hatton

Raymond Camden wrote:

> Then I'd consider this an opportunity. ;) When I was launching the one
> here in Virginia, I got a _lot_ of help from Macromedia, and this was
> before I worked for the company. If you don't have a CFUG in your area,
> simply contact us and we can help you launch it. The person in charge of
> the CFUGs is _very_ helpful.
> 
> ===
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> 
>>-Original Message-
>>From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
>>Sent: Wednesday, March 27, 2002 9:30 AM
>>To: CF-Talk
>>Subject: RE: Anyone from Orlando not in the CFUG?
>>
>>
>>  : whine, whine, whine:   All three Connecticut ones went 
>>DOA in the past 
>>year.
>>
>>  A quick search of the link below, Connecticut isn't even 
>>listed ( usually 
>>it is between Colorado and Delaware )
>>
>>  It also looks like there are no Macromedia user groups in 
>>Idaho, Maine, 
>>Mississippi, New Hampshire, North Dakota, South Dakota, and 
>>West Virginia.
>>
>>At 09:26 AM 3/27/2002 -0500, you wrote:
>>
>>>As a general follow up to this - anyone NOT in a CFUG is _really_
>>>missing out on a wonderful exprerience. I encourage everyone not
>>>attending a CFUG to go to 
>>>
>>http://www.macromedia.com/v1/usergroups/ and
>>
>>>see if a UG is in your area.
>>>
>>>
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ClusterCats

[dave fauth]

If anyone is doing ClusterCats, I have a configuration question that I 
can't figure out.  I have the IP/DNS information correct and the clustering 
works correctly but my NT event logs are filling up with cluster errors 
every 30 seconds.

Twice a minute I get an event log telling me this:

Cluster (clustername) SERVER FAILURE: Server (server.domain.name) NOT AVAILABLE

Checking the explorer, everything is fine. Load on the server is within 
acceptable limits. The server's performance is fine through my browser. The 
explorer displays no errors, but still I get the event log twice a 
minute.  It happens on both servers.

The machines are NT4sp6 with CF5.0

You can contact me off line if you prefer.

thanks
dave
---
dave fauth
[EMAIL PROTECTED]

"The opinions expressed here
are my own and not those of
DOMAIN technologies, inc."

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Robert Everland]

I have learned that in order to make it successful you have to be willing to
do a lot of work yourself. People do not want to spend thier time for free.
The benefit of you doing this though is that you tend to get a good
reputation as long as you try to run the group decently. So even though you
are doing tons of free work, your name is known now in local circlies. At
least I hope that's what it is doing. It's hard work, and I wish I had more
help, but all you need is a website to tell users about the group, a place
for meetings, and then a speaker. After that it's all gravy, all the cfug
groups will help you out. Presentations that are already done, there are
speakers that go to different cfug to tell them about new ideas, products,
and Macromedia send people out all the time.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:02 AM
To: CF-Talk
Subject: Re: Anyone from Orlando not in the CFUG?


I tried to get a CFUG up and going here in Buffalo and we actually had 
an orgianization meeting scheduled and it then fell through.  I'll agree 
that a CFUG is a wonderful thing... I'm still subscribed to the email 
list for the D/FW group.

The problem here (when we tried to get one started in Buffalo) was time.

Hatton

Raymond Camden wrote:

> Then I'd consider this an opportunity. ;) When I was launching the one
> here in Virginia, I got a _lot_ of help from Macromedia, and this was
> before I worked for the company. If you don't have a CFUG in your area,
> simply contact us and we can help you launch it. The person in charge of
> the CFUGs is _very_ helpful.
> 
> ===
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> 
>>-Original Message-
>>From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
>>Sent: Wednesday, March 27, 2002 9:30 AM
>>To: CF-Talk
>>Subject: RE: Anyone from Orlando not in the CFUG?
>>
>>
>>  : whine, whine, whine:   All three Connecticut ones went 
>>DOA in the past 
>>year.
>>
>>  A quick search of the link below, Connecticut isn't even 
>>listed ( usually 
>>it is between Colorado and Delaware )
>>
>>  It also looks like there are no Macromedia user groups in 
>>Idaho, Maine, 
>>Mississippi, New Hampshire, North Dakota, South Dakota, and 
>>West Virginia.
>>
>>At 09:26 AM 3/27/2002 -0500, you wrote:
>>
>>>As a general follow up to this - anyone NOT in a CFUG is _really_
>>>missing out on a wonderful exprerience. I encourage everyone not
>>>attending a CFUG to go to 
>>>
>>http://www.macromedia.com/v1/usergroups/ and
>>
>>>see if a UG is in your area.
>>>
>>>
> 
> 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE reads whole file into 1 var?

[Paul Giesenhagen]

but wouldn't it have to open the whole file up first to find the first
character or the 2000th character...

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

- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 9:54 AM
Subject: Re: CFFILE reads whole file into 1 var?


> Streams :-)  C (and I assume Java) can read a file one character at a
time.
>
>
> > I may not understand how that works, but I can't see anyway around not
> > opening the whole file first.
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Distributing MS Access

[Thane Sherrington]

At 07:55 AM 03/27/2002 -0800, Shawn Regan wrote:
>Yes, it is fine to do. MS even has a Access viewer only program that is ok
>distribute.

Any idea where one can get the viewer app?

T

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Getting field names, etc. from MSSQL 2000

[Jamie Jackson]

Is it possible to get information about a table via SQL (or some other
method)? I would like to get field names, datatypes/lengths, etc.

I am using MSSQL 2000.

Thanks,
Jamie
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting field names, etc. from MSSQL 2000

[Neil Giarratana]

I will leave it to the SQL gurus to describe the SQL commands for this but
we found a tool that is fantastic for documenting SQL2000 Databases with
pretty much anything you would need.

http://www.jn-software.com/sql2000print_features.html

Regards,
Neil

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:20 AM
To: CF-Talk
Subject: Getting field names, etc. from MSSQL 2000


Is it possible to get information about a table via SQL (or some other
method)? I would like to get field names, datatypes/lengths, etc.

I am using MSSQL 2000.

Thanks,
Jamie

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Jille Floridor]

Agree, but in that case your variable still contains the complete file,
right?

-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 maart 2002 16:58
To: CF-Talk
Subject: RE: CFFILE reads whole file into 1 var?


You could always read the file into a temp var then put it into an array by
linefeed and return carriage. There you go no java custom tag.

Shawn Regan
Applications Developer
Pacific Technology Solutions

-Original Message-
From: Jille Floridor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 7:40 AM
To: CF-Talk
Subject: RE: CFFILE reads whole file into 1 var?


There is a custom (java) tag that reads the file line per line. I don't
remember how the tag is called, but you'd probably find it if you check the
developers exchange.

Jille

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 maart 2002 16:37
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Shawn Regan]

Yes you have to open the file before you can do anything with it.

Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:08 AM
To: CF-Talk
Subject: Re: CFFILE reads whole file into 1 var?


but wouldn't it have to open the whole file up first to find the first
character or the 2000th character...

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

- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 9:54 AM
Subject: Re: CFFILE reads whole file into 1 var?


> Streams :-)  C (and I assume Java) can read a file one character at a
time.
>
>
> > I may not understand how that works, but I can't see anyway around not
> > opening the whole file first.
>
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Distributing MS Access

[Shawn Regan]

Do a search at the MS website for viewers. They have them for power point,
word, access and excel.

Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:24 AM
To: CF-Talk
Subject: RE: Distributing MS Access


At 07:55 AM 03/27/2002 -0800, Shawn Regan wrote:
>Yes, it is fine to do. MS even has a Access viewer only program that is ok
>distribute.

Any idea where one can get the viewer app?

T


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[jon]

Yeah... but realistically, how much different is IIS going to behave than
Apache -- especially if you don't have full control over the IIS configs?

I've been running XP HOME on my laptop with apache as a portable development
machine for about 4 months now -- no trouble there whatsoever. I've got that
single user version of CF 5 installed so I can mess about with my code when
I'm not attached to the net and mysql/access to handle DB stuff.

If someone has a clever way to synch databases when I hit the road, that
would be excellent.

At any rate, it all works fine and behaves in a very stable fashion.
Apache/CF seem to play well together and personally, I find apache way
easier to configure than IIS. (All those tabs!!! AGGG!)

Incidentally -- there was an article on the register about turning your XP
Pro machine from a workstation to a server:
http://www.theregus.com/content/4/24428.html

Apparently, the two versions of xp aren't as different as people might
think.

-- jon

-
jon roig
senior manager, online production
epilepsy foundation
tel:   215.850.0710
site:  http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 9:13 AM
To: CF-Talk
Subject: RE: web server for XP home?


At 09:10 AM 3/27/2002 +, you wrote:

>Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you can
>read instructions correctly), it has a smaller memory footprint than IIS
and
>theoretically is more secure as well, so WHY on earth would you want IIS?

  ( To set up a development identical to the live machine which you have no
control over? )



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting field names, etc. from MSSQL 2000

[Diana Nichols]

Here's a standard routine I use for listing tables and columns. More info
can be found by looking up "information schema views" in SQL books Online.


select * from information_schema.columns
order by table_name, column_name



#table_name#

#column_name# #data_type# #character_maximum_length#



HTH
D




Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374


-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:20 AM
To: CF-Talk
Subject: Getting field names, etc. from MSSQL 2000


Is it possible to get information about a table via SQL (or some other
method)? I would like to get field names, datatypes/lengths, etc.

I am using MSSQL 2000.

Thanks,
Jamie

__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Getting field names, etc. from MSSQL 2000

[Jamie Jackson]

Thanks for the tip, though I was hoping for something I could use
dynamically within CF. Best case scenario would be if there is SQL
that returns object descriptions.

Thanks,
Jamie

On Wed, 27 Mar 2002 11:27:31 -0500, in cf-talk you wrote:

>I will leave it to the SQL gurus to describe the SQL commands for this but
>we found a tool that is fantastic for documenting SQL2000 Databases with
>pretty much anything you would need.
>
>http://www.jn-software.com/sql2000print_features.html
>
>Regards,
>Neil
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 27, 2002 11:20 AM
>To: CF-Talk
>Subject: Getting field names, etc. from MSSQL 2000
>
>
>Is it possible to get information about a table via SQL (or some other
>method)? I would like to get field names, datatypes/lengths, etc.
>
>I am using MSSQL 2000.
>
>Thanks,
>Jamie
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: web server for XP home?

[Mike Townend]

Yea but the conversion causes a memory leak and so its not v stable at
all... Best wait till the xp servers come out...




-Original Message-
From: jon [mailto:[EMAIL PROTECTED]] 
Sent: 27 March 2002 16:32
To: CF-Talk
Subject: RE: web server for XP home?


Yeah... but realistically, how much different is IIS going to behave
than Apache -- especially if you don't have full control over the IIS
configs?

I've been running XP HOME on my laptop with apache as a portable
development machine for about 4 months now -- no trouble there
whatsoever. I've got that single user version of CF 5 installed so I can
mess about with my code when I'm not attached to the net and
mysql/access to handle DB stuff.

If someone has a clever way to synch databases when I hit the road, that
would be excellent.

At any rate, it all works fine and behaves in a very stable fashion.
Apache/CF seem to play well together and personally, I find apache way
easier to configure than IIS. (All those tabs!!! AGGG!)

Incidentally -- there was an article on the register about turning your
XP Pro machine from a workstation to a server:
http://www.theregus.com/content/4/24428.html

Apparently, the two versions of xp aren't as different as people might
think.

-- jon

-
jon roig
senior manager, online production
epilepsy foundation
tel:   215.850.0710
site:  http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 9:13 AM
To: CF-Talk
Subject: RE: web server for XP home?


At 09:10 AM 3/27/2002 +, you wrote:

>Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you 
>can read instructions correctly), it has a smaller memory footprint 
>than IIS
and
>theoretically is more secure as well, so WHY on earth would you want 
>IIS?

  ( To set up a development identical to the live machine which you have
no control over? )



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting field names, etc. from MSSQL 2000

[Ramin Surya]

sp_columns [tablename]

Try that!

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:42 AM
To: CF-Talk
Subject: Re: Getting field names, etc. from MSSQL 2000


Thanks for the tip, though I was hoping for something I could use
dynamically within CF. Best case scenario would be if there is SQL
that returns object descriptions.

Thanks,
Jamie

On Wed, 27 Mar 2002 11:27:31 -0500, in cf-talk you wrote:

>I will leave it to the SQL gurus to describe the SQL commands for this but
>we found a tool that is fantastic for documenting SQL2000 Databases with
>pretty much anything you would need.
>
>http://www.jn-software.com/sql2000print_features.html
>
>Regards,
>Neil
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 27, 2002 11:20 AM
>To: CF-Talk
>Subject: Getting field names, etc. from MSSQL 2000
>
>
>Is it possible to get information about a table via SQL (or some other
>method)? I would like to get field names, datatypes/lengths, etc.
>
>I am using MSSQL 2000.
>
>Thanks,
>Jamie
>
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Distributing MS Access

[Eric J Hoffman]

Yes you can.  If you build an app for shipment that runs offline as a
program (good old school access programming) you would need Office
Developer Tools to package it and send with runtime libraries, but even
then it was completely acceptable AFAWK.

Regards,

Eric J. Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 9:52 AM
To: CF-Talk
Subject: Distributing MS Access


Does anyone know about the licensing with MS Access and sending an MS
Access db with your application.  It has always been my understanding
that this is fine to do.

Does anyone know for sure?

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


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

custom 404 troubles

[Todd Ashworth]

I have a custom 404 template set up.  When I go to a bad .html file, the
custom 404 comes up properly.  When I go to a bad .cfm it doesn't.  I can't
activate the "check that file exists" option, because it screws up one of my
custom tags.

I was thinking about doing a meta refresh to the custom 404 from the
standard CF 404 page.  Does anyone know where this file is found?  Also, is
there a better way to handle this?

Todd



This email has been scanned courtesy of SCDinc.com 
System rejects all executable attachments such as:
com, .scr, .vbs, .exe, and .bat


__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Getting field names, etc. from MSSQL 2000

[Jamie Jackson]

YES!!! This is exactly what I needed!

Huge thanks,
Jamie

On Wed, 27 Mar 2002 11:34:33 -0500, in cf-talk you wrote:

>Here's a standard routine I use for listing tables and columns. More info
>can be found by looking up "information schema views" in SQL books Online.
>
>
>select * from information_schema.columns
>order by table_name, column_name
>
>
>
>#table_name#
>
>#column_name# #data_type# #character_maximum_length#
>
>
>
>HTH
>D
>
>
>
>
>Diana Nichols
>Webmistress
>http://www.lavenderthreads.com
>770.434.7374
>
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 27, 2002 11:20 AM
>To: CF-Talk
>Subject: Getting field names, etc. from MSSQL 2000
>
>
>Is it possible to get information about a table via SQL (or some other
>method)? I would like to get field names, datatypes/lengths, etc.
>
>I am using MSSQL 2000.
>
>Thanks,
>Jamie
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anyone from Orlando not in the CFUG?

[Stephen Moretti]

Jeffry,

>
>   A quick search of the link below, Connecticut isn't even listed (
usually
> it is between Colorado and Delaware )
>
There are groups in Massachusetts, loads in New York, New Jersey and Rhode
Island.

>   It also looks like there are no Macromedia user groups in Idaho, Maine,
> Mississippi, New Hampshire, North Dakota, South Dakota, and West Virginia.
>

I had a look through the CFUG info I get as a manager in the UK and
unfortunately there are no groups in those areas, but there are 3 Virginia
UGs.

Bear in mind that I'm a brit, so I have no idea how big a state Virginia is,
but there are groups in Hampton Roads, run by Raymond,  Northern Virginia
run by Bret Peters at Figleaf and the third is in Richmond run by Robert
Baird.

If none of these are close enough to you, as Raymond says, you should
consider it an opportunity and start your own local UG.  Check out the
usergroup section on the MM site (http://www.macromedia.com/v1/usergroups/).
The CFUG team at Macromedia are very helpful, even to the likes of us out in
the back and beyond of the UK. ;o)

Perhaps at this point I should really plug the UK usergroups. :o)

The UK CFUG, the largest and original ColdFusion Usergroup is based in
London - April 11th they have Jeremy Allaire speaking at a meeting (Location
to be confirmed) - you can find their website at http://www.ukcfug.org/

Then there's me - I manage the Northern UK CFUG.  We cover most of the north
of England.  We're a travelling show... So far we've held meetings in
Newcastle Upon Tyne, Edinburgh, Leeds and York. You can find our rantings
and other bits and bobs on our site at http://www.cfug.org.uk/

Hope that helps

Stephen


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: custom 404 troubles

[BEN MORRIS]

 will allow you to specify a template to use, but you cannot use cf variables 
and tags as usual.  You could do a meta refresh to your 404 page.

>>> "Todd Ashworth" <[EMAIL PROTECTED]> 03/27/02 11:51AM >>>
I have a custom 404 template set up.  When I go to a bad .html file, the
custom 404 comes up properly.  When I go to a bad .cfm it doesn't.  I can't
activate the "check that file exists" option, because it screws up one of my
custom tags.

I was thinking about doing a meta refresh to the custom 404 from the
standard CF 404 page.  Does anyone know where this file is found?  Also, is
there a better way to handle this?

Todd



This email has been scanned courtesy of SCDinc.com 
System rejects all executable attachments such as:
com, .scr, .vbs, .exe, and .bat



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anyone from Orlando not in the CFUG?

[Stephen Judd]

The NH CFUG recently became the Northern New England CFUG 
(http://www.mmug.info/index.jsp).  There's a meeting Tuesday, 4/2 in 
Brattleboro, Vermont.



Stephen Judd
Local Area Network Manager
UNH Cooperative Extension
59 College Road
Taylor Hall, G101
Durham, NH 03824
603-862-2847
[EMAIL PROTECTED]


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE reads whole file into 1 var?

[Hoffman, Joe (CIT)]

http://www.intrafoundation.com/freeware.html#cfx_readline
by Lewis Sellers

"The CFX_ReadLine tag allows you to read a text file line by line 
instead of having to load the entire thing in at once via CFFILE."


Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:37 AM
To: CF-Talk
Subject: CFFILE reads whole file into 1 var?


CFFILE READs whole file into 1 var?
Is there a limit on the size of the contents of that file?
Is there an alternative way to read and process one record at a time in the
traditional fashion? I had to parse thru the file looking for CR's and
CFLOOP thru the logic. Seems strange, but if that's the way we
must do it, when in Poughkeepsie, do as the... nevermind... how do
YOU process each record in a flat file?

Thanks In Advance

Ed Gordon
Weekdays: Software Developer
Weekends: Fighting Crime as Chicken Man

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: custom 404 troubles

[Chris Norloff]

You mean you're using the Missing Template Handler in CF admin? Or are you using 
CFERROR type=request?  

When you say you go to a bad file, do you mean you enter the name of a file that 
doesn't exist?

I use the Missing Template Handler and it works with CFM pages but not HTML pages or 
nonsense words. I'd use the web server to handle HTML, since the CF server is not 
called unless it's a CFM page.

Chris Norloff

-- Original Message --
from: "Todd Ashworth" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 27 Mar 2002 11:51:07 -0500

>I have a custom 404 template set up.  When I go to a bad .html file, the
>custom 404 comes up properly.  When I go to a bad .cfm it doesn't.  I can't
>activate the "check that file exists" option, because it screws up one of my
>custom tags.
>
>I was thinking about doing a meta refresh to the custom 404 from the
>standard CF 404 page.  Does anyone know where this file is found?  Also, is
>there a better way to handle this?
>
>Todd
>
>
>
>This email has been scanned courtesy of SCDinc.com 
>System rejects all executable attachments such as:
>com, .scr, .vbs, .exe, and .bat
>
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Neil Giarratana]

Regarding a New Hampshire user group, the Northern New England MMUG
(Brattleboro, VT) is run within 1/2 a mile of New Hampshire and we expect
quite a draw from New Hampshire.

Regards,
Neil

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 12:08 PM
To: CF-Talk
Subject: Re: Anyone from Orlando not in the CFUG?


Jeffry,

>
>   A quick search of the link below, Connecticut isn't even listed (
usually
> it is between Colorado and Delaware )
>
There are groups in Massachusetts, loads in New York, New Jersey and Rhode
Island.

>   It also looks like there are no Macromedia user groups in Idaho, Maine,
> Mississippi, New Hampshire, North Dakota, South Dakota, and West Virginia.
>

I had a look through the CFUG info I get as a manager in the UK and
unfortunately there are no groups in those areas, but there are 3 Virginia
UGs.

Bear in mind that I'm a brit, so I have no idea how big a state Virginia is,
but there are groups in Hampton Roads, run by Raymond,  Northern Virginia
run by Bret Peters at Figleaf and the third is in Richmond run by Robert
Baird.

If none of these are close enough to you, as Raymond says, you should
consider it an opportunity and start your own local UG.  Check out the
usergroup section on the MM site (http://www.macromedia.com/v1/usergroups/).
The CFUG team at Macromedia are very helpful, even to the likes of us out in
the back and beyond of the UK. ;o)

Perhaps at this point I should really plug the UK usergroups. :o)

The UK CFUG, the largest and original ColdFusion Usergroup is based in
London - April 11th they have Jeremy Allaire speaking at a meeting (Location
to be confirmed) - you can find their website at http://www.ukcfug.org/

Then there's me - I manage the Northern UK CFUG.  We cover most of the north
of England.  We're a travelling show... So far we've held meetings in
Newcastle Upon Tyne, Edinburgh, Leeds and York. You can find our rantings
and other bits and bobs on our site at http://www.cfug.org.uk/

Hope that helps

Stephen



__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

dynamic select boxes with dynamic names

[Metzy Martinez]

Hi everyone i've come accross a problem

I'm creating dynamic select boxes. i can have none to infinity and so i need
for them to have dynamic names. Because i'm not allowed to have select boxes
with the same name.

but when i post my results i'm having a problem resolving the the name of
the select box.

i thought i had fixed it by sending the recordcount number and looping
through the name. but by doing this it only gives me the name of the select
box not the value.

Does any one know the answer please.

Thank you,

Metzy


Here is some code below






Listing Fact





SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#


DELETE
FROM
listingFact
WHERE
listing_id = #txtListing_id#






#txtListing_id#
#thislistingFact#


















  

  Please Select A Fact



  Fact


  

  
SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#










SELECT
*
FROM
fact
WHERE
factType = '#factOutput.factType[i]#'


#factOutput.factType[i]#



#fact#








  
















__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: dynamic select boxes with dynamic names

[Sam Roach]

Try the Evaluate command:


#Evaluate("Answer#loopcount#")#


-- Sam

-Original Message-
From: Metzy Martinez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 9:22 AM
To: CF-Talk
Subject: dynamic select boxes with dynamic names


Hi everyone i've come accross a problem

I'm creating dynamic select boxes. i can have none to infinity and so i need
for them to have dynamic names. Because i'm not allowed to have select boxes
with the same name.

but when i post my results i'm having a problem resolving the the name of
the select box.

i thought i had fixed it by sending the recordcount number and looping
through the name. but by doing this it only gives me the name of the select
box not the value.

Does any one know the answer please.

Thank you,

Metzy


Here is some code below






Listing Fact





SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#


DELETE
FROM
listingFact
WHERE
listing_id = #txtListing_id#






#txtListing_id#
#thislistingFact#


















  

  Please Select A Fact



  Fact


  

  
SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#










SELECT
*
FROM
fact
WHERE
factType = '#factOutput.factType[i]#'


#factOutput.factType[i]#



#fact#








  

















__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: mySQL / ODBC / Windows problem

[Matt Robertson]

Neil,

Assuming a default install of mySQL, the log is at 

c:\mysql\data\mysql.err

You might ask these guys if they're using CFUPDATE on that query.  That
tag is problematic on mySQL... Some cfupdates work and some don't.  The
solution was to switch to straight SQL and the problem disappeared.

HtH,

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



-Original Message-
From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 5:35 AM
To: CF-Talk
Subject: RE: mySQL / ODBC / Windows problem


Where are the db.log files?  For mySQL or ColdFusion (if the latter, I
know where they are!)

Sorry, I am not a mySQL man.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: mySQL / ODBC / Windows problem

[Neil Clark =TMM=]

Thanks Matt, 

I know it is a problem with the actual SQL as everything else is sweet.
When you create a new datasource to mySQL, do you have to check any of
the multiple checkboxes?!

Neil

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Closing window

[phumes1]

How can I close a window using javascript without having to click on a link 
or button?

After my CF code runs I want the window to close.





+---+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
++


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[Tony_Petruzzi]

window.close();

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 1:17 PM
To: CF-Talk
Subject: Re: Closing window


How can I close a window using javascript without having to click on a link 
or button?

After my CF code runs I want the window to close.





+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[Neil Clark =TMM=]

Within a onRequestEnd.cfm file

Place 


   window.close();




__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[Matthew R. Small]

You can do this only if the window is a child of another window.  If it
is not, then a dialog box will pop up asking the user if he/she wants to
close the window.

- Matt Small




-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 1:17 PM
To: CF-Talk
Subject: Re: Closing window

How can I close a window using javascript without having to click on a
link 
or button?

After my CF code runs I want the window to close.





+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[VAN VLIET, SCOTT E (SBCSI)]

If there is nothing to display on the page:


window.close();


Not that this is buggy in NN, so I would recommend:

..
Your CF Code goes here
..











HTH.

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




-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:17 AM
To: CF-Talk
Subject: Re: Closing window


How can I close a window using javascript without having to click on a link 
or button?

After my CF code runs I want the window to close.





+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re[2]: Closing window

[Critz]

oi phumes1!!

at the end of your page after your cf processing just put


self.close()




-- 
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - 


-
Wednesday, March 27, 2002, 1:17:04 PM, you wrote:

p> How can I close a window using javascript without having to click on a link 
p> or button?

p> After my CF code runs I want the window to close.





p> 
+---+ 

p> Philip Humeniuk
p> [EMAIL PROTECTED]
p> [EMAIL PROTECTED]
p> 
++


p> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Closing window

[Rick Walters]

Without using Javascript or another client side language?  You can't. 
You could manually close the window or have a client event trigger some
other process.



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

>>> [EMAIL PROTECTED] 03/27/02 01:17PM >>>
How can I close a window using javascript without having to click on a
link 
or button?

After my CF code runs I want the window to close.





+---+


Philip Humeniuk
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
++



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Closing window

[Rick Walters]

Disregard this.. I read your question incorrectly.

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

>>> [EMAIL PROTECTED] 03/27/02 01:19PM >>>
Without using Javascript or another client side language?  You can't. 
You could manually close the window or have a client event trigger
some
other process.



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

>>> [EMAIL PROTECTED] 03/27/02 01:17PM >>>
How can I close a window using javascript without having to click on a
link 
or button?

After my CF code runs I want the window to close.





+---+


Philip Humeniuk
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
++




__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[phumes1]

Thats cool but whats the advantage of putting this code in the 
onrequestend.cfm instead on my file.cfm?

If I have other templates in the same directory that I don't want closed I 
should put the window.close only in the files that I want, right?

At 06:14 PM 3/27/2002 +, you wrote:
>Within a onRequestEnd.cfm file
>
>Place
>
>
>window.close();
>
>
>
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Word to HTML

[Greg Saunders]

More precisely:

   
http://www.cfcomet.com/cfcomet/Word/index.cfm?ArticleID=B70AD80E-3DAF-4CDC-AEA1E8059FD78D43

Greg Saunders




At 02:43 PM 3/26/2002 -0800, Douglas Brown wrote:
>http://www.cfcomet.com
>
>
>
>
>"Success is a journey, not a destination!!"
>
>
>
>Doug Brown
>- Original Message -
>From: "Eric J Hoffman" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, March 26, 2002 1:01 PM
>Subject: Word to HTML
>
>
> > I know this exists in some manner somewhere, but cannot seem to
> > find...when a user uploads a word doc, we want a custom tag to jam it
> > into HTML format for us.  Does this exist already?  Thanks for a pointer
> > or two!
> >
> > Regards,
> >
> > Eric J. Hoffman
> > Director of Internet Development
> > DataStream Connexion, LLC
> > (formerly Small Dog Design)
> >
> >
> >
> >
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re[2]: Closing window

[Critz]

oi Neil!!

wouldn't that execute that bit of code on EVERY page in the app then?


-- 
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - 


-
Wednesday, March 27, 2002, 1:14:49 PM, you wrote:

NCT> Within a onRequestEnd.cfm file

NCT> Place 

NCT> 
NCT>window.close();
NCT> 



NCT> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[Neil Clark =TMM=]

Well, if you want it to be actioned DEFINITELY at the end of the server
call, use OnRequestEnd.cfm.  Your page will effectively action the close
window before the server call has ended.

N

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Closing window

[Neil Clark =TMM=]

Good point! :-) sorry, I think it works directory by directory...

I have had a bad day, and to top it all off my 2nd monitor just blew up!

Uurgh

Neil

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: dynamic select boxes with dynamic names

[Metzy Martinez]

Sam that was perfect Thank you so much

-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 12:36 PM
To: CF-Talk
Subject: RE: dynamic select boxes with dynamic names


Try the Evaluate command:


#Evaluate("Answer#loopcount#")#


-- Sam

-Original Message-
From: Metzy Martinez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 9:22 AM
To: CF-Talk
Subject: dynamic select boxes with dynamic names


Hi everyone i've come accross a problem

I'm creating dynamic select boxes. i can have none to infinity and so i need
for them to have dynamic names. Because i'm not allowed to have select boxes
with the same name.

but when i post my results i'm having a problem resolving the the name of
the select box.

i thought i had fixed it by sending the recordcount number and looping
through the name. but by doing this it only gives me the name of the select
box not the value.

Does any one know the answer please.

Thank you,

Metzy


Here is some code below






Listing Fact





SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#


DELETE
FROM
listingFact
WHERE
listing_id = #txtListing_id#






#txtListing_id#
#thislistingFact#


















  

  Please Select A Fact



  Fact


  

  
SELECT
distinct factType
FROM
fact
WHERE
Type_id = #Type_id#










SELECT
*
FROM
fact
WHERE
factType = '#factOutput.factType[i]#'


#factOutput.factType[i]#



#fact#








  


















__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anyone from Orlando not in the CFUG?

[Dave Watts]

> Perhaps at this point I should really plug the UK 
> usergroups. :o)
>
> The UK CFUG, the largest and original ColdFusion 
> Usergroup is based in London ...

I feel compelled to correct you on this. The first ColdFusion User Group was
(and is) the DC CFUG, founded by Steve Drucker and me in 1996. As for the
largest, I have no idea. You may have meant the largest in the UK, but as a
point of pride, I couldn't let the statement stand as it is.

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

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Forms: submit via button and required fields not working

[Tim]

I have a form that I wanted to restrict so that the user has to hit the Submit button 
to enter the form, and not the Enter key.  I included the following:



This does work as far as resticting the Enter Key, but the Required attribute does not 
work now.  The user does not get a message if a required field is left blank, and the 
form is acted upon, producing errors.  If I take the above code out and insert a plain 
submit button, the Required attribute works, but not restricting the Enter key.

Anyone have an idea on how to do both, restrict form submission only when the button 
is selected and checking for required fields?

Tim



-
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Forms: submit via button and required fields not working

[Matthew R. Small]

You're using cfform, right?  Form.submit() does not drive the form
submission event.  What you can do is look at your form page's html
source and find the javascript in the  tag that is called when the
form is submitted.  Call the same functions in your button tag and it
should work.


- Matt Small


-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 2:01 PM
To: CF-Talk
Subject: Forms: submit via button and required fields not working

I have a form that I wanted to restrict so that the user has to hit the
Submit button to enter the form, and not the Enter key.  I included the
following:



This does work as far as resticting the Enter Key, but the Required
attribute does not work now.  The user does not get a message if a
required field is left blank, and the form is acted upon, producing
errors.  If I take the above code out and insert a plain submit button,
the Required attribute works, but not restricting the Enter key.

Anyone have an idea on how to do both, restrict form submission only
when the button is selected and checking for required fields?

Tim



-
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy AwardsR

__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Forms: submit via button and required fields not working

[Alex]

onClick="somefunction()"

function somefunction() {
   validation_goes_here
   submit();
}

On Wed, 27 Mar 2002, Tim wrote:

> I have a form that I wanted to restrict so that the user has to hit the Submit 
>button to enter the form, and not the Enter key.  I included the following:
> 
> 
> 
> This does work as far as resticting the Enter Key, but the Required attribute does 
>not work now.  The user does not get a message if a required field is left blank, and 
>the form is acted upon, producing errors.  If I take the above code out and insert a 
>plain submit button, the Required attribute works, but not restricting the Enter key.
> 
> Anyone have an idea on how to do both, restrict form submission only when the button 
>is selected and checking for required fields?
> 
> Tim
> 
> 
> 
> -
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards®
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFNORTH CF Mx conference news

[Michael Smith]

I got this message from the Toronto CFUG. Check it out if you are
interesting in going to Toronto for a CF Mx conference in May.
- Michael Smith, TeraTech, Inc http://www.teratech.com/

CFNORTH UPDATE issue No.3
CFNorth ColdFusion Developers Conference, MAY 4-5
Toronto Eaton Centre Marriott Hotel: TORONTO, CANADA
http://www.CFNorth.com/

Use Reg discount code CFNTECH361 to get the discount price.
-
| EARLY BIRD PRICE OF $123(USD) ENDS ON APRIL 2ND
| PRICE WILL GO UP TO $145(USD) ON WED., APRIL 3RD
-


 In this issue
 Introduction: Price goes up to $230 on April 2nd
 FLASH MX AND COLDFUSION MX (formally known as NEO)
 Exhibitors & Give-A-Ways
 Beyond the lectures
 How Topic Tracks work
 Hotel Update: Group Booking extended to April 5th
 CF Developers Journal Full Page Ad
 CFNorth Sponsors and Supporters


 INTRODUCTION
---
March 27, 2002: Kevin Towes and Byron Bignell here to give you the
latest development of the CFNorth DevCon.  Its hard to believe that we
are only 5 weeks away from the CFNorth Developers Conference.  Its seems
like yesterday that we came up with the idea.  You only have *6 DAYS
LEFT TO REGISTER* for the conference using the Earlybird Discount of
$200 (CDN) ~ $123 (US). This Tuesday will be your absolute final day to
register using this discount.  On Wednesday April 3rd, the price will go
up to $230 (CDN) ~$145 (US).  Group discounts (of more then 5 people
will still be available on request >> Email [EMAIL PROTECTED]).
Register Online Now!
   http://www.CFNorth.com/Register/

For our American friends remember, Canada has a really LOW exchange
rate offering about $0.63 on our dollar! ($100 CDN = $63 US).  You will
NEVER see a conference offering as much CFNorth for as little.

~


 FLASH MX AND COLDFUSION MX (formally known as NEO)
-
There is no doubt -- it is a really good time to know ColdFusion.  Since
our last newsletter, Macromedia has released the much-anticipated new
release of Flash MX.  Macromedia has also released the mention of the
next version of ColdFusion.  Previously referred to as the lead
character from the movie the Matrix  NEO has been formally announced
as ColdFusion MX.

This is a direct Quote from the March 4th Press Release from Macromedia:

   Macromedia ColdFusion MX, which can be
used in conjunction with Microsoft .NET,
Java application servers, and web services,
will provide developers with the fastest and
easiest way to create rich applications with
Macromedia Flash MX. In addition, developers
will be able to use a new server gateway technology
to build Macromedia Flash applications that work
directly with leading application servers and
web services.

http://www.macromedia.com/macromedia/proom/pr/2002/flash_mx_apps.html

What does this mean and why, as ColdFusion developers, are we paying so
much attention to it?  Using the new server gateway technology
ColdFusion MX can now be leveraged even more to work with Flash MX
applications.. Ok, its a bit vague, but trust me when I say that the
CFNorth conference will really make it all make sense and will
definitely leave you stunned with the possibilities of what these two
technologies can provide.
~


 EXHIBITORS & Give-A-Ways
---
CFNorth will have over 12 exhibit booths and a tonne of give-aways.
Exhibitor booths are a fantastic way for you to really explore what this
ColdFusion community is made up of.  ColdFusion consultants, cool
Developer tools, applications that you can incorporate into your own
products, lead authors of many of the ColdFusion books will all
available for you to interact and talk with.

If you are on the borderline of choosing an application server (such as
ColdFusion) then talking with these people will give you a great
perspective onto what ColdFusion can offer your organization.  Its not
just about ColdFusion, remember.  ColdFusion is the foundation for a lot
of awesome products and services, and these exhibitors will demonstrate
the real power of what ColdFusion is all about.


If you have been to any of the ColdFusion User Group meetings, you know
we always give away lots of stuff.  Well, here is a preview of just some
of the give-a-ways from some of our sponsors, that you could win, just
for coming!
- Very cool Macromedia Bags
- ColdFusion Application Server from Macromedia
- Flash MX from Macromedia
- Free Internet Hosting from NI Solutions Group
- FuseTalk from e-Zonemedia
- Adalon application design tools from Synthis
- Load Testing from OpenDemand
- Swift3D Animation Software for Flash MX from Electric Rain
- ColdFusion and Flash Books plus conference discounts
- Content Management systems from PaperThin and Ektron
- Consulting Services and more!
- Lots of T-Shirts, Mugs an

RE: mySQL / ODBC / Windows problem

[Matt Robertson]

Neil,

You mean in cf administrator?  You can't use CF to create datasources
(so far at least).  You have to have admin access to the server and use
the Windows ODBC applet to do that directly -- Programs / Administrative
Tools / Data Sources (ODBC).  Then CF will automatically be able to see
the source inside of itself (and that source should be properly
configured by default, unless you want to restrict sql ops via cf for
some reason).

Cheers,

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



-Original Message-
From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 9:59 AM
To: CF-Talk
Subject: RE: mySQL / ODBC / Windows problem


Thanks Matt, 

I know it is a problem with the actual SQL as everything else is sweet.
When you create a new datasource to mySQL, do you have to check any of
the multiple checkboxes?!

Neil


__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF and EBAY

[Tony Schreiber]

I wrote one of those two. It goes a step further and grabs all the bidders
on the matching auctions... Very evil. ;)

> I have an agent that takes a search term and an optional category and
> searches for all items of that type. Would that do? I also did a little
> with an ebay agent in my HTTPAgent lecture from one of the conferences.
> Should be on the front of HoF.
>
> At 06:27 PM 3/26/02, you wrote:
> >Does anyone know if any tags exist that grab a sellers auctions form ebay?
> >I thought I would ask before trying to do this myself... no sense in reinventing 
>the wheel.
> >
> >Thanks,
> >
> >Mike
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF and EBAY

[Robert Everland]

Can the rest of us see?

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 3:19 PM
To: CF-Talk
Subject: Re: CF and EBAY


I wrote one of those two. It goes a step further and grabs all the bidders
on the matching auctions... Very evil. ;)

> I have an agent that takes a search term and an optional category and
> searches for all items of that type. Would that do? I also did a little
> with an ebay agent in my HTTPAgent lecture from one of the conferences.
> Should be on the front of HoF.
>
> At 06:27 PM 3/26/02, you wrote:
> >Does anyone know if any tags exist that grab a sellers auctions form
ebay?
> >I thought I would ask before trying to do this myself... no sense in
reinventing the wheel.
> >
> >Thanks,
> >
> >Mike
> >
> >
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Dynamic attributes in CF tags?

[Jamie Jackson]

Is it possible to dynamically generate attributes in CF tags?

Of course it's possible to dynamically change attribute values:


But, is it possible to dynamically control *inclusion* of the
attribute itself? For instance:


The above doesn't work, and neither does this:
attribute="#myVar#">>

My problem is much more complex, but this is the crux of it.

Thanks,
Jamie
_
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

XML news feed

[chris.alvarado]

I know this is like the 1.3^35 time this has been brought up but can anyone
list the XML news feeds they know of?

Preferably free but if its good i wouldnt mind paying.

Thanks a 1.3^35

=)

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.

__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dynamic attributes in CF tags?

[Raymond Camden]

It is, but only for custom tags. To use this feature, you pass a struct
called AttributeCollection. Ie:










Depending on x, you will either have foo or goo passed.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Jamie Jackson [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, March 27, 2002 3:26 PM
> To: CF-Talk
> Subject: Dynamic attributes in CF tags?
> 
> 
> Is it possible to dynamically generate attributes in CF tags?
> 
> Of course it's possible to dynamically change attribute values:
> 
> 
> But, is it possible to dynamically control *inclusion* of the
> attribute itself? For instance:
> 
> 
> The above doesn't work, and neither does this:
> attribute="#myVar#">>
> 
> My problem is much more complex, but this is the crux of it.
> 
> Thanks,
> Jamie
> _
> 
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists