Re: Quotes in dynamic queries [solved]
My mistake, however it wouldn't solve my particular problem because this
particular app is recording a 'history' of changes {"x changed from y
to z"). Yes, I know I could do this with triggers / stored procedures
but in this case it would be awfully complicated, so instead I am
evaluating the form returns and only updating fields which have changed
[to acceptable values], and also writing to a history log. The entire
thing is configured from a single structure of parameters so it is
fairly simple to manage.
To update only the fields with valid alterations I am building a query
string on the fly "fieldx = 'newvalue', fieldy = 'other new value',
fieldz = new date" etc. which is eventually put into the UPDATE query.
Single quotes input by the user in text fields were causing problems
because of their reserved use in SQL but not any other characters I can
find.
Jochem van Dieten wrote:
>
> Richard Meredith-Hardy wrote:
> >
> > > have
>
> That is incorrect, you can use it anywhere.
>
> > Second off, in a dynamic query like below, you need the
> > preservesinglequotes() so the single quotes 'surrounding' the text value
> > are not escaped automatically, however this will also preserve single
> > quotes in the body of the text value which will cause an error. The fix
> > is to escape any single quotes in the body of the text value before you
> > give it to preservesinglequotes(). Once I realized what I wanted, a very
> > simple UDF did the trick (easier to read and I will use it a lot):
> >
> >
> > function EscapeSingleQuotes(x)
> > {
> > return replace(x,"'","''","all");
> > }
> >
> >
> >
> > > idx])#'">
> >
> >
> > UPDATE testtable
> > SET #preservesinglequotes(tempVar)#
> > WHERE rowref = #idx#
> >
> >
>
> Escaping single quotes often is not enough, many database have
> escape characters like "\". You really should use cfqueryparam:
>
>
>
> UPDATE testtable
> SET fieldstr = value="#form["fieldstr_" & idx]#">
> WHERE rowref = value="#idx#">
>
>
>
> Jochem
>
>
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137438
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
RE: wanted features (was Re: (Admin) disclosure)
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 1:07 AM
> To: CF-Talk
> Subject: Re: wanted features (was Re: (Admin) disclosure)
>
> > The two biggest requests for new functionality I here are:
> >
> > 1) End of session processing (however it's done, an event model, a
> > special template handler, etc - people are always asking "how do I
tell
> > when a user is about to time-out").
> That would be great. OnEventEnd as a setting of some sort in the
> CFAPPLICATION
> tag to run a template when the specific event ends (OnSessionEnd,
> OnApplicationEnd). An admin or programatic way of watching the current
> session
> information would also be great. You can hack such a thing now, but
built
> in
> would be so much nicer.
I've got a feature request in the MM system now (actually added for me
by Adam Cameron) suggesting the extension of the Application.cfm to at
least four levels:
Application.cfm/OnRequestStart.cfm (a much better name I think)
OnRequestEnd.cfm: Already implemented
OnServerStart.cfm: Runs when the server starts. (Maybe not a good idea
as there may be file placement issues).
OnServerEnd.cfm: Runs when the server is taken down "nicely" - would be
useful for logging and such.
OnApplicationStart.cfm: Runs once the first time an app starts (server
refresh).
OnApplicationEnd.cfm: Runs on a nice server refresh or app time-out.
OnSessionStart.cfm: Runs once when a session is initialized in that
session's space.
OnSessionEnd.cfm: Runs right before a session is timed-out in that
session's space (but doesn't reset the session timeout).
> > 2) Direct Image manipulation (at the very least information access
and
> > resizing - it seems like every other week somebody is asking how to
do a
> > thumbnail gallery). This is pretty easy nowadays if you know a
little
> > Java - but many CFers don't.
> Direct image, PDF, RTF, etc. manipulation/creation. We can create
graphs
> on the
> fly nativly in CF, we can create images using the CFX_Image tag, we
can
> use X,Y,
> or Z product to create PDFs. Why not make it all native to CF.
This is the kind of thing that you can really extend infinitely. For
specific file formats (like PDF) I'm not sure if it's something MM would
want to do (licensing costs, perhaps, and version issues might crop up).
However it seems like they may be able to partner with somebody for this
stuff and include it in the base product.
In general CF's handling of binary data leaves a lot to be desired
(although it has gotten much better). Although it is possible to embed
binary data in a CF file now it's a little kludgy.
It would be very nice to be able to stream data into CF (as from a text
log file) instead of being forced to always load the entire file into
memory via CFFILE.
> > Even if NNTP's not "in demand" it does seem like one of the only
major
> > protocols that CF doesn't support natively. For that reason alone
it
> > might be nice to see it in there ("Supports all major Internet
> > protocols").
> My point. :)
And a fine point it is. ;^)
I'm just surprised that this was never done... I know that they've
always got bigger, better on the horizon and they're working on that,
but NNTP is such a simple protocol (no more complex than say SMTP or
POP). You'd think they would have done something long ago.
Jim Davis
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137437
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
RE: (Admin) disclosure
Or a HomeSite+ as a seperate product! I have CF Studio but HS+ has really grown on me - even the different icon representation of CFML templates after all these years. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 12:24 PM To: CF-Talk Subject: Re: (Admin) disclosure >>to Macromedia so they can review what people are talking about in ColdFusion. Joly good idea, so MM listen : GIVE US BACK CF STUDIO, PLASE ! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137436 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
ot: somewhat dumb mail ?
a few weeks ago i did a bulk email out to my clients & the program used my localhost to send it i guess. Im running XP pro NO/IIS just cfmx 6.1 standalone. But this 1 dam email keeps coming back & i cant figure out where to kill it at, any thoughts? its driving me nutz! here is the whole message The original message was received at Tue, 16 Sep 2003 07:06:51 -0700 from [EMAIL PROTECTED] - The following addresses had permanent fatal errors - [EMAIL PROTECTED] (reason: 554 5.4.6 Too many hops) - Transcript of session follows - 554 5.4.6 Too many hops 27 (25 max): from [EMAIL PROTECTED] via localhost, to [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137435 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: wanted features (was Re: (Admin) disclosure)
> The two biggest requests for new functionality I here are:
>
> 1) End of session processing (however it's done, an event model, a
> special template handler, etc - people are always asking "how do I tell
> when a user is about to time-out").
That would be great. OnEventEnd as a setting of some sort in the CFAPPLICATION
tag to run a template when the specific event ends (OnSessionEnd,
OnApplicationEnd). An admin or programatic way of watching the current session
information would also be great. You can hack such a thing now, but built in
would be so much nicer.
> 2) Direct Image manipulation (at the very least information access and
> resizing - it seems like every other week somebody is asking how to do a
> thumbnail gallery). This is pretty easy nowadays if you know a little
> Java - but many CFers don't.
Direct image, PDF, RTF, etc. manipulation/creation. We can create graphs on the
fly nativly in CF, we can create images using the CFX_Image tag, we can use X,Y,
or Z product to create PDFs. Why not make it all native to CF.
> Even if NNTP's not "in demand" it does seem like one of the only major
> protocols that CF doesn't support natively. For that reason alone it
> might be nice to see it in there ("Supports all major Internet
> protocols").
My point. :)
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137434
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Re: wanted features (was Re: (Admin) disclosure)
> > Now they'll have to go through over 225,000 messages to see what we > > want in CF > > and where we want it to go (NNTP, full protocol support, enhanced > > scheduling, > > Studio, etc.). Even with threading and subject sorting, it's not going > > to be > > something easy. > > > Studio seems like a pretty obvious want from the community. However, I > was hoping you could clarify what you mean by full protocol support and > enhanced scheduling. > > BTW, I wasn't aware that NNTP was in such high demand from CFers. Full protocol as in full communication protocols. We've got FTP, HTTP, SMTP, POP but there are others like NNTP that are missing. I'm not putting NNTP itself on the top of the list, but it's one of the most commonly used protocols that's missing from CF. A CFSocket tag might take care of it while a CFSocket and a CFNNTP (and maybe even a CFTelnet) might be nice. I'm just looking for the complete spread. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137433 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: wanted features (was Re: (Admin) disclosure)
> -Original Message-
> From: Matt Liotta [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 17, 2003 11:50 PM
> To: CF-Talk
> Subject: wanted features (was Re: (Admin) disclosure)
>
> > Now they'll have to go through over 225,000 messages to see what we
> > want in CF
> > and where we want it to go (NNTP, full protocol support, enhanced
> > scheduling,
> > Studio, etc.). Even with threading and subject sorting, it's not
going
> > to be
> > something easy.
> >
> Studio seems like a pretty obvious want from the community. However, I
> was hoping you could clarify what you mean by full protocol support
and
> enhanced scheduling.
>
> BTW, I wasn't aware that NNTP was in such high demand from CFers.
I for one would like it - but I'm with you: I doubt it's high on most
people lists (although, as a list-admin, Mike may have different
priorities). ;^)
The two biggest requests for new functionality I here are:
1) End of session processing (however it's done, an event model, a
special template handler, etc - people are always asking "how do I tell
when a user is about to time-out").
2) Direct Image manipulation (at the very least information access and
resizing - it seems like every other week somebody is asking how to do a
thumbnail gallery). This is pretty easy nowadays if you know a little
Java - but many CFers don't.
Even if NNTP's not "in demand" it does seem like one of the only major
protocols that CF doesn't support natively. For that reason alone it
might be nice to see it in there ("Supports all major Internet
protocols").
Personally I think we're doing pretty well - except for a few things CF
pretty much does it all. The vast majority of requests, it seems, are
for enhancements to existing stuff (and a good number of them are pretty
esoteric).
Jim Davis
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137432
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
RE: (Admin) disclosure
hint hint ... macromedians ... hint ... hint :)> tw -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:18 PM To: CF-Talk Subject: Re: (Admin) disclosure Yep. The request was made and I compiled the information and made it available to them. I saw no reason not to do so and every reason to do it. They didn't ask for user information or anything for tracking so there wasn't even a concern in that area. Now they'll have to go through over 225,000 messages to see what we want in CF and where we want it to go (NNTP, full protocol support, enhanced scheduling, Studio, etc.). Even with threading and subject sorting, it's not going to be something easy. Note that this is only the information since Jan 2000. I still have never put up the pre-2000 archives. That would have involve another few hundred thousand. Now if they want to hire me to do the sorting and collating for them as a full time job, I'm all for it. :) > well done MM, you have impressed me again :) > mike, did they actually ask you for this? > > tony > > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 10:24 PM > To: CF-Talk > Subject: Re: (Admin) disclosure > > > >>to Macromedia so they can review what people are talking about in > ColdFusion. > > Joly good idea, so MM listen : GIVE US BACK CF STUDIO, PLASE ! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137431 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
wanted features (was Re: (Admin) disclosure)
> Now they'll have to go through over 225,000 messages to see what we > want in CF > and where we want it to go (NNTP, full protocol support, enhanced > scheduling, > Studio, etc.). Even with threading and subject sorting, it's not going > to be > something easy. > Studio seems like a pretty obvious want from the community. However, I was hoping you could clarify what you mean by full protocol support and enhanced scheduling. BTW, I wasn't aware that NNTP was in such high demand from CFers. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137430 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: order and re-oder
> The user wants to be able to add new photographs and reorder them so that > prefered photos come first. I think Jeff Howden's provided an excellent start on this for you: http://evolt.jeffhowden.com/jeff/code/total_select.cfm - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137429 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Oracle error
> We have an Oracle 8.15 database. We have recently been experiencing periodic error meesage when some of our CF scripts try to execute an insert statement. The error that is returned is > > Error Message: Oracle Error Code = 1704ORA-01704: string literal too long > > When I copy and paste the SQL insert statement into SQLPlus it inserts teh data, no problem. > > This is only happening with long strings of data (varchar(4000)). The one change I do make when I paste it into sqlplus is that I insert carriage returns into any single line that is too long. This is because SQLPlus has issues with lines that are too long and if I dont put these in then SQLPlus gives me a different error indicating it can't handle the length. > > Has anyone seen this behavior before? If not, does anyone know of a way to add line breaks into a string every 90 charachters or so (reemembering that the line breaks can't occur in the middle of a word) > For strings that long, use cfqueryparam with the cf_sql_longvarchar type. We use CLOBs on CF 4.5 using cfqueryparam (11K, 12K, etc) with no problem. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137428 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: DNS, IIS Tags?
Thanks everyone! I'm off to check out your suggestions Brad -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:00 PM To: CF-Talk Subject: Re: DNS, IIS Tags? http://www.intrafoundation.com/ihtk.asp Doesn't do DNS, but there is a free DNS COM object floating around, as well as some command line scripts that MS gives away to manage dns. I had a few issues with it in the past, but it's been a while, and it could have been my fault. Personally I'd go with straight ADSI stuff using scripts, VB, .Net, or whatever else floats your boat, and not worrying about using CF except to run whatever scripts/executable are needed. I can say that .Net makes working with ADSI much less painful, and it's guaranteed (as guaranteed as anything MS) to be supported in future versions of Windows... -- jon mailto:[EMAIL PROTECTED] Wednesday, September 17, 2003, 6:29:36 PM, you wrote: BR> Anyone know of a tag that will create DNS records in Windows DNS, or a tag BR> that will create websites in IIS 5? Using Win2K Server, IIS 5, & CF 6.1. BR> Thanks, BR> Brad BR> ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137427 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: (Admin) disclosure
Yep. The request was made and I compiled the information and made it available to them. I saw no reason not to do so and every reason to do it. They didn't ask for user information or anything for tracking so there wasn't even a concern in that area. Now they'll have to go through over 225,000 messages to see what we want in CF and where we want it to go (NNTP, full protocol support, enhanced scheduling, Studio, etc.). Even with threading and subject sorting, it's not going to be something easy. Note that this is only the information since Jan 2000. I still have never put up the pre-2000 archives. That would have involve another few hundred thousand. Now if they want to hire me to do the sorting and collating for them as a full time job, I'm all for it. :) > well done MM, you have impressed me again :) > mike, did they actually ask you for this? > > tony > > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 10:24 PM > To: CF-Talk > Subject: Re: (Admin) disclosure > > > >>to Macromedia so they can review what people are talking about in > ColdFusion. > > Joly good idea, so MM listen : GIVE US BACK CF STUDIO, PLASE ! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137426 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Oracle error
We have an Oracle 8.15 database. We have recently been experiencing periodic error meesage when some of our CF scripts try to execute an insert statement. The error that is returned is Error Message: Oracle Error Code = 1704ORA-01704: string literal too long When I copy and paste the SQL insert statement into SQLPlus it inserts teh data, no problem. This is only happening with long strings of data (varchar(4000)). The one change I do make when I paste it into sqlplus is that I insert carriage returns into any single line that is too long. This is because SQLPlus has issues with lines that are too long and if I dont put these in then SQLPlus gives me a different error indicating it can't handle the length. Has anyone seen this behavior before? If not, does anyone know of a way to add line breaks into a string every 90 charachters or so (reemembering that the line breaks can't occur in the middle of a word) thanks for any help Ricki ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137425 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Finding CF Server
> I need to get my hands on a copy of CF Server, and i'm hoping atleast > 4.5. I need to find it as cheap as possible and i'm wondering, can > you upgrade a CF Server 4.0 to 4.5 for free or does that require a > purchase? Anyone know? Anyone got any leads on finding the pro or > ent version for dirt cheap? I've been checking Ebay and it looks like > i'll end up paying several hundred for it, but I want the best deal I > can get. Anyone got an old copy laying around they wanna unload for > some cash? > You know you can BlueDragon for free and it supports CF 5 features. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137424 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: (Admin) disclosure
well done MM, you have impressed me again :) mike, did they actually ask you for this? tony -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:24 PM To: CF-Talk Subject: Re: (Admin) disclosure >>to Macromedia so they can review what people are talking about in ColdFusion. Joly good idea, so MM listen : GIVE US BACK CF STUDIO, PLASE ! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137423 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Finding CF Server
Hey all: I need to get my hands on a copy of CF Server, and i'm hoping atleast 4.5. I need to find it as cheap as possible and i'm wondering, can you upgrade a CF Server 4.0 to 4.5 for free or does that require a purchase? Anyone know? Anyone got any leads on finding the pro or ent version for dirt cheap? I've been checking Ebay and it looks like i'll end up paying several hundred for it, but I want the best deal I can get. Anyone got an old copy laying around they wanna unload for some cash? Thanks, Robert ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137422 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: order and re-oder
I would use thumnail images, and drag'n drop the (in Javascript). Depending on the y value where the image is droped, you can determine between which images the image was droped. Suppose the image was moved up, then move one position down all images between the end and start position and set the image at thre new position. To "move images", just change their address (.src) in the images array. If the image was moved down, inverse the algorithm. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137421 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: (Admin) disclosure
>>to Macromedia so they can review what people are talking about in ColdFusion. Joly good idea, so MM listen : GIVE US BACK CF STUDIO, PLASE ! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137420 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: order and re-oder
There are probably a lot of different solutions to this, but here's my suggestion. To put it simply, create a sort order field attached to each image. While the user is sorting, let them go at it, reordering however they want. When they are done, reindex all of the items they were sorting, and update the sort order field in the database. Whether you keep track of the sort order number behind the scenes, or make them input a number doesn't matter. Your sorting routine should basically loop through the numbers, and reorder them from 1 , and the reordered numbers are what you put in the database, and what you use to sort by. If performance is an issue, scheduling reindexing would keep the sort values from getting messy as well. Remember that, when sorting item 1 down, it becomes item 2, and item 2 becomes item 1. Follow that logic through...and the rest is icing on the cake. If you are looking for an idea for a UI and are javascript inclined you can use this if you want. IE only...some complexish DOM2 stuff. http://216.136.31.190/sort/ -- jon mailto:[EMAIL PROTECTED] Wednesday, September 17, 2003, 9:01:41 PM, you wrote: m> I would like to be able let a user reorder photographs. m> Grouping them by type is not the issue, (fashion, runway, nature, etc...) or m> by subcategory (fashion_gender, runway_designer) m> The user wants to be able to add new photographs and reorder them so that m> prefered photos come first. m> My first thought is to have a photoOrder field which the user can update m> with an admin screen (simplified) something like the following: m> photoOrder Number --- photo m> 10 -- [img] m> 15 -- [img] m> 20 -- [img] m> The user can update the 10 (it's in a text field) to a 21 and have the first m> photo appear last. With only a few graphics in each sub category this can m> work fairly well --- but it's REALLY UGLY. m> Better yet would be to be able to move the graphic m> 1. up or down with an arrow (for one at a time) m> 2. send to end / beginning m> 3. have a text box to send a specified amount up or down. m> A simplified example below: m> << < [insert amount] > >> m> I can think of a way to update the records for this to work but eventually m> it would be a real big mess. m> User moves number 33 to behind 55. m> If 56 is there the photoOrder gets designated 55a m> 55b comes after 55a m> (55,55a,55b,56) m> Now with only a few photos, or even a few dozen photos who cares. But in a m> more involved system one would get situation like the following m> (55a1,55a2,55a3,55a4,55a5) m> (55a2a,55a2b,55a2c,55a2d) m> This is ridiculous.( or is it?) m> Is there a way to reorder/organize this field? m> to take a sorted list(of this field) 1-77-203-204-999 and make it m> 10,20,30,40,50 or (1000,2000,3000) m> Gilbert Midonnet ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137419 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: order and re-oder
How about just assigning every image with a sequetial integer and for updating just do swaps with the IDs, sort of like a bubble sort. for reordering use a bit of CSS and javascript and have each of your images as a span with an onclick which highlights that image to show its selected. Between each element have an arrow of some type which is basically a "insert here" > ---image--- > ---image--- > ---image--- > etc. when an image is selected and one of the arrows is clicked you need to do your updating. In your database say you have imagename | orderID a 1 b 2 c 3 d 4 e 5 f 6 where imagename is your primary key now if you wanted to move f to be just below b you would have to have an UPDATE statement like UPDATE table SET orderID = orderID + 1 WHERE orderID > (SELECT orderID FROM table WHERE imagename = 'b') UPDATE table SET orderID = (SELECT orderID FROM table WHERE imagename = 'b')+ 1 WHERE imagename = 'f' You would need to also have a case where you want to move in the other direction. This hasnt been tested, just an idea. regards, Gunther -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 11:02 AM To: CF-Talk Subject: order and re-oder I would like to be able let a user reorder photographs. Grouping them by type is not the issue, (fashion, runway, nature, etc...) or by subcategory (fashion_gender, runway_designer) The user wants to be able to add new photographs and reorder them so that prefered photos come first. My first thought is to have a photoOrder field which the user can update with an admin screen (simplified) something like the following: photoOrder Number --- photo 10 -- [img] 15 -- [img] 20 -- [img] The user can update the 10 (it's in a text field) to a 21 and have the first photo appear last. With only a few graphics in each sub category this can work fairly well --- but it's REALLY UGLY. Better yet would be to be able to move the graphic 1. up or down with an arrow (for one at a time) 2. send to end / beginning 3. have a text box to send a specified amount up or down. A simplified example below: << < [insert amount] > >> I can think of a way to update the records for this to work but eventually it would be a real big mess. User moves number 33 to behind 55. If 56 is there the photoOrder gets designated 55a 55b comes after 55a (55,55a,55b,56) Now with only a few photos, or even a few dozen photos who cares. But in a more involved system one would get situation like the following (55a1,55a2,55a3,55a4,55a5) (55a2a,55a2b,55a2c,55a2d) This is ridiculous.( or is it?) Is there a way to reorder/organize this field? to take a sorted list(of this field) 1-77-203-204-999 and make it 10,20,30,40,50 or (1000,2000,3000) Gilbert Midonnet ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137418 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
order and re-oder
I would like to be able let a user reorder photographs. Grouping them by type is not the issue, (fashion, runway, nature, etc...) or by subcategory (fashion_gender, runway_designer) The user wants to be able to add new photographs and reorder them so that prefered photos come first. My first thought is to have a photoOrder field which the user can update with an admin screen (simplified) something like the following: photoOrder Number --- photo 10 -- [img] 15 -- [img] 20 -- [img] The user can update the 10 (it's in a text field) to a 21 and have the first photo appear last. With only a few graphics in each sub category this can work fairly well --- but it's REALLY UGLY. Better yet would be to be able to move the graphic 1. up or down with an arrow (for one at a time) 2. send to end / beginning 3. have a text box to send a specified amount up or down. A simplified example below: << < [insert amount] > >> I can think of a way to update the records for this to work but eventually it would be a real big mess. User moves number 33 to behind 55. If 56 is there the photoOrder gets designated 55a 55b comes after 55a (55,55a,55b,56) Now with only a few photos, or even a few dozen photos who cares. But in a more involved system one would get situation like the following (55a1,55a2,55a3,55a4,55a5) (55a2a,55a2b,55a2c,55a2d) This is ridiculous.( or is it?) Is there a way to reorder/organize this field? to take a sorted list(of this field) 1-77-203-204-999 and make it 10,20,30,40,50 or (1000,2000,3000) Gilbert Midonnet ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137417 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: (Admin) disclosure
Glad to hear they're interested. These lists contain a wealth of information that should serve them well if they listen with an open mind to what's being said and truly take it to heart. Ken -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:16 PM To: CF-Talk Subject: (Admin) disclosure I'm for full disclosure which is why I'm letting everyone here know that I'm giving a data dump of this and a few other lists to Macromedia so they can review what people are talking about in ColdFusion. This data will be used to enhance their ability to give us the features we want and address our concerns. I will be providing message bodies and subjects only. No user information, names, email addresses, message headers or other identifying information will be given. This is actually less information than is available in the public archives of this list. Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137416 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Dreamweaver Fatal Exception
I just got that error this morning for the first time. It happened when I was redoing a bunch of steps in a row (say 10-15) and was mashing the keys in rapid succession. barneyb > -Original Message- > From: Stacy Young [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 4:21 PM > To: CF-Talk > Subject: RE: Dreamweaver Fatal Exception > > > I used to get this all the time with MX, never figured out what cause > it. 2004 hasn't crashed on me yet. > > Stace > > > -Original Message- > From: Gary Hotko [mailto:[EMAIL PROTECTED] > Sent: September 17, 2003 11:05 AM > To: CF-Talk > Subject: Dreamweaver Fatal Exception > > A bit puzzled... I am using DWMX and during this morning.. I have gotten > > "Dreamweaver has encoutered a Fatal Exeption and will now terminiate"... > > What is causing this? It seems while I have been working on 2 pages. Any > > Ideas...? > > Thanks > > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137415 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Dreamweaver Fatal Exception
I used to get this all the time with MX, never figured out what cause it. 2004 hasn't crashed on me yet. Stace -Original Message- From: Gary Hotko [mailto:[EMAIL PROTECTED] Sent: September 17, 2003 11:05 AM To: CF-Talk Subject: Dreamweaver Fatal Exception A bit puzzled... I am using DWMX and during this morning.. I have gotten "Dreamweaver has encoutered a Fatal Exeption and will now terminiate"... What is causing this? It seems while I have been working on 2 pages. Any Ideas...? Thanks ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137414 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SSL / Flash Remoting / CFMX
Yep, no issues...but make sure the pluginspace address is HTTPS inside ur object tag. Stace -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: September 17, 2003 1:30 PM To: CF-Talk Subject: SSL / Flash Remoting / CFMX Any issues here? Has anyone done this yet? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137413 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
(Admin) disclosure
I'm for full disclosure which is why I'm letting everyone here know that I'm giving a data dump of this and a few other lists to Macromedia so they can review what people are talking about in ColdFusion. This data will be used to enhance their ability to give us the features we want and address our concerns. I will be providing message bodies and subjects only. No user information, names, email addresses, message headers or other identifying information will be given. This is actually less information than is available in the public archives of this list. Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137412 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Linux Newbie Advice
I think the kernal is 2.4.21. But when I think about it, I haven't actually used the data in Windows. (I use Windows data in Linux and Linux data in Linux, but not Linux data in Windows.) Matt Liotta wrote: >>I've never had any trouble with NTFS from Linux (using Mandrake 8/9). >> >> >> >Which kernel are you using and are you writing to NTFS from Linux and >then making use of the data from Windows later? > >Matt Liotta >President & CEO >Montara Software, Inc. >http://www.MontaraSoftware.com >(888) 408-0900 x901 > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137411 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: DNS, IIS Tags?
http://www.intrafoundation.com/ihtk.asp Doesn't do DNS, but there is a free DNS COM object floating around, as well as some command line scripts that MS gives away to manage dns. I had a few issues with it in the past, but it's been a while, and it could have been my fault. Personally I'd go with straight ADSI stuff using scripts, VB, .Net, or whatever else floats your boat, and not worrying about using CF except to run whatever scripts/executable are needed. I can say that .Net makes working with ADSI much less painful, and it's guaranteed (as guaranteed as anything MS) to be supported in future versions of Windows... -- jon mailto:[EMAIL PROTECTED] Wednesday, September 17, 2003, 6:29:36 PM, you wrote: BR> Anyone know of a tag that will create DNS records in Windows DNS, or a tag BR> that will create websites in IIS 5? Using Win2K Server, IIS 5, & CF 6.1. BR> Thanks, BR> Brad BR> ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137410 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Linux Newbie Advice
> I've never had any trouble with NTFS from Linux (using Mandrake 8/9). > Which kernel are you using and are you writing to NTFS from Linux and then making use of the data from Windows later? Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137409 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: DNS, IIS Tags?
Well I have to do the same thing. I couldn't find a tag so I wrote the code. I create the website using a Batch file and CFEXECUTE the same for DNS entries and WARFTP Accounts. The script you need to run for IIS is 'mkw3site' DNS is 'Dnscmd' I think you need to get it off of the Windows 2000 tool kit. Rick -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:30 PM To: CF-Talk Anyone know of a tag that will create DNS records in Windows DNS, or a tag that will create websites in IIS 5? Using Win2K Server, IIS 5, & CF 6.1. Thanks, Brad ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137408 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: DNS, IIS Tags?
Brad, we have a link in our blog to some CFX's for this and other purposes. http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowComments&ArticleID=20030717113914 Hth Kind Regards - Mike Brunt Original Message --- Anyone know of a tag that will create DNS records in Windows DNS, or a tag that will create websites in IIS 5? Using Win2K Server, IIS 5, & CF 6.1. Thanks, Brad ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137407 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Linux Newbie Advice
I've never had any trouble with NTFS from Linux (using Mandrake 8/9). Matt Liotta wrote: >>Even if you used NTFS originally, you can usually get to the filesystem >>using Linux, and bypass NTFS ACLs as well of course. I don't think >>you'll be >>able to get to it if you reformat or repartition your disk during the >>Linux >>install, though. >> >> >> >NTFS support in Linux is always up in the air. Last I heard, they have >a special Windows tool that you have to run in order to use NTFS in >Windows after Linux mucked with it. > >Matt Liotta >President & CEO >Montara Software, Inc. >http://www.MontaraSoftware.com >(888) 408-0900 x901 > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137406 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
DNS, IIS Tags?
Anyone know of a tag that will create DNS records in Windows DNS, or a tag that will create websites in IIS 5? Using Win2K Server, IIS 5, & CF 6.1. Thanks, Brad ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137405 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Help: CF5 is making access file grow to 2GB
Bruce, Rodney S HQISEC/Veridian IT Services wrote: > I had a similar issue, but quite as bad, but an MS access db would grow to > 2GB in about a week or less depending on the activity. You might want to check if your client variables have "global updates" enabled, they can add quite a bit of load. > I solved (if you call it that) the issue by doing an automatice compression > of the db everynight. > > Let me know and I will email you the code off list. > > I got the origanal code from Jochem, so he might have a more updated version > as well. I received some patches (for password protected databases), but haven't gotten around testing them yet. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137404 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
advice
I've been in Puerto Rico a little over a year and I cannot BEGIN to tell you how awesome it's been. Truly widens the paradigms and offers a much more diverse and enriching life. ATTENTION!!! *** This email is privileged and/or confidential information that is intended solely for the person or person(s) to whom it is addressed. If you are receiving this email in error, please delete it immediately and contact the sender by return email. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137403 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Linux Newbie Advice
> Even if you used NTFS originally, you can usually get to the filesystem > using Linux, and bypass NTFS ACLs as well of course. I don't think > you'll be > able to get to it if you reformat or repartition your disk during the > Linux > install, though. > NTFS support in Linux is always up in the air. Last I heard, they have a special Windows tool that you have to run in order to use NTFS in Windows after Linux mucked with it. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137402 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
Yes please, it may be a good short term fix. Or long term... You can mail it to: [EMAIL PROTECTED] -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:42 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB I had a similar issue, but quite as bad, but an MS access db would grow to 2GB in about a week or less depending on the activity. I solved (if you call it that) the issue by doing an automatice compression of the db everynight. Let me know and I will email you the code off list. I got the origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137401 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
I had a similar issue, but quite as bad, but an MS access db would grow to 2GB in about a week or less depending on the activity. I solved (if you call it that) the issue by doing an automatice compression of the db everynight. Let me know and I will email you the code off list. I got the origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137400 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Urgent: Performance Help
At the starting level you seem to be at with the site and databases, I'd recommend taking the MySQL route its free... runs on more platforms.. runs darn fast... If you think your clients/company will be a Windoze shop or clients will be wanting MS solutions I'd say pickup MsSQL afterwards... Simple selects, writes and updates aren't very different between them... syntax can be annoying... Transactions and complicated sub queries, mass unions, etc. typically are beyond what most folks actually need... Finally, MySQL + CF can be setup on a smallish computer within your home /office and run pretty well... Be sure to setup dev environment of your own before deploying your monster apps... -paris -- Original Message -- From: Jim Campbell <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 15:51:14 -0500 >It's interesting they'd charge you more for MySQL than Access (since I >assume they'll have more tech support issues with Access ;) > >However, MySQL is not that hard to learn. You don't have transactional >support nor real foreign keys, etc. There are a number of differences >that we've discussed before on this list, and you should be able to pick >them up for the archives. > >SQL Server might be a better choice - it should be able to recognize >your tables/datatypes from Access without any problems, and if you're >using things like transactions, the migration should be fairly >painless. _Fairly_ painless, not necessarily totally painless. > >Best of luck. > >- Jim > >Andy Ousterhout wrote: > >>Jim, >>I've asked them to look specifically at the Access connection, because I >>have heard that also. They have MySQL and SQL Server, for more $$$. I also >>would have to learn them, which would take time. I was hoping to put off >>moving to a "real" engine after I had a site that might drive some traffic. >>I may have to change my plans. >> >>Thanks >>Andy >> >>-Original Message- >>From: Jim Campbell [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, September 17, 2003 3:32 PM >>To: CF-Talk >>Subject: Re: Urgent: Performance Help >> >> >>Your problem might lie with Access - I've had plenty of problems with >>Access and ColdFusion - especially with keeping threads open and bogging >>down the system - and always on servers that handle many simultaneous >>requests. Can you use a different database with them? PostgreSQL? SQL >>Server? MySQL? >> >>- Jim >> >>Andy Ousterhout wrote: >> >> >> >>>No, don't recommend Viagrathe problem is I just won't stop. >>> >>>My ISP is accusing me of writing code that keeps threads open long after >>> >>> >>they >> >> >>>should be closed and are threatening to shut down my site. Good news is >>> >>> >>that >> >> >>>I don't have many users yet, Bad news is that they can't give me any >>> >>> >>details >> >> >>>because they don't have their analytical software, Cognos, up yet. >>> >>>Is there a site anywhere that can help we walk through my code and try to >>>figure out what the problem is? Running MX and Microsoft Access. It runs >>>fine as a single user on my PC. >>> >>>Thanks for anything you can give me >>> >>>Andy >>> >>> >>> >>> >>> >> >> > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137399 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Linux Newbie Advice
> > Are you concerned about recovering the data on the machine? > > If so, installing Linux won't necessarily help you (especially > > if you end up repartitioning or reformatting). You might want > > to try NT Locksmith and/or NT Recover: ... > > Assuming NTFS wasn't used then the file system could be accessed > directly from Linux without issue. Even if you used NTFS originally, you can usually get to the filesystem using Linux, and bypass NTFS ACLs as well of course. I don't think you'll be able to get to it if you reformat or repartition your disk during the Linux install, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137398 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
CF5 (as in the subject :-)) I've had a long day too. MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:18 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are you are on CF5 or MX? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:18 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB I am sorry! The site uses menu monger pro and MM pro does use client vars. So yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think that is on the low side) it would only be 20 hours till it built the 2 GB file. Thanks MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137397 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Help: CF5 is making access file grow to 2GB
>>Has anyone seen this before? This will happen if you make frequent updates by deleting records and rewriting them with different data. I know it is easier, but it leaves plenty of holes in the database and every new record takes new space. One way of avoiding this is to make sure you reuse and update all records you can instead of deleting them. It is more work however. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137396 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
Are you are on CF5 or MX? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:18 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB I am sorry! The site uses menu monger pro and MM pro does use client vars. So yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think that is on the low side) it would only be 20 hours till it built the 2 GB file. Thanks MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137395 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
customer list handling custom tag
I need to let clients upload a mailing list in a delimited format and "manage" it on the server - add/edit/delete. I've done this type of thing before, but I was wondering if there is a custom tag that will handling everything from upload to display. Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137394 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
I am sorry! The site uses menu monger pro and MM pro does use client vars. So yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think that is on the low side) it would only be 20 hours till it built the 2 GB file. Thanks MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137393 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Linux Newbie Advice
Nope...no valued data...just thought i might need to get access to Windows to toast it and get Linux ontotal drive wipe is fine ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 1:36 PM Subject: RE: Linux Newbie Advice > > One big issue is the passwords for this box have been lost. > > Are you concerned about recovering the data on the machine? If so, > installing Linux won't necessarily help you (especially if you end up > repartitioning or reformatting). You might want to try NT Locksmith and/or > NT Recover: > > http://www.winternals.com/ > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137392 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
What does the application do? Are there tons of inserts and deletes? > -Original Message- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 12:45 PM > To: CF-Talk > Subject: Help: CF5 is making access file grow to 2GB > > > I just got back from a client site and they are running CF5 and MS > access. > The problem is that the MSAccess file grows at least 5 MB per min. thus > filling the hard disk. I was able to do a simple compact with access > and the file shrunk from 2 GB to 5 MB, but soon after started to grow > again. > > Has anyone seen this before? > > I assume that since I can shrink the database to 5 MB then it is not > real data that is taking up the 2gb of space. > > Anyone have any ideas? > > I found that if reset CF it took about 15mins for the growing to start. > > Thanks > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137391 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Eolas, Flash et al
Matt Robertson wrote: > Just came across this on-topic-insofar-as-MM/Flash/CF/The-Future-is-concerned > subject. > > http://www.webpagesthatsuck.com/dailysucker/ > > Not looking to spark another debate, but this mentions a MM/MS meeting I hadn't > heard about, and I assume I'm not alone on that score Here's a couple of links you might find useful: Report by the W3C's Steven R Bratt: http://www.w3.org/2003/08/patent The public mailing list: http://lists.w3.org/Archives/Public/public-web-plugins/ HTH Dave ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137390 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
Dan, Nothing out of the ordinary. I have RDS access the client's server. I am downloading a back up of the file I made a few min ago. I'll take a 2nd look. Thanks. MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137389 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Urgent: Performance Help
Andy Ousterhout wrote: > > I've asked them to look specifically at the Access connection, because I > have heard that also. They have MySQL and SQL Server, for more $$$. I also > would have to learn them, which would take time. I was hoping to put off > moving to a "real" engine after I had a site that might drive some traffic. > I may have to change my plans. While not on MX, I have some experience with Access and CF. If your site is as lightly loaded as you say, it shouldn't be the cause of your problems. Maybe wrong drivers/settings, but not the Jet engine itself. Not before you are doing 40+ queries per second. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137388 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137387 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Urgent: Performance Help
Having come from where you are at not that long ago, I can tell you that picking up the basics of MS SQL server will be very easy. The parts of Access that you use in a CF application are fairly similar to the parts of MS SQL you will use for a CF application, the creation of tables, fields and relationships. Adding, editing and deleting are all almost the same. Now of course there is a LOT more to MS SQL, but the vast majority of this stuff falls under the "DBA" role, and that person is at the ISP. So, unless you are planning on completely taking over the database either in-house or out. You shouldn't have to worry about many of these issues. At least not just yet. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:43 PM To: CF-Talk Subject: RE: Urgent: Performance Help Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a "real" engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: >No, don't recommend Viagrathe problem is I just won't stop. > >My ISP is accusing me of writing code that keeps threads open long after they >should be closed and are threatening to shut down my site. Good news is that >I don't have many users yet, Bad news is that they can't give me any details >because they don't have their analytical software, Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try to >figure out what the problem is? Running MX and Microsoft Access. It runs >fine as a single user on my PC. > >Thanks for anything you can give me > >Andy > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137386 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Urgent: Performance Help
It's interesting they'd charge you more for MySQL than Access (since I assume they'll have more tech support issues with Access ;) However, MySQL is not that hard to learn. You don't have transactional support nor real foreign keys, etc. There are a number of differences that we've discussed before on this list, and you should be able to pick them up for the archives. SQL Server might be a better choice - it should be able to recognize your tables/datatypes from Access without any problems, and if you're using things like transactions, the migration should be fairly painless. _Fairly_ painless, not necessarily totally painless. Best of luck. - Jim Andy Ousterhout wrote: >Jim, >I've asked them to look specifically at the Access connection, because I >have heard that also. They have MySQL and SQL Server, for more $$$. I also >would have to learn them, which would take time. I was hoping to put off >moving to a "real" engine after I had a site that might drive some traffic. >I may have to change my plans. > >Thanks >Andy > >-Original Message- >From: Jim Campbell [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2003 3:32 PM >To: CF-Talk >Subject: Re: Urgent: Performance Help > > >Your problem might lie with Access - I've had plenty of problems with >Access and ColdFusion - especially with keeping threads open and bogging >down the system - and always on servers that handle many simultaneous >requests. Can you use a different database with them? PostgreSQL? SQL >Server? MySQL? > >- Jim > >Andy Ousterhout wrote: > > > >>No, don't recommend Viagrathe problem is I just won't stop. >> >>My ISP is accusing me of writing code that keeps threads open long after >> >> >they > > >>should be closed and are threatening to shut down my site. Good news is >> >> >that > > >>I don't have many users yet, Bad news is that they can't give me any >> >> >details > > >>because they don't have their analytical software, Cognos, up yet. >> >>Is there a site anywhere that can help we walk through my code and try to >>figure out what the problem is? Running MX and Microsoft Access. It runs >>fine as a single user on my PC. >> >>Thanks for anything you can give me >> >>Andy >> >> >> >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137385 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Urgent: Performance Help
Andy Ousterhout wrote: > > My ISP is accusing me of writing code that keeps threads open long after they > should be closed and are threatening to shut down my site. Good news is that > I don't have many users yet, Bad news is that they can't give me any details > because they don't have their analytical software, Cognos, up yet. Then how can they tell it is your site that is keeping threads open? Please ask them how they found that out, it may be important to solving the issue. > Is there a site anywhere that can help we walk through my code and try to > figure out what the problem is? Running MX and Microsoft Access. It runs > fine as a single user on my PC. Does Access use persisent connections? Which driver are they using for Access? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137384 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Help: CF5 is making access file grow to 2GB
Sounds like it might be client variables in the DB - that's the first thing I'd check. - Jim Mark W. Breneman wrote: >I just got back from a client site and they are running CF5 and MS >access. >The problem is that the MSAccess file grows at least 5 MB per min. thus >filling the hard disk. I was able to do a simple compact with access >and the file shrunk from 2 GB to 5 MB, but soon after started to grow >again. > >Has anyone seen this before? > >I assume that since I can shrink the database to 5 MB then it is not >real data that is taking up the 2gb of space. > >Anyone have any ideas? > >I found that if reset CF it took about 15mins for the growing to start. > >Thanks > >Mark W. Breneman >-Cold Fusion Developer >-Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137383 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Eolas, Flash et al
The W3C has a mailing list setup for this issue and the meeting announcement was posted to that mailing list. -Matt On Wednesday, September 17, 2003, at 04:46 PM, Matt Robertson wrote: > Just came across this > on-topic-insofar-as-MM/Flash/CF/The-Future-is-concerned subject. > > http://www.webpagesthatsuck.com/dailysucker/ > > Not looking to spark another debate, but this mentions a MM/MS meeting > I hadn't heard about, and I assume I'm not alone on that score > > -- > --- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > --- > > -- > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137382 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137381 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
That seems to be the consensus. I knew this going in, but thought that I could get some of my site out first, then change. This may not be possible... Andy -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:34 PM To: CF-Talk Subject: RE: Urgent: Performance Help access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137380 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Urgent: Performance Help
Access database is 15 tables and 15 Meg. Pretty small right now. And I just compressed it last night. Very few inserts,updates and deletes right now, mostly view. I'll ask them to monitor the DB connections Thanks, Andy -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: RE: Urgent: Performance Help Show do they know its you if they can't prove it? One guess is that they may be view database connections from perfmon which may be pointing to your domain. How big is your access DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137379 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137378 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a "real" engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: >No, don't recommend Viagrathe problem is I just won't stop. > >My ISP is accusing me of writing code that keeps threads open long after they >should be closed and are threatening to shut down my site. Good news is that >I don't have many users yet, Bad news is that they can't give me any details >because they don't have their analytical software, Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try to >figure out what the problem is? Running MX and Microsoft Access. It runs >fine as a single user on my PC. > >Thanks for anything you can give me > >Andy > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137377 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Help: CF5 is making access file grow to 2GB
I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137376 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Eolas, Flash et al
Just came across this on-topic-insofar-as-MM/Flash/CF/The-Future-is-concerned subject. http://www.webpagesthatsuck.com/dailysucker/ Not looking to spark another debate, but this mentions a MM/MS meeting I hadn't heard about, and I assume I'm not alone on that score -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137375 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Linux Newbie Advice
> Are you concerned about recovering the data on the machine? If so, > installing Linux won't necessarily help you (especially if you end up > repartitioning or reformatting). You might want to try NT Locksmith > and/or > NT Recover: > Assuming NTFS wasn't used then the file system could be accessed directly from Linux without issue. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137374 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
Webmin (and usermin) should work with any Linux distro - but to be sure, read the docs on sourceforge == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 3:09 PM Subject: Re: OT: Linux Newbie Advice | Can WebAdmin work with other GUIs (i.e. could I have Mandrake with X Windows | installed and still use WebAdmin)? | | Bryan Stevenson B.Comm. | VP & Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder & Director | www.cfug-vancouverisland.com | - Original Message - | From: "Doug White" <[EMAIL PROTECTED]> | To: "CF-Talk" <[EMAIL PROTECTED]> | Sent: Wednesday, September 17, 2003 12:59 PM | Subject: Re: OT: Linux Newbie Advice | | | > RedHat 9.0 is in wide use and is supported by CFMX 6.1 | > | > Purchasing the package for about $39.00 at Best Buy will give you free | support | > and updates (which seem to come about as often as the ones from | Microsoft.) | > | > When doing the install, be sure to install KDE desktop if you are wanting | a GUI | > to work with. Or if you are wanting to maintain it remotely, install | Webmin. | > | > == | > Stop spam on your domain, use our gateway! | > For hosting solutions http://www.clickdoug.com | > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. | > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 | > Suggested corporate Anti-virus policy: | http://www.dshield.org/antivirus.pdf | > == | > If you are not satisfied with my service, my job isn't done! | > | > - Original Message - | > From: "Bryan Stevenson" <[EMAIL PROTECTED]> | > To: "CF-Talk" <[EMAIL PROTECTED]> | > Sent: Wednesday, September 17, 2003 2:23 PM | > Subject: Re: OT: Linux Newbie Advice | > | > | > | Thanks Matt | > | | > | So what's the current RedHat version that is stable? where can I grab a | > | copy? | > | | > | Is it installed from a floppy/CD at boot up? | > | | > | I promise to RTFM after I get the dang thing ;-) | > | | > | Cheers | > | | > | Bryan Stevenson B.Comm. | > | VP & Director of E-Commerce Development | > | Electric Edge Systems Group Inc. | > | t. 250.920.8830 | > | e. [EMAIL PROTECTED] | > | | > | - | > | Macromedia Associate Partner | > | www.macromedia.com | > | - | > | Vancouver Island ColdFusion Users Group | > | Founder & Director | > | www.cfug-vancouverisland.com | > | - Original Message - | > | From: "Matt Liotta" <[EMAIL PROTECTED]> | > | To: "CF-Talk" <[EMAIL PROTECTED]> | > | Sent: Wednesday, September 17, 2003 12:14 PM | > | Subject: Re: OT: Linux Newbie Advice | > | | > | | > | > > So can I simply install Linux over Windows (i.e. from boot up)? or | do | > | > > I have | > | > > to wipe the drive first (FDisk)? | > | > > | > | > Yes, you can simply install Linux over Windows assuming you don't want | > | > access to any of the data on the hard drive. | > | > | > | > > What do you Linux folks recommend for a Linux package to install | (i.e. | > | > > RedHat version...Mandrake etc.)? Bear in mind I know very little | about | > | > > Linux and I don't want to play the command line game. So a package | > | > > that has | > | > > a decent GUI would be nice (I've seen and played a bit with X | > | > > Windows...seemed nice...but what do I know...hehe). | > | > > | > | > I always recommend RedHat to people since it is the most widely used | > | > distribution and thus it is easier to get help from others with. After | > | > you become more familiar with Linux in general then you can start | > | > worrying about why you would choose one distribution over the others. | > | > | > | > Matt Liotta | > | > President & CEO | > | > Montara Software, Inc. | > | > http://www.MontaraSoftware.com | > | > (888) 408-0900 x901 | > | > | > | > | > | > | > | | > | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137373 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/c
RE: Urgent: Performance Help
Access tends to 'abandon' connections... a fair amount of memory loss with any large usage on a server.. Access isn't good at all for shared hosting company environments... Easy way to hose a server... Find out if they have your DSN maintaining connections ... depending on the application you will or won't want to enable maintain connections... I have found that if your are doing lots of database activity to leave it on with Access... There is also the timeout to maintain DSN connection... try putting that at 1-5 minutes.. probably set at 0 default now... -paris -- Original Message -- From: "Tony Weeg" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 16:33:45 -0400 >access has been known at some point (amount of connections or maybe >lines in the database) >to hose up, what that means? not sure, but I know this, if at all >possible, STAY AWAY FROM ACCESS > >tony > >tony weeg >sr. web applications architect >navtrak, inc. >[EMAIL PROTECTED] >www.navtrak.net >office 410.548.2337 >fax 410.860.2337 > > >-Original Message- >From: Andy Ousterhout [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2003 4:24 PM >To: CF-Talk >Subject: Urgent: Performance Help > > >No, don't recommend Viagrathe problem is I just won't stop. > >My ISP is accusing me of writing code that keeps threads open long after >they should be closed and are threatening to shut down my site. Good >news is that I don't have many users yet, Bad news is that they can't >give me any details because they don't have their analytical software, >Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try >to figure out what the problem is? Running MX and Microsoft Access. It >runs fine as a single user on my PC. > >Thanks for anything you can give me > >Andy > > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137372 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
Show do they know its you if they can't prove it? One guess is that they may be view database connections from perfmon which may be pointing to your domain. How big is your access DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137370 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Urgent: Performance Help
access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137371 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: OT: Linux Newbie Advice
> Can WebAdmin work with other GUIs (i.e. could I have Mandrake > with X Windows installed and still use WebAdmin)? Yes, it does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137367 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Linux Newbie Advice
> One big issue is the passwords for this box have been lost. Are you concerned about recovering the data on the machine? If so, installing Linux won't necessarily help you (especially if you end up repartitioning or reformatting). You might want to try NT Locksmith and/or NT Recover: http://www.winternals.com/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137368 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Urgent: Performance Help
Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: >No, don't recommend Viagrathe problem is I just won't stop. > >My ISP is accusing me of writing code that keeps threads open long after they >should be closed and are threatening to shut down my site. Good news is that >I don't have many users yet, Bad news is that they can't give me any details >because they don't have their analytical software, Cognos, up yet. > >Is there a site anywhere that can help we walk through my code and try to >figure out what the problem is? Running MX and Microsoft Access. It runs >fine as a single user on my PC. > >Thanks for anything you can give me > >Andy > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137369 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Urgent: Performance Help
No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137366 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Linux Newbie Advice
Bryan, Overall, I found SuSE 8.2 to be the easiest to install on an older machine. I'm a complete Linux newbie and didn't want to fool with the comand line during installation. SuSE install was straightforward and went without any hitches. It even recognized my windows network connection and DHCP and I can surf the net without any additional configuration. Others I tried: - I could install Mandrake 7.2, but it didn't recognize the D-Link DFE-530TX+ (my ethernet card). I found a Linux driver but coudn't really follow the install instructions, so I bailed out. - I couldn't install RedHat 9.1 because it didn't seem to work with my video card. My computer is old enough that I don't even have an AGP port. So RedHat 9.1 was out of the question (although I installed it on my laptop without issue). I picked SuSE because it had a reputation for ease of installation and it supposedly will support CFMX 6.1, although I have not tried installing CF yet. Hope this helps, from one newb to another. Oh yeah, I installed Linux right over Windows 98 -- it wipes the drive. -- Marc A. Garrett since1968.com "Bryan Stevenson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hey All, > > > So can I simply install Linux over Windows (i.e. from boot up)? or do I have > to wipe the drive first (FDisk)? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137365 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
Can WebAdmin work with other GUIs (i.e. could I have Mandrake with X Windows installed and still use WebAdmin)? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Doug White" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 12:59 PM Subject: Re: OT: Linux Newbie Advice > RedHat 9.0 is in wide use and is supported by CFMX 6.1 > > Purchasing the package for about $39.00 at Best Buy will give you free support > and updates (which seem to come about as often as the ones from Microsoft.) > > When doing the install, be sure to install KDE desktop if you are wanting a GUI > to work with. Or if you are wanting to maintain it remotely, install Webmin. > > == > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf > == > If you are not satisfied with my service, my job isn't done! > > - Original Message - > From: "Bryan Stevenson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 17, 2003 2:23 PM > Subject: Re: OT: Linux Newbie Advice > > > | Thanks Matt > | > | So what's the current RedHat version that is stable? where can I grab a > | copy? > | > | Is it installed from a floppy/CD at boot up? > | > | I promise to RTFM after I get the dang thing ;-) > | > | Cheers > | > | Bryan Stevenson B.Comm. > | VP & Director of E-Commerce Development > | Electric Edge Systems Group Inc. > | t. 250.920.8830 > | e. [EMAIL PROTECTED] > | > | - > | Macromedia Associate Partner > | www.macromedia.com > | - > | Vancouver Island ColdFusion Users Group > | Founder & Director > | www.cfug-vancouverisland.com > | - Original Message - > | From: "Matt Liotta" <[EMAIL PROTECTED]> > | To: "CF-Talk" <[EMAIL PROTECTED]> > | Sent: Wednesday, September 17, 2003 12:14 PM > | Subject: Re: OT: Linux Newbie Advice > | > | > | > > So can I simply install Linux over Windows (i.e. from boot up)? or do > | > > I have > | > > to wipe the drive first (FDisk)? > | > > > | > Yes, you can simply install Linux over Windows assuming you don't want > | > access to any of the data on the hard drive. > | > > | > > What do you Linux folks recommend for a Linux package to install (i.e. > | > > RedHat version...Mandrake etc.)? Bear in mind I know very little about > | > > Linux and I don't want to play the command line game. So a package > | > > that has > | > > a decent GUI would be nice (I've seen and played a bit with X > | > > Windows...seemed nice...but what do I know...hehe). > | > > > | > I always recommend RedHat to people since it is the most widely used > | > distribution and thus it is easier to get help from others with. After > | > you become more familiar with Linux in general then you can start > | > worrying about why you would choose one distribution over the others. > | > > | > Matt Liotta > | > President & CEO > | > Montara Software, Inc. > | > http://www.MontaraSoftware.com > | > (888) 408-0900 x901 > | > > | > > | > > | > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137364 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: advice
OK, well past time for this thread to head over to CF-Community. Thanks ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137363 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: advice
Okay guys -- this thread has gone on long enough. Time to kill it, please. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:44 AM To: CF-Talk Subject: Re: advice "Bruce, Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > That is why I did specify American Pizza ;o) > Yes, but using the word pizza for "that thing" should be illegal :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137362 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
RedHat 9.0 is in wide use and is supported by CFMX 6.1 Purchasing the package for about $39.00 at Best Buy will give you free support and updates (which seem to come about as often as the ones from Microsoft.) When doing the install, be sure to install KDE desktop if you are wanting a GUI to work with. Or if you are wanting to maintain it remotely, install Webmin. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 2:23 PM Subject: Re: OT: Linux Newbie Advice | Thanks Matt | | So what's the current RedHat version that is stable? where can I grab a | copy? | | Is it installed from a floppy/CD at boot up? | | I promise to RTFM after I get the dang thing ;-) | | Cheers | | Bryan Stevenson B.Comm. | VP & Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder & Director | www.cfug-vancouverisland.com | - Original Message - | From: "Matt Liotta" <[EMAIL PROTECTED]> | To: "CF-Talk" <[EMAIL PROTECTED]> | Sent: Wednesday, September 17, 2003 12:14 PM | Subject: Re: OT: Linux Newbie Advice | | | > > So can I simply install Linux over Windows (i.e. from boot up)? or do | > > I have | > > to wipe the drive first (FDisk)? | > > | > Yes, you can simply install Linux over Windows assuming you don't want | > access to any of the data on the hard drive. | > | > > What do you Linux folks recommend for a Linux package to install (i.e. | > > RedHat version...Mandrake etc.)? Bear in mind I know very little about | > > Linux and I don't want to play the command line game. So a package | > > that has | > > a decent GUI would be nice (I've seen and played a bit with X | > > Windows...seemed nice...but what do I know...hehe). | > > | > I always recommend RedHat to people since it is the most widely used | > distribution and thus it is easier to get help from others with. After | > you become more familiar with Linux in general then you can start | > worrying about why you would choose one distribution over the others. | > | > Matt Liotta | > President & CEO | > Montara Software, Inc. | > http://www.MontaraSoftware.com | > (888) 408-0900 x901 | > | > | > | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137361 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: SSL / Flash Remoting / CFMX
I've got a site running using SSL/remoting/CFMX, no problems.. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:30 AM To: CF-Talk Subject: SSL / Flash Remoting / CFMX Any issues here? Has anyone done this yet? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137360 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
> > So what's the current RedHat version that is stable? where can I grab a > > copy? > > >I am currently sticking with RedHat 7.x myself. You could download the >ISOs directly from RedHat's FTP and just burn them to CD if you want. >You can also buy directly from RedHat, which has the advantage of free >technical support. > Just to take Matt's 7.x endorsement one step further, if you plan to use CF on this machine, you will need to have RedHat 7.2 (or earlier) to use Verity because of the Verity binary version restrictions. While CFMX 6.1 officially supports later versions of RedHat, Verity is not. Regards, Dave. _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137359 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Using data from HTTP post
> My problem is I don't know how to use their data. I've worked with http > post/variables, but never with raw data. If someone has any idea how to > start me off in the right direction, I'd greatly appreciate it. > One trick you might be interested in is turning that data into XML so it is easily used from CF. http://archive.devx.com/java/free/articles/ml040802/ml040802-1.asp is an article I wrote on how to do this with CSV files. > I was thinking I could build a struct or array with this, splitting > lines with / & line breaks, and determining item[x] of each line by the > spaces. I just don't know how to get at the data to manipulate it since > its not being passed as a named variable (like a form). > You would use GetHTTPRequestData(), which returns a struct containing everything --including RAW request data-- from the request. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137358 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: advice
Kris, No, not France! Anywhere but France. :-) Also, don't go getting yourself one of those Mad-Cow burgers over there. Stick with pork in Europe (they don't have trichinosis [sp?] over there so you can eat it medium-rare). On the pizza thing, any of you Euro-pizza-purists ever had Chicago style? Try it before you condemn American pizza. Greg -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:17 AM To: CF-Talk Subject: RE: advice So the beef in europe is not as good in US huh? I am going for final semester of my MBA so I will fo in Feb tehn graduate in france on july 8th -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM To: CF-Talk Subject: RE: advice Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 14:46 > To: CF-Talk > Subject: advice > > > Anyone on the list ever study/work /been overseas Trying to make a > decsion about finishing my MBA overseas and wanted to speak to someone > who has done it > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137357 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
> So what's the current RedHat version that is stable? where can I grab a > copy? > I am currently sticking with RedHat 7.x myself. You could download the ISOs directly from RedHat's FTP and just burn them to CD if you want. You can also buy directly from RedHat, which has the advantage of free technical support. > Is it installed from a floppy/CD at boot up? > Most of the current distributions boot up from CDs. Further, they tend to provide floppy images on the CD in case you need to create a floppy for machines that can't boot from CD. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137356 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Using data from HTTP post
Hello all, A site I am working on is going to feature some live data feeds from a 3rd party. The third party has their system setup to send data via http post, and they want a url to send to. My problem is I don't know how to use their data. I've worked with http post/variables, but never with raw data. If someone has any idea how to start me off in the right direction, I'd greatly appreciate it. The data sample provided: 1 #CSXTSWSAM010309120845/ 2 CLMDFR CSXT DJJOSE03091208DJC 3 ACFX 11 BERKELEY SC 09 12 0641 L W TOLEDOOH 4 ACRX 11 CASHAYNE NC 09 11 1339 E W BERKELEY SC 5 BNSF 11 CUMBERLAN MD 09 12 0730 L A Q14811 BALTIMORE MD 6 CSXT 11 THOMASVIL GA 09 12 0745 L A Q54511 BERKELEY SC 7 CSXT 11 CALERAAL 09 11 2230 L P Q68111 BERKELEY SC 8 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 9 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 10 CSXT 11 THOMASVIL GA 09 12 0745 L A Q54511 BERKELEY SC 11 CSXT 11 WAYCROSS GA 09 12 0820 L A Q68110 BERKELEY SC 12 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 13 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 14 CSXT 11 CALERAAL 09 11 2230 L P Q68111 BERKELEY SC 15 CSXT 11 WAYCROSS GA 09 12 0820 L A Q68110 BERKELEY SC I was thinking I could build a struct or array with this, splitting lines with / & line breaks, and determining item[x] of each line by the spaces. I just don't know how to get at the data to manipulate it since its not being passed as a named variable (like a form). Thanks in advance, Chris ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137355 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
Bryan, As a Linux Newbie, I'd recommend you look at Mandrake for this first toe in the water. Mandrake is very friendly to noobs, and you'll be able to get up and running in no time. RedHat is better known, and their installer gets better and better with each iteration, but I think Mandrake will be a little more forgiving :) Not to knock RedHat, though. I've had version 8 running on an old Compaq Presario minitower for a year with no reboots, except for when I moved and had to power down for a few days. - Jim Bryan Stevenson wrote: >Thanks Matt > >So what's the current RedHat version that is stable? where can I grab a >copy? > >Is it installed from a floppy/CD at boot up? > >I promise to RTFM after I get the dang thing ;-) > >Cheers > >Bryan Stevenson B.Comm. >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >t. 250.920.8830 >e. [EMAIL PROTECTED] > >- >Macromedia Associate Partner >www.macromedia.com >- >Vancouver Island ColdFusion Users Group >Founder & Director >www.cfug-vancouverisland.com >- Original Message - >From: "Matt Liotta" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, September 17, 2003 12:14 PM >Subject: Re: OT: Linux Newbie Advice > > > > >>>So can I simply install Linux over Windows (i.e. from boot up)? or do >>>I have >>>to wipe the drive first (FDisk)? >>> >>> >>> >>Yes, you can simply install Linux over Windows assuming you don't want >>access to any of the data on the hard drive. >> >> >> >>>What do you Linux folks recommend for a Linux package to install (i.e. >>>RedHat version...Mandrake etc.)? Bear in mind I know very little about >>>Linux and I don't want to play the command line game. So a package >>>that has >>>a decent GUI would be nice (I've seen and played a bit with X >>>Windows...seemed nice...but what do I know...hehe). >>> >>> >>> >>I always recommend RedHat to people since it is the most widely used >>distribution and thus it is easier to get help from others with. After >>you become more familiar with Linux in general then you can start >>worrying about why you would choose one distribution over the others. >> >>Matt Liotta >>President & CEO >>Montara Software, Inc. >>http://www.MontaraSoftware.com >>(888) 408-0900 x901 >> >> >> >> >> > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137354 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Linux Newbie Advice
hippy stuff? LOL! I guess a proper introduction to this would be RTFM! Ha! Yeah, you should be able to grab redhat, mandrake, etc and install right over your windows install. The installers usually run a proggy to partition/format your drive and all. What flavour to use? Try them all and settle on the one you like. Redhat is fairly popular, a good start probably. I've been a Slackware fan myself, but that's real old skool hippy like I suppose. http://linuxiso.org for all of them. Have fun! Doug >-Original Message- >From: Bryan Stevenson [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2003 3:09 PM >To: CF-Talk >Subject: OT: Linux Newbie Advice > > >Hey All, > >OK...so I'm going to give this open source hippie stuff a whirl ;-) > >I have an old AMD K6-2 400 MHz box with Win2K Pro currently installed > >One big issue is the passwords for this box have been lost. > >So can I simply install Linux over Windows (i.e. from boot >up)? or do I have >to wipe the drive first (FDisk)? > >What do you Linux folks recommend for a Linux package to install (i.e. >RedHat version...Mandrake etc.)? Bear in mind I know very little about >Linux and I don't want to play the command line game. So a >package that has >a decent GUI would be nice (I've seen and played a bit with X >Windows...seemed nice...but what do I know...hehe). > >So at this point...any and all advice is welcome (and feel >free to send me >info offlist). > >TIA > >Cheers > >Bryan Stevenson B.Comm. >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >t. 250.920.8830 >e. [EMAIL PROTECTED] > >- >Macromedia Associate Partner >www.macromedia.com >- >Vancouver Island ColdFusion Users Group >Founder & Director >www.cfug-vancouverisland.com > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137352 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
Thanks Matt So what's the current RedHat version that is stable? where can I grab a copy? Is it installed from a floppy/CD at boot up? I promise to RTFM after I get the dang thing ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 12:14 PM Subject: Re: OT: Linux Newbie Advice > > So can I simply install Linux over Windows (i.e. from boot up)? or do > > I have > > to wipe the drive first (FDisk)? > > > Yes, you can simply install Linux over Windows assuming you don't want > access to any of the data on the hard drive. > > > What do you Linux folks recommend for a Linux package to install (i.e. > > RedHat version...Mandrake etc.)? Bear in mind I know very little about > > Linux and I don't want to play the command line game. So a package > > that has > > a decent GUI would be nice (I've seen and played a bit with X > > Windows...seemed nice...but what do I know...hehe). > > > I always recommend RedHat to people since it is the most widely used > distribution and thus it is easier to get help from others with. After > you become more familiar with Linux in general then you can start > worrying about why you would choose one distribution over the others. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.MontaraSoftware.com > (888) 408-0900 x901 > > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137353 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: Linux Newbie Advice
> So can I simply install Linux over Windows (i.e. from boot up)? or do > I have > to wipe the drive first (FDisk)? > Yes, you can simply install Linux over Windows assuming you don't want access to any of the data on the hard drive. > What do you Linux folks recommend for a Linux package to install (i.e. > RedHat version...Mandrake etc.)? Bear in mind I know very little about > Linux and I don't want to play the command line game. So a package > that has > a decent GUI would be nice (I've seen and played a bit with X > Windows...seemed nice...but what do I know...hehe). > I always recommend RedHat to people since it is the most widely used distribution and thus it is easier to get help from others with. After you become more familiar with Linux in general then you can start worrying about why you would choose one distribution over the others. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137351 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
OT: Linux Newbie Advice
Hey All, OK...so I'm going to give this open source hippie stuff a whirl ;-) I have an old AMD K6-2 400 MHz box with Win2K Pro currently installed One big issue is the passwords for this box have been lost. So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). So at this point...any and all advice is welcome (and feel free to send me info offlist). TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137350 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
cfcookie and browser back button - causes page refresh - help?
Hi y'all I have a new issue that has me stumped. Maybe if i talk it out, someone will know the answer. I have a CFMX include (tho the same thing probably happens in a CF5 environment tho i haven't gone back and tested it) that i'm using to create a popcorn trail at the top of all the pages in my site. We opted to use cookies to do this (yes, there are a million other ways)... and i've recently discovered this is causing a problem. There is something in the code shown at the bottom of this note that is causing my problem. If I leave the code uncommented, the code executes and cookies are properly created -- yet if i use the browser back key on any page, the previous page (which also executes the same code) re-executes - even tho the traditional back button action is to just display the page as it was. The real problem occurs when the previous page was a form - the refresh forces all of the user entered data to be lost and I don't want that to happen! If I comment out the code, everything works ok (tho the popcorn trail obviously isn't created) - but the back button in the browser does NOT cause the page to refresh automatically. Does anyone know WHY this code would cause the browser to force a page refresh in both IE5.5 and NS 4.73?? (Stuck there due to work requirements - can't go to newer browsers - sorry I can't share a link with the group - 'tiz inside a firewall) Here's the code that seems to be the problem: cfif get_page.menuLevel eq 1> not level 1 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137349 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
Oh you would love it Massimo, one of the major national pizza chains is running a promotion on a new "pizza concoction". They call it the Philly Cheese Steak pizza! :-) -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:21 AM To: CF-Talk Subject: Re: advice > Would recommend it to anyone that can live on food other than American > Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137348 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: advice
"Bruce, Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > That is why I did specify American Pizza ;o) > Yes, but using the word pizza for "that thing" should be illegal :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137347 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: integrating Cybersource credit-card processing
> I'm working on integrating creditcard processing from Cybersource. I
> work in a mixed environment of Linux and Windows so we're planning on
> using the Java web services interface. I've managed to get their
> demonstration web service clients working on the command line, but I'm
> having trouble with using CFINVOKE to consume their webservice.
>
> I've gotten closest with the NVP (name/value pairs) interface to the
> web service -- I get something like this:
> Web service operation "runTransaction" with parameters
> {INPUT={{MERCHANTID={myId},}},} could not be found.
>
> The XML interface just dies. Anyone done this successfully?
>
I successfully used their Java API.
Matt Liotta
President & CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137346
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
integrating Cybersource credit-card processing
Folks,
I'm working on integrating creditcard processing from Cybersource. I work in a mixed
environment of Linux and Windows so we're planning on using the Java web services
interface. I've managed to get their demonstration web service clients working on the
command line, but I'm having trouble with using CFINVOKE to consume their webservice.
I've gotten closest with the NVP (name/value pairs) interface to the web service -- I
get something like this:
Web service operation "runTransaction" with parameters
{INPUT={{MERCHANTID={myId},}},} could not be found.
The XML interface just dies. Anyone done this successfully?
Regards,
John Paul Ashenfelter
CTO/Transitionpoint
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137344
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
SSL / Flash Remoting / CFMX
Any issues here? Has anyone done this yet? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137345 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
That is why I did specify American Pizza ;o) and the beef is just different not better or worse just different -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:21 AM To: CF-Talk Subject: Re: advice > Would recommend it to anyone that can live on food other than American > Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137343 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
OT: N/N Group Conference
Is anyone going to the Nielson Norman Group User Experience Conference next week? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137342 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
CFMX 6.1 and JRun 4
We have had CFMX and JRun 4 coexisting peacefully on a W2K server for months, blissfully ignorant of each other. Last week we upgraded CF to 6.1 and now it appears that JRun is interfering with CF somehow. CF was grinding to a halt on a regular basis until we disabled the services for the JRun servers. Does anyone know anything about this? Thanks Nick ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137341 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: advice
Puuuhhhlze! We've added so much to the genre. Go to any of the major american cities (or at least the ones I've lived in) and you'll find pizza thats pretty close to what you find in italy. And it only starts there. Theres so many other wonderful kinds of pizzas that you'll only find in america. DRE > -Original Message- > From: Massimo Foti [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 10:21 AM > To: CF-Talk > Subject: Re: advice > > > > Would recommend it to anyone that can live on food other > than American > > Pizza and Cheeseburgers ;o) > > Let's be real, what you have there in the USA really > shouldn't be called pizza... It's really very far away from > the *real* thing... > > I am sorry to sound pedandic, but pizza is clearly the most > important contribution to modern civilization coming from > Italy and definitely deserve a better treatment :-))) > > Massimo > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137340 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Having problem comparing variables and returning the correct results
Hi, I'm having a problem displaying some directories. Below are two sample variables which I get from my database. These are inserted into the database from another template that has checkboxes and then once submitted the database gets re-populated. That is not my problem though. It's displaying the directory tree. There are other variables in my sample which I haven't supplied code for because the problem I think is just in my #indent# #SESSION.stDirFileName[i]# ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137339 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
