RE: MySQL Conversion

2011-04-20 Thread Zac Wingfield

 then remember that MSSQL Express is also FREE

limited to 4GB in size.



if you definitely want to end up with MySQL then it would be easier to
use the built in wizard to upsize from MSAccess to MSSQL then (if you
still want to) ... convert from MSSQL to MySQL

i would bother trying to use the MySQL Migration Tool Kit. ive never had
much luck with this.

I've converted many DBs from MS to My. So many that i bought some third
party software to do it for me. takes about 30 seconds. Let me know if i
can help out.

zac

Regards,

Zac Wingfield
Operations Manager

For and on behalf of,

Allied Facilities.com Limited
01903 723999


7 Wickham Business Centre
Harwood Road
Littlehampton
West Sussex
BN17 7AU

For more information about Allied please visit: http://www.allied-facilities.com

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: 20 April 2011 11:20
To: cf-talk
Subject: Re: MySQL Conversion


You would probably find it easier to upgrade to MSSQL, which is better
anyway in so many ways than MySQL esp if you are on windows (speed,
performance, reliability, scheduled backups, automated maintenance, no
table
corrupting issues, no horrid SQL dumps to name a few). Presumably if
your
using Access you must be on a windows host, so MSSQL is probably
available
to you. If you are choosing MySQL only because it is free, as many do,
then
remember that MSSQL Express is also FREE.

You have an upgrade tool built in to MSACCESS, and Microsoft also
provide
free migration tools as well.

just something to consider.

On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev
azadi.sar...@gmail.comwrote:


 how are you migrating your db?

 mysql used to have a migration toolkit as part of mysql gui tools
bundle
 which handled access-mysql migration very well.
 the gui tools have now been replaced by mysql workbench, but you can
 still download them from mysql website.
 gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html
 workbench: http://dev.mysql.com/downloads/workbench/5.2.html

 mysql equivalent of access's autonumber type is an Integer column with
 auto_increment attribute.
 http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of
 page for auto_increment attr info)
 you can also set/change the next auto_increment value to use on mysql
 column: ALTER TABLE t2 AUTO_INCREMENT = value (from
 http://dev.mysql.com/doc/refman/5.5/en/alter-table.html)

 all this and much much more is covered in mysql reference manual on
 mysql website: http://dev.mysql.com/doc/

 another point to keep in mind: if you cfqueries used any
access-specific
 syntax you will have to re-write them to use proper sql to work with
 mysql db.

 Azadi

 On 20/04/2011 13:46 , Scott Williams wrote:
  Oy -- I shouldn't have started this one until the weekend.
 
  I'm converting from MS Access to MySQL on one of my ColdFusion
sites, and
 having problems converting my Autonumbered Access tables to MySQL
format.
 They just won't import at all. If I remove the primary key and change
the
 format to Integer instead of Autonumber, the tables import.
 
  The real problem is when I try to add data to these tables later. It
will
 take one additional record (numbering it 0), then won't take anymore
because
 then there would be two 0s.
 
  How can I get a MySQL table to autonumber like Access?
 
  Scott
 
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Good CF Host in Texas

2011-04-15 Thread Zac Wingfield

try gowestweb.com

over your way somewhere, not exactly sure where though
Regards,

Zac Wingfield
Operations Manager

For and on behalf of,

Allied Facilities.com Limited
01903 723999


7 Wickham Business Centre
Harwood Road
Littlehampton
West Sussex
BN17 7AU

For more information about Allied please visit: http://www.allied-facilities.com

-Original Message-
From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] 
Sent: 15 April 2011 11:11
To: cf-talk
Subject: RE: Good CF Host in Texas


Do NOT use Vortech.  A Texas based hosting company that gives awful
service.

-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: 15 April 2011 06:06
To: cf-talk
Subject: Good CF Host in Texas



Client is requesting that hosting *has* to be in Texas. I've NO idea
why. But - anybody familiar with good reliable, CF hosting in Texas with
*helpful* 24/7 tech support?

Most of my stuff is either at hosting.com or CrystalTech, niether in
Texas

TIA





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343744
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Good CF Host in Texas

2011-04-15 Thread Zac Wingfield

yes sorry everyone. i was thinking of gowestwebdesign.com which is the
same company.

isn't Utah just up the road from Texas? :-)


Regards,

Zac Wingfield
Operations Manager

For and on behalf of,

Allied Facilities.com Limited
01903 723999


7 Wickham Business Centre
Harwood Road
Littlehampton
West Sussex
BN17 7AU

For more information about Allied please visit: http://www.allied-facilities.com

-Original Message-
From: Peter Donahue [mailto:pdonah...@satx.rr.com] 
Sent: 15 April 2011 14:57
To: cf-talk
Subject: Re: Good CF Host in Texas


Good morning everyone,

If you mean www.GoWest.com they're in Utah not Texas.

Peter Donahue


- Original Message - 
From: Zac Wingfield z...@allied-facilities.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Friday, April 15, 2011 5:25 AM
Subject: RE: Good CF Host in Texas



try gowestweb.com

over your way somewhere, not exactly sure where though
Regards,

Zac Wingfield
Operations Manager

For and on behalf of,

Allied Facilities.com Limited
01903 723999


7 Wickham Business Centre
Harwood Road
Littlehampton
West Sussex
BN17 7AU

For more information about Allied please visit: 
http://www.allied-facilities.com

-Original Message-
From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk]
Sent: 15 April 2011 11:11
To: cf-talk
Subject: RE: Good CF Host in Texas


Do NOT use Vortech.  A Texas based hosting company that gives awful
service.

-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: 15 April 2011 06:06
To: cf-talk
Subject: Good CF Host in Texas



Client is requesting that hosting *has* to be in Texas. I've NO idea
why. But - anybody familiar with good reliable, CF hosting in Texas with
*helpful* 24/7 tech support?

Most of my stuff is either at hosting.com or CrystalTech, niether in
Texas

TIA









~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343746
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFM Generators

2011-03-30 Thread zac wingfield

I just picked this up from another post but i thought it deserves it's own 
thread.

http://www.sebgen.com

this is brilliant! ive never come across anything like this before. Also there 
are full apps on there. Many thanks Steve Bryant :-)

If anyone else knows of similar sites please do post some links.

thanks
zac


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343406
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFM Generators

2011-03-30 Thread zac wingfield

Cool, book marked, thanks again
zac


  If anyone else knows of similar sites please do post some links.
 
 Zac,
 
 Thanks for the kind words. The best place to look for these sorts of 
 things is Charlie Arehart's brilliant CF411. I see that I haven't 
 asked Charlie to list my generator yet, so I will try to do that soon.
 
 
 Here is the category for CFML Code Generators:
 http://www.carehart.org/cf411/#cfmlgen
 
 He has lots of other useful categories as well. I visit it frequently, 
 and I am always surprised at the wealth of information contained 
 within.
 
 Steve 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343418
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Open source ColdFusion forums

2011-03-28 Thread zac wingfield

what i'd really really really like to see is a fully blown cfml hosting control 
panel.

so not just a control panel that integrates with CF but a control panel that is 
built on CF. probably built around Railo if you were to go the open source 
route.

the hosting control panel would handle everything from resource allocation to 
billing to auto account creation and even domain registration.

fancy biting that one off? :-)

zac

P.S. lots of individual packages already exisit that could be brought together 
to make this happen.

FileZilla for FTP
LightHouse Pro for bug tracking and support
CF-works for billing
you get the idea... the list goes on

Hi everyone, I've recently taken a new job that has opened up some
free time for me, and I'm considering a project I'd thought about long
ago but never had time to implement.  I'm curious if there is any
interest in the development of an open source, ColdFusion-based forum
application.  The goal would be something comparable to vBulletin or
PHPBB done in ColdFusion, done in open source style, completely free.

It would seem that Ray's Galleon forums project is still alive and
well, so with one open source forum application out in the wild I'm
unsure if there is really need for another.  So first, I want to be
sure there would be interest in such a project; would the community
welcome a second open source forum application in ColdFusion?  Would
anyone use it?  Is there really a need for one?  Is there some other
category of software that I could invest time into that would be
better served?

I've been writing ColdFusion for over a decade, like many of you, and
am interested in contributing back to the community.  I welcome any
thoughts or feedback you might have.


-Justin Scott 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: social networking app in CF

2011-03-25 Thread zac wingfield

