RE: Which version of vista plays well with CF7?

[Mike Tangorre]

Will,

I have it running nicely on Vista Business and Vista Ultimate. Like Sandy, I
too am liking Vista - it takes a little getting used to but then again, most
new things takes some getting used to.

-Mike


 From: Will Tomlinson
 Sent: Wednesday, March 28, 2007 9:59 AM
 To: CF-Talk
 Subject: Which version of vista plays well with CF7?
 
 THat's my question..



~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273991
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: IE7 vs IE6

[Mike Tangorre]

 From: Claude Schneegans [mailto:[EMAIL PROTECTED]
 Has any one tried IE7, and is it possible to run both version IE6 and
 IE7 concurrently on the same machine?
 Question of verifying code for both versions of course.


There is a standalone version of IE6 floating around, Google IE6
Standalone. It requires no install and allows exactly what you're looking
for.

-Mike




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269230
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Setting properties in COM objects

[Mike Tangorre]

 From: Jerry Kew [mailto:[EMAIL PROTECTED]
 Set theDoc = Server.CreateObject(ABCpdf6.Doc)
 theDoc.Rect.Inset 72, 144


Just a shot in the dark as I am not familiar with the COM object you're
using.

theDoc.Rect.Inset(72,144)








~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: StructClear and passing in a string...

[Mike Tangorre]

 From: Andy Matthews [mailto:[EMAIL PROTECTED]
 Quick question...
 What if we wanted to just call a CFC and pass in ANY scoped variable?

Pass the name of the scope, that is, the string... session, application,
etc.. and not the scope itself.




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267771
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Apache config

[Mike Tangorre]

 From: Dave Watts [mailto:[EMAIL PROTECTED]
 http://people.apache.org/~rbowen/presentations/apacheconEU2005/hate_apa
 che.p
 df

That is a classic!




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267049
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Advanced Search

[Mike Tangorre]

 From: Pete [mailto:[EMAIL PROTECTED]
 cfquery name=qGetAdvertisers datasource=#request.db_dsn#
 username=#request.db_login# password=#request.db_pwd# select *
 from tbl_advertisers a, tbl_procedures p, tbl_advertiserprocs ap,
 tbl_advertiserstates r, tbl_states s where a.advertiserid =
 ap.advertiserid and a.advertiserid = r.advertiserid and p.procedureid =
 ap.procedureid and s.stateid = r.stateid AND
 p.procedureid=#form.procedureid# AND s.stateid=#form.stateid#
 /cfquery

I would check the value of #form.stateid#... if it's a string, get some
quotes around it.

Shouldn't you be using cfqueryparam :-)






~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266952
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: Eclipse Configuration

[Mike Tangorre]

Is it possible to use the same Eclipse configuration/preferences for all
users?  Currently, the following directory exists (hidden by default):

 

 C:\Documents and Settings\mtangorre\.eclipse\

 

I would like to move it under the Eclipse home directory:

 

D:\eclipse\

 

What is the process for moving the configuration so that Eclipse will
recognize and use the new location?  Ideally, I would like to store all of
the Eclipse configuration here. the documentation talks about shared versus
user specific versus private. I am thinking that I just need to pass the
appropriate params in when launching Eclipse or set them in the config.ini
file. I want to make sure though.  BTW, I am working with a fresh install of
Eclipse, haven't launched it yet.

 

Thanks!

 

Mike

 





~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264483
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Eclipse Configuration (solved)

[Mike Tangorre]

I think I got it... I am not sure if this is the best way to keep all (user,
global, private) configuration data together, but specifying -configuration
X:\eclipse\configuration in the startup parameters (via the .ini file or
shortcut path) does the trick - as far as I can tell.

Mike




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264518
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: IIS 6.0 Configuration

[Mike Tangorre]

I realize this is off-topic, although the end result will be related to 
ColdFusion.  I am having trouble getting two sites working on IIS.  The 
server is running Windows Server 2003 Enterprise w/ SP1.

I have two web sites setup:

www.domain.com
Host Header: www.domain.com
IP: 10.100.20.11
TCP Port: 80
SSL Port: 443

site2.domain.com
Host Header: site2.domain.com
IP: 10.100.20.11
TCP Port: 80
SSL Port: 443

I have two DNS entries as well:

www - 10.100.20.11
site2 - 10.100.20.11

Both sites have the same security certificate assigned which is actually a 
wild card certificate (but can be changed to whatever, should it be 
necessary) - *.domain.com

I need to have SSL and basic authentication set on both sites.  When I 
attempt to start both sites, www.domain.com starts fine. The second site 
however will not start as it complains about various things (depending upon 
the settings I am toying with). If the SSL port set on site2 is the same as 
www.domain.com it gives an error pertaining to that.

I have been reading various MS article regarding host headers + IIS 6 + SSL 
and have tried the various solutions and have gotten as far as 
www.domain.com working fine with SSL and basic authentication and 
site2.domain.com continuously asking me for my credentials which I continue 
to provide until I get an access denied (HTTP 401.1) the credentials are 
the same as www.domain.com.

Can anyone recommend an approach that will allow me to get both sites 
running with SSL and basic authentication?

Thanks,

Mike





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: IIS 6.0 Configuration

[Mike Tangorre]

From: Kym Kovan [EMAIL PROTECTED]
 You cannot have two different SSL sites n the same IP address as
 everything is encrypted by the SSL, even the hostname in the initial
 connection, so IIS cannot work out what site is being connected to. You
 need to use differing IP addresses.

Actually, I got it working!

Somehow, Integrated Windows Authentication got checked along with Basic 
Authentication for both sites.  Removing the first check, fixed the 
problem.

One thing I did not mention, which I discovered from Microsoft's web site, 
is that when using host headers on multiple sites running on the same IP 
where SSL is required, setting the secure bindings must be done as well as 
using the wildcard certificate with the common name set to (*.domain.com).

Set the secure bindings using the following:

cscript.exe adsutil.vbs set /w3svc/website identifier/SecureBindings 
:443:www.domain.com

and

cscript.exe adsutil.vbs set /w3svc/website identifier/SecureBindings 
:443:site2.domain.com

This only applies to Windows Server 2003 running IIS 6.0.  There is a whole 
slew of other steps when dealing with Windows Server 2000.

Anyway, its all running fine now.

Mike 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259728
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOT: MySql 4.1.21

[Mike Tangorre]

Is there a quick way to get the number of tables and columns for a given 
database?

TIA,

Mike 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258383
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SOT: MySql 4.1.21

[Mike Tangorre]

From: Barney Boisvert [EMAIL PROTECTED]
 cfquery name=get ...
   show tables
 /cfquery
 #get.recordCount#
 cfquery name=get ...
   explain #tablename#
 /cfquery
 #get.recordCount#

Perfect. Thanks Barney!




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258387
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CSS nested tag question

[Mike Tangorre]

 ..entryheader h1 A:link{
   font-family: Trebuchet MS, verdana,arial, sans-serif;
   font-size: 1.3em;
   font-weight: bold;
   margin: 0;
   color: #ff;
 }
 ..entryheader h1 a:hover{
   font-family: Trebuchet MS, verdana,arial, sans-serif;
   font-size: 1.3em;
   font-weight: bold;
   margin: 0;
   color: white;
 }
The two styles are the same what are you expecting to see? Change 
the color on the hover style and you should see a change.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257943
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: IE7 ?

[Mike Tangorre]

From: Kevin Aebig [EMAIL PROTECTED]
 All in all, I uninstalled it and got IE 6 back, but frankly I'll 
 personally
 call up M$ and tell them to eat a bowl of my nuts if they try and force 
 this
 on me with a patch...

 Wow... crap.

Tell us how you really feel!

Seriously though, why are you so upset about it? If you don't like it, don't 
use it 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257497
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Select/combine two years

[Mike Tangorre]

From: Orlini, Robert [EMAIL PROTECTED]
 cfloop list=#form.year# index=i

 cfquery name=getlist dataSource=printprices
 SELECT * FROM purchases
 where year = '#i#'
 order by orderid desc
 /cfquery

 /cfloop

cfquery name=getlist dataSource=printprices
SELECT
*
FROM
purchases
WHERE
year IN (cfqueryparam  list=true value=#trim(form.year)# 
/)
ORDER BY
orderid desc
/cfquery 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257198
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Select distinct on multiple columns

[Mike Tangorre]

From: Gareth Hughes [EMAIL PROTECTED]
 I'm turning my brain to mush with a SQL conundrum and wonder if anyone can
 offer some help.

 I keep a record of what people searched for, the date/time they searched 
 for
 it and the page they were on when they searched. My table consists of 
 three
 columns 'search_criteria', 'search_datetime' and 'search_page'.

 What I can't figure out is how to produce reports using distinct values 
 such
 as 'the 10 most recent searches' where I get ten unique results even if
 there are duplicates in the most recent db entries.

 For example let's say the most recent 10 entries includes the search 
 phrase
 'foo' 3 times - if I selected TOP 10 I'd actually only have 8 unique
 results.

 I've tried using DISTINCT in various ways but, because I need the
 'search_datetime' and 'search_page' columns in the select list, the 'foo'
 entries are all considered unique. So, I'm wondering if it's possible to 
 get
 unique values for my search phrases but include the other column data?


SELECT
TOP 10
DT.search_criteria,
ST.search_datetime,
ST.search_page
FROM
(
SELECT
DISTINCT
search_criteria
FROM
search_table
) DT
INNER JOIN search_table ST ON
DT.search_criteria = ST.search_criteria





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257197
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How do you debug this one?

[Mike Tangorre]

From: Will Tomlinson [EMAIL PROTECTED]
 Just found a bug that I don't rememeber happening before.
 I know the file is there. Where do ya start figurin this one out?
 ColdFusion could not delete the file 
 C:\CFusionMX7\wwwroot\plutonation\productImages\ScienceTeacherShirt_Small.gif
  
 for an unknown reason.


Does the file exist?
Is the file read-only?
Have you gotten any sleep? :-)





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256999
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Form Validation Custom Tag

[Mike Tangorre]

From: Ali Majdzadeh [EMAIL PROTECTED]
 Hi everybody:
 Is there any reliable, complete form validation custom tag?
 Thanks
 Benign

Form validation is pretty generic... what kinds of validations do you need 
to do? No blank fields? Check dates? Ensure one and only one checkbox is 
checked in a group of related checkboxes?





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256806
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Simple CFDump

[Mike Tangorre]

From: Snake [EMAIL PROTECTED]
 CFDUMP is just a CFML tag, so you could just rip the code out and modify 
 it.

The dump.cfm ct on my box is encrypted... last I checked. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256366
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unknown error

[Mike Tangorre]

Try clearing the class files out and then manually check the log files. 
Post some of the server error log to the list if clearing out the class 
files does not help.

Tango


From: Richard White [EMAIL PROTECTED]
 does anyone have any idea why this might be
 happening?






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254972
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Zip Code Question

[Mike Tangorre]

Search Google for the zip code distance formula. I believe you need to 
have the corresponding latitude and longitude values for the zip(s) though.

Dan Switzer has a database over at www.pengoworks.com that can get you going 
with the necessary data; grab the formula and have it.

Tango


From: John Eubanks [EMAIL PROTECTED]
I have a great question, and could use some help on it.  I am trying to
 integrate a search function based off of zip code (one of those things
 where you enter your zip code and the results near you come back).
 However, I am having issues with it, and how the zip code structure
 works.  Any assistance would be very greatful.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254987
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfinput text backcolour

[Mike Tangorre]

From: Jake Churchill [EMAIL PROTECTED]
 style=backgroundColor:##xx;  This goes inside your cfinput tag

style=background-color:##xx;






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfinput text backcolour

[Mike Tangorre]

From: Bobby Hartsfield [EMAIL PROTECTED]
 style=background:##xx;
 had to ;-)

Why?



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfinput text backcolour

[Mike Tangorre]

From: Richard White [EMAIL PROTECTED]
 is there any way of changing this background in javascript e.g. i am 
 trying to do the following but dont know exactly the syntax

 script type=text/javascript
function changeColor()
{
   firstName.style=background:##C0;
}
 /script

Put an ID on the form field and use:

document.getElementById('formElementId').style.backgroundColor = #c0; 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Hosting companies

[Mike Tangorre]

From: Doug Brown [EMAIL PROTECTED]
 Was wondering who the best hosting companies were. Need to support mySql.

Search the archives at houseoffusion.com. This is a popular question that 
pops up about once a month... lots of good info in the archives.





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252520
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CR in a textarea problem

[Mike Tangorre]

htmlCodeFormat()



From: [EMAIL PROTECTED]
 and I want to output
 the values of the field
 exaxtly the same like:





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251145
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Image Resize - again

[Mike Tangorre]

If your client got a ticket every time they didn't follow instructions 
they'd probably resize the image prior to uploading it but since no web 
enforcement exists we must anticipate EVERY possibility and help the user 
along. :-)


From: Les Mizzell [EMAIL PROTECTED]
 So, if I get a speeding ticket for going 120 in a 65 zone, the car maker
 is dumb for not limiting the top speed of the car? Or am I dumb for not
 paying attention to the instructions (speed limit sign)?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250813
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfqueryparam acting up

[Mike Tangorre]

Put a trim() and val() around the url.productId. Perhaps some whitespace is 
getting in there.


From: Richard Cooper [EMAIL PROTECTED]
 I've recently been getting some odd occurrences when using cfqueryparam. 
 For instance I've have a table products. Everything was fine until 
 recently when a product was updated via a CMS system.
 Each product that was edited after this point had this error when 
 attempted to view in a listing:
 [code]
 [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested 
 type.
 The error occurred in W:\inetpub\wwwroot\testsite\www\untitled.cfm: line 4
 2 : SELECT *
 3 : FROM products
 4 : WHERE productID = cfqueryparam value=#URL.productID# 
 cfsqltype=cf_sql_integer /
 5 : /cfquery




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249991
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: zip code converter

[Mike Tangorre]

Ray,

There is a zip file over at Pengoworks.com that contains 
zip,city,state,county,lat,long,area code, etc

It is not the most current resource as Dan Switzer was providing it to work 
with a few JS Gateway examples he developed. You can also use some web 
services from the USPS I believe...

Tango.




From: Ray Champagne [EMAIL PROTECTED]
 Anyone know of a good custom tag that will take in a zip code and return a 
 city/town that it belongs to?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250015
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: zip code converter

[Mike Tangorre]

Is that nice Ray?



From: Ray Champagne [EMAIL PROTECTED]
I take no advice from upstate New Yorkers.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250048
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Way OT: But you know you want one..

[Mike Tangorre]

I am pretty sure this is the best Dave Watts post, ever.

From: Dave Watts [EMAIL PROTECTED]
 Without getting into another endless Mac vs PC debate, I would just like 
 to
 point out that a reacharound does not involve analingus. In other words,
 you're doing it wrong. In addition, to get the derogatory effect you're
 trying to achieve, you'd want to describe Bill Gates' giving Windows users 
 a
 reacharound, not the other way around. Here's an example:

 Bill G really screwed me hard with Windows ME, and I didn't even get a
 reacharound!




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249932
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Fusebox 4 Slow?

[Mike Tangorre]

From: dave [EMAIL PROTECTED]
I don't think I have ever seen a fast fb application

Keep looking.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Stupid form fields

[Mike Tangorre]

Probably the quotes in the dump tag. Try this...

cfdump var=#form['CH58']#cfabort

HTH,

Mike T.


From: Robert Everland III [EMAIL PROTECTED]
 cfdump var=#form[CH58]#cfabort




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241809
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: (admin) important:flight favor

[Mike Tangorre]

Mike,

I sent you an email. to [EMAIL PROTECTED] I just wanted to let you 
know in case it got delivered to your spam folder.

Mike

From: Michael Dinowitz [EMAIL PROTECTED]
 Thanks and sorry again for the OT post.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241822
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Autorun exe from a usb key

[Mike Tangorre]

This should help you out...
http://www.fatwallet.com/t/28/511697/

Mike

From: Jason Rogoz [EMAIL PROTECTED]
 Has any one created an autorun.inf file that will run an exe when the user 
 inserts the usb key?
 Jason Rogoz




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241708
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Not to start a flame war.....

[Mike Tangorre]

Cutter (CF-Talk) wrote:
 hhhmmm, sounds like mach-ii, or fusebox, or...
 
 Cutter





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212065
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Oh..my...god!

[Mike Tangorre]

Dave Watts wrote:
Guess whats on the home page of macromedia.com  A ColdFusion banner!

 If you click on the banner, there's a neat little CF timeline. I'm
 especially fond of 1996.
 http://www.macromedia.com/software/coldfusion/special/birthday/?trackingid=B
 ICG
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

Pretty neat timeline! I didn't see that. I also didn't know Fig Leaf 
created the first users group! You learn something new everyday.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211503
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Oh..my...god!

[Mike Tangorre]

Connie DeCinko wrote:
 Hey, why does none of the confetti fall upon the cupcake?  Is that a
 conspiracy too?  And why does ColdFusion only get a cupcake?  After ten
 years, you'd think it would desert at least a regular size cake!

If you were at CFUNITED you could have had a nice piece of the CF 
Cake... full size and real! It looked more like a wedding cake!

:-p





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211212
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CF and JS

[Mike Tangorre]

Forgive me if this same question was going through from my work email, I am having 
problems with that email.

My question was the following:

I have a CF page with 7 form elements on it: 3 select boxes, 2 multi select boxes and 
2 buttons.
I am populating the 3 select boxes and 1 multi select boxes with queries, all related.

select box 1 - states
select box 2 - cities
select box 3 - streets
multi select box 1 - houses

What I am trying to do, is make these select boxes drill down without refreshing the 
page. For example, user selects a state, the cities box is then populated with the 
cities in that state... the user then selects a city, and that populates the streets. 
The user selects a street, and all the houses on that street are listed in the multi 
select box 1. The user can then select multiple houses from the multi select box and 
click the add button, which will add those to the multi select box 2.

Could someone assist me in writing the JS for this or point me in the right online 
resource to accomplish this? I am a novice in JS. 

Thanks.

Mike



__
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 and JS

[Mike Tangorre]

thanks for taking the time to throw that together!
That is a good start for me.. i'll shoot ya an email offlist when I get the
task done!

Thanks again.

Mike


- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 7:06 PM
Subject: Re: CF and JS


 Hi Mike:

 I threw together a quick (basic) javascript that allows you to select 1 of
3
 states, then one of 3 cities, then one of 3 streets.

 It's at http://130.13.170.56:6699/bigArray.html

 you can view the source to see what the arrays look like.  Since I assume
 your data is coming from a database, you should be able to create the
arrays
 fairly easily on the server just looping over query output.  If you're
bold
 enough, give it a shot to see how quickly it runs.  It's still gonna be a
 big big big array :)

 hth,
 charlie

 - Original Message -
 From: Mike Tangorre [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, August 18, 2002 2:59 PM
 Subject: CF and JS


  Forgive me if this same question was going through from my work email, I
 am having problems with that email.
 
  My question was the following:
 
  I have a CF page with 7 form elements on it: 3 select boxes, 2 multi
 select boxes and 2 buttons.
  I am populating the 3 select boxes and 1 multi select boxes with
queries,
 all related.
 
  select box 1 - states
  select box 2 - cities
  select box 3 - streets
  multi select box 1 - houses
 
  What I am trying to do, is make these select boxes drill down without
 refreshing the page. For example, user selects a state, the cities box is
 then populated with the cities in that state... the user then selects a
 city, and that populates the streets. The user selects a street, and all
the
 houses on that street are listed in the multi select box 1. The user can
 then select multiple houses from the multi select box and click the add
 button, which will add those to the multi select box 2.
 
  Could someone assist me in writing the JS for this or point me in the
 right online resource to accomplish this? I am a novice in JS.
 
  Thanks.
 
  Mike
 
 
 
 
 
__
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

CF 5 Books

[Mike Tangorre]

If anyone is interested in the following books, email me offlist... I am selling off 
the following books:

Macromedia Cold Fusion Studio 5, Using Cold Fusion 5 Studio
... this is the manual that comes with studio or that you can buy form MM website.

Macromedia Cold Fusion 5, Advanced Cold Fusion Administration
... this is book 1 of 3 that comes with server or that you buy from MM website.

Macromedia Cold Fusion 5, Installing and Configuring Cold Fusion Server
... this is book 2 of 3 that comes with server or that you buy from MM website.

Macromedia Cold Fusion 5, CFML Reference
... this is book 3 of 3 that comes with server or that you buy from MM website.

The Macromedia Cold Fusion 5 Web Applications Construction Kit
... this is the big blue book by Forta, Weiss, et al.

FUSEBOX: Methodology and Techniques
... This is the first fusebox book (fusebox 2) by Nelson, Girard, Papovich, and Helms

All the books are in superb condition and rarely if ever used.. You can buy 1 or all 
of them just shoot me an email.

If this is against posting rules I apologize.

Mike


__
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

CF MX / FLASH MX - Tree Menu

[Mike Tangorre]

  Hi All..

  Can anyone point me to some tutorials or online docs or manuals that would aid 
me in doing the following:

  I have a menu to build consisting of dynamic parent categories. Next to each 
parent will be an image, a + sign. When clicked the menu will expand to reveal the 
parent's children. If the child also has children, there will be a + sign next 
to their text as well and so on. Whenever a parent is expanded the + will turn to a 
- and thus when clicked again will be retracted. A tree menu!  LOL
  Anyways, does this sound like a good Flash MX project? I have never used Flash 
to interact with dynmaic data so any tips, links, advice, or thoughts would be much 
appreciated.

  Thanks!

  Mike 



__
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 MX / FLASH MX - Tree Menu

[Mike Tangorre]

Thanks Ben.

I think I will go with the Flash approach now.. no better time to get up to
speed.. I'll deal with the elarning curve.  :-)

Flashkit.com has been useful in the past, are there any other sites you can
think of that might discuss the concepts I will need to grasp to build the
menu?

Data Binding and Data Glue.. any other concepts/ideas/or approaches?

I appreciate the help.

Mike


- Original Message -
From: Ben Johnson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 6:41 PM
Subject: RE: CF MX / FLASH MX - Tree Menu


Anyways, does this sound like a good Flash MX project? I
  have never used Flash to interact with dynmaic data so any tips,
  links, advice, or thoughts would be much appreciated.

 Well, the answer is two fold.  One hand, yes, this is actually a great
Flash
 MX project.  On the other hand, if you haven't used Flash MX before,
there's
 going to be quite a learning curve to get to the point where you can pull
 dynamic data from the server and populate a Tree component with a
recursive
 function.

 I have an article that will/may/(who knows) be on FlashKit that covers
Data
 Binding using the DataGlue class.  That would be a good start.  It doesn't
 cover adding tree data, though, because that's a whole other can of worms.

 If you don't have to worry about browser compatibility, you can go with an
 IE 5.0+ solution which involves some heavy javascripting  XML.  That also
 has a pretty steep learning curve, but it's really a nice interface.  It's
 used as the left hand navigation on Microsoft's MSDN library:

 http://msdn.microsoft.com/library




 Ben Johnson

 
__
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

Books - CF MX / FLASH MX - Books.

[Mike Tangorre]

Can anyone recommend some good books that deal with Flash MX and CF MX integration? I 
am looking to advance my skills in actionscripting and the like, and could use some 
books for reference.

Also I will need them for my earlier post about a CF and Flash menu...  :-)

Thanks!

Mike


__
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

Tracking time in CF

[Mike Tangorre]

Hi everyone.

I am trying to find a way on how to do the following securely.
I have a website that has 4 chat rooms.
Chat Room A = $0.50/minute
Chat Room B = $0.60/minute
Chat Room C = $0.70/minute
Suppose when people sign up they prefill their account with X amount of
dollars.
Is there a way in CF to monitor time on a certain page and compare it to the
total
amount of time available for the room based on the number of dollars
available in the account... then
if they run out of money direct them to the order time page...?

Any help would be appreciated.  I thought maybe Javascript might be of use
but wuld it not be easy to hack???  For instance:

Get the dollar total form the DB, divide it by the price of the room you
enter...store that value in a variable, then set a counter to count down
from the total available time...when the counter hits 0 refresh them to a
page... if they logout, take the value of counter and refigure money
available and store it back into the db  AM i all confused or what?  :-)

Thanks for any help,

Mike
~~
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

List Slow?

[Mike Tangorre]

Is the list slow today?


=
Michael T. Tangorre
Web Applications Developer

Alfred University Webteam Slave  :-)
[EMAIL PROTECTED]
AIM: CrazyFlash4
=
Friends don't let friends code before coffee!
=
~~
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

