RE: Why are my clients having so many login problems all of a sud den?

2003-02-03 Thread Roberson, Jeff, Mr (Contractor) ACI
I had this same issue with my app with domain cookies turned on in the
Application.cfm.
When I turn it off they all returned to working normally.


-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 11:44 AM
To: CF-Talk
Subject: RE: Why are my clients having so many login problems all of a
sudden?


> Now they can log in and see the site management options, but when they
> click on a link to go that area, the system kicks them back to the
login
> page.

Sounds like the Internet Explorer 6 cookie bug. Its been such a common
occurrence for us over the past year we actually published a page on our
site that we could just direct people to when they report the problem:

  http://www.c4.net/Index.cfm?Method=Support.FAQ.IE6Privacy

In short, Internet Explorer inexplicably stops accepting cookies for
certain sites now and again. Users who d log into a site daily without
problems for a year will all the sudden experience the problems you've
described. The only foolproof work around we've found is to have user
add our site to their list of "trusted sites," which apparently bypasses
whatever causes the problem.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057


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

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




RE: Why are my clients having so many login problems all of a sud den?

2003-02-03 Thread Roberson, Jeff, Mr (Contractor) ACI
It stores them there by default in the registry which has a set size in
windows in Linux it's just a file

Setup a data source it's in the CF_ADMIN

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 10:29 AM
To: CF-Talk
Subject: RE: Why are my clients having so many login problems all of a
sudden?


Hi, Dave.

Unless client variables are stored in the registry as an automatic
part of using clientmanagment, I don't have any there.  I've never
used any cookies or stored client info in the registry.  There's also
still 5 GB of space left on the drive, so I don't think hard drive space
is an issue, unless the registry is set to a limit on how much it can use,
but even so, these are low-traffic sites, with few users that log in to
performance management functions.

