Re: How to set a file upload input box to readonly.

2004-01-23 Thread Gary Groomer
Mario,

Find below a snippet that I use:

" (event.keyCode > 0) event.returnValue = false;"

Just add the above to the input tag.  It allows the selection of files by using the path button, but prevents direct of entry.

Gary
  - Original Message - 
  From: Ciliotta, Mario 
  To: CF-Talk 
  Sent: Thursday, January 22, 2004 2:52 PM
  Subject: SOT: How to set a file upload input box to readonly.

  Hi,

  Does anyone know how to make a file upload input box read only.  I am having a
  problem where my users do not click the browser button but instead type the
  name of the file they want to upload and I though that if I make the input box
  read only I can stop this.  Also can the color of the  button be
  changed, all the buttons on the page are blue and white expect for this one.

  I searched for a CSS solution but I did not find any.

  Thanks

  Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Passing a List to Oracle 8i Stored Proc

2003-11-05 Thread Gary Groomer
Unfortunately, it is not a simple task to send a list to a stored procedure.  Find attached a copy of one that I developed for use with SQL server.  Hope it helps.  I can't remember if this list strips off attachments.  If it does, I'll send the attachment to you offline.

Gary
  - Original Message - 
  From: Dave Carabetta 
  To: CF-Talk 
  Sent: Wednesday, November 05, 2003 4:43 PM
  Subject: Passing a List to Oracle 8i Stored Proc

  I'm trying to pass a list in to an Oracle 8i stored proc (using MX 6.1), but 
  it doesn't seem to be working. This list would be something like:

  BO,AT,CA

  and in the proc, the query would be something like

  SELECT foo
  FROM myTable
  WHERE code IN (theList)

  Is this even possible? If I pass in one value, the proc works fine, but as 
  soon as I try and use a list, I get no results back.

  Thanks,
  Dave.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfselect Bug in CF6.1?

2003-09-04 Thread Gary Groomer
I ran into this problem when I first ported a couple of CF5 application to
CFMX.  I can't remember the names that caused problems, but I determined
that it was not a bug.  It had to with the switch to underlying Java code
and the use of reserved words.  It would be nice if Macromedia listed all
reserved words.  On the good side, if you are developing in CFMX, it will
throw an error as soon as a reserved word is used.

Gary Groomer

- Original Message - 
From: "Avi Flax" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 7:07 AM
Subject: cfselect Bug in CF6.1?


> It seems that CF6.1 throws an error if it encounters the value "Name" in
> the "value" attribute of CFSELECT. This worked fine in CF5. Has anyone
> else seen this? Is it a known bug or known behavior?
>
> This code works in CF5, throws an error in CF6.1:
>
>  action="LIST"
> directory="#GetDirectoryFromPath(GetCurrentTemplatePath())#"
> name="Q_Files"
> filter="*.cfm">
>
> 
>  name="FileName"
> size="1"
> query="Q_Files"
> value="Name"/>
> 
>
> The error is:  You have attempted to dereference a scalar variable of
> type class java.lang.String as a structure with members.
>
> It's not the biggest deal, just somewhat annoying. I'm using this
> workaround for now:
>
>  action="LIST"
> directory="#GetDirectoryFromPath(GetCurrentTemplatePath())#"
> name="Q_Files"
> filter="*.cfm">
>
> 
>  ListToArray(ValueList(Q_Files.Name)))>
>
> 
>  name="FileName"
> size="1"
> query="Q_FileNames"
> value="FileName"/>
> 
>
> Thanks!
>
> -
> Avi Flax - Systems Architect
> The Argus Group, Inc. (a division of ADP)
> [EMAIL PROTECTED]
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Cheap CF hosting?

2003-04-02 Thread Gary Groomer
I have been real happy with www.abihosting.com.  Excellent services, support
and prices.

Gary Groomer

- Original Message -
From: "Simon Horwith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:28 AM
Subject: RE: Cheap CF hosting?


> I like CFDynamics... I don't know if it's "cheap" in your book, but I
think
> their prices are excellent considering what you get with the packages.
>
> ~Simon
>
> Simon Horwith
> Macromedia Certified Instructor
> Certified Advanced ColdFusion MX Developer
> Certified Flash MX Developer
> CFDJList - List Administrator
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> http://www.figleaf.com
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 02 April, 2003 12:17 PM
> To: CF-Talk
> Subject: Cheap CF hosting?
>
>
> Anyone have recommendations for CHEAP CF hosting, preferably MX?  I tried
> signing on with Exciteworks, but their paypal stuff doesn't work.  I also
> tried nexpoint, but their ordering system doesn't work either.
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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



Re: Current JS & CSS help files for CF Studio 5?