T-SQL to Access Acceptable SQL

[Mike Tangorre]

I need to find something that will convert the Transact SQL statements 
that we use into 
SQL 7  into SQL that MS Access can handle any ideas?? IS it even 
possible?

Thanks,
Mike

===
Michael T. Tangorre
Web Applications Developer

Alfred University Webteam Slave  :-)
[EMAIL PROTECTED]
AIM: CrazyFlash4===
Friends don't let friends code before coffee!===

~~
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: Important - For a project -- please help

[Mike Tangorre]

The only dumb questions are the ones not asked!
hehehe, I don't know the answer though  sorry.  :-(

Mike

- Original Message -
From: Julia Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 10:29 AM
Subject: Important - For a project -- please help


 Can you use counts with joined tables and a where statement?

 This seems like a dumb question...

 Goto:  http://www.cheshiregroup.com/gilway/subcount3.cfm

 My client wants the count of each separate number...next to the
 number preferably...

 This is tricky because there is 2  tables, one that takes the input
 of the form with the customer's number(tblfile), and the other that has
all
 the valid numbers (gilway12).

 I got just the valid numbers to come up on subcount3.cfm, by using aliases
 and
 a where statement and joining tables.

 Then he said he  wanted a count and I can't get it to work with the
 code...

 Below is the sql code for the statement using File in both tables...
 I keep getting errors around the WHERE statement when it worked in
 subcount3.cfm...

 CFQUERY NAME=gilwaya  DATASOURCE=cgi2

   SELECT count(t.File) as file3, g.File, t.File
   FROM tblfile t, gilway12 g
   GROUP BY g.File
   WHERE t.File=g.File


 /CFQUERY

 produces the incorrect code.

 CFQUERY NAME=GetQuery DATASOURCE=cgi2
 SELECT count(File) AS file2
 FROM tblfile
 /cfquery


 CFQUERY NAME=gilwaya  DATASOURCE=cgi2

   SELECT t.File, g.File
   FROM tblfile t, gilway12 g
   WHERE t.File=g.File
   ORDER BY t.File DESC

 /CFQUERY

 produces subcount3.cfm





 From: Mark Stewart [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, October 04, 2001 10:17 AM
 Subject: Stored Procedure Question


  All,
 
  I've been using stored procedures for a while now but I've never really
  needed to create one that returned multiple result sets. My question is,
  how do you do that? Would someone be kind enough to show me a little
  pseudo code or a snippet of code on how to accomplish this?
 
  I assume in cf, I would build my cfstoredproc like this:
 
  cfstoredproc procedure=procedure_name datasource=#maindsn#
  cfprocresult name=result1
  cfprocresult name=result2
  /cfstoredproc
 
  But I draw a blank when it comes to building the stored proc in SQL
  Server where it would return multiple results. I assume the following:
 
  create procedure [procedure] as
 
  select ... from ... where...
 
  select ... from... where...
 
  How do I specify what query goes with what result?
 
  Thanks for your help!
 
  Mark
 
 
 
~~
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: CFServer 4.01 to 5

[Mike Tangorre]

Jason,
If you wouldn't mind, our company is going through the same situation only
with NT boxes.
I would be interested in hearing anything you find out, and I will post
naything I find out.

Thanks,

Mike

- Original Message -
From: Stevens, Jason [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 6:51 PM
Subject: CFServer 4.01 to 5


 My company has finally decided that they are going to keep Cold Fusion
 around rather than moving the entire site to Java Server Pages (though we
 are doing all new dev in jsp). We never upgraded from 4.01 to 4.5. We're
 exploring the risks of this upgrade. I've hear that it is necessary to
 upgrade to 4.5 then to 5.0. With that in mind, what are some of the
 complications that the community has faced doing an upgrade like this? Is
 there any words of wisdom/prevention that you all can offer? Also, we run
 the solaris version of cfserver.

 Thank you.

 Jason Stevens

 
~~
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

E-commerce

[Mike Tangorre]

Hi everyone.
I am trying to elarn how to create a simple E-commerce site (for 
practice purposes).
I have no experience with this yet and could use some pointers.

What is the est way to store information when the user wants to add 
something to their basket?
I was thinking about using a structure of arrays, or a structure of 
lists... or just arrays.. im not really sure what is easiest to work 
with for a novice?

Does anyone know some online examples with code that I could study from?
Should the cart be stored as a session var?

Any help would be appreciated.

Thanks 

Mike

===
Michael T. Tangorre
Web Applications Developer

Alfred University Webteam Slave  :-)
[EMAIL PROTECTED]
AIM: CrazyFlash4===
Friends don't let friends code before coffee!===

~~
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: E-commerce

[Mike Tangorre]

Thanks, I understand what you are saying... I really do.
I am a senior in college right now, just toying with different languages and
trying to work with them a  bit..
I want to see if I can do it, and then see if I can do it better...  :-)