I do have issues with memory leak due to several websites running
that don't have the session and application variables locked properly.
(They were built before I knew better and haven't had time to rewrite them)
But I've been running these sites for a couple of years without problem,
except for the memory loss, which causes me to have to reboot the
server about once a week,  so it hasn't been a big deal.

Any other thoughts, Dave?  Anyone?

Rick


>  -Original Message-
>  From: Dave Wilson [mailto:[EMAIL PROTECTED]]
>  Sent: Monday, February 03, 2003 10:05 AM
>  To: CF-Talk
>  Subject: RE: Why are my clients having so many login
>  problems all of a
>  sudden?
>
>
>  Rick,
>
>  A shot in the dark, but;
>
>  Are you storing client variables in the system registry? Maybe you're
>  running low on space. Try reconfiguring to store client
>  variables in a
>  database.
>
>  HTH,
>  Dave
>
>  -Original Message-
>  From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
>  Sent: 03 February 2003 15:02
>  To: CF-Talk
>  Subject: Why are my clients having so many login problems all of a
>  sudden?
>
>
>  Hi, all.
>
>  Seems like over the last week, several of my clients have all
>  started having problems logging into password-protected areas
>  for site management.
>
>  The setup uses a query to check username and password stored
>  in a db to see if their form entries match, and if so, the
>  userid becomes
>  the session.userid and their off and running.
>
>  Now they can log in and see the site management options, but
>  when they
>  click on a link to go that area, the system kicks them back
>  to the login
>  page.
>  I can get in fine to all the management areas of the sites,
>  with various
>  passwords
>  and usernames...and they can "sporadically", but the
>  behavior is fairly
>  consistent.
>
>  Nothing's been changed on the sites' code or the database or on the
>  server settings.  (Except that I've been tinking a little
>  with setting up
>  some FTP sites through IIS...)  Some of these sites have
>  been running with
>  no problems
>  for a couple of years now...
>
>  I started using MySQL instead of Access a couple of months
>  ago for new
>  sites...
>  both are still running.
>
>  Haven't updated Windows 2000 Server recently.
>
>  Cold Fusion hasn't been updated...still using 4.5.2.
>
>  I was able to get one client in on their office computers
>  when I set their
>  cookie
>  screening to "low" (accept all cookies, all the time), but
>  I'm not setting
>  any cookies
>  for authentication...at least not that I'm aware of.  I use
>  CFAPPLICATION
>  and
>  set ClientManagemet = "Yes" and SessionManagement = "Yes"
>  all the time,
>  but I don't use cookies for storing and checking information.
>
>  Just can't figure out why this is happening...
>
>  Anyone have any ideas or thoughts on what to check?
>
>  Thanks,
>
>  Rick
>
>
>
>  

~|
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: CF & Database Options

2003-01-23 Thread Roberson, Jeff, Mr (Contractor) ACI
Use CFQUERYPARAM 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 6:21 AM
To: CF-Talk
Subject: Re: CF & Database Options


Quoting paul smith <[EMAIL PROTECTED]>:
> 
> For some time, I have run the main listing database at 
> www.SMARTERyellowpages.com as read-only, being more than a little paranoid

> about it.  Obviously, this means the queries are read only.

How have you set the database to read-only?


> But this complicates updating the database, which I do every 24 
> hours.  Since so many queries are cached, CFQUERYPARAM is of no help in 
> preventing SQL Injection.  The vast majority of these are amenable to
using
> VAL to prevent SQL Injection.
> 
> What are your thoughts on not having the database read-only, or any other 
> related issues, and (me, not users) being able to update a running
> database?

Just some thoughts:
- query caching does not necessarily have to happen through the cfquery tag
- you could use multiple logins to the database, a readonly login and a
normal
one for instance
- use something not CF to update the database

Jochem

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

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




RE: Incrementing number verification

2003-01-22 Thread Roberson, Jeff, Mr (Contractor) ACI
[Variable] MOD 25 EQ 0

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 1:54 PM
To: CF-Talk
Subject: Incrementing number verification


(best title I could come up with).

Q.  I have a form that allows for a number to be submitted.  I need to
verify that the number submitted is in 25 increments...

ie 50, 100, 125,150,200,225 etc..

numbers not valid would be 120,132,180,174 etc..

I am sure I can do some hoops .. but wanted to see if anyone had any quick
sure way (or a UDF) that would make sure the number submitted is in the
right increment.

(Note:, I am not looking for order an order, just that it is divisable by 25
evenly).

Thank you,
Paul Giesenhagen
QuillDesign

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

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




RE: reconnecting to MySQL

2003-01-21 Thread Roberson, Jeff, Mr (Contractor) ACI
Are you inserting large blobs by any chance?


-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 11:44 AM
To: CF-Talk
Subject: Re: reconnecting to MySQL


On Tuesday 21 Jan 2003 16:18 pm, Rahmin Pavlovic wrote:

> Hrmph. There isn't a more elegant way to regain lost connections to MySQL?

Well, you could find out why MySQL is dropping the link ?
Are you using maintain connections ? Is the timout on that longer than the 
timeout in MySQL, or something betwen coldfusion and MySQL, like tcpwrappers

?

-- 
Tom C

If a language doesn't affect the way you think about programming,
it's not worth knowing.

~|
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: WOT: MySQL in the Enterprise

2003-01-15 Thread Roberson, Jeff, Mr (Contractor) ACI
I use phpmyadmin even though it doesn't have everything it's pretty good.

And better than straight command line.

-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:20 AM
To: CF-Talk
Subject: Re: WOT: MySQL in the Enterprise


> samcfug wrote:
> > The soon to be 4eleased version 4 of MySQl, will definitely bring it
into the
> > mainstream and direct competition with Oracle and SQL2k
> > (stored procedures and triggers)
>
> Although version 4.0 will be out Real Soon Now(tm), it will be a far cry
> from a real cross the board competitor. unicode (rather important with
> CF MX and i18n) and subqueries are only due in 4.1, and triggers and
> stored procedures 'have to be done sometime' (which means version 5 at
> best). Views is even later as triggers and stored procedures.
>
> They are making progress, but they have an awfull long road ahead.
>
> Jochem

Not to mention the fact that *management tools* are a key feature of
databases. Spend a lot of time using osql in MSSQL? How often do you
schedule jobs using the sp_addjob (know how to figure out the int for
@frequency?). I'm all for the command line, but just getting a taste of the
MySQL Control Center made me realize how much a front-end tool contributes
to usability.



~|
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: Dreamweaver MX - finally had enough..........

2003-01-15 Thread Roberson, Jeff, Mr (Contractor) ACI
When you open them it's downloading them all to your local machine if you
are working on a remote server

Just set it to not download all the attached files.


-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 8:46 AM
To: CF-Talk
Subject: Dreamweaver MX - finally had enough..


Does anybody know why files with huge numbers of cfincludes in them cause
dreamweaver to hang for long periods?

This is particularly annoying with Fusebox and the switch file.



~|
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: RE: WOT: MySQL in the Enterprise

2003-01-14 Thread Roberson, Jeff, Mr (Contractor) ACI
Actually do transactions actually work in CF MX w/ ORACLE?

It throws errors here.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 2:09 PM
To: CF-Talk
Subject: Re: RE: WOT: MySQL in the Enterprise


Oh wait,

let me add the wonderful CONNECT BY statement.
The ability to force a table to stay in memory.
The ability to fine tune your database to maximize performance.

Don't diss a product just because you don't need the features.

- Original Message -
From: [EMAIL PROTECTED]
Date: Tuesday, January 14, 2003 12:04 pm
Subject: Re: RE: WOT: MySQL in the Enterprise

> Hmm.  Well, I could use the different indexing methods that Oracle 
> has, it's better implemented transactional support, cursors that 
> don't suck, and the ability to use a language (PL-SQL/Java) that 
> actually works like a real language, unlike the suckage that is T-
> SQL..
> Oh, let's not forget packages.  Having SPs organized?  Who'd have 
> thunk it?
> 
> - Original Message -
> From: "Roberson, Jeff, Mr (Contractor) ACI" 
> <[EMAIL PROTECTED]>Date: Tuesday, January 14, 2003 
> 12:01 pm
> Subject: RE: WOT: MySQL in the Enterprise
> 
> > I currently develop in MYSQL, MSSQL, and ORACLE.
> > 
> > My choice by far is MYSQL because 90% of my work involves data 
> > from other
> > systems that gets imported and I display on WebPages - or 
> generate 
> > reports.In using MYSQL for 2 years on several projects I have 
> had 
> > no issues at all.
> > 
> > My Second Choice would be MSSQL (even though it doesn't run on 
> > LINUX :( ) in
> > 7 years I have had one major issue and that was because I 
> > corrupted the RAID
> > :) oops!
> > 
> > I WOULD NEVER recommend ORACLE.  It is was too overpriced if you 
> > need the
> > features go with MSSQL.
> > It runs horribly with CF.  TOAD is a nightmare and things just 
> > don't seem to
> > work.  Although 9i supporting ANSI SQL has made it a little less 
> > hated in my
> > book.
> > 
> > Just my opinion.
> > 
> > Jeff Roberson
> > 
> > -Original Message-
> > From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 14, 2003 1:48 PM
> > To: CF-Talk
> > Subject: RE: WOT: MySQL in the Enterprise
> > 
> > 
> > Jon wrote:
> > > for 99% of what I do, mysql handles my needs perfectly. 
> > > 'Course, I'm doing mostly insert, delete, update, select... 
> > > nothing too complicated. I'll be very happy when the next 
> > >version comes out that can do subqueries, though.
> > 
> > My sentiments exactly.  I can't wait for subqueries.  And 
> despite the
> > to-do list on their site that's been pointed out with regard to low
> > priority for stored procedures, that's out of date.  They 
> acknowledge> somewhere in that cavernous site that stored procs 
> are the #1 most
> > requested feature and are slated for v4.1.  I personally don't 
> use 'em
> > as most of what I write needs to work on anything, so no stored 
> > procs =
> > no big deal.
> > 
> > 
> > Matt Robertson   [EMAIL PROTECTED] 
> > MSB Designs, Inc.  http://mysecretbase.com
> > 
> > 
> > 
> > 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: RE: WOT: MySQL in the Enterprise

2003-01-14 Thread Roberson, Jeff, Mr (Contractor) ACI
I didn't diss it I use it everyday I just prefer the other ones.

Sorry i didn't know everyone had to like ORACLE.

My Bad

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 2:09 PM
To: CF-Talk
Subject: Re: RE: WOT: MySQL in the Enterprise


Oh wait,

let me add the wonderful CONNECT BY statement.
The ability to force a table to stay in memory.
The ability to fine tune your database to maximize performance.

Don't diss a product just because you don't need the features.

- Original Message -
From: [EMAIL PROTECTED]
Date: Tuesday, January 14, 2003 12:04 pm
Subject: Re: RE: WOT: MySQL in the Enterprise

> Hmm.  Well, I could use the different indexing methods that Oracle 
> has, it's better implemented transactional support, cursors that 
> don't suck, and the ability to use a language (PL-SQL/Java) that 
> actually works like a real language, unlike the suckage that is T-
> SQL..
> Oh, let's not forget packages.  Having SPs organized?  Who'd have 
> thunk it?
> 
> ----- Original Message -
> From: "Roberson, Jeff, Mr (Contractor) ACI" 
> <[EMAIL PROTECTED]>Date: Tuesday, January 14, 2003 
> 12:01 pm
> Subject: RE: WOT: MySQL in the Enterprise
> 
> > I currently develop in MYSQL, MSSQL, and ORACLE.
> > 
> > My choice by far is MYSQL because 90% of my work involves data 
> > from other
> > systems that gets imported and I display on WebPages - or 
> generate 
> > reports.In using MYSQL for 2 years on several projects I have 
> had 
> > no issues at all.
> > 
> > My Second Choice would be MSSQL (even though it doesn't run on 
> > LINUX :( ) in
> > 7 years I have had one major issue and that was because I 
> > corrupted the RAID
> > :) oops!
> > 
> > I WOULD NEVER recommend ORACLE.  It is was too overpriced if you 
> > need the
> > features go with MSSQL.
> > It runs horribly with CF.  TOAD is a nightmare and things just 
> > don't seem to
> > work.  Although 9i supporting ANSI SQL has made it a little less 
> > hated in my
> > book.
> > 
> > Just my opinion.
> > 
> > Jeff Roberson
> > 
> > -Original Message-
> > From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 14, 2003 1:48 PM
> > To: CF-Talk
> > Subject: RE: WOT: MySQL in the Enterprise
> > 
> > 
> > Jon wrote:
> > > for 99% of what I do, mysql handles my needs perfectly. 
> > > 'Course, I'm doing mostly insert, delete, update, select... 
> > > nothing too complicated. I'll be very happy when the next 
> > >version comes out that can do subqueries, though.
> > 
> > My sentiments exactly.  I can't wait for subqueries.  And 
> despite the
> > to-do list on their site that's been pointed out with regard to low
> > priority for stored procedures, that's out of date.  They 
> acknowledge> somewhere in that cavernous site that stored procs 
> are the #1 most
> > requested feature and are slated for v4.1.  I personally don't 
> use 'em
> > as most of what I write needs to work on anything, so no stored 
> > procs =
> > no big deal.
> > 
> > 
> > Matt Robertson   [EMAIL PROTECTED] 
> > MSB Designs, Inc.  http://mysecretbase.com
> > 
> > 
> > 
> > 
> 

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

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




RE: WOT: MySQL in the Enterprise

2003-01-14 Thread Roberson, Jeff, Mr (Contractor) ACI
I currently develop in MYSQL, MSSQL, and ORACLE.

My choice by far is MYSQL because 90% of my work involves data from other
systems that gets imported and I display on WebPages - or generate reports.
In using MYSQL for 2 years on several projects I have had no issues at all.

My Second Choice would be MSSQL (even though it doesn't run on LINUX :( ) in
7 years I have had one major issue and that was because I corrupted the RAID
:) oops!

I WOULD NEVER recommend ORACLE.  It is was too overpriced if you need the
features go with MSSQL.
It runs horribly with CF.  TOAD is a nightmare and things just don't seem to
work.  Although 9i supporting ANSI SQL has made it a little less hated in my
book.

Just my opinion.

Jeff Roberson

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 1:48 PM
To: CF-Talk
Subject: RE: WOT: MySQL in the Enterprise


Jon wrote:
> for 99% of what I do, mysql handles my needs perfectly. 
> 'Course, I'm doing mostly insert, delete, update, select... 
> nothing too complicated. I'll be very happy when the next 
>version comes out that can do subqueries, though.

My sentiments exactly.  I can't wait for subqueries.  And despite the
to-do list on their site that's been pointed out with regard to low
priority for stored procedures, that's out of date.  They acknowledge
somewhere in that cavernous site that stored procs are the #1 most
requested feature and are slated for v4.1.  I personally don't use 'em
as most of what I write needs to work on anything, so no stored procs =
no big deal.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com



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

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




RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)