Hey, thats brilliant!

are you sharing it? perhaps post it on riaforge 
http://www.riaforge.org/index.cfm?event=page.categoryid=1

nice work! 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343296
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


who's in charge around here?

2011-03-22 Thread zac wingfield

having just recently found H.O.F ive used it a few times. there are some really 
helpful, knowledgeable guys monitoring these lists and I’ve received some 
great help from the CF Newbie list.

however the web site needs some attention. it's slow to respond and poorly 
presented.

why are all the adverts over on the right hand side? they take up a whole 
quarter of the page.

why must we be subscribed to each list before we can post?

when viewing a thread sometime it's all displayed, other times i have to 
refresh the page, cant quite work it out.

considering how much experience there is floating around here i guess i just 
expected it to be a little bit better put together.

I know communities like this are normally built up from people either donating 
their time or cash so, if it's needed, I’d like to volunteer hosting 
services. I'll have a new server online within a couple of weeks. let me know 
if you're interested.

Z


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343190
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: who's in charge around here?

2011-03-22 Thread zac wingfield

Perhaps you'd better enjoy the mailing list vs. the web interface?

yes good point. i try not to respond directly via email because of my email 
header/footer. I use my work email address for everything which is unrelated to 
any web dev work that i do.

I work for MI5 so i wouldn’t want people to find out :-), oops!

Are you volunteering to help MD with a new design?

yes i'd love to be involved. not sure i'd like sole responsibility though as i 
am still a bit of a newbie

anyone else willing to put their name on a list?

z

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343194
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: who's in charge around here?

2011-03-22 Thread zac wingfield

ok, i'm getting idea about using it as a mailing list. :-) 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343212
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: WYSIWYG inline editor on mac browsers

2003-10-08 Thread Zac
On Wednesday, October 8, 2003, at 06:01PM, Peter Tilbrook wrote:

 Perhaps the open source FCK Editor? (http://www.fredck.com/FCKeditor/)

 From their webpage

Requirements
Client Side:
Internet Explorer 5+ over Windows with _javascript_ enabled (for rich 
text editing)

I think that it only works on IE/Windows as it didn't work on any of 
the browsers on my Mac.

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




Access database 401 error

2003-10-07 Thread Zac Belado
We are running into an unreproducible error when trying to connect to an Access database using CF 5.

Our system has a series of scheduled events and in some cases our clients are reporting a 401 Unauthorised error when the scheduled event tries to connect to an Access database.

The database connection is stored as a verified ODBC connection in the CF Administrator.

Has anyone seen this error before?

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




Re:Access database 401 error

2003-10-07 Thread Zac Belado
This error isn't related to the database connection.A 401 means that 
your web server has the requested URL protected and the client (in 
this case, the ColdFusion scheduler) is being rejected by the web 
server.The ColdFusion scheduler connects to the server as an HTTP 
client (so, it looks like a browser to the web server).You can enter 
a user name and password into the scheduled event so that the HTTP 
request will include a login.

I tried to verify this with the client already (it was my first idea) and (according to them) they have set up the directory so that IIS has access to it and permission to access the directory.

I'll double-check this with them to make doubly sure that this isn't the case

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




Copying session vars to request scope

2003-10-07 Thread Zac Belado
Can anyone see any reason why you wouldn't want to copy session scope variables to a request scope variable if all you want to do is to test the values in them but not set them?

It strikes me that this would be more efficient than locking the session scope each time you wanted to test the variables.

But then again I might be missing something really obvious :-)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Copying session vars to request scope

2003-10-07 Thread Zac
On Tuesday, October 7, 2003, at 06:02PM, Dave Watts:

 In my experience, this has occasionally caused severe performance
 degradation, so you'll want to be very careful when doing this. In 
 general,
 I'd try to avoid doing it at all.

Really?That is quite surprising.

So is it the duplication of the struct that is causing the performance 
hit?

 As others have mentioned, this often isn't necessary with CFMX.

I'm just starting to write some code for MX and this is one of the 
things I am trying to be very careful of

 Finally, you should be very careful when attempting to apply common 
 sense to
 expected performance outcomes.

Or anything associated with application development in general :-)

Thanks to everyone for the links and comments

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




Re: XML Serialisation

2003-08-19 Thread zac spitzer
Neil Middleton wrote:

Guys,

I'm after a tag or function which can convert a complex cf data type into an
xml packet.  I've seen the ones on CFlib that convery queries and structs
but I'm after one which can do combinations of datatypes all in one go and
return a valid xml packet.

I would use WDDX but I'd like XML as opposed to WDDX and I would also like
the node names to match the object names within the cf data object.

Am I asking too much or is there one out theresomewhere?

sounds like you want to re-invent the wheel... everything you describe 
here about wanting over normal xml is provided by wddx WDDX is a 
xml as for node names it's more complex in xml than plain old cf 
structures... wddx rocks and it just plain works and is widely supported 
outside cf

z

~|
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: mx tag help/insight for studio 5

2003-08-19 Thread zac spitzer
Massimo Foti wrote:

I have CF Studio 5 and am just starting to code for MX a bit.  Is there
anyway I can get tag insight and help files for the new MX stuff such as
cfc's?  I looked around on the macromedia site a bit but couldn't find
anything.



The files for Homesite+ should work just fine for CF Studio as well:

http://www.macromedia.com/software/coldfusion/downloads/

there are two files here, homesitetags.zip and homesiteextensions..zip

there is under homesiteextensions an empty tagDefs tree but no VTM's

homesitetags contains vtm's for pre MX tags presumably updated... but 
there's no cfcomponent.vtm for example

so still no joy

z


~|
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: packet sniffer

2003-08-18 Thread zac spitzer
Michael T. Tangorre wrote:

I am in the hunt for a tool that will allow me see the http traffic to and from ym 
machine. I am trying to debug an application that makes http posts to some servers 
and need to see what im sending and receiving.

I have ethereal now, are there any alternatives (free if possible).

try mozilla with http://livehttpheaders.mozdev.org .. it really rocks

or http://www.proxomitron.info/files/index.shtml which is a filtering 
proxyserver, which is cool anyway,
but it has a log window where you can also see all the http requests live

zac

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


Cold Fusion Studio 5 CFMX tag updater?

2003-08-14 Thread zac spitzer
is there a tag updater for cf studio 5.0 which contains CFMX tags, the 
only one i find on the MM site is

http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/tag_updaters/

and it doesn't contain anything except vtms for cf 5.0 era tags

z

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



Mach II 1.0 released

2003-08-14 Thread zac spitzer
Mach II has been released

http://www.mach-ii.com

with three sample apps, roulette, contactmanager and shopping cart

redsky required

being australian, I am thinking this is more of the usual aussie jvm 
date problems
as i'm hitting a date problem on the parsing of the xml config file..

anyone got any pointers?

z

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: Mach II 1.0 released

2003-08-14 Thread zac spitzer
zac spitzer wrote:

Mach II has been released

http://www.mach-ii.com

with three sample apps, roulette, contactmanager and shopping cart

redsky required

being australian, I am thinking this is more of the usual aussie jvm 
date problems
as i'm hitting a date problem on the parsing of the xml config file..

anyone got any pointers?

ok, it's fixable with a lsparsedatetime on the

MachII\framework\AppLoader.cfc
shouldReloadConfig
cfset lastConfigDate = configFile.dateLastModified/  
 becomes
cfset lastConfigDate = 
LSParseDateTime(configFile.dateLastModified)/

now I'm on a (shudder) old win98 box here so maybe it will work 
different on w2k etc,
but having CFDIRECTORY return non-parsable dates for datelastmodified is 
REALLY dumb MM!

Zac



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

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



Re: CF tag for highlighting text in a textfield?

2003-08-01 Thread zac spitzer
Jerry Johnson wrote:

I don't think you can highlight in a textarea.


you can do this actually... you can also move the cursor in a text field 
or select part of it...

here's a good start .. mozilla is way ahead on the easiness too.. ie is 
a bit more difficult

FAQTs - Knowledge Base - View Entry - How can I manipulate the selection 
and the caret in an input type=text element in NN6 and IE?

http://www.faqts.com/knowledge_base/view.phtml/aid/13562/fid/130

what makes text areas more difficult is they aren't treated like a 
string if i remember right, they r access more by rows and columns

zac


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: Page Context Bug?

2003-08-01 Thread zac spitzer
Matt Liotta wrote:

It does make it difficult to write efficient frameworks using CFCs
tho' so, for example, Mach II will require Red Sky to run efficiently.



I'm glad you finally admitted that.

so matt, you said a while back it was impossible to write mvc frameworks 
in cfmx,
with the advent of redsky, has this changed in your opinion?

z


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

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



Re: MachII Speed (was RE: Mach II)

2003-07-16 Thread zac spitzer
Haggerty, Mike wrote:

1) Speed. Each page took  700 ms to generate with debugging off. This was
using a slow server: Apache / XP / RedSky / Celeron 733 with 512 MB RAM.
However, FB3 pages doing just about the same amount of work average ~100 ms
on the same server.

coz of the page context bug, mach-ii currently recreates itself on each 
request

you have redsky, so it should work, try commenting out line 19 in
framework/requesthandler.cfc

cfset application.appManager =  /

z


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: cf5 - ColdFusion Graphing Server = JRun??

2003-06-06 Thread Zac Spitzer


Any other suggestions?

  

I'm running cf5 on my laptop and I noticed that the graphing
server is JRun.exe.

So does this mean that I can use it as a jsp container?

guys, i am prettys ure this is a runtime limited use version of jrun 
license wise, you can't use it legally for anything else than generator 
(or graphing server)

z


-- 
zac spitzer - mailto:[EMAIL PROTECTED]
http://fraggle.datagear.net/
radio://+61 405 847 168 / fixed://+61 3 9528 6775 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



Re: New to Java and MX

2003-03-05 Thread Zac Spitzer
 I've tried this (mind you I am totally lost)
 
 cfobject type=JAVA action=Create name=myFtp class=Ftp
 cfset ret = myFtp.init()
 cfset ret2 = myFtp.main('ftp.server.org')
 
 
 The first two lines seem accepted fine, but when I add the third, it starts throwing 
 errors.
 Any help would be appreciated.

what's the errors being thrown?

z

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

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



Re: all records deleted from table

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Kay Smoljak wrote:
| A long time ago, I made a really stupid mistake that results in
| deletion of all data from a table...
|
|
| A tip I picked up from somewhere - it might even have been this list
| - is to not ever actually delete records using code. Instead, I have
| a dtDeleted field, which is set to the current date when I want to
| delete the record. When doing selects, I add WHERE dtDeleted IS
| NULL to get only non-deleted records.
|

good idea, badly implemented. a select using a null criteria cannot
use a index and means the database must do a full table scan which means
~ bad performancetry changing your logic round so you can use an
index...

z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+QSAM1lRHdy8ASusRAnb4AJoDt66u5fWbgibWEoFPmqmMu5AElwCeMmsK
pSKubEkErq+ymszYSb/7QRo=
=lz66
-END PGP SIGNATURE-

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

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




Re: all records deleted from table

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jochem van Dieten wrote:
| Zac Spitzer wrote:
|
|Kay Smoljak wrote:
||
|| A tip I picked up from somewhere - it might even have been this list
|| - is to not ever actually delete records using code. Instead, I have
|| a dtDeleted field, which is set to the current date when I want to
|| delete the record. When doing selects, I add WHERE dtDeleted IS
|| NULL to get only non-deleted records.
||
|
|good idea, badly implemented. a select using a null criteria cannot
|use a index and means the database must do a full table scan which means
|~ bad performancetry changing your logic round so you can use an
|index...
|
|
| That is just a limitation of your specific dbms. Others can use much
| fancier indexing schemes. (If your database supports it, look into
| partial indexes for this type of problem.)

interesting i think oracle (at least in the 8i world)  ms-sql don't
support it, which dbms *DO* support it?

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+QSql1lRHdy8ASusRAtArAJwLPMHtUOvCWV9KR5Ronyoi9NljbQCgqla/
LwScJAm+7C2MZthJd2ZhqCA=
=y9Ph
-END PGP SIGNATURE-

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

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




Re: Replication - Mirroring Software for Linux?

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mike Brunt wrote:
| We are about to add a new production environment that will be CFMX on
Linux.
| Can anyone recommend good replication software for Linux as this will be a
| clustered environment.

rsync would be a good starting point

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+QTXk1lRHdy8ASusRAo7xAJ9KzZYoeyS1vVIOJ0Xanc2PJVJ2lwCfQ6s5
Kq2pxQBttF21IqS1N6X+HlI=
=OR3t
-END PGP SIGNATURE-

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

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




Re: sql 2000 vs sql 2000 enterprise

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Tony Weeg wrote:
| can someone explain to me, very high level, what the difference is
| between
|
| sql server 2000 Standard Edition
| sql server 2000 Enterprise Edition
|
| we have 2000 ent edition on our servers now, however we are about to
| configure 2 new ones, and my software ordering guys, got us standard
| edition instead of what we already have, which is enterprise edition.
|
| thank you
|
| ...tony

http://www.microsoft.com/sql/evaluation/features/choosing.asp

for an overview chart

or Choosing an Edition of SQL Server 2000

http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp

is a good start i think standard is limited to four processors and
enterprise is expensive


i just noticed that a passiv or backup standby server requires no second
license for sql server... coool :)


z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+QV7S1lRHdy8ASusRAoTTAKCWmkNG7EB+PX2K1oGrFsWN1LmjxgCfZSpr
ml3Ak410pHxhlpUTgxExqwY=
=i+Zp
-END PGP SIGNATURE-

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

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




Re: Character Encoding - Reward Offered!

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Eric Hoffman wrote:
| The xml got changed this year and it all comes back UTF-8 encoding.  Is
| this what you are looking for?

but then the xml version would need to be 1.1 at the start, otherwise
not if it 1.0...i think

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+QWEP1lRHdy8ASusRAgJKAJ0cLkS2WsfNAl/dds3K9IbPBik33gCgt3DP
W+RxEyNup/MpP6mg0PduQyM=
=xwEJ
-END PGP SIGNATURE-

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

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




faxing from cf

2003-02-03 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

what r people using for online faxing solutions ( need to work in europe
) with only a tcp-ip connection

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+PnEU1lRHdy8ASusRAiS4AJ9GQak0g/ir7TVjuL7cmo1Uq0MubACgrqsd
8LWBbrTA3PjHdMvAlXRti4w=
=IgXy
-END PGP SIGNATURE-

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

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




Re: Screening files before CFFile upload: Follow-up

2003-01-30 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

webguy wrote:
| becuase you can do this
|
| cffile action=read file=ntuser.dat 

only when cold fusion is not running under a restricted user acount

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+OU961lRHdy8ASusRArGnAKCogbTj7BbBL7PPZHRu9g12GyylfgCgp275
gg1PNcWNatprfrHAziM/U+A=
=muwX
-END PGP SIGNATURE-

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

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




Pet Market Benchmarks?

2003-01-23 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

does anyone know of some benchmarks of pet market against the java or
.NET versions

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+MDU31lRHdy8ASusRAiNeAJ9eEiyqEoWqt3CuQvB3zWUMw7QsnwCeME26
+ZVOfHQcmrk3L/jqBhvCiTM=
=z5pa
-END PGP SIGNATURE-

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

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




Re: PDF Conversion Tools Question

2003-01-23 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

cflist wrote:
| We use AdLib for converting large amounts of uploaded resumes in all
| sorts of file formats to PDF. And it works great.
|
| We were using ActivePDF, and it worked well at converting, but the
| application always seemed to hang and spit out errors, and after a
| few moths of back and forth with tech support - we dumped it for
| AdLib.


i just downloaded adlib..looks nice but it's not ready yet for realtime
conversion from what i see in the forums...

are u using adlib simply in batch mode or can u generate a html document
pass it to adlib and return the file reasonably quickly???

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+MHHA1lRHdy8ASusRAlgfAKCCi6WLY7g8NEDYGkzoZmFvw9TAtACfQoNQ
tvv7vYn8PHkvv60GbP9MFaQ=
=zvBz
-END PGP SIGNATURE-

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

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




SQL 2000 sp3

2003-01-21 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


http://www.microsoft.com/sql/downloads/2000/sp3.asp

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+LYPM1lRHdy8ASusRAofVAJ0Zz+wl/Rqa3wOuqXKE4oX+JLxWfACgrT/c
xyQnPU3Jnbs3sMDvdb9M7Rk=
=7GJK
-END PGP SIGNATURE-

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

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