Mike


- Original Message -
From: DSJ / PC1, Inc. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 11:42 PM
Subject: RE: E-commerce


 Mike,

 I was in the same position a few years back, and instead of trying to
 re-invent the wheel, I just went with a commercial CF based solution.  In
my
 own scenario, I simply did not have the time or patience to program a
 shopping cart in CF, when I knew a plug  play solution already existed.

 I understand you are in practice mode here, but when it's time for the
 rubber to meet the road, I would highly recommend just using something
 commercial.

 Just my .02... for what it's worth.

 DSJ

 -Original Message-
 From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 04, 2001 9:01 PM
 To: CF-Talk
 Subject: E-commerce


 Hi everyone.
 I am trying to elarn how to create a simple E-commerce site (for
 practice purposes).
 I have no experience with this yet and could use some pointers.

 What is the est way to store information when the user wants to add
 something to their basket?
 I was thinking about using a structure of arrays, or a structure of
 lists... or just arrays.. im not really sure what is easiest to work
 with for a novice?

 Does anyone know some online examples with code that I could study from?
 Should the cart be stored as a session var?

 Any help would be appreciated.

 Thanks

 Mike

 ===
 Michael T. Tangorre
 Web Applications Developer

 Alfred University Webteam Slave  :-)
 [EMAIL PROTECTED]
 AIM: CrazyFlash4===
 Friends don't let friends code before
 coffee!===


 