2003-03-28 Thread Gary Groomer
Pete,

Try the JavaScript reference at this link
http://devedge.netscape.com/central/javascript/.  I downloaded both the
guide and the reference and placed the folders within Studio's help folder.
I chose to use v1.3, but you can pick a later version if you want.  This way
I can search and get to the files just like any other help file within
Studio.

Gary Groomer

- Original Message -
From: "Pete Ruckelshaus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 5:39 AM
Subject: OT: Current JS & CSS help files for CF Studio 5?


> Hi,
>
> I was wondering if there were any current JavaScript (to 1.3 at least) and
Cascading Style Sheet (to 1.0/XHTML at least, 2.0 would be even better) help
files that will work with Cold Fusion Studio 5?  I found some online but
they were dated 1998 and I think by now I have most of that stuff committed
to memory :G:
>
> Thanks,
>
> Pete
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Homesite+

2003-03-26 Thread Gary Groomer
I use ColdFusion Studio 5 at work and HomeSite+ at home.  HomeSite+ is,
basically, the same as CF Studio 5 except for two main items.  It installs a
slimmed down set of help files.  I simply copied by CF Studio 5 help files
into the Help folder so I would have both sets available.  As far as
obtaining it, the only way that I know is by purchasing Studio MX - it is on
the CD.

Gary Groomer

- Original Message -
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 4:35 AM
Subject: Homesite+


> I purchased Homesite 5 a while back, but I was wondering what the
> difference between that & Homesite+ is.  Also, how can I upgrade to
> Homesite+ (and how much)?
>
> Scott
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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



Re: HomeSite+ v5.2 - Can't Dock the Resources Window

2003-03-25 Thread Gary Groomer
Your correct!  I would have never guessed, but you have to right-click and
select "Move to" for each of the resource tabs and move one at the time to
the location you want.

Thanks, Gary

- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 5:49 PM
Subject: RE: HomeSite+ v5.2 - Can't Dock the Resources Window


> Try right clicking on the window, then Move xyz to...
>
> Make sense? (Don't know if this works, just guessing)
>
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 26 March 2003 1:40 p.m.
> To: CF-Talk
> Subject: HomeSite+ v5.2 - Can't Dock the Resources Window
>
> I accidentally undocked the 'Resources Window" and can't figure out how to
> dock it.  I use CF Studio 5 at work and all you have to do is to drag the
> window and it will dock anywhere that you wish.  But, HomesSite+ doesn't
> offer this option.  Any ideas would be greatly appreciated.
>
> Gary
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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



HomeSite+ v5.2 - Can't Dock the Resources Window

2003-03-25 Thread Gary Groomer
I accidentally undocked the 'Resources Window" and can't figure out how to
dock it.  I use CF Studio 5 at work and all you have to do is to drag the
window and it will dock anywhere that you wish.  But, HomesSite+ doesn't
offer this option.  Any ideas would be greatly appreciated.

Gary


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

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



Re: Old Version of CF $erver

2003-02-22 Thread Gary Groomer
What about Blue Dragon for CFML?
http://www.newatlanta.com

Gary

- Original Message -
From: "Michael Pool" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 22, 2003 7:07 AM
Subject: Old Version of CF $erver


> Anybody out there know a place I can get ahold of an old copy of CF Server
5 or less? I have a new boss that won't spring for CFMX and he want's me to
build a huge Intranet document/information management system.
>
> All in all I am looking for ANY cheap routes to getting CF on this server
(what a tight ass this guy is!this is a Billion dollar contract and he
is worried about $700!!).
>
> ANY help you can give me would be greatly appreciated.
>
> Believe me, I have tried to convince him to buy me the new version of the
server, to no avail. There has got to be a way I can get this thing running
inexpensively. I'm only going to have about 75 users on this Intranet (if
that) but, this app could carry over to many other installations around the
world if I can make it fly. (this means lots of CFMX sales...and I mean
LOTS! Plus, lots of CF Programmer jobs for all of us!!!)
>
> I know about the single user version, but that is not going to work...I
need a cheap, legal, workable solution to this.
>
> Thank's CF Peeps.
>
> Tryin' to keep the faith
> M.Pool
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

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



Re: CFMX CFHTTP test

2003-02-15 Thread Gary Groomer
I received the following message:

0 Failure Hard 250005 No Access Identification provided

Gary
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 15, 2003 4:29 PM
Subject: Re: CFMX CFHTTP test


> On 2/15/03, Bud penned:
> >https://www.ups.com/ups.app/xml/Rate"; method="POST">
> >
> >
>
> ACK!
>
> I don't know how I didn't paste this in there:
>
> #cfhttp.filecontent#
>
> Could anyone that said they get a blank page try it again and see if
> you get any output or just "Connection Failure"?.
>
> Thanks and sorry.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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