2003-01-13 Thread Roberson, Jeff, Mr (Contractor) ACI
You should be able to use DTS on the SQL server through ODBC to copy the
databases.


-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 11:32 AM
To: CF-Talk
Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database
syntacticall y similar to SQL Server?)


I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to
work pretty well, now if someone only made a utility that would allow me
to move data from SQL Server to Sybase without having to write queries.

Yes, I AM lazy - thank you very much.

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

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

*


-Original Message-
From: Roberson, Jeff, Mr (Contractor) ACI
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 13, 2003 11:20 AM
To: CF-Talk
Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database
syntacticall y similar to SQL Server?)


You can also run virtualPC with windows for mac to get the SQL server

http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF
67Rc
18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0

But I agree you will need lots of ram

-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 11:11 AM
To: CF-Talk
Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically
similar to SQL Server?)


Requirements for VMWare (for Linux) are remarkable low, but you need a
*lot* of memory, decent disk space, and solid processor. I run Linux and
Windows emulations under Windows 2000 with 512MB and PIII/500 -- but
like it better on the P4 1+ GHz and 1 GB RAM.

Did a little research and not a solution (obviously) for Mac. Looks like
x86 architecture is part of the lowlevel emulation -- not that I know
anything about hardware emulation in software :)

Regards,

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


> I wonder what kind of system specs would be required to run an 
> emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac?
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> **
> **
> *
> Any views expressed in this message are those of the individual
sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it 
> is addressed and contains information that is private and 
> confidential. If you are not the intended recipient you are hereby 
> notified that any dissemination, distribution or copying is strictly 
> prohibited. If you have received this e-mail in error please delete it