~~
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

Output Issue

[Mike Tangorre]

I have the following code:

cfloop list=#form.fieldnames# index=x delimiters=,
tr
 td
  cfoutput#x#/cfoutput
 /td
 td
   cfoutput#form.#x## /cfoutput
  /td
/tr
/cfloop


The value for the form field throws an error the way I am doing it. I am 
not familiar with the Evaluate function and the concatonation of 
strings, is this what I should do?

Thanks for any help or explanation.

Mike

===
Michael T. Tangorre
Web Applications Developer

Alfred University Webteam Slave  :-)
[EMAIL PROTECTED]
AIM: CrazyFlash4===
Friends don't let friends code before coffee!===

~~
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: Output Issue

[Mike Tangorre]

Thank you!

:-)

Mike

- Original Message - 
From: Dave Babbitt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 12:42 PM
Subject: RE: Output Issue


 How about cfdump var=#form.fieldnames# or 
 cfloop list=#form.fieldnames# index=x
 tr
  td
   cfoutput#x#/cfoutput
  /td
  td
cfoutput#Evaluate('form.'  x)# /cfoutput
   /td
 /tr
 /cfloop
 
 There are many variations.
 
 -Original Message-
 From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 02, 2001 12:37 PM
 To: CF-Talk
 Subject: Output Issue
 
 
 I have the following code:
 
 cfloop list=#form.fieldnames# index=x delimiters=,
 tr
  td
   cfoutput#x#/cfoutput
  /td
  td