Re: CF Hosting Suggestions

2003-01-22 Thread Gary Groomer
I use ABI Hosting http://www.abihosting.com/.  I use them personally and
have several clients with them, as well.  Excellent support and inexpensive.

Gary

- Original Message -
From: "Cutter (CF_Talk)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 12:04 PM
Subject: CF Hosting Suggestions


> Anyone know who is the low cost CFMX host with MSSQL or mySQL support?
> (and mail)
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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




Coldfusion Message - Oracle Error Code = 0

2002-10-28 Thread Gary Groomer
The company that I am working for, is periodically, bombarded with the
following error message:

Coldfusion Error Type - DATABASE
Coldfusion Message - Oracle Error Code = 0
Timeout while obtaining an Oracle connection lock

They are running CF 5 with Oracle 8i on the backend and are using the native
drivers to connect to Oracle.  I have searched high and low, but have not
been able to find a definitive solution.  Has anyone run into this error and
found a solution?

Gary Groomer

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



Re: MYSQL DRIVER for CF 5

2002-06-12 Thread Gary Groomer

Why not make a DSNLess connection.  Here is a url with some good
instructions.

http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp

Gary Groomer

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 12:47 PM
Subject: RE: MYSQL DRIVER for CF 5


> Whoot, I can finally come to the rescue here...
>
> Here's a tutorial on how to setup CF5 / MySQL together:
> http://www.web-rat.com/Tutorials/CFMySQL/
>
> ~Todd
>
>
> On Wed, 12 Jun 2002, Bosky, Dave wrote:
>
> > Download myODBC from
> > http://www.mysql.com/downloads/api-myodbc-2.50.html
> >
> > ~Dave
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 12, 2002 3:43 PM
> > To: CF-Talk
> > Subject: MYSQL DRIVER for CF 5
> >
> > IS there an odbc driver i can use to setup a Datasource with CF5 to a
mysql
> > DB? or am i gonn have to write this in PHP :)
> >
> > Bill Wheatley
> > Senior Database Developer
> > Macromedia Certified Advanced Coldfusion Developer
> > EDIETS.COM
> > 954.360.9022 X159
> > ICQ 417645
> >
> >
> >
> 
__
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



Hybrid Macromedia ColdFusion MX Tag Updater

2002-06-09 Thread Gary Groomer

I made some modifications to the installation procedure for the Macromedia
ColdFusion MX Tag Updater for Studio 4.5 and 5.0 so as to add some
functionality.  The first part adds tag insight and tag completion. The
second part adds a new help section to Studio's help pane reflecting the new
and changed tags.  Since I couldn't attach the file, anyone interested can
find the instructions at the following url:

http://www.designfirst.com/library.cfm?CatID=3

Gary Groomer



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ColdFusion Studio - Added Functionality for MX VTM's and Help Files

2002-06-06 Thread Gary Groomer

I forgot that this news group strips attachments.  I'll upload the file to
my web site and re-post the message when I get a chance.

Gary Groomer

- Original Message -
From: "Gary Groomer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 9:16 PM
Subject: ColdFusion Studio - Added Functionality for MX VTM's and Help Files


> As I am an avid fan of ColdFusion Studio and want to get as much life out
of
> it as possible, I made some modifications to make it a bit friendlier to
the
> new and changed MX tags.  I decided to document the changes in case anyone
> else might be interested.
>
> First, I added tag completion so the new tags appear in the popup list and
> tag completion.  Second, I added a section to Studio's help pane entitled
> "ColdFusion MX Tags - New and Changed so that the new help files could be
> easily browsed.  The instructions are in the attached text file.  I hope
> that you find it useful.
>
> For the record, I would like to see Macromedia turn over Studio to an open
> source group.  Then, we as developers, could control Studio's destiny.  It
> wouldn't hurt them in the long run as I still plan on developing
ColdFusion
> applications, which means more money in their pockets.  But, I don't like
> being told to convert to a graphical interface after years of developing
in
> Studio and other text based IDE's.  I would rather go back to Notepad.
>
> Gary Groomer
>
> 
__
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



ColdFusion Studio - Added Functionality for MX VTM's and Help Files

2002-06-06 Thread Gary Groomer

As I am an avid fan of ColdFusion Studio and want to get as much life out of
it as possible, I made some modifications to make it a bit friendlier to the
new and changed MX tags.  I decided to document the changes in case anyone
else might be interested.