> immediately and advise us by return e-mail to 
> [EMAIL PROTECTED]
>

> *
>
>
> -Original Message-
> From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 13, 2003 9:12 AM
> To: CF-Talk
> Subject: Re: Unix database syntactically similar to SQL Server?
>
>
> > On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter 
> > wrote:
> >
> > > So does VMWare for Linux run under MacOSX? Now *that* would be a 
> > > solution :)
> >
> > VirtualPC emulates a PC and runs on OS X.
>
> Right. But VMWare let's you install *lots* of OS's -- most *nix, most 
> Win, even Solaris if you're a glutton for install punishment. With 
> VMWare, you could run a virtual Win2k Server instance on your Mac and 
> use it for the db part of the development.
> >
> > Dick
> >
> >
>
> 



~|
Archives: h

RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)

2003-01-13 Thread Roberson, Jeff, Mr (Contractor) ACI
You can also run virtualPC with windows for mac to get the SQL server

http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF67Rc
18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0

But I agree you will need lots of ram

-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 11:11 AM
To: CF-Talk
Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically
similar to SQL Server?)


Requirements for VMWare (for Linux) are remarkable low, but you need a *lot*
of memory, decent disk space, and solid processor. I run Linux and Windows
emulations under Windows 2000 with 512MB and PIII/500 -- but like it better
on the P4 1+ GHz and 1 GB RAM.