cfoutput#form.#x## /cfoutput
   /td
 /tr
 /cfloop
 
 
 The value for the form field throws an error the way I am doing it. I am 
 not familiar with the Evaluate function and the concatonation of 
 strings, is this what I should do?
 
 Thanks for any help or explanation.
 
 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

CFMAIL and Attachments

[Mike Tangorre]

Hello Everyone,

I am having problems sending mail with attachments.
I have a user fill out a form, and on the form is an input type of 
file
where the suer browses to select the file they wish to send.
When they click submit, I process the form and mail its contents to
someone. In the cfmail tag i am using cfmailparam and i specify the 
#form.ufile# as the FILE to send... am I doing something wrong? When the 
email arrives,
attached is a TEMP file which when opened in notepad is the right file, 
but it is not the correct
file type... for instance, I email a word doc, and it comes in as a TEMP 
file all garbled.

Any help would be appreciated.

Mike

===
Michael T. Tangorre
Web Applications Developer

Alfred University Webteam Slave  :-)
[EMAIL PROTECTED]
AIM: CrazyFlash4===
Friends don't let friends code before coffee!===

~~
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: CFMAIL and Attachments

[Mike Tangorre]

I'll give that a shot...  I am an novice user here so it might take a bit of
working.  :-)

Thanks for the help, I appreciate it.