First, I added tag completion so the new tags appear in the popup list and
tag completion.  Second, I added a section to Studio's help pane entitled
"ColdFusion MX Tags - New and Changed so that the new help files could be
easily browsed.  The instructions are in the attached text file.  I hope
that you find it useful.

For the record, I would like to see Macromedia turn over Studio to an open
source group.  Then, we as developers, could control Studio's destiny.  It
wouldn't hurt them in the long run as I still plan on developing ColdFusion
applications, which means more money in their pockets.  But, I don't like
being told to convert to a graphical interface after years of developing in
Studio and other text based IDE's.  I would rather go back to Notepad.

Gary Groomer

__
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: Updating a form from a pop up window (Frames)

2002-05-21 Thread Gary Groomer

This is what the below script does.  In the example that I am referring to,
the user clicks on a link in one frame, selects the quantity and item color
in the PopUp.  Upon clicking the submit button in the PopUp, the PopUp
closes and posts the data back to another frame for addition to the users
shopping cart.

Gary Groomer

- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 8:29 AM
Subject: RE: Updating a form from a pop up window (Frames)


> Can the same methodology be used to update a frame and/or frames from a
> pop-up window?
>
>
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 11:03 AM
> To: CF-Talk
> Subject: Re: Updating a form from a pop up window
>
>
> Steve,
>
> I just went through this for a shopping cart that I developed.  Here is
the
> code that I used.
>
> 
> 
> <!--
> // Link the Popup Window Back to the Opener
> function targetopener(mylink, closeme, closeonly)
> {
> if (! (window.focus && window.opener))return true;
> window.opener.focus();
> if (! closeonly)window.opener.location.href=mylink.href;
> if (closeme)window.close();
> return false;
> }
> //-->
> 
>
> 
> 
>   onClick="javascript:window.close();">
> 
>
> I hope it helps, Gary Groomer
> - Original Message -
> From: "Steve Powell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, May 21, 2002 7:36 AM
> Subject: Updating a form from a pop up window
>
>
> > Hi guys
> >
> > I'm building a content control system where new products are added or
> updated
> > via a form. I want the users to be able to upload images. I'm storing
the
> image
> > name in the DB along with the other porduct details.
> >
> > The plan is to use a sub window whihc allows the users to upload a new
> image
> > using CFFILE and then retrive the filename with the serverFile param.
> >
> > I wonderd if there were any quick ways of updating the master form with
> the new
> > image name. I'm guessing the answer is some Javascript and DHTML. I
> suppose I'd
> > better also set the value of a hidden control and then pass that along
> with the
> > regular text inputs to the action page whihc will insert/update the DB?
> >
> > And I hate debugging JavaScript.
> >
> > Anyone have any better ideas?
> >
> > regards
> >
> > Steve
> >
> >
> > Steve Powell
> > 07971 583 792
> > [EMAIL PROTECTED]
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> >
>
>
> 
__
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



Pop-up window question

2002-04-27 Thread Gary Groomer

I am developing a shopping cart application where the specifications call
for the user being able to view product details and select order the
quantity from a pop-up "Child" window.  They will be given the option to
close the Child window and continue shopping.  If they want to order the
item, they would select the quantity in the Child window and click on the
submit button.  Upon clicking on the submit button, the Child window needs
to close and send the form field values back to the "Parent" window for
processing.

Personally, I can't see how the form data can be sent from the Child window
to the Parent window.  My only thought would be using URL parameters, but I
can't figure out how to call the Parent window from the Child window.  If
anyone has any ideas, they would be greatly appreciated.  Otherwise, I am
going to have to convince the client to convert the pop-up window to a
normal window so that I can control things.

Gary

__
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: How do you send a ColdFusion variable to a Flash Movie?

2002-04-03 Thread Gary Groomer

The solution was so simple, but it didn't occur to try it.

Thanks, Gary

- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 3:10 PM
Subject: RE: How do you send a ColdFusion variable to a Flash Movie?


> I like this way the best:
>
>
> mymovie.swf?var1=value1&var2=value2
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 5:58 PM
> To: CF-Talk
> Subject: How do you send a ColdFusion variable to a Flash Movie?
>
>
> I got roped into creating a small Flash movie for a client.  Creating the
> Flash movie was simple, but I can't figure out how to send a ColdFusion
> variable to the Flash movie.  It should be simple, but I can't seem to
find
> how to do it in the Flash documentation without saving the variable to a
> file.  If I save it to a file, it works great.
>
> Basically, ColdFusion will create a variable by querying a database and
then
> it will do some string manipulation.  This variable, intern, needs to be
> passed directly on to a Flash movie.  If anyone can direct me in the right
> direction, it would be greatly appreciated.
>
> Gary Groomer
>
>
> 
__
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