Did a little research and not a solution (obviously) for Mac. Looks like x86
architecture is part of the lowlevel emulation -- not that I know anything
about hardware emulation in software :)

Regards,

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


> I wonder what kind of system specs would be required to run an emulator,
> MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac?
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> 
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to [EMAIL PROTECTED]
> 
> *
>
>
> -Original Message-
> From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 13, 2003 9:12 AM
> To: CF-Talk
> Subject: Re: Unix database syntactically similar to SQL Server?
>
>
> > On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote:
> >
> > > So does VMWare for Linux run under MacOSX? Now *that* would be a
> > > solution :)
> >
> > VirtualPC emulates a PC and runs on OS X.
>
> Right. But VMWare let's you install *lots* of OS's -- most *nix, most
> Win, even Solaris if you're a glutton for install punishment. With
> VMWare, you could run a virtual Win2k Server instance on your Mac and
> use it for the db part of the development.
> >
> > Dick
> >
> >
>
> 

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

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




RE: Unix database syntactically similar to SQL Server?

2003-01-13 Thread Roberson, Jeff, Mr (Contractor) ACI
If you use ANSI standard syntax it works on most with little changes...

If you program in Transact (MS Only) or SQL+ (ORACLE only) you will have
some issues.

I tend to use the LEFT OUTER JOIN  and INNER JOIN syntax and it works well
through mySQl, MSSQL, and ORACLE 9i

Jeff


-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 9:12 AM
To: CF-Talk
Subject: Re: Unix database syntactically similar to SQL Server?


> On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote:
>
> > So does VMWare for Linux run under MacOSX? Now *that* would be a
> > solution :)
>
> VirtualPC emulates a PC and runs on OS X.

Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win,
even Solaris if you're a glutton for install punishment. With VMWare, you
could run a virtual Win2k Server instance on your Mac and use it for the db
part of the development.
>
> Dick
>
> 

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

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




Red hat 7.3