Happy evening to you,

Mike


- Original Message -
From: Garza, Jeff [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 10:57 PM
Subject: RE: CFMAIL and Attachments


 Mike,

 You need to write the uploaded file to disk before you can attach it using
 CFMAIL.  The process should go like this:

 1) User fills in form and selects file, clicks submit.
 2) Use CFFILE to write file to web server harddrive.
 3) Use CFMAIL to send the file using #cffile.serverfile# as the
attachment.
 4) Use CFFILE to delete the file from the server using the same var as
above.

 HTH,

 Jeff Garza
 Webmaster/Lead Developer
 Spectrum Astro, Inc.
 [EMAIL PROTECTED]

 -Original Message-
 From: Mike Tangorre
 To: CF-Talk
 Sent: 10/2/01 7:14 PM
 Subject: CFMAIL and Attachments

 Hello Everyone,

 I am having problems sending mail with attachments.
 I have a user fill out a form, and on the form is an input type of
 file
 where the suer browses to select the file they wish to send.
 When they click submit, I process the form and mail its contents to
 someone. In the cfmail tag i am using cfmailparam and i specify the
 #form.ufile# as the FILE to send... am I doing something wrong? When the

 email arrives,
 attached is a TEMP file which when opened in notepad is the right file,
 but it is not the correct
 file type... for instance, I email a word doc, and it comes in as a TEMP

 file all garbled.

 Any help would be appreciated.

 Mike

 ===
 Michael T. Tangorre
 Web Applications Developer

 Alfred University Webteam Slave  :-)
 [EMAIL PROTECTED]
 AIM: CrazyFlash4===
 Friends don't let friends code before
 coffee!===


 
~~
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: CFMAIL and Attachments (SOLUTION)

[Mike Tangorre]

Thanks Jeff!
That worked great!

Much appreciated.

Mike

- Original Message -
From: Garza, Jeff [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 10:57 PM
Subject: RE: CFMAIL and Attachments


 Mike,

 You need to write the uploaded file to disk before you can attach it using
 CFMAIL.  The process should go like this:

 1) User fills in form and selects file, clicks submit.
 2) Use CFFILE to write file to web server harddrive.
 3) Use CFMAIL to send the file using #cffile.serverfile# as the
attachment.
 4) Use CFFILE to delete the file from the server using the same var as
above.

 HTH,

 Jeff Garza
 Webmaster/Lead Developer
 Spectrum Astro, Inc.
 [EMAIL PROTECTED]

 -Original Message-
 From: Mike Tangorre
 To: CF-Talk
 Sent: 10/2/01 7:14 PM
 Subject: CFMAIL and Attachments

 Hello Everyone,

 I am having problems sending mail with attachments.
 I have a user fill out a form, and on the form is an input type of
 file
 where the suer browses to select the file they wish to send.
 When they click submit, I process the form and mail its contents to
 someone. In the cfmail tag i am using cfmailparam and i specify the
 #form.ufile# as the FILE to send... am I doing something wrong? When the

 email arrives,
 attached is a TEMP file which when opened in notepad is the right file,
 but it is not the correct
 file type... for instance, I email a word doc, and it comes in as a TEMP

 file all garbled.

 Any help would be appreciated.

 Mike

 ===
 Michael T. Tangorre
 Web Applications Developer

 Alfred University Webteam Slave  :-)
 [EMAIL PROTECTED]
 AIM: CrazyFlash4===
 Friends don't let friends code before
 coffee!===


 
~~
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: Points of failure for session variables

[Mike Tangorre]

I have a question semi related. I am studying CF while I finish up school
and was getting into how an e-commerce site works in terms of sessions and
what not. In an e-commerce site, is it best to not use cookies at all? What
is a good approach to an e-commerce site?

Mike

- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, September 30, 2001 8:39 PM
Subject: Re: Points of failure for session variables


 If you're relying on cookies to implement session variables, then there
are
 a lot of ways that cookies can be blocked or otherwise not passed from
 server to client or vise versa.  Hardware firewalls, software firewalls,
 proxy servers, browser settings are a few.  Then there are issues at the
 server end... clustering, load balancing.

 Jim


 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, September 30, 2001 6:30 PM
 Subject: Points of failure for session variables


  Of course I've used system variables several times in the past, but