How do you send a ColdFusion variable to a Flash Movie?

2002-04-03 Thread Gary Groomer

I got roped into creating a small Flash movie for a client.  Creating the
Flash movie was simple, but I can't figure out how to send a ColdFusion
variable to the Flash movie.  It should be simple, but I can't seem to find
how to do it in the Flash documentation without saving the variable to a
file.  If I save it to a file, it works great.

Basically, ColdFusion will create a variable by querying a database and then
it will do some string manipulation.  This variable, intern, needs to be
passed directly on to a Flash movie.  If anyone can direct me in the right
direction, it would be greatly appreciated.

Gary Groomer

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Studio - Can't select a word by double-clicking with a mouse

2002-03-15 Thread Gary Groomer

You were on the right track.  I went into my mouse control program and
adjusted the Double-Click Timing and it works perfectly.

Thanks,

Gary Groomer

- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 3:52 PM
Subject: Re: CF Studio - Can't select a word by double-clicking with a mouse


> Yupit just happens.  I've been dealing with that since Studio 4.0.1 I
beleive.  It just seems
> that if you double-click too fast it will only select part of a word.
I've never tried, but mabye
> slowing down the mouse double-click speed my help.
>
> HTH
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>
> - Original Message -
> From: "Gary Groomer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 15, 2002 3:45 PM
> Subject: CF Studio - Can't select a word by double-clicking with a mouse
>
>
> > Until recently, I have been able to select a word in ColdFusion Studio
by
> > double-clicking on the word.  Recently, I can only select part of a
word.
> > This is the only application in which I am having this problem. I have
> > re-installed CF Studio and my mouse drivers, but nothing seems to help.
Has
> > anyone else run into this problem and arrived at a solution?
> >
> > Gary Groomer
> >
> >
> 
__
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



CF Studio - Can't select a word by double-clicking with a mouse

2002-03-15 Thread Gary Groomer

Until recently, I have been able to select a word in ColdFusion Studio by
double-clicking on the word.  Recently, I can only select part of a word.
This is the only application in which I am having this problem. I have
re-installed CF Studio and my mouse drivers, but nothing seems to help.  Has
anyone else run into this problem and arrived at a solution?

Gary Groomer

__
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



Open Multiple Rich Text Format (RTF) Files On One Page

2002-01-08 Thread Gary Groomer

Does anyone know how to open multiple Rich Text Format (RTF) files on one
html page?  The text for the RTF files will be stored in a database and each
file will have it's own fonts and layout that needs to be maintained.  Any
ideas would be greatly appreciated.

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



Re: MySQL?

2001-10-28 Thread Gary Groomer

The only way to connect to the ColdFusion Application Server is via an ODBC
connection.  Therefore, download and install MyODBC.  It is available at
http://www.mysql.com/downloads/api-myodbc.html.

Gary Groomer

- Original Message -
From: "Rich Tretola" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 12:09 PM
Subject: MySQL?


> How can I connect to a MySQL datasource through the CF 5 admin (Windows
> 2000)?
>
> Rich
> 
~~
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: IIF vs if,else

2001-06-20 Thread Gary Groomer

The only advantage would be if you, as a coder, prefer the IIF() format over
the ... format.  Where performance is an issue, stay away from
the use of ColdFusion's dynamic functions such as IIF() as performance will
definitely suffer.

Gary Groomer

- Original Message -
From: "Cameron" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 4:02 PM
Subject: IIF vs if,else


Ok, after a bit of testing... can anyone tell me what the advantage of IIF
over if ( or if () {}), else ( or else {}).

I tested a simple block of code using IIF and  & IIF
ran twice as slow...

I can't see any major advantage by using it... yeah, it is kinda similar to
i = (true?1 : 2); in javascript but it's really slow case of the implicit
evaluate() on each part. Would be better if it was implicit & made explicit,
IF NEEDED.

Can anyone give me a decent reason why IIF is better that ?

Cameron Junge
Web Developer
Strongnet
[EMAIL PROTECTED]
http://www.strongnet.co.nz
Ph: +64 9 414 2492
Fax: +64 9 414 2960

"You play with a Mac until you break it,
You play with a PC until it works."


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Interland

2001-06-12 Thread Gary Groomer

My experiences with Interland's hosting services over about two years was
nothing but bad.  I finally moved all accounts away.  It was almost
impossible to get the simplest thing done or question answered.  Also, a
couple of months ago they more than tripled their ColdFusion hosting rates.
I was told that they want to discourage the hosting of ColdFusion.

Gary

- Original Message -
From: "Kay Smoljak" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 11:53 PM
Subject: Interland