2003-01-07 Thread Roberson, Jeff, Mr (Contractor) ACI
I am currently running my CFMX server on Red hat Linux 7.2 with
PLESK and APACHE 1.32.

It seems really stable and runs great (the Linux Guy at the DEVCON
Said only 7.2!)

The place I buy my servers from only supports 7.3 now  Is anyone
running 7.3 in production?

Are there any issues?

I have everything running on a test 7.3 machine but I'm worried :)

Thanks for the comments,

Jeff Roberson

~|
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: For the mac users out there

2003-01-07 Thread Roberson, Jeff, Mr (Contractor) ACI
Don't knock 4.5 :)

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 12:14 PM
To: CF-Talk
Subject: RE: For the mac users out there


4.5?!  jeezo

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 17:16
To: CF-Talk
Subject: Re: For the mac users out there


On 1/7/03, Christian Cantrell penned:
>We will certainly keep our eye on the demand for other versions.  This 
>was sort of the fastest  thing we could get tested and released to meet 
>the immediate demand we knew was there.  Now we will see where things
>go from here.

I for one will be purchasing an XServe and CFMX the day a stable 
version is released for OSX. Until then, I'll likely keep chugging 
along with 4.5.
-- 

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
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

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



RE: For the mac users out there

2003-01-07 Thread Roberson, Jeff, Mr (Contractor) ACI
Unfortunately it's only the developers edition.

When the standard (non-j2ee) version of CFMX runs there will be dancing in
the streets :)

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:57 AM
To: CF-Talk
Subject: For the mac users out there


Tell me this is true!?

http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

Ryan


~|
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: Retaining formatting in form fields

2003-01-06 Thread Roberson, Jeff, Mr (Contractor) ACI
We can't use FLASH where I work :(


-Original Message-
From: James Alexander [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 2:35 PM
To: CF-Talk
Subject: RE: Retaining formatting in form fields


Don't forget soEditor! http://www.siteobjects.com/pages/soeditor.cfm

- James

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 1:59 PM
To: CF-Talk

At 01:46 PM 1/6/03 -0500, Roberson, Jeff, Mr (Contractor) ACI wrote:
>Use Activedit
>
>http://www.cfdev.com/activedit/asp.cfm

Whoa.  That is cool.  I'll look into it.

T



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Retaining formatting in form fields

2003-01-06 Thread Roberson, Jeff, Mr (Contractor) ACI
Use Activedit

http://www.cfdev.com/activedit/asp.cfm



-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 1:39 PM
To: CF-Talk
Subject: RE: Retaining formatting in form fields


text form fields only carry the 
formatting that is laid out in style sheet info.

fme

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 12:17 PM
To: CF-Talk
Subject: Retaining formatting in form fields


Is it possible to retain text formatting (like bolding/italics) when 
pasting data into form fields?

T



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

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



RE: Web Hosting for CFMX and MySQL

2003-01-06 Thread Roberson, Jeff, Mr (Contractor) ACI
Try www.plesk.com  I use it and it works great with CFMX

-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 11:29 AM
To: CF-Talk
Subject: RE: Web Hosting for CFMX and MySQL


Actually, the Ensim issue IS documented. :-)
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23524&Method=Full (#6 in
the list at the bottom of the article)

As it mentions in the description, it's actually a general Apache issue, but
it was the Ensim version that made the bug most visible. The 1.3.x connector
that is available for download in the technote does contain the fix for this
bug. The 2.0.x version should hopefully be added to the article within the
next week or so. I'll be sure to get the technote updated to reflect this
information.

Deb

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:16 PM
To: CF-Talk
Subject: RE: Web Hosting for CFMX and MySQL


No, unfortunately--

Just letting you know what the techs told us; we couldn't get CFMX to
work with Ensim for some reason or another.  They said that the two
don't seem to get along and we ended up snagging a box with Webmin on
it.

I prefer Ensim for it's ease-of-use, but...

Apparently, there are more than a few undocumented "things" when it
comes to CFMX and Linux.

Sorry.