never
 in
  an application where their proper functioning is absolutely necessary,
 until
  now.
 
  The application I'm building now relies heavily on session variables and
  will fail if variables are not properly passed.
 
  Of course, I'm using CFLock around all session variables (both read and
  write).
 
  Besides that, I'm wondering are their other problems to look and plan
for?
  Is it possible that session variables will not work with some clients?
If
  so, under what conditions. How do you plan for such possible failures?
 
  I just want to do my best to cover all of the bases here.
 
  H.
 
~~
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: Calling Custom Tag

[Mike Tangorre]

I believe the local folde ris called first, then it checks the custom tags
fodler

Mike

- Original Message -
From: saro [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 26, 2001 10:29 AM
Subject: Calling Custom Tag


 i have a custom tag named textinput in custom tags
 directory.I am calling the custom tag from a
 default.cfm file from webroot folder.The webroot
 folder also has a file named textinput.cfm.
 Now which file would the default.cfm call whether the
 file in webroot folder or in custom tags directory.

 Or in other words what is the precedence in calling
 custom tags.


 Any documentation reference is highly appreciated.


 -Saro



 
~~
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: Calling Custom Tag

[Mike Tangorre]

geeesh, sorry for the typos!


- Original Message -
From: Mike Tangorre [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 26, 2001 10:38 AM
Subject: Re: Calling Custom Tag


 I believe the local folde ris called first, then it checks the custom tags
 fodler

 Mike

 - Original Message -
 From: saro [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, September 26, 2001 10:29 AM
 Subject: Calling Custom Tag


  i have a custom tag named textinput in custom tags
  directory.I am calling the custom tag from a
  default.cfm file from webroot folder.The webroot
  folder also has a file named textinput.cfm.
  Now which file would the default.cfm call whether the
  file in webroot folder or in custom tags directory.
 
  Or in other words what is the precedence in calling
  custom tags.
 
 
  Any documentation reference is highly appreciated.
 
 
  -Saro
 
 
 
 
 
~~
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

SQL Server - OT

[Mike Tangorre]

How difficult is it to go fom SQL Server 7 to SQL server 2K?
Is it easy to get the databases tranfered over?


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

Re: Highlight Script

[Mike Tangorre]

Neat!  :-)


- Original Message -
From: Tilbrook, Peter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 26, 2001 8:22 PM
Subject: RE: Highlight Script


 Try this:

 script language=JavaScript1.2
 //Highlight form element- © Dynamic Drive (www.dynamicdrive.com)
 //For full source code, 100's more DHTML scripts, and TOS,
 //visit http://www.dynamicdrive.com

 var highlightcolor=lightyellow

 var ns6=document.getElementById!document.all
 var previous=''
 var eventobj

 //Regular expression to highlight only form elements
 var intended=/INPUT|TEXTAREA|SELECT|OPTION/

 //Function to check whether element clicked is form element
 function checkel(which){
 if (which.styleintended.test(which.tagName)){
 if (ns6eventobj.nodeType==3)
 eventobj=eventobj.parentNode.parentNode
 return true
 }
 else
 return false
 }

 //Function to highlight form element
 function highlight(e){
 eventobj=ns6? e.target : event.srcElement
 if (previous!=''){
 if (checkel(previous))
 previous.style.backgroundColor=''
 previous=eventobj
 if (checkel(eventobj))
 eventobj.style.backgroundColor=highlightcolor
 }
 else{
 if (checkel(eventobj))
 eventobj.style.backgroundColor=highlightcolor
 previous=eventobj
 }
 }
 /script


 Your CFFORM tag should look something like this:

 cfform name=applicationform method=post action=index.cfm
 enctype=multipart/form-data  passthrough=onClick='highlight(event)
 '
 input type=hidden name=fuseaction value=SubmitApplication

 Cheers!

 Peter Tilbrook
 ColdFusion Applications Developer
 Australia New Zealand Food Authority
 Boeing House
 55 Blackall Street
 BARTON ACT 2600
 Ph: +61-2-6271-2671
 Fax: +61-2-6271-2278

 http://www.anzfa.gov.au



 **

 This transmission is intended only for the use of the addressee(s)
 and may contain confidential or legally privileged information. If you are
 not the intended recipient, you are notified that any use or dissemination
 of this communication is strictly prohibited. If you have received this
 transmission in error, please notify the ANZFA IT helpdesk prior to
deleting
 all copies of this transmission together with any attachments.

 ANZFA helpdesk:

 E-mail:  [EMAIL PROTECTED]
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

 www.mimesweeper.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

HELP!... with intranet idea

[Mike Tangorre]

Hello all.
I have been asked to do the following:

Design an intranet with a message board, events calendar, and a few 
other items. The requirement I am bothered by is that of connecting to 
an exchange server and getting schedules and stuff from peoples accounts 
to make a master schedule online for conference room meetings and what 
not...

I have no idea even where to begin on this in terms of the exchange 
server thing.  Any ideas?
Is it even possible to access the server with CF?  Can I pull info, 
update info, and add new info?

Any help, tips, tricks, or recommendations would be much appreciated.

Thanks,

Mike Tangorre

~~
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: HELP!... with intranet idea

[Mike Tangorre]

I am a little confused... would I want to connect to the application outlook
or to the exchange server?


- Original Message -
From: Mark Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 5:24 PM
Subject: RE: HELP!... with intranet idea


 Check out cfcomet - http://www.cfcomet.com - there are some examples
 there on how to connect through COM, etc.

 Mark

 -Original Message-
 From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 25, 2001 5:04 PM
 To: CF-Talk
 Subject: HELP!... with intranet idea


 Hello all.
 I have been asked to do the following:

 Design an intranet with a message board, events calendar, and a few
 other items. The requirement I am bothered by is that of connecting to
 an exchange server and getting schedules and stuff from peoples accounts

 to make a master schedule online for conference room meetings and what
 not...

 I have no idea even where to begin on this in terms of the exchange
 server thing.  Any ideas?
 Is it even possible to access the server with CF?  Can I pull info,
 update info, and add new info?

 Any help, tips, tricks, or recommendations would be much appreciated.

 Thanks,

 Mike Tangorre


 
~~
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: HELP!... with intranet idea

[Mike Tangorre]

We alreayd have exchange installed and they want me to pull the stuff form
there  :-(

Mike

- Original Message -
From: Conrad Classen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 6:46 PM
Subject: RE: HELP!... with intranet idea


 Another alternative is to scrap exchange server and go with
 Imail (www.ipswitch.com), which has the functionality built
 in already, and a heck of a lot cheaper too.

 Conrad


 -Original Message-
 From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 25, 2001 11:04 PM
 To: CF-Talk
 Subject: HELP!... with intranet idea


 Hello all.
 I have been asked to do the following:

 Design an intranet with a message board, events calendar, and a few
 other items. The requirement I am bothered by is that of connecting to
 an exchange server and getting schedules and stuff from peoples accounts

 to make a master schedule online for conference room meetings and what
 not...

 I have no idea even where to begin on this in terms of the exchange
 server thing.  Any ideas?
 Is it even possible to access the server with CF?  Can I pull info,
 update info, and add new info?

 Any help, tips, tricks, or recommendations would be much appreciated.

 Thanks,

 Mike Tangorre


 
~~
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

Cold Fusion upgrade

[Mike Tangorre]

Does anyone know of any issues that exist when upgrading from CF 4.01 to 
CF 5.0? Unfortunately our company never got 4.5 and now they decided we 
need 5.0. I wanna become familiar with any issues we might be facing.

Thanks.

Mike Tangorre

~~
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

SQL Server 2K

[Mike Tangorre]

Can anyone tell me how much toruble it is to upgrade from SQL Server 7 
to SQL Server 2K.
Anything to watch for?  Anything to be aware of?

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

Re: Internet Faxing Service

[Mike Tangorre]

I use eFax...  it does a pretty good job  :-)

Mike

- Original Message -
From: Duane Boudreau [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 11:39 PM
Subject: Internet Faxing Service


 Hey Gang,

 Is anyone here using an internet faxing service? I've looked at eFax and
 EasyLink, but I would like to get some recommendations if there are any.

 Thanks,
 Duane
 
~~
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 SERVER 2000 GOING TO Single User Mode

[Mike Tangorre]

when you set it up did you use the right licensing mode?  :-)


- Original Message - 
From: William J Wheatley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 9:16 AM
Subject: OT: SQL SERVER 2000 GOING TO Single User Mode


 Sql server 2000 keeps going into Single user mode anyone have ideas??
 
 Thanks :)
 
 
 Bill Wheatley
 Director of Development
 Certified Master ColdFusion 5 Developer
 AEPS INC
 Allaire ColdFusion Consulting Partner
 www.aeps.com
 www.aeps2000.com
 954-472-6684 X303
 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

Re: Certified Master ColdFusion 5 Developer

[Mike Tangorre]

Brainbench and Allaires test are like apples and oranges..   :-)