> Hi,
>
> I've just been through the archives looking for any comments on
Interland's
> hosting service. I notice there's quite a few negatives in there, as well
as
> a few "they're ok" kind of messages, but they are all from quite long ago.
> Does anyone have any recent comments to make about them? Has their service
> improved at all?
>
> I have a client who is already on Interland with a HTML/ASP site... I'm
> doing some CF for them... and they really don't want to move if they don't
> have to. Does anyone know what CF version they are using? I sent them an
> email but I haven't heard back yet.
>
> Thanks,
> K.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Random records?

2001-06-06 Thread Gary Groomer

See the following:

Pulling Random Records from a Database:

There are occasions when you need to pull random records from a
database--for example, you might have a database of articles from which you
want to display one at random. For the sake of discussion, let's say your
Articles table contains the following fields:

ArticleID, Author, and Content. ArticleID is a unique numerical value, while
Author and Content are both Text fields.

If ArticleID contains sequential numbers, you can simply pull the last
record, get the ArticleID, generate a random number from 1 to that
ArticleID, then pull the record associated with that random ArticleID
number.

Of course, this method will work only if there are no gaps in the numeric
values--if your random number is one that doesn't exist in the database,
your query will return a blank result or throw an error. To get around this
potential problem, however, you can use some of ColdFusion's list
functionality. Let's take a look:

First, query the database and retrieve all the ArticleID values:


SELECT articleid FROM articles


Next, build a list of the values returned and determine the number of items
in the list. Use the RandRage() function to choose the position in the list
from which to pick an ArticleID, and set that value as a variable:







Finally, use the randomly selected ArticleID to query the database for that
record:


SELECT Author, Content FROM Articles
WHERE ArticleID = #RandomArticleID#


There you have it--a simple way to retrieve a random record from the
database.

I hope the above helps, Gary Groomer

- Original Message -
From: "Alii Design" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 8:07 AM
Subject: Random records?


> How do i display a random record from a query?
>
> Rich
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Next-Previous Record Display

2001-05-07 Thread Gary Groomer

Try the below link.  This custom tag does an excellent job and it is easy to
customize.

http://www.fruir.net/web/JustApp/customTags/CF_RESULTPAGES/

Gary Groomer

- Original Message -
From: "Steve Reich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 9:13 PM
Subject: Next-Previous Record Display


> Does anyone know of a good, robust tag to do the Previous 10 - Next 10
> routine on displaying recordsets? I need it to output the number of pages
in
> the return as well. There is cf_nextrecords in the tag gallery, but it is
> too thin for my needs. I know I've seen a couple of good one's out there,
> but I can never find anything when I need it. I'm hoping I won't have to
> write my own anyone?
>
> Thanks,
> Steve
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Close window : JavaScript (OT)

2001-05-05 Thread Gary Groomer

Put the below code in the head of your document to open another window when
the browser window is closed.

Gary Groomer