Re: Next N Navigation and query caching theory question

2003-01-17 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

| needs to get run again?  Should I do something like append the
| CFTOKEN for that user's session to the query name so that it is
| unique?  Or should I store the query output as an array in a session
| variable?

store them in a session structure keyed on the query criteria, or if the
results are the same for each user in an application structure.. never
use arrays for such stuff, structs are better because they can be
accessed via keys, not just numbers you will also have to manage
this cache structure, deleting results when the database is changed

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+KBHf1lRHdy8ASusRAi6LAJ9MKgFRC2maNlYbXHREM4TT6zW3owCbBts3
P4x9GoxQG0atg7m+1SQy1Y4=
=wmFs
-END PGP SIGNATURE-

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

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




OT: mac cfmx zdnn et confused!

2003-01-07 Thread Zac Spitzer
http://zdnet.com.com/2001-11-0.html?legacy=zdnn

Macromedia heats up ColdFusion MX

Adobe touts three new versions of its applications server software that 
will work with systems running on BEA's WebLogic, IBM's WebSphere and 
Sun's Sun ONE server software.


adobe now makes mx? :-)

z

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

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



Re: Text images on the fly

2002-12-20 Thread zac sitzer


Does anyone have any pointers for creating GIFs on the fly? I would like
to create dynamic headings for one of our portals (such as the quick
link header on this page: http://my.georgetown.edu/)
  

css2 would work 2 :-)

cfx_image, imagemagik, cfx_image_cr from efflare.. the first 2 are free 
the efflare one is $99 but has better quaility and is a native cfx ( 
cfx_image is too)


z

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



OT: browser stats, mozilla rising

2002-12-19 Thread Zac Spitzer
few interesting stories around the web today about mozilla's market 
share rising...

this is the stats from heise.de a big german news site, where mozilla 
based browsers now accounting for 19.4% of users

http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000/

found from a story on mozilazine

http://www.mozillazine.org/talkback.html?article=2767

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



Re: How to do this without the subselect?