- Original Message - 
From: Tristram Charnley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 10:04 AM
Subject: RE: Certified Master ColdFusion 5 Developer


 Brainbench do a Master Cert - I can't remember my score but it was
 enough.
 
 Tristram Charnley
 
 
~~
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: Certified Master ColdFusion 5 Developer

[Mike Tangorre]

Brainbnech is easy comparatively, you get like 60 or 90 seconds per
question. I just took the Allaire CF 5.0 exam and did not do so well... the
questions for the cf 5 exam (form allaire) are much harder than those at
Brainbench.

:-)

Mike

- Original Message -
From: Mark Smyth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 10:12 AM
Subject: RE: Certified Master ColdFusion 5 Developer


 has anyone taken both tests, how do they compare for difficulty?
 Mark

 -Original Message-
 From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 Sent: 24 September 2001 15:11
 To: CF-Talk
 Subject: Re: Certified Master ColdFusion 5 Developer


 Brainbench and Allaires test are like apples and oranges..   :-)


 - Original Message -
 From: Tristram Charnley [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, September 24, 2001 10:04 AM
 Subject: RE: Certified Master ColdFusion 5 Developer


  Brainbench do a Master Cert - I can't remember my score but it was
  enough.
 
  Tristram Charnley
 
 

 
~~
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

Software Migration

[Mike Tangorre]

Hello.

Our company is upgrading from SQL Server 7.0 to SQL Server 2K and from 
Cold Fusion 4.01 to Cold Fusion 5.0.  Does anyone know a site online or 
any documentation discussing upgrading issues?
What I am mainly concerned with is how things will function when we 
upgrade. What are the differences between the above mentioned 
versions... any comparison charts out there?

Thanks for any help.

Mike Tangorre


~~
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: Ways to pass variables

[Mike Tangorre]

hidden form fields


- Original Message -
From: Michael S. Kimmett [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 1:02 PM
Subject: Ways to pass variables


 Ok, one more question.  I have a client that does not want variables
 passed through the URL ( security reasons ).  But I am having problems
 passing a variable through a form (see previous message).  Session
 variables are a not permitted on thie project.  Does anyone have another
 idea on how to move variables and their values from page to page?

 Thanks in advance.

 --Michael

 
~~
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: Ways to pass variables

[Mike Tangorre]

good call Bruce, that thought didn't even come into mind..  :-)


- Original Message -
From: Bruce Holm [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 1:30 PM
Subject: Re: Ways to pass variables


 Hidden form fields can be views in the HTML page source view...so not
ideal
 for security reasons either.  It's less blatantly obvious but still
viewable
 to prying eyes.

 Bruce
 [EMAIL PROTECTED]

 - Original Message -
 From: Mike Tangorre [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, September 24, 2001 10:23 AM
 Subject: Re: Ways to pass variables


  hidden form fields
 
 
  - Original Message -
  From: Michael S. Kimmett [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, September 24, 2001 1:02 PM
  Subject: Ways to pass variables
 
 
   Ok, one more question.  I have a client that does not want variables
   passed through the URL ( security reasons ).  But I am having problems
   passing a variable through a form (see previous message).  Session
   variables are a not permitted on thie project.  Does anyone have
another
   idea on how to move variables and their values from page to page?
  
   Thanks in advance.
  
   --Michael
  
  
 
 
~~
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

Studio 5.0

[Mike Tangorre]

Does anyone know the email to get in contact with Allaire to betatest 
studio 5.0.. is it still in beta?
I am a student here at Alfred University and we use CF down in the Web 
department, and we were considering beta testing.

When I goto Beta.Allaire.com, I cannot find an email or number to call 
in order to get in touch with them.

Any help would be appreciated.

Thanks,

Mike Tangorre


~~
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