<!--
function goExit() {

nextWin=window.open('<A  HREF="http://localhost/PopUp.htm">http://localhost/PopUp.htm</A>','lastWin','status=no,resiza
ble=yes,scrollbars=no,location=no,left=0,top=0,width=400,height=400');
}
//-->


- Original Message -
From: "Joseph Eugene" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 9:33 AM
Subject: Close window : JavaScript (OT)


> Hi all,
>   I would like to know, if you guys had any code to
>   1.Open a new window when the User tries to close his Browser.
>   2. Close the new window Just opened when the user tried to close
> his browser.
>
> The above really is to Log the User Out and terminate his
> session.
> Appretiate any help
> Thanks
> Joe
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hosting

2001-05-01 Thread Gary Groomer

I recently moved my ColdFusion web site from Interland to ABI Hosting
(www.abihosting..com) and the service puts all others that I have used to
shame.  The basic setup, which includes SQL Server 2000, starts at only
$19.95 per month with no setup fee.  Less for a yearly contract, more for
some e-commerce options.

Gary Groomer

- Original Message -
From: "CF Crazy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 1:01 PM
Subject: Hosting


> Anyone know of a hosting company who will provide the CF/SQL server and
> manage it?
> I just need monthly cost for a year contract. Maybe setup too.
>
> Steph
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Cfmail

2001-04-25 Thread Gary Groomer

I had the same problem with Earthlink.  After extensive research, I found
out that as an anti-spam effort their mail servers wouldn't allow the
sending of email through their servers unless logged in as a user.  I was
told that they block the email so as to avoid spamers from using their
servers to send spam in order to hide their identity

Gary Groomer

- Original Message -
From: "Heidi Belal" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 6:42 AM
Subject: Cfmail


> Hi!
> I have a question regarding cfmail.  It's really
> strange.  I used the cfmail tag to send an email, but
> it is not going through to the webemails such as
> excite, yahoo, hotmail..etc..but it goes through to my
> pop3 account just fine.
> Does anybody have an idea why that would be case or
> how to fix it?
> thanks!
>
> =
> Heidi Belal
> ICQ# 32127109
> http://m3.easyspace.com/hmbelal
>
> A bus stops at a bus station.
> A train stops at a train station.  On my desk
> I have a work station...
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SQL books

2001-03-16 Thread Gary Groomer

The best book that I have found that covers complex queries is "SQL Queries
for Mere Mortals" by Hernandez & Viescas.  It is very clearly put together
and comes with sample databases for MS Access, MS SQL Server and Oracle.

Gary Groomer

- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 12:26 PM
Subject: OT: SQL books


> Hi,
>
> I need to buy a good SQL book for reference and help on joins and
> complicated queries - if only to stop me clogging the list up with "Query
> help" subjects...
>
> Anyone got any favourites?
>
> Will
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Evaluating height/width of a JPG?

2001-01-21 Thread Gary Groomer

I have successfully used the "ImageSize.cfm" custom tag from Allaire's web
site.  If you use this with Photoshop images, make sure that the files are
not saved with thumbnails as this tag may pick up the size of the thumbnail
vs. the size of the image.  Also, you will find more custom tags on
Allaire's site which do the same thing.

Gary Groomer

- Original Message -
From: "Les Irvin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, January 20, 2001 11:37 PM
Subject: Evaluating height/width of a JPG?


> Is it possible to dynamically evaluate the width and/or height of a JPG or
> GIF that a client uploads to a site?  I want to take action based upon
> those parameters of a graphics file.
> Thanks,
> Les
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Studio list and Studio 4.5.2 released

2000-12-23 Thread Gary Groomer

Warning!  The first thing that I needed to do after installing the
ColdFusion Studio 4.5.2 Update was to look up a WDDX question under
"Exchanging Data via XML in Help References.  To my amazement, the help
screen came up blank.  After further research, I found that most of the
"HTM" help files are zero bytes.  Hopefully, this problem will be addressed
in 4.5.3.

Gary Groomer

- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 22, 2000 7:43 AM
Subject: Studio list and Studio 4.5.2 released


> ColdFusion Studio 4.5.2 has been released. This is a rather useful release
> just for its ability to lock the side tabs and 'remember' that its in an
RDS
> session for saving. You can read about the other features in the release
> notes and download the update at:
>
http://allaire11.allaire.com/download/startdownload.cfm?ProdID=4F02C6C0-D533
> -11D4-B0BF00508BCF1978&FamID=1953B558-7AC0-11D4-849E0010B547F60A&SubFamID=
77
> 1264D3-6E4C-11D4-849E0010B547F60A&DownloadType=Update
> An additional announcement is the opening of the Studio list at House of
> Fusion. This list is for discussion about CF Studio, JRun Studio and
> Homesite. You can subscribe from the list page at www.houseoffusion.com.
> Have a happy holidays.
>
> Michael Dinowitz
> Publisher: Fusion Authority weekly news alert
> (www.fusionauthority.com/alert)
> Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
> (www.houseoffusion.com)
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFMAIL and undelivered mail

2000-12-22 Thread Gary Groomer

I had the same problem with CF 4.5.1 and SP1 and SP2 did not solve it.  The
only solution that I found was to roll back to CF 4.0.1, which ran
flawlessly.  If you find a reliable solution with CF 4.5.1, I would like to
know.

Gary Groomer

- Original Message -
From: "David Cummins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 21, 2000 1:53 PM
Subject: CFMAIL and undelivered mail


> Hi guys,
>
> Our CF 4.5 server is generating a lot of undelivered mail.
>
> Does anyone know what conditions make CF put mail in the undelivered
directory?
>
> Also, we've tried moving mail from undelivered to spool. Sometimes it gets
sent,
> but if you move too much into spool it doesn't seem to.
>
> Could this be timeout related? Does anyone have a solution for remailing
these
> easily?
>
> David Cummins
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Problem with

2000-12-06 Thread Gary Groomer

I am having a problem loading a file that needs to be cached.  In tracking
down the problem, I ended up with a blank page except for the ""
tag.  Everything looks properly configured in the ColdFusion Administrator,
but I get the message "Connection Failure".  Has anyone run into this and
know what I am overlooking?

Gary




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Help With SQL Query

2000-11-29 Thread Gary Groomer

Using a UNION did the trick.  Thanks for the tip.

Gary

- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2000 8:21 AM
Subject: RE: Help With SQL Query


> Well, the problem is with your join - each row in table 1 is being joined
> with EVERY row in table 2, so that your result set is 6 rows rather than
3.
> What happens if you take out the where a.user=b.user condition and just
have
> WHERE a.user = 'karl' and b.user = 'karl'?
>
> If you give us a little more information, we might be able to recommend
some
> alternatives.
>
> Some options:
>
> 1) Use a UNION
>
> 2) Use 2 queries
>
>
>
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 29, 2000 10:08 AM
> To: CF-Talk
> Subject: Help With SQL Query
>
>
> I have two tables from which I want the sum of the columns based on a
common
> key.  From the below tables, the desired output is 3,5,1,2.  Instead I get
> 6,10,6,3.  I am sure the solution is simple, but I haven't run into this
one
> before and any help would be appreacited.
>
> Gary
>
> Table1
> ---
> TableIDUserCol1Col2
> 1Karl10
> 2Karl02
> 3Karl23
>
> Table2
> ---
> TableIDUserCol1Col2
> 1Karl10
> 2Karl02
>
> SQL Query
> -
> SELECT Sum(a.Col1), Sum(a.Col2), Sum(b.Col1), Sum(b.Col2)
> FROM Table1 a, Table2 b
> WHERE a.User = b.User
> AND a.User = 'Karl'
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> 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
>
> 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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Help With SQL Query