> -Original Message-
> From: Chris Kief [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, January 03, 2003 3:15 PM
> To: CF-Talk
> Subject: RE: Web Hosting for CFMX and MySQL
> 
> 
> Russ,
> 
> None that I have heard of...but I haven't tried the two 
> together...any links
> or documentation on the problem(s) you can send my way??
> 
> thanks
> chris
> 
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, January 02, 2003 10:45 AM
> To: CF-Talk
> Subject: RE: Web Hosting for CFMX and MySQL
> 
> Isn't there an issue with Ensim and CFMX?
> 
> We just switched to Webmin and I thought that some incompatibilities
> with Ensim was one of the reasons.
> 
> > -Original Message-
> > From: Chris Kief [mailto:[EMAIL PROTECTED]] 
> > Sent: Thursday, January 02, 2003 12:43 PM
> > To: CF-Talk
> > Subject: RE: Web Hosting for CFMX and MySQL
> > 
> > 
> > It's a skinned version of Ensim (http://www.ensim.com).
> > 
> > chris
> > 
> > 
> > -Original Message-
> > From: Kevin Graeme [mailto:[EMAIL PROTECTED]] 
> > Sent: Thursday, January 02, 2003 7:13 AM
> > To: CF-Talk
> > Subject: RE: Web Hosting for CFMX and MySQL
> > 
> > Wow. Nice control panel for that hosting! Anyone know what it is?
> > 
> > -Kevin
> > 
> > > -Original Message-
> > > From: Massimo, Tiziana e Federica 
> [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, 
> January 02, 2003 5:02 AM
> > > To: CF-Talk
> > > Subject: Re: Web Hosting for CFMX and MySQL
> > >
> > >
> > > > Does anyone know of any web hosting company that provides 
> > the above
> > > > solution?
> > >
> > > I never tried them, since I try to stay away from MySQL and 
> > still looking
> > > for a CF/Postgres host:
> > >
> > > http://www.mediatemple.net/
> > >
> > > Massimo
> > >
> > > 
> > 
> > 
> 
> 


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



ToBase64 - ToBinary Functions in MX

2002-12-11 Thread Roberson, Jeff, Mr (Contractor) ACI
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C2A14D.CBD23560
Content-Type: text/plain;
charset="iso-8859-1"

Sorry about the previous post I had HTML EMail turned on :
 
 
I have an application in CF 4.5 :
 
I store files in a mySQL database by:
 
1.reading the File with CFFILE
2. convert it to base64
3.store it in a blob in the database
 
Retrevial is:
 
1.read database
2.run tobinary()
3.write it out with CFFILE.
 
This works fine on my 4.5 server but on MX I get no error at all but after I
run the ToBinary() function it is till BASE64.
 
Anyone have any ideas?
 
 
CODE:
 
UPLOAD -
 


  
  
  
  
tmpFile = toBase64(docObject);
  
  
  
   INSERT INTO id_projectfiles
 
(projectid,projecttype,filename,fileblob,contenttype,Notes,uploaduserid,disp
layname)
   VALUES(#iif(taskid NEQ 0,de(taskid),de(projectid))#,'#iif(taskid NEQ
0,de('T'),de('P'))#','#serverfile#','#tmpFile#','#contenttype#','#Notes#',#l
cl.userid#,'#displayname#')
  
  
 
DOWNLOAD -
 

   SELECT filename,fileblob,contenttype
   FROM id_projectfiles
   WHERE projectfileid = 
  
  

  
  
   tmpFile = ToBinary(qryfiles.fileblob);
   tmpFile = ToString(tmpFile);
  
  
  
   
  
   
  
 



Jeffrey Roberson

  _  

US Army Research, 
Development, Acquisition, and Sustainment 
Information Activity (USARDASIA) 
Radford, VA 24143-0004  

  _  

Phone:   540.731.3501   
DSN: 540.231.3501   
 

--_=_NextPart_001_01C2A14D.CBD23560
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Sorry about the=20
previous post I had HTML EMail turned on :
 
 
I =
have an=20
application in CF 4.5 :
 
I =
store files in a=20
mySQL database by:
 
    1.reading the File with CFFILE
    2. convert it to base64
    3.store it in a blob in the database
 
Retrevial=20
is:
 
    1.read database
    2.run tobinary()
    3.write it out with CFFILE.
 
This works fine on=20
my 4.5 server but on MX I get no error at all but after I run the =
ToBinary()=20
function it is till BASE64.
 
Anyone have any=20
ideas?
 
 
CODE:
 
UPLOAD=20
-=

 
  =
 INSERT=20
INTO=20
id_projectfiles  (projectid,projec=
ttype,filename,fileblob,contenttype,Notes,uploaduserid,displayname)&=
nbsp;  VALUES(#iif(taskid=20
NEQ 0,de(taskid),de(projectid))#,'#iif(taskid NEQ=20
0,de('T'),de('P'))#','#serverfile#','#tmpFile#','#contenttype#','#Notes#=
',#lcl.userid#,'#displayname#')   =
; 
 
DOWNLOAD=20
-=

 
   SELECT=20
filename,fileblob,contenttype   FROM=20
id_projectfiles   WHERE projectfileid =3D =
   &=
nbsp;  &=
nbsp;tmpFile=20
=3D ToBinary(qryfiles.fileblob);   tmpFile =3D=20
ToString(tmpFile);    &=
nbsp;         =
;  
 

  
  
Jeffrey Roberson
  

  

  
US=20
  Army Research, Development, Acquisition, and =
Sustainment=20
  Information Activity (USARDASIA) Radford, VA 24143-0004 =

  

  

  
Phone:
540.731.3501
  
DSN:
540.231.3501
 

--_=_NextPart_001_01C2A14D.CBD23560--



ToBase64 - ToBinary Functions in MX

2002-12-11 Thread Roberson, Jeff, Mr (Contractor) ACI
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C2A149.5CDD80A0
Content-Type: text/plain;
charset="iso-8859-1"

I have an application in CF 4.5 :
 
I store files in a mySQL database by:
 
1.reading the File with CFFILE
2. convert it to base64
3.store it in a blob in the database
 
Retrevial is:
 
1.read database
2.run tobinary()
3.write it out with CFFILE.
 
This works fine on my 4.5 server but on MX I get no error at all but after I
run the ToBinary() function it is till BASE64.
 
Anyone have any ideas?
 
 
CODE:
 
UPLOAD -
 


  
  
  
  
tmpFile = toBase64(docObject);
  
  
  
   INSERT INTO id_projectfiles
 
(projectid,projecttype,filename,fileblob,contenttype,Notes,uploaduserid,disp
layname)
   VALUES(#iif(taskid NEQ 0,de(taskid),de(projectid))#,'#iif(taskid NEQ
0,de('T'),de('P'))#','#serverfile#','#tmpFile#','#contenttype#','#Notes#',#l
cl.userid#,'#displayname#')
  
  
 
DOWNLOAD -
 

   SELECT filename,fileblob,contenttype
   FROM id_projectfiles
   WHERE projectfileid = 
  
  

  
  
   tmpFile = ToBinary(qryfiles.fileblob);
   tmpFile = ToString(tmpFile);
  
  
  
   
  
   
  
 



Jeffrey Roberson

  _  

US Army Research, 
Development, Acquisition, and Sustainment 
Information Activity (USARDASIA) 
Radford, VA 24143-0004  

  _  

Phone:   540.731.3501   
DSN: 540.231.3501   
 

--_=_NextPart_001_01C2A149.5CDD80A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I =
have an=20
application in CF 4.5 :
 
I =
store files in a=20
mySQL database by:
 
    1.reading the File with CFFILE
    2. convert it to base64
    3.store it in a blob in the database
 
Retrevial=20
is:
 
    1.read database
    2.run tobinary()
    3.write it out with CFFILE.
 
This works fine on=20
my 4.5 server but on MX I get no error at all but after I run the =
ToBinary()=20
function it is till BASE64.
 
Anyone have any=20
ideas?
 
 
CODE:
 
UPLOAD=20
-=

 
   INSERT=20
INTO=20
id_projectfiles  (projectid,projec=
ttype,filename,fileblob,contenttype,Notes,uploaduserid,displayname)&=
nbsp;  VALUES(#iif(taskid=20
NEQ 0,de(taskid),de(projectid))#,'#iif(taskid NEQ=20
0,de('T'),de('P'))#','#serverfile#','#tmpFile#','#contenttype#','#Notes#=
',#lcl.userid#,'#displayname#')   =
; 
 
DOWNLOAD=20
-=

 
   SELECT=20
filename,fileblob,contenttype   FROM=20
id_projectfiles   WHERE projectfileid =3D =
   &=
nbsp;  &=
nbsp;tmpFile=20
=3D ToBinary(qryfiles.fileblob);   tmpFile =3D=20
ToString(tmpFile);    &=
nbsp;         =
;  
 

  
  
Jeffrey Roberson
  

  

  
US=20
  Army Research, Development, Acquisition, and =
Sustainment=20
  Information Activity (USARDASIA) Radford, VA 24143-0004 =

  

  

  
Phone:
540.731.3501
  
DSN:
540.231.3501
 

--_=_NextPart_001_01C2A149.5CDD80A0--