2002-12-19 Thread Zac Spitzer
Rick Faircloth wrote:
 Hi, all.
 
 How can I get the same results as this query with using the subselect?
 
 CFQUERY Name=GetWaivers Datasource=#DSN#
 
  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)
 
 /CFQUERY
 
 (I'll be s glad when they get subselects in mySQL 4.2!)

do a left outer join on RentalWaivers in the query and then do a check 
that where UW.ClientID is null (if, this is standard perfomance 
improvement anyway as it uses a index...)

not in is actually a real bad performance killer... this technique is 
found in most good oracle books... should work for mysql but i don't know

z

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



Re: OT : Mac / IE / OS X

2002-12-18 Thread Zac Spitzer
Robertson-Ravo, Neil (RX) wrote:
 I'm running into some of the very problems you mention.
 I tried Decimal as the field type, but 100.5 gets rounded up to
 101.00...not good.
 
 I tried Integer, but when, for example, 100.50 gets entered into a
 formfield,
 then inserted into the db, it gets truncated to 100.  How do I set up
 Integer
 to retain 2 decimal places?
 
 cfqueryparam cfsqltype=CF_SQL_INTEGER
 Value=#LSCurrentFormat(LSParseNumber(Form.UCPaymentAmount))#

CFQUERYPARAM value=100.5 CFSQLType=CF_SQL_DECIMAL scale=2

integers are whole numbers and you need to specific how many decimal 
points using scale as above...

z

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



Working with CF MMS enabled phones

2002-12-17 Thread Zac Spitzer
anyone got any good pointers on working with these next gen gsm phones, 
like the nokia 7650 with the built in camera and GPRS?

what do i need server side to recieve mms in coldfusion? i see there are 
two options, email or http(s)

z

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



Re: Compare Two Lists - Keep What Is Similar

2002-12-17 Thread Zac Spitzer
Scott Brady wrote:
 Hi everyone. I am looking for a way to compare 2 different lists of
  information, and after comparing them keep which records are
 exactly the same.
 
 
 I'd probably convert them both to arrays. Then, I'd loop along the
 first array and look for each element within the second array.  If it
 exists in the second array, keep it; otherwise, delete that element
 from the first array.  When you're done, whatever's left in the first
 array should be the items you need.
 
 You can do that keeping them as lists, but I think it'd be faster
 with arrays.
no, structures would be faster would be
faster...though where you use the

load dataset1 into a structure
load dataset2 into a structure

loop over dataset2
if (NOT structkeyexists(dataset1,dataset2.id))
structdelete(dataset2,dataset2.id);

or not deleete etc

this is faster because the lookup is random, ( reminds be of basic data
handling in MBASIC on my old CP/M box) structures are always faster for 
random access

the array approach too much overhead, ie looping over 
dataset1.recordcount  dataset2.recordcount times

so 500 x 500 25 loops!

above ends up being 1500 loops

z

z


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



Re: CFMX: Caching files

2002-12-17 Thread Zac Spitzer
Dave Carabetta wrote:
Hey all,

I am running into an issue with CFMX apparently not showing the latest
files that I place on the server.
If I make a change to a file, say showdetails.cfm on my machine and load
that page from the webserver,
it shows me the previous page, not the page I just updated.

I need to stop and restart the CFMX service in order to see my update.

Why is this happening, and how can I prevent it?
 
 
 Dumb question I suppose, but do you have the Enable Trusted Cache option 
 checked in the Administrator?

thats for 'production' servers with static code bases, ie cold fusion 
can assume that the files never change and therefore doesn't check to 
see if the cfm file is updated since last time

z


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



Re: Generating PDFs in CF

2002-12-17 Thread Zac Spitzer
Ciliotta, Mario wrote:
 Hi,
 
 I was wondering if anyone has any information on how to create a PDF
 on the fly in CF.  I have been told to look at Active PDF, but right
 now there is no money to purchase that tool, so I was looking of
 either a custom tag or maybe an article or two on how to do this.  We
 are currently using CF 4.5 but will be using CFMX for J2EE within the
 1st quarter of 2003, so maybe even a JSP library that does this would
 be an option.

http://www.easysw.com/htmldoc/ produces pdfs using html 3.2, no 
css/style support but it's free, which is the same as active pdf without 
the ie option which is slower and no 100% perfect... there a tag in the 
tag gallery called cf_html2pdf which is a wrapper for it

z


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



Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread Zac Spitzer
Matt Kornguth wrote:
 Would love to hear people's feelings and relative
 advantages/disadvantages of each.Need to make a decision and I'm
 vacilating between the two.

really simple advantage of verity is that it's way more intelligent than
sql-2000/full text/index server truy searching on msdn which uses 
the ms stuff, very limited.. verity returns much better matches on the 
same data set

z

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



Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread Zac Spitzer
paul smith wrote:
 In my experience with storing recordsets in cached structures, subsequent 
 reading records from the structure was slower than reading the same records 
 from a cached query.
 
 Is this expected behavior, or did I screw up? (first time again)

probably, show us your code... you should only need structkeyexists and 
never structfind

anyway quasi code

cflock timeout=4 throwontimeout=No type=READONLY scope=APPLICATION
cfif NOT structkeyExists(application,search)
cfset application.search=structnew()
/cfif
cfif structkeyExists(application.search,search_string)
cfset qry_search=duplicate(application.search[search_string]
cfelse
cfsearch name=qry_search criteria=#search_string#
cflock timeout=5 throwontimeout=No type=EXCLUSIVE 
scope=APPLICATION
cfset application.search[search_string]=qry_search
/cflock   
/cfif
/cflock

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



Re: mySQL CF (url injection info)

2002-12-16 Thread Zac Spitzer
Cary Gordon wrote:
 CFQueryParam gives you an easy way to validate the query params.  Some 
 clever, bored hackers have figured out how to do things like pass a drop 
 table query through the header.  It is an even easier exploit if you are 
 passing query parameters through the url string.

a simple example .. passing the column name instead of a value
can get very damaging

delete from comments where comment_id = #comment_id#

which when #comment_id# = comment_id

means

delete from comments where comment_id=comment_id

or as comment_id=comment_id is always true

actually becomes  delete from comments  neat huh?

or with users

update  user
set password='#password#'
where   user_id=#user_id#

nice way to reset all passwords on the site

z



z



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



Re: CF 5 PDF - FDF files

2002-12-10 Thread Zac Spitzer
   You really only NEED activePDF (or something similar) if you want the
 users to be able to save the generated PDF files with the fields
 filled out. If you just want them to print it (without being able to
 save the files), you can do it all within CF. (I believe there is a
 custom tag which can do this for you)

see htmldoc, htmldoc is free but only supports html 3.2, without css, 
active pdf can do css via ie but it's slower, by default active pdf is 
functionally almost the same as htmldoc Ie html 3.2 without styles

htmldoc is also open-source cross platform

now if only someone would just hookup gecko ( mozilla) to output (PS) 
postscript to pass to a PS - PDF converter... that would be s cool

z

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



Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
Michael Dinowitz wrote:
 I think that a new array search function might be in order here. Something to
 look through an array for a value and return its index.
 
I'm not sure what you are really trying to accomplish here. 

I agree with matt, are you working on the maketree tag in cf? lets talk 
examples...

do you modify the array, ( ie inserting or deleting array members other 
than from the end?) if not then u could index the array using structures

cfscript
 item_array=ArrayNew(1);
 item_struct=StructNew();
/cfscript

cfloop query=qry_items
cfscript
x=arraylen(item_array);
item_array[x]=qry_item.item;
item_struct[qry_item.item]=x;
/cfscript
/cfloop

find where dog is in the array = item_struct[dog] or item_struct.dog

this method is so fast scaling the dataset makes almost no difference in 
speed

now you can always find the position of x in the array using the struct,
this of course doesn't handle very well adding elements to the aray

ideally I would try to eliminate arrays all together... esp when u 
consider that have 2 values in a struct, the key and the value

z

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



Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
Michael Dinowitz wrote:
 You can see the code here:
 http://www.houseoffusion.com/_library/maketree.txt
 Your example will fail as there can be more than one item with the same
 'parent', which is what we're looking for. No matter what, we have to do a
 search and the list search functions seem to be the fastest of the searches
 around, even though the list items have to be parsed.

ok gotta run, times short in a second but off the top of my head

i would loop over the query first and then make each parentid a 
structure containing the items


cfscript
item_struct=StructNew();
/cfscript

cfloop query=qry_items
cfscript
if (NOT structkeyExists(item_struct,qry_items.parentId) )
item_struct[qry_items.parentId]=structnew();

item_struct[qry_items.parentId][qry_items.itemid]=qry_items.currentrow; 
/cfscript
/cfloop

now everything is grouped by parentid

now we know that the items in item_struct[0] are the first level,
you could then loop over the collection

cfloop collection=#item_struct[0]# item=child
cfscript
if ( structkeyExists(item_struct,child) )
// yes there are children add to the to be processed list
else
// no it's just a member with no children
/cfscript
/cfloop

and so on... sorry time ran out

z

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



Re: Lists vs. Arrays vs. Structures

2002-12-05 Thread Zac Spitzer
Michael Dinowitz wrote:
isn't structkeyexists better than structfindvalue? as our jedi friend
says, after not evalutating, cflocking I think that's his next biggest tip
 
 It's better if you just want to know if the value exists. I need to know where
 it exists.
 
 
my experience is that structures are always *way* faster than lists or
arrays.. basically because structures are key indexed
 
 Do you have any code to show this? I'm not seeing *way* faster.

ok, it depends on what we are talking about, I would usually use a 
single depth structure, ie kinda of denormalising the data structure... 
to provide an indexing function, that returns references, know what i mean?

structfindvalue isn't going to be using hashing in cf is it? ie a full 
table scan... my approach is only to work via struct keys, as they are 
hash indexed

anyway, throw some of your code up and we can explore the ideas...

z



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



Re: Lists vs. Arrays vs. Structures

2002-12-04 Thread Zac Spitzer
Michael Dinowitz wrote:
 I'm rewriting my CFMakeTree tag in order to make it tighter and work in CFMX
 better. One of the assumptions I had was that Lists would be problematic in
 comparison to Arrays or Structs. My first test was to find a value in one of
 these data collections.
 For Lists I used ListFindNoCase. For Arrays, I looped over the array to find the
 value and for Structs I used StructFindValue(). I ran each test in a 1000

isn't structkeyexists better than structfindvalue? as our jedi friend 
says, after not evalutating, cflocking I think that's his next biggest tip

my experience is that structures are always *way* faster than lists or 
arrays.. basically because structures are key indexed

z

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



Re: Nested Query Loops

2002-12-04 Thread Zac Spitzer
Jeff D. Chastain wrote:
 I was referring to the inner query using the full scoped name -
 variables.queryName.
 
 So, why does setting newQueryName = variables.queryName PRIOR to looping
 the first query change anything?  Both variables are in the variable
 scope and are created prior to the first loop - they should be the same
 right?

cf loses track of the currentrow when nesting, you need to track it, ie

cfloop query=qry1
cfset qry1_row=qry1.currentrow
cfloop query=qry2
cfoutput#qry1.name[qry1_row]# #qry2.name#/cfoutput
/cfloop
/cfloop

z

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



Re: Nested Query Loops

2002-12-04 Thread Zac Spitzer
Jeff D. Chastain wrote:
 I am not even making it that far.  I am getting an error on cfloop
 query=qry2 stating that qry2 is not a recordset.  If I do a cfdump
 prior to the first loop, qry2 is a recordset with several rows of data.
 If I do a cfdump right before the second loop (i.e. inside the outer
 loop), then qry2 is null.  For some reason the variable is just gone.

umm is qry2 by anychance a column name in qry1? z






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



Re: Checking SESSION variable

2002-12-03 Thread Zac Spitzer
FlashGuy wrote:
 Hi,
 
 I have session variable that contains the directory name
 session.strFileName. I also have another session variable
 session.ShowMe that contains multiple directory names 
 (comma-delimited) which i'm setting from my database. Basically, i
 need to check if the directory session.strFileName exists in the
 variable session.showme.
 
 Example:
 
 session.strfilename = 'mywork'
 
 session.showme =
 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2'

use a struct, it's more reliable  faster than a comma delimetered lists

z

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



Re: CFX_Image - Quality of images not good when rotating

2002-12-03 Thread Zac Spitzer
Craig Dudley wrote:
 I'd stick to cfx_image then, it works well, can read and convert many,
 many formats. It's fast enough as well, as long as you don't run it on
 the front end of your site.

just make sure your using the latest version too

http://www.kolumbus.fi/jukka.manner/

z

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



Re: When CFHTTP fails, use WGET

2002-11-26 Thread Zac Spitzer
Craig Dudley wrote:
 I use a self written java cfx, took 2 hrs to write (I'm a java n00b) and
 is massively faster than cfhttp, granted it's a little more simple but
 it works well. Using a w32 utility with cfexecute is likely to be even
 slower than cfhttp, I wouldn't go there to be honest. If your'e already
 doing it, I'd think again.

agreed for simple stuff, but wget is much, much more than a simple http 
tool, it's a spider, it can process the files, do ftp and it's XP, it 
runs on linux etc... for example YAST ( the setup config install tool 
from suse ) uses wget for all network stuff..

z

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



Re: Application variables

2002-11-25 Thread Zac Spitzer
Bryan Stevenson wrote:
 You have to restart CF to reset APPLICATION vars (timing out the app might
 work too).


application=strucnew();

z

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



Re: How to get a JPEG's width/height (not cf_imgagesize)?

2002-11-21 Thread Zac Spitzer
Bob Haroche wrote:
 I need to determine the width and height of JPEG's being uploaded. I've used
 the free cf_imagesize but it sometimes returns the wrong dimensions. I'm
 told it's just buggy with JPEG's.
 
 I'm deploying to a shared hosting situation so I can't control what can be
 installed on the server, but the server does presently support cfx_image.
 
 I see that cfx_image does have a getsize command, but I still can't figure
 out the command syntax of this tag?
 
 Can anyone help on that front or recommend an alternative to cf_imagesize
 that doesn't require
 additional installation on the server?

if you are uploading via a web form, u can use the browser to get the 
values... create an onchange on the file input field and then use js to 
set an img src to the value from the file field and then access the img 
size via js


z


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



Re: Gif Pipes

2002-11-20 Thread Zac Spitzer
Jochem van Dieten wrote:
 Adrian Lynch wrote:
 
 
www.depressedpress.com used to have something but the site isn't 
working for some reason.

another way to do this that is becoming more common is like this

document.write('script src=j.cfm?id=3opt=4/script');

j.cfm then returns javascript which gets added to the body of the 
document...


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



Re: java cfx and administrator woes

2002-11-13 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

| Any suggestions on what to try next?

do you have the CF 5.0 hotfixes installed?

z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE90nMU1lRHdy8ASusRAi9WAJ9ij1hsFR9XDwft+/0YuoNW+2vt5QCfe+ok
1sqA4Y8fy51re9SfhR7mHJM=
=NmnJ
-END PGP SIGNATURE-

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



Re: OT: good Meta taggers

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Carlisle, Eric wrote:
| Hi CF-Talkers,
|
| I'm looking for a good meta tagging mechanism -- something that'll build
| good description and keyword meta tags from text content.

FYI: meta keywords are dead, google never even read them

http://searchenginewatch.com/sereport/02/10-meta.html

z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE90OWC1lRHdy8ASusRAmHvAJoDfjaHtcQiKRQ9z2B6PZ8CsaB4+gCfYppB
Y1BAHGIs9zfR/7yfxCLKoFg=
=M/Xe
-END PGP SIGNATURE-

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



cfqueryparam in MX

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

[EMAIL PROTECTED] wrote:
| Well, it's good to learn Rick.  For further reading on cfqueryparam
| check out Ben Forta's article:
|
| http://www.macromedia.com/desdev/articles/ben_forta_faster.html
|
| Anyway, I would advise anyone working with *any* db to use queryparams.
| You'll be doing yourself and your database a favor.  Granted, not all
| databases use the speed advantage, but the security of it is worth it.

does cfqueryparam work with cached queries in MX? that is the only
downside of cfqueryparam in Cf 5.0

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE90SfW1lRHdy8ASusRAohSAJ0e0FdmVXOyeQ+SFnuPqQ1xiXOWmgCeImPt
ZjTSkX3+tc2LaFc8CIEtHpc=
=2zow
-END PGP SIGNATURE-

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



Re: Compare code on two pages...

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Adrian Lynch wrote:
| Print out both versions, put them together and hold them up to the
light :OD
|
|
| -Original Message-
| From: Chris White [mailto:whitec;earthlink.net]
| Sent: 12 November 2002 13:10
| To: CF-Talk
| Subject: Compare code on two pages...
|
|
| I have the need to take the same page but there different versions and see
| what has changed.  Is it possible to see the differences in two different
| files using DreamweaverMX?  What are others using if they need to compare
| code to see what has changed?

from the unix world there is diff, which is used for cvs

http://directory.google.com/Top/Computers/Software/File_Management/File_Comparison/Windows/?tc=1

z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE90Sud1lRHdy8ASusRAtzxAJ9v30cxeeF6hA2AZ3let0crQch7igCaAjMD
iqOE4cnrVJ2VPgFldcrNfK8=
=6OVd
-END PGP SIGNATURE-

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



w2k optimal directory size?

2002-11-11 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

anyone know what w2k  ntfs5 's optimal file count per directory is?

ie I have 1,000,000 files, splitting them in to dirs with 5000 files, or
1000 files per directory... this is for cfcontent returned content,
linked to a db with a security check, so human usability/readabilty is
not a factor...

whats the optimal split?

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9z9Xp1lRHdy8ASusRApdYAJ0WfnmOpbPJXwmbffmsg+3dtZyGtACeKRc0
QxGCZ/gGRfdjRrbb19mUf/8=
=A9Qd
-END PGP SIGNATURE-

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



Re: JSP share with CF 4.5?

2002-11-08 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Chris Norloff wrote:
| I have a request to get JSP's and CFML (CF 4.5) to share data. My
first response is to say Easy - buy CFMX
|
| In the meantime, they'd like JSP's and CFML to share data. Can they
share jsessionid or something?

use your database :-) it's a common datastore

z

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9y5UO1lRHdy8ASusRAjDGAJ9SfVR39K0+GnYxIgKMDtXCxoSuEACgmdPs
UowGkEIDH0F9eGQpIP9o6pc=
=EPVL
-END PGP SIGNATURE-

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



Re: Simple serial interface and CF???

2002-11-08 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Kris Pilles wrote:
| Can I read data vai SSI into a CF application???
|
| We have symbol datawand III and I would like to read the data from the
| wand directly into my app... can I do this???

if you can find a commandline tool (ie dos ) you can always cfexecute
and then parse the results back in to cf

z
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9y+I/1lRHdy8ASusRAspmAJ9ZNT/EQkjLt97nkFRPED7OKBEoqgCfbjxv
Eh3zuhacu1eiPFdDIfdlu2U=
=HtXi
-END PGP SIGNATURE-

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



Re: Deleting duplicate values in list

2002-11-06 Thread Zac Spitzer
Dowdell, Jason G wrote:
 Hi all,
 
 Does anyone know of an easy way to delete duplicate
 values from a list.
 
 For example:
 
 List = Jason, Jeremy, John, Jason, Jack

i think the quickest way is to create a struct, make each list item a 
key in the struct and then return the structkeylist

z


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



Re: Running custom tag

2002-11-06 Thread Zac Spitzer
FlashGuy wrote:
 Hi,
 
 I downloaded the custom tag cf_sleep. I changed the path of my
 custom tags directory to e:\inetpub\customtags and added the custom
 tag path via CF Administrator and deleted the default path of
 c:\cfusion\customtags. When I run my template with the cf_sleep I
 get the following error. Why? What does it mean? I run CFX tags no 
 problem.
 
 Maybe CF only likes the custom tags to reside in
 c:\cfusion\customtags directory?
 
 Here is the error:
 
 
 Error Occurred While Processing Request Error Diagnostic Information 

here is your answer from your post :-) ...

 The JVM library path is empty. To use Java objects or Java CFXs, you
 need to install (if not already installed) the JDK or JRE and specify
 the path of the JVM in the ColdFusion Administrator. Please read the
 release notes regarding the version of the software that is needed.

coz, cf_sleep most likey uses a java function to pause.. which needs a 
jvm to run,

cheers

z

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



Re: Max length of Text Data?

2002-10-24 Thread Zac Spitzer
Matthew Walker wrote:

 You can't apply max() to a text datatype. So how about:

 SELECT MAX(LEN(CAST(textdatafield AS nvarchar(4000

 If the result is  4000 then it will work. If not, it won't. Or you
 could use varchar(8000).

and you can only stored 8000 bytes in varchars in a row total, you can 
define more than 8000 in the table, but once the total bytes stored in a 
row reaches 8000, ms sql server throws and error..

pretty huh?

this something that doesn't happen with oracle :-)

z

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



Re: How can you get the latest version of a page.

2002-10-18 Thread Zac Spitzer
Adams, Stephen wrote:

 Hi all,

 How can I get the latest version of a CF page.  I am opening a page in a
 popup window and I want the latest version, not the one stored in the 
 cache,
 I'm not sure how to do this can anyone give me any pointers.


CFHEADER NAME=cache-control
VALUE=no-cache, no-store, must-revalidate, max-age=0
cfheader name=Pragma value=no-cache

which sets http headers that tells the browser don't cache the file, or 
when that fails becuase of a brain dead proxy server then add a random 
number or date to the url

z

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



Re: Page Expires

2002-10-11 Thread Zac Spitzer

Everett, Al wrote:
 This is what I use:
 
   CFHEADER NAME=Expires VALUE=#DateFormat(Now(), 'ddd, dd-mmm-')#
 00:00:00 GMT
   CFHEADER NAME=Pragma VALUE=no-cache
   CFHEADER NAME=cache-control VALUE=no-cache

you can also use the confusingly named 
GetHttpTimeString(date_time_object) function for the same effect

z

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



Re: Counting Page Views

2002-10-11 Thread Zac Spitzer

I have a spec on a project that has me counting page views in order to
generate a 'most popular' list of the 10 most commonly 
clicked on links.

Has anybody done anything like this?

Initially I was thinking of a db counter that incremented a 
field in my db
as people viewed the page.  Is there a better way to do this?

that is the right approach, you need the info in the db for the 
resulting query. if your site is high load, you could cache the value in 
an application var ( do lock! ) and update the db less often to avoid so 
many database updates

z

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



EU internet law resources

2002-10-08 Thread Zac Spitzer

I'm looking for some information regarding EU law and the internet,
with regards to user agreements, privacy and what is legal and what 
isn't, in plain english or better from a developer point of view

things in the direction for example that the MS eula is not legal in the 
eu and what isn't

for example how binding is a purchase contact for when i buy something 
online

gotcha and what isn't allowed is really what I am looking for

z

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



Cumulative Patch for SQL Server (Q316333) Crtical for 2000

2002-10-03 Thread Zac Spitzer

Microsoft Security Bulletin MS02-056

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS02-056.asp

have fun, yet another crappy m$ patch from with no installer and 2 pages 
  of instructions

and it's rated critical for all internet instances

z

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



Re: QofQ weirdness when using QueryNew

2002-10-03 Thread Zac Spitzer

Ryan Kime wrote:
 OK, I really need some help on this one. 
 
 I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell.
 Everything is fine until I try to use a cfquery with dbtype=Query on the
 created query to order the results - it throws a QofQ runtime error. If I
 comment out the cfquery and call the original query created with QueryNew,
 it runs fine and spits out the data (albeit unordered).
 
 I could really use some insight on this. I need to get that query in a
 particular ordered format and time is breathing down my neck.
 
 
 Here's a code snippet, it dies right on the cfquery tag saying
 Unsupported Numeric type conversionyet it worked fine in CF5:

when using querysetcell you need to explictly force the datatype with 
int() etc, there was a thread on this late last week

z


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



Re: CFM Files are Locked?

2002-10-02 Thread Zac Spitzer

[EMAIL PROTECTED] wrote:
 IIS likes to lock files for a little while if they have been recently accessed from 
the web.  

If you wait about 30 mins, they'll be freed.  Annoying.

rename then delete then write a new file always seems to work for me in w2k

z

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



opinions about XSL

2002-10-01 Thread Zac Spitzer

is found this article talking about why xsl is bad

http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html

any comments? I haven't personally looked into xsl, the syntax always 
looked like RTF :-) through babelfish

and it looks like doing client side work on the server ( ie browser 
stuff ) i know from my old man who does java that it's quicker to go 
xml-dom-xml than xsl

what's peoples experience?

z

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



Re: opinions about XSL

2002-10-01 Thread Zac Spitzer

Alex wrote:
 What other option is there to transform xml docs?

convert the xml to dom, do your mods and then back to xml, as a CF 
developer, it much easier to work IMHO with the xml dom as structures 
etc than messing around with...

apparently one of the problems with XSL as an approach performance wise 
is something to do with the way that it progressively processes the xml 
file and has to do some prediction stuff (read more overhead) as it goes...

you can do amazing stuff with xml and css, write a style sheet which 
hides nodes ( display:none;)

now if only we could get everyone to upgrade to mozilla.. then life 
would be so much easier.. back to workarounds, again :-(


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



Re: opinions about XSL

2002-10-01 Thread Zac Spitzer

Tony Weeg wrote:
 zac.
 
 can u explain in brief, or give a brief example
 of taking an xml node(s) and sending that to a structure?

using an xml parser in cf 5 or native in MX, you can convert an xml 
document into a dom object... like a tree of objects or structures of 
structures

take an xml document and convert it to dom

you end up with an complex array of array's and structyure and variables...

a good example is rss.. rss is really simple syndication, except that so 
many people can't read a spec and produce well formed or valid rss files

see this link here for a good working example

http://static.userland.com/gems/backend/sampleRss.xml

ok... rss should be something like

channel
title etc
item
title
description
/item
and so on...

but sometimes you get no channel and only items

so you can load the xml into a dom under a var called rss and then say

rss.channel.item=rss.item

then if you have modified the xml structure or transformed it

z








__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Using the Verity Engine on non-cf apps

2002-09-30 Thread Zac Spitzer

Bruce Sorge wrote:
 If you have CFMX and .net apps running on the same server, is it possible to use the 
K2 
Verity engine on the .net apps, or does this require one to purchase and 
install the K2 product?

sounds like you coud expose it via a web service :-) that would be the 
license compliant way

z


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



Re: NSLookup

2002-09-24 Thread Zac Spitzer

James Smith wrote:
 Hi all.
 
 Here is a problem I have been pulling my hair out over.  I want to do an
 NSLookup directly (ie: no custom tags if it can be avoided) and have tried
 both w3sockets and TCPClient to open the socket but not for love nor money
 can I find the appropriate commands to send.
 
 I can use either to connect to a POP3 server, login, read mail etc but I
 just cant get DNS queries to work.
 
 Can anyone point me in the correct direction?

honestly the best advice here is don't re-invent the wheel.. use 
cfexecute and dig from sendmail/bind or maybe a java class

this code using dig will give u really detailed info about dns

cfsavecontent variable=dig_outcfexecute name=#server.dig_exe#
arguments=#attributes.domain# +nssearch  timeOut=5/cfexecute
/cfsavecontent
cfscript
soa_pos=FindNoCase(SOA,dig_out,1);
if (soa_pos gt 0){
soa_server=ListGetAt(dig_out,2, );
request.mod.dnsdig.status=1;
} else {
// name server soa not found!
soa_server=;
request.mod.dnsdig.status=-1;
}
/cfscript
cfif len(soa_server) gt 0
cfsavecontent variable=request.mod.dnsdig.infopre
cfexecute name=#server.dig_exe#
arguments=#soa_server# #attributes.domain# axfr +multiline
timeOut=5/cfexecute/pre/cfsavecontent

the short explanation is SOA is the master server for a domain, u can 
only get the detailed info from the master server, you first get the SOA 
server, then u query the SOA server for the domain info


is there a reason why you don't want to use custom tags??? what are u 
wanting to do?

z


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



Re: NSLookup

2002-09-24 Thread Zac Spitzer

James Smith wrote:
 The reason for attempting direct interaction is that the page I have here
 has about 200+ domains on it and it is growing every day and every custom
 tag I have tried can't cope with the volume.

like always, cache your results, if it's possible, most likely the 
results your are getting are cached in the dns server anyway..

cache to application vars or write out txt files

z

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



Re: IIS Security

2002-09-24 Thread Zac Spitzer

Candace Cottrell wrote:
 What is the disadvantage of using the native IIS directory security
 functionality over using a cf-based login?

you don't have so much control over the interface ( ie browser login 
dialogs ) and it generally more flexible via cf logins with error 
handling.. ie you control the flow and not with IIS  HTTP status codes 
and then u need to configure IIS error pages etc etc

z


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



Re: IIS Security

2002-09-24 Thread Zac Spitzer

Robertson-Ravo, Neil (REC) wrote:
 I am pretty sure that there are Netscape issues with IIS/NT security based
 systems.

only with NTLM/kerbos auth, use basic security... NTLM is not secure 
anyway coz it's flawed (crackable) ... if you are worried about 
passwords in clear text then use ssl

z

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



Re: QueryNew() Filtering Problems

2002-09-24 Thread Zac Spitzer

Raymond Camden wrote:
 Can we see your code? I had no issues with this on either CF5 or MX.
 Here is the code I used:
 
 
 cf_querysim name=foo
 price name
 6000  foo
 1 goo
 2 moo
 /cf_querysim
 cfdump var=#foo#
 
 cfquery name=test dbtype=query
 select  price
 fromfoo
 where   price  7000
 /cfquery
 
 cfdump var=#test#

order by in CF 5.0 doesn't work with QoQ's when the query is built or 
modified using QuerySetCell, and I found no work arounds, querying the 
query and then trying to query and order by with that recordset still 
doesn't work

z

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



Textarea manipluation with JS ( IE Moz)

2002-09-24 Thread Zac Spitzer

the following link show how to create controllable textarea's for 
editing, ie get selection, insert at selection with both mozilla and
IE 456 ( diff methods, but same results )

hope it saves someone some time :-)

http://www.faqts.com/knowledge_base/view.phtml/aid/1052/fid/130

http://bugzilla.mozilla.org/attachment.cgi?id=89748action=view

http://www.faqts.com/knowledge_base/view.phtml/aid/13562/fid/130

z

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



Re: UUID's ( maybe OT)

2002-09-19 Thread Zac Spitzer

Bryan Love wrote:
 Not really true.  The word terrible is a vast overstatement.
 
 Assuming you use char (or varchar) for the UUID (char is better since the
 size is constant)...
 The difference btwn string keys and numeric keys (performance-wise) is
 pretty much null until you get up into the millions of records and even then
 it's not enough to worry about.

ok some simple maths, a uuid is what 30 chars or something, that means a 
join using two tables with lets say 1 and 3000 rows.. that means a 
query between the two is going to be working with either 13000 bytes or 
13000 * 30 bytes just to join data... the answer there is that you are 
working with 30 times the amount of data, sure there is some optimzation 
but the logic goes further..

each index requires space, both memory and disk space... db's usually 
try and cache the indexes in ram sure the db can probably do some 
magic here and the difference is not 30 times in processing speed..but 
you will still need 30x more cache for your indexes but then each of 
pages will then contain x * content links * 30 more data, which means 
more transfer between your db and webserver, more bandwidth costs as all 
your pages are then bigger...

z


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



Re: Returning columns with null values when specific columns are unknown at runtime

2002-09-19 Thread Zac Spitzer

null values are not indexed btw. (maybe thigs have changed in the last 
few years but) using a value like 0 as a quasi null means that

select user_id from users where b_sysadmin is null

versus

select user_id from users where b_sysadmin = 0

do an explain plan in oracle or execution plan in sql server, the second 
can use an index, the first cannot, which means the db server has to do 
a full table scan ( slow, expensive )

there are tricks to use a join in oracle to get around this

z

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: more cfstoredproc issues -- ARGH!!

2002-09-18 Thread Zac Spitzer

S. Isaac Dealey wrote:
 Yea, it turned out to be the cf_sql_date that was causing the wrong number
 of parameters error message... so changing that to cf_sql_timestamp solved
 the problem... Better support for cfstoredproc ( naming and better error
 handling in particular. ) would be _great_ to see from the folks at MM...
 I'll probably toy with it some once I start working with it on MX just to
 see if any improvements came with the new J2EE platform.

my biggest peve with the cf query/stored proc param support is that 
there is no null=AUTO option...

z

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



UUID's ( maybe OT)

2002-09-18 Thread Zac Spitzer

I am probably OT here, but I see so many people using UUID's when
simpler normal numeric keys are better... a classic example for me is 
article id's... look at cfcomet for example... the article ids aren't 
user friendly, it reminds me of good old lotus notes and we all know how 
short urls are better than long one ( email wrapping for example )

not to mention that your database and CF load is much higher using  long 
text pk's than with nice short numeric keys and your page size is 
increased a lot too..

just letting off steam. don't want to create a flame war or anything

z


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



Re: FW: Jsp Vs Cfm (CFMX) -- Test Code

2002-09-17 Thread Zac Spitzer

snip
 Anyone else have any ideas?

try scoping your variables

z


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



Re: FW: Jsp Vs Cfm (CFMX) -- Test Code

2002-09-17 Thread Zac Spitzer

and writeoutput in cf 5.0 is slower than cfoutput, did you try the same 
test with cfml and not cfscript ?

z

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Recursion

2002-09-13 Thread Zac Spitzer

S. Isaac Dealey wrote:
 Before you give up... There's a couple of things you can do for the
 recursion in the db... One is to create a cross-reference table which shows
 the parent-child relationship between all records in the table...
 Alternatively, you could try this:
 
 cfset rs = QueryNew(ID)
 cfset temp = QueryAddRow(rs)
 cfset rs.id[1] = 0
 cfset rs2 = QueryNew(ID)
 
 cfloop condition=rs.recordcount
   cfquery name=rs datasource=...
   SELECT * FROM mytable
   WHERE parentid IN (#valuelist(rs.id)#)
   /cfquerycfquery name=rs3 dbtype=query
   SELECT * FROM rs UNION SELECT * FROM rs2
   /cfquerycfset rs2 = rs3
 /cfloop
 
 This or something like it ought to give you a single query containing all of
 the children of the parent... It will be much slower than a cross-reference
 table in the db, however, it should be similar in performance to the current
 solution... Once you have this query, however, you can then use the
 recursive UDF in CF 5 and either pass the query to the UDF along with the
 current parent id for the tree, or you can place the query in the request
 scope and reference it from there...

never do to much work in cf when your database can do it faster

http://www.sqlteam.com/item.asp?ItemID=8866 is a really nice and simple 
method for doing trees it stores an id path for each node in your 
tree, automatically, that why you can do a query like (see example on 
page above) select node where lineage contains '/#target_node_id#' to 
return a specific part of the tree

z

 
 
 hth
 
 Isaac
 Certified Advanced ColdFusion 5 Developer
 
 www.turnkey.to
 954-776-0046
 
 
All,
 
 
Thank you for your responses to my inquiry.
 
 
As it turns out, the CFSCRIPT option is not viable because
the point of the recursion was querying a database for
records that represented subordinate records which might
have subordinate records of their own.
 
 
The cfmodule seems to take forever and therefore is not
practical.
 
 
In the end, I will have to change the design of the
application.  However, that is not necessarily a bad
thing.  However, it does make me appreciate the changes in
CFMX.
 
 
Again, thank you all for your responses.
 
 
 
 
-- Original Message
--
From: Mosh Teitelbaum [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 12 Sep 2002 15:45:57 -0400
 
 
Or, you could rewrite the function without recursion.
Just thought I'd
mention it as another alternative.


 
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 2:23 PM
To: CF-Talk
Subject: RE: Recursion



I wrote this really neat recursive function using the
cffunction tag on my development system which is
running
CFMX on WindowsXP Pro.  When I ported to the
operational host
(third party), I discovered that they were running a
previous
version of CF (I do not know which) which does not
support
the new tag.  Does anybody know how to do recursion
without
the cffunction tag?

If your recursive function is relatively simple, you can
probably write it
as a CF 5-compliant user-defined function, using
CFSCRIPT.
CFSCRIPT is a tag
in which you can write CF commands using a
JavaScript-like language, which
uses the same syntax and control flow structures as
JavaScript, but uses
CFML operators and expressions. You can't use CFML tags
within a CFSCRIPT
tag, though, and CFSCRIPT doesn't support all the things
you can do with
CFML tags, such as querying a database. Keep in mind
that the host would
have to be using CF 5 or higher for this to work.

Alternatively, you could write a recursive custom tag.
However,
this is the
least desirable alternative, as custom tags don't
provide any built-in
ability to return values (you can write that ability
into your
code, though)
and they tend to negatively affect performance.
Nevertheless, if you need
recursion and you're using a version of CF prior to 5,
that's the only way
you can do it within CFML.

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



__

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

Re: Saving a static version of a website

2002-09-08 Thread Zac Spitzer

Jason Miller wrote:
 I have been unsuccesful as well with some of the download utitilies. 
 This would be great if UltraDev did indeed have this. Just wanted to 
 post my interest if this is found - I would appreciate a note to the list.
 
 I will do the same if I should happen to solve the issue adequately.
 Thanks,
 Jay Miller


gnu wget http://www.wget.org

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



Re: upload multiple image files

2002-09-06 Thread Zac Spitzer

Chris Edwards wrote:
 how do I access a file's information after uploading multiple images in a
 single form?
 
 the default is FILE.stuff. or CFFILE.stuff..

cfset this_file_info=duplicate(cffile)

i think u need the duplicate because otherwise as cffile is a struct, 
when cffile changes this_files_info would change as it's only a reference

z




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



Re: html2jpg

2002-08-30 Thread Zac Spitzer

James Smith wrote:
 Some time ago there was a thread about HTML2JPG (http://www.html2jpg.com/)
 and using it to create screen shots of web sites.
 
 Has anyone got it to work with the cfexecute tag?
 
 It works just fine when I execute it directly or with a batch file from
 windows, but either method with CF just produces screenshots of my desktop
 which is not a whole lot of use to me.

use the cfx_html2bmp from http://www.efflare.com it's free

~|
Archives/subscription: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=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: Programmatically Control IIS with CF.

2002-08-29 Thread Zac Spitzer

Bryan F. Hogan wrote:
 I'm faced with a task of creating an app for our company where a sales
 person can input a new client and have it create the needed information
 within IIS.
 
 I have been able to do this with my registrar for domain names and have it
 programmatically create the needed DNS records. I can not seem to figure out
 how to do this with IIS. Does anyone have any suggestions?

Intrafoundation Software - IHTK, Intranet/Hosting Toolkit
.. Intranet/Hosting Toolkit. ... In short, it's a toolkit for anyone 
using ColdFusion
to administrate an intranet or web hosting organization. ...

www.intrafoundation.com/ihtk.html

iis admin via cfx tags

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



  1   2   3   4   5   >