2000-11-29 Thread Gary Groomer

I have two tables from which I want the sum of the columns based on a common
key.  From the below tables, the desired output is 3,5,1,2.  Instead I get
6,10,6,3.  I am sure the solution is simple, but I haven't run into this one
before and any help would be appreacited.

Gary

Table1
---
TableIDUserCol1Col2
1Karl10
2Karl02
3Karl23

Table2
---
TableIDUserCol1Col2
1Karl10
2Karl02

SQL Query
-
SELECT Sum(a.Col1), Sum(a.Col2), Sum(b.Col1), Sum(b.Col2)
FROM Table1 a, Table2 b
WHERE a.User = b.User
AND a.User = 'Karl'

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Create Table Question

2000-11-13 Thread Gary Groomer

Try the below:

create table T_AddBook (
> AddID COUNTER PRIMARY KEY,
> Name text(20),
> Add1 text(40),
> Add2 text(40)

Remove the PRIMARY KEY code if the filed is not to be a primary key.


Sincerely,

Gary Groomer

- Original Message -
From: "Will Ryan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 6:36 AM
Subject: Create Table Question


> Greeting Guru's
>
>   I'm trying to create a table in Access via CF. I need to create an
> AutoNumber field for an ID.  I don't want to create it through access as I
> would have to upload a 60 meg DB to our offsite server.  Any suggestions
for
> the SQL Statement?
>
> create table T_AddBook (
> AddID autonumber,
> Name varchar (20),
> Add1 varchar (40),
> Add2 varchar (40)
> )
>
>
> Thanks,
>  Will
>
> Will Ryan
> [EMAIL PROTECTED]
> http://www.zerotoeighty.com
> w: 410-327-9152
> f: 410-327-4086
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: CFMAIL Problems

2000-11-12 Thread Gary Groomer

Yes!
- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 12:01 AM
Subject: Re: CFMAIL Problems


> Are you specifying the SERVER attribute?
>
> ----- Original Message -
> From: "Gary Groomer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, November 12, 2000 11:43 AM
> Subject: CFMAIL Problems
>
>
> > I have an application that uses CFMAIL that worked perfectly with
> ColdFusion
> > Server v4.0.1.0.  I recently upgraded my server to v4.5.1 with SP1.
> >
> > Now 10 to15% of the emails are moved to the "UNDELIVR" folder and the
> > mail.log shows the following message:
> >
> > SMTP server replied "Communication failure with mail server.
> >
> > I developed a routine to move the files back to the "SPOOL" folder so
that
> > they could be resent.  The log file shows that all files are ultimately
> > sent, but 1 or 2 emails out of 6 is lost and are never received.  Has
> anyone
> > run into this problem and come up with a solution?
> >
> > Gary Groomer
> >
> >
>
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



CFMAIL Problems

2000-11-12 Thread Gary Groomer

I have an application that uses CFMAIL that worked perfectly with ColdFusion
Server v4.0.1.0.  I recently upgraded my server to v4.5.1 with SP1.

Now 10 to15% of the emails are moved to the "UNDELIVR" folder and the
mail.log shows the following message:

SMTP server replied "Communication failure with mail server.

I developed a routine to move the files back to the "SPOOL" folder so that
they could be resent.  The log file shows that all files are ultimately
sent, but 1 or 2 emails out of 6 is lost and are never received.  Has anyone
run into this problem and come up with a solution?

Gary Groomer



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]