dhtml menu w/ opaque dropdowns and cfm integration?

2007-01-15 Thread DRE
Hi,
Anybody know of a good dhtml menu that does opaque dropdowns?  cfm
integration a plus?
Browser compatibility notes?
Thanks.

DRE

On 1/15/07, chr chr [EMAIL PROTECTED] wrote:

 Hi Everybody,

   I have one question about file upload, i am uploading file using cffile
 tag but how to display the uploaded file in html form for user verification.
 Any ideas please.

   I hope everybody had good week end and thanks in advance.

   Raj


 -
 Have a burning question? Go to Yahoo! Answers and get answers from real
 people who know.

 

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

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


Re: dhtml menu w/ opaque dropdowns and cfm integration?

2007-01-15 Thread DRE
Hi Bobby,
Does it do the opaque dropdowns in a reliable manner? I would of thought it
to be a good selling point but didnt see much of it on their site.

DRE

On 1/15/07, Bobby Hartsfield [EMAIL PROTECTED] wrote:

 I've used Milonic NUMEROUS times. It's quite customizable.

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Monday, January 15, 2007 1:43 PM
 To: CF-Talk
 Subject: dhtml menu w/ opaque dropdowns and cfm integration?

 Hi,
 Anybody know of a good dhtml menu that does opaque dropdowns?  cfm
 integration a plus?
 Browser compatibility notes?
 Thanks.

 DRE

 On 1/15/07, chr chr [EMAIL PROTECTED] wrote:
 
  Hi Everybody,
 
I have one question about file upload, i am uploading file using
 cffile
  tag but how to display the uploaded file in html form for user
 verification.
  Any ideas please.
 
I hope everybody had good week end and thanks in advance.
 
Raj
 
 
  -
  Have a burning question? Go to Yahoo! Answers and get answers from real
  people who know.
 
 



 

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

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


Re: Firebug 1.0 Beta is Out

2006-12-04 Thread DRE
I love the fact that he has a roach as his logo.  Then his tagline contains
the word evolved.  Such irony.

Truly a great software tho.

DRE

On 12/4/06, Rey Bango [EMAIL PROTECTED] wrote:

 Guys, I posted this on my blog but since I haven't reached reader levels
 on par with Ben Forta, Vince Bonfanti, Rob Ghonda or Sean Corfield, I
 figured I'd let you guys know.

 If you've been doing any form of Ajax development, you know how
 invaluable an HTTP sniffer  DOM inspector is. And quite honestly, I've
 found none better than the FireBug extension in FireFox to handle these
 tasks. Its a nice little plugin that sits unobtrusively until you need it.

 Well, Joe Hewitt, the author of FireBug, has released an open beta of
 the anxiously awaited FireBug 1.0. This is a MAJOR revamp of the
 original version and a must download if you're doing any type of Ajax,
 CSS or DOM manipulation. Trust me when I tell you that this plugin is
 invaluable and you will end up using it all of the time.

 http://www.getfirebug.com/

 

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

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


Re: ajax cfc

2006-12-02 Thread DRE
get firebug?

On 12/2/06, Rick Root [EMAIL PROTECTED] wrote:

 Dan Vega wrote:
  I have been playing around with ajaxCFC today and ran into a problem. I
 have
  a whois cfc that basically does a whois query and returns a very long
 string
  of text that contains information about the domain. I can run this
 lookup
  method no problem without ajax cfc but everytime I run it now I am
 getting
  an error Invalid reply from the server.
 
  If it works fine without ajaxCFC why would i bet getting this message
 better
  yet how do i figure out whats wrong? I changed the degug:true property
 iin
  the ini of ajaxCFC but alll that shows is the post. I also changed it in
  ajax.cfc but that will not show anything either. How can I solve this?
 

 That Invalid reply from server is coming from ajax.cfc, not from your
 CFC.  Something isn't configured properly or something like that.  The
 worst thing about doing ajax is debugging ajax.  Start by looking in
 your coldfusion server's exception log.

 Rick


 

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

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


Re: Cool things about cf

2006-11-14 Thread DRE
Dan,
I didnt have to deal with that.  I looked over my old code (my first cfc -
yikes!) you just use isready and readline.  There is an example here.

http://coldfusion.sys-con.com/read/86121.htm

DRE

On 11/13/06, Dan Plesse [EMAIL PROTECTED] wrote:

 DRE how do you deal with EOF and the null issue?

 Do you remember where you discovered BufferedReader and do you use the
 close() methods for those
 two objects?

 thanks I use StringReader to LineNumberReader after cffile to avoid
 another
 close() method and to get
 line number if I happen to need them.


 

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

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


Re: Cool things about cf

2006-11-14 Thread DRE
Jacob,
There are a bunch of php caching classes available.  Basically, the classes
usually serialize any object to a text representation and store that in a
file.  The serialization and deserialization to from file is very quick and
once you have the class, performing the process is usually a one liner.

Here is an example.
http://www.zend.com/zend/spotlight/code-gallery-wade4.php?article=code-gallery-wade4kind=slid=1899open=anc=0view=1

Its not as easy as using the application scope but it does work.

DRE

On 11/14/06, Munson, Jacob [EMAIL PROTECTED] wrote:

   I'm trying to think how I would live without the application
   scope...hard to fathom.  What do they do, store application
   level stuff
   in files or DBs?
 
  Every PHP guy I've spoken with uses a config file of some sort.

 Ok, but that doesn't help for caching application level data.  For
 example, to speed CFQuickDocs up, I put the data in server memory using
 the application scope.  Then when /any/ site user does a query, it pulls
 directly from memory.  And, it's insanely easy to do this:

 cfset application.cftagsquery = variables.cftagsquery

 but how would you accomplish such a thing in PHP?  It's probably
 possible, but with a lot of code.  Or maybe it's not possible?


 -


 --
 This transmission may contain information that is privileged, confidential
 and/or exempt from disclosure under applicable law. If you are not the
 intended recipient, you are hereby notified that any disclosure, copying,
 distribution, or use of the information contained herein (including any
 reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
 in error, please immediately contact the sender and destroy the material in
 its entirety, whether in electronic or hard copy format. Thank you.


 ==
 EMF idahopower.com made the previous annotations.

 

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

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


Re: Cool things about cf

2006-11-14 Thread DRE
Its nice to just wrap it up in a cfc.  It makes it more readable and a bit
more reeuseable(just a wee bit).

DRE

On 11/14/06, Dan Plesse [EMAIL PROTECTED] wrote:

 DRE,

 I agree that's some bad stuff. It looks like when I first started
 coding
 2 years ago.

 I would readLine() first

 Check Null true/false

 Enter the loop

 readLine again on the bottom of the loop

 End loop

 close() objects

 null them force gc()

 Look like this.

 cfset variable.line = java_io_LineNumberReader.readline()

 cfloop condition=#IsDefined(variable.line)#

 cfif find(findThis, variable.line) GT 0

 cfset variable.line = Replace(variable.line, 
 http://www.opticalalert.com/r.cfm?urlvalue=,,ONE;)
 cfset variable.line = Replace(variable.line, findThis, replacethis,
 ONE)

 cfset start = REFind([[:digit:]], variable.line, 1, true).pos[1]+5

 cfset some_text = left(variable.line,start)  ' target=new
 style=font:none;'

 cfset bigstring = bigstring  some_text

 cfelse
 cfset bigstring = bigstring  variable.line
 /cfif

 cfset variable.line = java_io_LineNumberReader.readline()

 /cfloop

 I had to do a big switch / remove text from all my pages. And this is
 inside
 another recursive loop.

 Big job.


 

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

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


Re: Cool things about cf

2006-11-13 Thread DRE
Nobody has any feedback?  I posted over the weekend and think I missed
everybody so here it is again.

http://increasetheknowledge.com/t-c9d22c37a5e3e708dc3971ac6_Coldfusion_out_of_the_box.html

DRE



On 11/11/06, Dan Plesse [EMAIL PROTECTED] wrote:

 I am interested to find out how other CFers do line by line search replace
 and the insert text like Dreamweaver does it.

 What do CF developers do if there is multiple steps are needed to change a
 html file for example.

 I guess they play with the whole html file as one big chunk of text and
 use
 the mid  replace functions.

 Does anyone use something else?


 

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

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


Re: Cool things about cf

2006-11-13 Thread DRE
ps, please respond directly [EMAIL PROTECTED]
DRE

On 11/13/06, DRE [EMAIL PROTECTED] wrote:

 Nobody has any feedback?  I posted over the weekend and think I missed
 everybody so here it is again.


 http://increasetheknowledge.com/t-c9d22c37a5e3e708dc3971ac6_Coldfusion_out_of_the_box.html

 DRE



 On 11/11/06, Dan Plesse  [EMAIL PROTECTED] wrote:
 
  I am interested to find out how other CFers do line by line search
  replace
  and the insert text like Dreamweaver does it.
 
  What do CF developers do if there is multiple steps are needed to change
  a
  html file for example.
 
  I guess they play with the whole html file as one big chunk of text and
  use
  the mid  replace functions.
 
  Does anyone use something else?
 
 
  

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

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


Re: Cool things about cf

2006-11-13 Thread DRE
Dan,
To do it line by line via Java, I've used java.io.FileReader and
java.io.BufferedReader. Theres plenty of info online and probably some cfc's
available that already do it.

However, in most cases, you can just turn the file into an array by using
listtoarray on the content from cffile then loop thru that array.

Make sure you use arrays as opposed to list structures, as its a fair bit
faster.

DRE

On 11/13/06, Dan Plesse [EMAIL PROTECTED] wrote:

 Yes I look it over and bookmarked it. I like this part In the case where
 you have a very large document, it is still fairly simple to use the
 underlying Java functionality to read documents in small increments and
 this was my question out to all CF Dev on how
 CF developers do this normally and maybe vote on the best method or
 methods.


 

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

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


Re: Cool things about cf

2006-11-11 Thread DRE
Grief these tutorials take forever to write!

If anybody wants to see what I've written and or give me some feedback, it
will be welcome.

http://increasetheknowledge.com/t-c9d22c37a5e3e708dc3971ac6_Coldfusion_out_of_the_box.html

Please respond directly to me at [EMAIL PROTECTED]

Also, please link to it if you have a coldfusion blog.

Thanks!

DRE

On 11/9/06, DRE [EMAIL PROTECTED] wrote:

 Thanks Bobby, I'll use that.

 On 11/8/06, Bobby Hartsfield [EMAIL PROTECTED] wrote:
 
  Here's a simple, useful example.
 
  cfscript
  function bhimginfo(imgfile){
  jFileIn = createObject(java,java.io.File).init(imgfile);
  ImageInfo = StructNew();
  ImageObject =
  createObject(java,javax.imageio.ImageIO).read(jFileIn);
 
  imageFile = CreateObject(java, java.io.File);
  imageFile.init(imgfile);
  sizeb = imageFile.length();
  sizekb = numberformat(sizeb / 1024, 9.99);
  sizemb = numberformat(sizekb / 1024, .99);
 
  bhImageInfo = StructNew();
   bhImageInfo.ImgWidth = ImageObject.getWidth();
  bhImageInfo.ImgHeight = ImageObject.getHeight();
  bhImageInfo.SizeB = sizeb;
  bhImageInfo.SizeKB = sizekb;
  bhImageInfo.SizeMB = sizemb;
  }
  /cfscript
 
 
  It will return image width, height, filesize (in bytes, kilobytes, and
  megabytes)
 
 
  -Original Message-
  From: DRE [mailto: [EMAIL PROTECTED]
  Sent: Wednesday, November 08, 2006 11:29 AM
  To: CF-Talk
  Subject: Re: Cool things about cf
 
  Ben,
  I've instantiated java before using cf but its not been all that simple.
  What would be a good example of a simple but very useful java
  instantiation
  suitable for a tutorial?
 
  DRE
 
  On 11/8/06, Ben Nadel [EMAIL PROTECTED] wrote:
  
   I looked through the other responses, and I might have missed it, but
   the ability to instantiate Java objects, call underlying Java methods,
   and write your own Java classes... That's pretty freakin' nifty.
  
  
   ..
   Ben Nadel
   Certified Advanced ColdFusion MX7 Developer
   www.bennadel.com
  
   Need ColdFusion Help?
   www.bennadel.com/ask-ben/
  
   -Original Message-
   From: DRE [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, November 07, 2006 7:01 PM
   To: CF-Talk
   Subject: Cool things about cf
  
   Hey, I'm writing a short article about the cool things that cf comes
   with that most others dont. I've got so far:
  
   qoq
   groupd output (Hey, I think its cool)
   charting
   cfdocument
  
   I'm thinking of adding a section on custom tags but not cfc's because
   you can write classes easily in most other languages.  Flash forms
  seem
   mostly annoying and I dont like cfform all that much.
  
   So, stuff that is very useful but only comes with cf.  Any others you
   can think of?  I'm sure there is much that I have'nt thought of.
  
   Thanks for the moment.
  
   --
   DRE
   www.webmachineinc.com
   www.theanticool.com
  
  
  
  
  
 
 
 
  

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

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


Re: Cool things about cf

2006-11-11 Thread DRE
Just keeping the non coldfusioners slightly confused.

DRE

On 11/11/06, Doug Brown [EMAIL PROTECTED] wrote:

   Category SubCategory Sub SubCategory Name Quantity
   Birds Large Vegetarian Ibis 3
   Birds Large Vegetarian Flamingo 8
   Birds Large Meatatarian Heron 2
   Birds Large Meatatarian Vulture 2
   Birds Small Vegetarian HummingBird 20
   Birds Small Vegetarian Sparow 1
   Birds Small Vegetarian Swallow 3
   Rodent Small Vegetarian Fieldmouse 6
   Rodent Medium Vegetarian Guinea Pig 2
   Rodent Medium Omnivore Rat 2



 Are meat eating birds really called Meatatarians? Too damn funny!! I
 thought
 everything was called carnivores that ate meat



 Doug B..

 - Original Message -

 From: DRE [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Saturday, November 11, 2006 1:07 PM
 Subject: Re: Cool things about cf


  Grief these tutorials take forever to write!
 
  If anybody wants to see what I've written and or give me some feedback,
 it
  will be welcome.
 
 

 http://increasetheknowledge.com/t-c9d22c37a5e3e708dc3971ac6_Coldfusion_out_of_the_box.html
 
  Please respond directly to me at [EMAIL PROTECTED]
 
  Also, please link to it if you have a coldfusion blog.
 
  Thanks!
 
  DRE
 
  On 11/9/06, DRE [EMAIL PROTECTED] wrote:
  
   Thanks Bobby, I'll use that.
  
   On 11/8/06, Bobby Hartsfield [EMAIL PROTECTED] wrote:
   
Here's a simple, useful example.
   
cfscript
function bhimginfo(imgfile){
jFileIn = createObject(java,java.io.File).init(imgfile);
ImageInfo = StructNew();
ImageObject =
createObject(java,javax.imageio.ImageIO).read(jFileIn);
   
imageFile = CreateObject(java, java.io.File);
imageFile.init(imgfile);
sizeb = imageFile.length();
sizekb = numberformat(sizeb / 1024, 9.99);
sizemb = numberformat(sizekb / 1024, .99);
   
bhImageInfo = StructNew();
 bhImageInfo.ImgWidth = ImageObject.getWidth();
bhImageInfo.ImgHeight = ImageObject.getHeight();
bhImageInfo.SizeB = sizeb;
bhImageInfo.SizeKB = sizekb;
bhImageInfo.SizeMB = sizemb;
}
/cfscript
   
   
It will return image width, height, filesize (in bytes, kilobytes,
 and
megabytes)
   
   
-Original Message-
From: DRE [mailto: [EMAIL PROTECTED]
Sent: Wednesday, November 08, 2006 11:29 AM
To: CF-Talk
Subject: Re: Cool things about cf
   
Ben,
I've instantiated java before using cf but its not been all that
 simple.
What would be a good example of a simple but very useful java
instantiation
suitable for a tutorial?
   
DRE
   
On 11/8/06, Ben Nadel [EMAIL PROTECTED] wrote:

 I looked through the other responses, and I might have missed it,
 but
 the ability to instantiate Java objects, call underlying Java
 methods,
 and write your own Java classes... That's pretty freakin' nifty.


 ..
 Ben Nadel
 Certified Advanced ColdFusion MX7 Developer
 www.bennadel.com

 Need ColdFusion Help?
 www.bennadel.com/ask-ben/

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 07, 2006 7:01 PM
 To: CF-Talk
 Subject: Cool things about cf

 Hey, I'm writing a short article about the cool things that cf
 comes
 with that most others dont. I've got so far:

 qoq
 groupd output (Hey, I think its cool)
 charting
 cfdocument

 I'm thinking of adding a section on custom tags but not cfc's
 because
 you can write classes easily in most other languages.  Flash forms
seem
 mostly annoying and I dont like cfform all that much.

 So, stuff that is very useful but only comes with cf.  Any others
 you
 can think of?  I'm sure there is much that I have'nt thought of.

 Thanks for the moment.

 --
 DRE
 www.webmachineinc.com
 www.theanticool.com





   
   
   
   
 
 

 

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

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


hello tags in tiny_mce?

2006-11-10 Thread DRE
Hi,
I'm using tiny_mce to edit text that sometimes contains tags, like hello
or cfoutput.  The first time thru it works but then I edit and it starts
vanishing. Anybody got any workarounds?

-- 
DRE
www.webmachineinc.com
www.theanticool.com


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

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


Re: Cool things about cf

2006-11-09 Thread DRE
Thanks Bobby, I'll use that.

On 11/8/06, Bobby Hartsfield [EMAIL PROTECTED] wrote:

 Here's a simple, useful example.

 cfscript
 function bhimginfo(imgfile){
 jFileIn = createObject(java,java.io.File).init(imgfile);
 ImageInfo = StructNew();
 ImageObject =
 createObject(java,javax.imageio.ImageIO).read(jFileIn);

 imageFile = CreateObject(java, java.io.File);
 imageFile.init(imgfile);
 sizeb = imageFile.length();
 sizekb = numberformat(sizeb / 1024, 9.99);
 sizemb = numberformat(sizekb / 1024, .99);

 bhImageInfo = StructNew();
 bhImageInfo.ImgWidth = ImageObject.getWidth();
 bhImageInfo.ImgHeight = ImageObject.getHeight();
 bhImageInfo.SizeB = sizeb;
 bhImageInfo.SizeKB = sizekb;
 bhImageInfo.SizeMB = sizemb;
 }
 /cfscript


 It will return image width, height, filesize (in bytes, kilobytes, and
 megabytes)


 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 08, 2006 11:29 AM
 To: CF-Talk
 Subject: Re: Cool things about cf

 Ben,
 I've instantiated java before using cf but its not been all that simple.
 What would be a good example of a simple but very useful java
 instantiation
 suitable for a tutorial?

 DRE

 On 11/8/06, Ben Nadel [EMAIL PROTECTED] wrote:
 
  I looked through the other responses, and I might have missed it, but
  the ability to instantiate Java objects, call underlying Java methods,
  and write your own Java classes... That's pretty freakin' nifty.
 
 
  ..
  Ben Nadel
  Certified Advanced ColdFusion MX7 Developer
  www.bennadel.com
 
  Need ColdFusion Help?
  www.bennadel.com/ask-ben/
 
  -Original Message-
  From: DRE [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, November 07, 2006 7:01 PM
  To: CF-Talk
  Subject: Cool things about cf
 
  Hey, I'm writing a short article about the cool things that cf comes
  with that most others dont. I've got so far:
 
  qoq
  groupd output (Hey, I think its cool)
  charting
  cfdocument
 
  I'm thinking of adding a section on custom tags but not cfc's because
  you can write classes easily in most other languages.  Flash forms seem
  mostly annoying and I dont like cfform all that much.
 
  So, stuff that is very useful but only comes with cf.  Any others you
  can think of?  I'm sure there is much that I have'nt thought of.
 
  Thanks for the moment.
 
  --
  DRE
  www.webmachineinc.com
  www.theanticool.com
 
 
 
 
 



 

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

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


Re: Cool things about cf

2006-11-08 Thread DRE
Ben,
I've instantiated java before using cf but its not been all that simple.
What would be a good example of a simple but very useful java instantiation
suitable for a tutorial?

DRE

On 11/8/06, Ben Nadel [EMAIL PROTECTED] wrote:

 I looked through the other responses, and I might have missed it, but
 the ability to instantiate Java objects, call underlying Java methods,
 and write your own Java classes... That's pretty freakin' nifty.


 ..
 Ben Nadel
 Certified Advanced ColdFusion MX7 Developer
 www.bennadel.com

 Need ColdFusion Help?
 www.bennadel.com/ask-ben/

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 07, 2006 7:01 PM
 To: CF-Talk
 Subject: Cool things about cf

 Hey, I'm writing a short article about the cool things that cf comes
 with that most others dont. I've got so far:

 qoq
 groupd output (Hey, I think its cool)
 charting
 cfdocument

 I'm thinking of adding a section on custom tags but not cfc's because
 you can write classes easily in most other languages.  Flash forms seem
 mostly annoying and I dont like cfform all that much.

 So, stuff that is very useful but only comes with cf.  Any others you
 can think of?  I'm sure there is much that I have'nt thought of.

 Thanks for the moment.

 --
 DRE
 www.webmachineinc.com
 www.theanticool.com




 

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

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


Re: Cool things about cf

2006-11-08 Thread DRE
Andy,
I learned a bunch of php lately and was stunned by this lack of application
scope as well.

I do think tho that .net and java both have similar structures so I'm a bit
wary of including it.

DRE

On 11/8/06, Andy Matthews [EMAIL PROTECTED] wrote:

 The Application scope, and Application.cfm/cfc.

 I was talking with my two co-workers who program in PHP which doesn't have
 anything like an Application scope.

 !//--
 andy matthews
 web developer
 certified advanced coldfusion programmer
 ICGLink, Inc.
 [EMAIL PROTECTED]
 615.370.1530 x737
 --//-

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 07, 2006 6:01 PM
 To: CF-Talk
 Subject: Cool things about cf


 Hey, I'm writing a short article about the cool things that cf comes with
 that most others dont. I've got so far:

 qoq
 groupd output (Hey, I think its cool)
 charting
 cfdocument

 I'm thinking of adding a section on custom tags but not cfc's because you
 can write classes easily in most other languages.  Flash forms seem mostly
 annoying and I dont like cfform all that much.

 So, stuff that is very useful but only comes with cf.  Any others you can
 think of?  I'm sure there is much that I have'nt thought of.

 Thanks for the moment.

 --
 DRE
 www.webmachineinc.com
 www.theanticool.com




 

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

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


Cool things about cf

2006-11-07 Thread DRE
Hey, I'm writing a short article about the cool things that cf comes with
that most others dont. I've got so far:

qoq
groupd output (Hey, I think its cool)
charting
cfdocument

I'm thinking of adding a section on custom tags but not cfc's because you
can write classes easily in most other languages.  Flash forms seem mostly
annoying and I dont like cfform all that much.

So, stuff that is very useful but only comes with cf.  Any others you can
think of?  I'm sure there is much that I have'nt thought of.

Thanks for the moment.

-- 
DRE
www.webmachineinc.com
www.theanticool.com


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

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


Re: Top 100 ColdFusion Programmers

2006-08-26 Thread DRE
Thats the truth!  I've been working on public sites lately and I'm just
bored to tears.

DRE

On 8/25/06, Ali Awan [EMAIL PROTECTED] wrote:

 I second that.
 In terms of SQL prowess being an indication of a developer's skills, some
 of the reporting I have done, requires an intense knowledge of SQL Server
 complex queries and Stored Procedures.  Something that your average HTML
 guru who just picked up teach yourself Coldfusion in 10 days, won't have any
 clue about.

 That being said, it's only in my work with intranets and extranets that I
 got more involved with Coldfusion, AJAX, JSON, XML, and dhtml, to a level
 that I hadn't with the jobs I had working on public sites.

 Ali
 Agreed. The intranets and back ends I do make full featured websites look
 like a joke.
 
 !k
 
 -Original Message-
 From: Ian Skinner [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 24, 2006 1:53 PM
 To: CF-Talk
 Subject: RE: Top 100 ColdFusion Programmers
 
 When they say the majority of their work is on intranets, extranets or
 reporting tools that may be an indication they're doing some pretty
 simple
 CF scripting. ...
 
 I have to object to this one.  I use more ColdFusion features working on
 this company's intranets and reporting tools then I even did creating a
 consumer based site.
 
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.

 

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

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


OT ? Sql View Weird Item?

2006-08-07 Thread DRE
Hi, I've run across this view in a sql 7 db.  Please note right after
the from clause, there looks like a table name before any of the join
parameters and lots of parenthesis in the same area. I've never seen
this and I couldnt find it in any of my sql books.  Can anybody share
any insight?  It seems to run in 7 but not in 2k?

DRE

SELECT item.itemID AS ProdID,
numOfBlank + itemName AS ProdName,
catalogCategoryGroup + ' - ' + catalogCategory AS ProdCat,
item.itemDesc AS ProdDesc,
CASE WHEN classCartPrice.priceList = NULL AND
itemCartPrice.priceList = NULL
THEN '0' ELSE CASE WHEN classCartPrice.priceList IS NULL
THEN itemCartPrice.priceList ELSE classCartPrice.priceList END
 END AS priceList,
CASE WHEN classCartPrice.memberPriceList = NULL AND
itemCartPrice.memberPriceList = NULL
THEN '0' ELSE CASE WHEN classCartPrice.memberPriceList IS NULL
 THEN itemCartPrice.memberPriceList ELSE classCartPrice.memberPriceList
 END END AS memberPriceList, 1 AS VendorID,
'Bradford Publishing' AS Vendor, item.dlvryType,
'' AS DlvryFmt, '' AS FilePath, '' AS FileName, '' AS FileSize,
0 AS ShipCost, 10 AS DaysToExp, 1 AS Taxable,
0 AS catDiscount, item.classID, class.class
FROM ((class RIGHT JOIN
 (catalogCategoryGroup RIGHT JOIN
((item LEFT JOIN
itemToCatalogCategory ON
item.itemID = itemToCatalogCategory.itemID) LEFT JOIN
catalogCategory ON
itemToCatalogCategory.catalogCategoryID = catalogCategory.catalogCategoryID)
 ON
catalogCategoryGroup.catalogCategoryGroupID =
catalogCategory.catalogCategoryGroupID)
 ON class.classID = item.classID) LEFT JOIN
classCartPrice ON class.classID = classCartPrice.classID) LEFT
JOIN
itemCartPrice ON item.itemID = itemCartPrice.itemID

-- 
DRE
www.webmachineinc.com
www.theanticool.com

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

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


HELP, sql 7 to 2k upgrade, least risk

2006-08-05 Thread DRE
Hey,
I have a client with an in house sql 7 db. I'm a bit afraid of trying
to upgrade them to 2k on this box and I'm in a bit of a hurry.  We're
moving them to a sql 2k hosted server.  The sql manager on this
computer is sql 7 and doesnt want to communicate with the sql 2k
server.  So, what are my options for quick risk free conversion?

I've thought of trying to dump it into an access database or even some
sort of flat file format and then importing that into another 2k
machine at a different location then uploading to the hosted 2k
server.  This seems vaguely excessive tho.

What are my other options?

THanks in advance.

-- 
DRE
www.webmachineinc.com
www.theanticool.com

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

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


Re: Cfmail cfmailparam outlook?

2006-04-25 Thread DRE
Lo and behold, there it is in the docs.  It is kind of funny that it takes
it as a cfmailparam tag and then adds a second xmailer line.

I'm still not receiving the blasted emails so I'm off to hunt for more
solutions.  Thanks for the help.

DRE

On 4/24/06, Mosh Teitelbaum [EMAIL PROTECTED] wrote:

 Andre:

 The MAILERID attribute needs to be in the CFMAIL tag, not in a CFMAILPARAM
 tag.  So your code should be something like:

 cfmail to=#form.email# #form.email#
 from=[EMAIL PROTECTED]
 subject=Brochure mimeattach=#request.sitemachineroot#docs/my.pdf
 server=#request.mailserver# type=HTML mailerid=Microsoft Outlook
 Express
 4.72.3110.5
 cfmailparam name=Reply-To value=[EMAIL PROTECTED]
 cfmailparam name=MIME-Version value=1.0..

 That is, add the MAILERID attribute to the CFMAIL tag and remove the
 equivalent CFMAILPARAM tag.

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


  -Original Message-
  From: DRE [mailto:[EMAIL PROTECTED]
  Sent: Monday, April 24, 2006 2:55 PM
  To: CF-Talk
  Subject: Re: Cfmail cfmailparam outlook?
 
 
  Thanks for taking the time.  Here it is.
 
  cfmail to=#form.email# #form.email#
  from=[EMAIL PROTECTED]
  subject=Brochure mimeattach=#request.sitemachineroot#docs/my.pdf
  server=#request.mailserver# type=HTML
  cfmailparam name=mailerid value=Microsoft Outlook Express
  4.72.3110.5
  cfmailparam name=Reply-To value=[EMAIL PROTECTED]
  cfmailparam name=MIME-Version value=1.0..
 
 
  On 4/24/06, Mosh Teitelbaum [EMAIL PROTECTED] wrote:
  
   Andre:
  
   Would you mind sending along the CFMAIL code (and all of the
  CFMAILPARAMs)
   so we could take a look at it?
  
   --
   Mosh Teitelbaum
   evoch, LLC
   Tel: (301) 942-5378
   Fax: (301) 933-3651
   Email: [EMAIL PROTECTED]
   WWW: http://www.evoch.com/
  
  
-Original Message-
From: DRE [mailto:[EMAIL PROTECTED]
Sent: Monday, April 24, 2006 1:42 PM
To: CF-Talk
Subject: Re: Cfmail cfmailparam outlook?
   
   
Al, Mosh,
I used the mailerid key as you suggested and still get two entries
   
X-Mailer: ColdFusion MX Application Server
X-Mailer: Microsoft Outlook Express 4.72.3110.5
   
Any other thoughts?
   
DRE
   
On 4/24/06, Damien McKenna  [EMAIL PROTECTED] wrote:

  I could be wrong, but I think his point was that he COULD
  send mail
   to
  Gmail, but it got filtered out in the junk mail folder every
 time.
  His assumption was that Gmail filtered his messages as
  spam because
   of
  their header.

 I know from the past that SpamAssassin can filter messages that
 have
 funky headers, e.g. duplicate headers (two X-Mailer lines,
  etc), so if
 he's incorrectly composing messages then it is entirely likely
 this
 could be happening.

 --
 Damien McKenna - Web Developer - [EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 #include stdjoke.h


   
   
  
  
 
 

 

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


Re: Uploading multiple files - not necessarily CF

2006-04-25 Thread DRE
If you dont mind ie, you could use an hta wrapper.  This effectively removes
any security limitations allowing you to script code that browses the
clients os.  I think it also allows you to prefill the input type=file...
value so that you can auto submit a dynamic form with the files you want to
upload.

It would be some fancy dhtml but all the pieces are there.

DRE

On 4/25/06, Mark Leder [EMAIL PROTECTED] wrote:

 www.aurigma.com

 Awesome Java tag - some of the best documentation I've seen anywhere.


 Thanks,
 Mark

 -Original Message-
 From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 25, 2006 3:05 PM
 To: CF-Talk
 Subject: RE: Uploading multiple files - not necessarily CF

 Alas, I spoke too soon. No, that's not going to work for me. The upload
 multiple files is simply 20 HTML file fields. No good.

 I might be able to use it for something else, but not for this project.

 -Original Message-
 From: Everett, Al (NIH/NIGMS) [C]
 Sent: Tuesday, April 25, 2006 3:00 PM
 To: CF-Talk
 Subject: RE: Uploading multiple files - not necessarily CF

 Looks promising, but may be more than I need/want. I certainly don't want
 the end users able to delete files or directories on the server.

 But I've just glanced at it. Thanks for the tip.


 -Original Message-
 From: Russ Michaels [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 25, 2006 2:37 PM
 To: CF-Talk
 Subject: Re: Uploading multiple files - not necessarily CF

 Checkout the CFFM (CF file Manager) by Rick root I think.
 Russ

 -Original Message-
 From: Rob Wilkerson [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Date: Tue, 25 Apr 2006 14:19:22 -0400
 Subject: Re: Uploading multiple files - not necessarily CF

  What about using DHTML?  Take a look at something like this:
 
  http://the-stickman.com/web-development/javascript/upload-multiple-fil
  e
  s-with-a-single-file-element/
 
  I've played with it a little bit and it looks pretty nice.  I have not

  used it in production, though, so it will require some testing.
 
  On 4/25/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED]
 wrote:
   I'm looking for a solution to this problem:
  
   For an intranet site, the end user should be able to select multiple

   files (or even a directory) located on his/her local machine, and
  press
   a single button to upload them to the server.
  
   We're a CF shop and I don't see a CF solution for this piece, but it

   needs to work with CF. Perhaps a Java applet? Maybe Flash? We'll
   certainly be using CF for the back-end processing of the files, but
  what
   is not desired is having the multiple html file form fields.
  
   This is for an intranet application with VERY tightly controlled
  browser
   and OS environments. Downloading a separate application is pretty
  much a
   non-starter; it needs to work in the browser window.
  
   Any pointers you can offer would be appreciated.
  
  
  
 
 





 

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


Cfmail cfmailparam outlook?

2006-04-24 Thread DRE
Hi,
I'm trying to send an email via cfmail and it keeps getting caught in
various spam catchers.  I cant seem to get into gmail for instance. I''ve
sent the same or similar emails via outlook and it always gets there. So,
I'm trying to mimic the email headers of outlook.

I've found this on the net.
cfmailparam name=X-Mailer value=Microsoft Outlook Express 4.72.3110.5
which I added. However, it doesnt overwrite the cfmail one. The header ends
up looking like this:
X-Mailer: ColdFusion MX Application Server
X-Mailer: Microsoft Outlook Express 4.72.3110.5

Anybody know of a way to overwrite this behavior so as to only get the
outlook one??

Also, the cfmailparam name=Message-Id
value=#createUUID()[EMAIL PROTECTED]

Seems to get ignored for the built in
Message-ID: [EMAIL PROTECTED]

I'm all ears for tips! and thanks in advance.

Andre


On 4/12/06, Andrew Grosset [EMAIL PROTECTED] wrote:

 I think this tag does:

 http://www.cftagstore.com/tags/cfxhttp5.cfm

  Scott Stewart wrote:
 
  CFFTP doesn't support Secure FTP, unfortunately.

 

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


Re: Cfmail cfmailparam outlook?

2006-04-24 Thread DRE
Al, Mosh,
I used the mailerid key as you suggested and still get two entries

X-Mailer: ColdFusion MX Application Server
X-Mailer: Microsoft Outlook Express 4.72.3110.5

Any other thoughts?

DRE

On 4/24/06, Damien McKenna [EMAIL PROTECTED] wrote:

  I could be wrong, but I think his point was that he COULD send mail to
  Gmail, but it got filtered out in the junk mail folder every time.
  His assumption was that Gmail filtered his messages as spam because of
  their header.

 I know from the past that SpamAssassin can filter messages that have
 funky headers, e.g. duplicate headers (two X-Mailer lines, etc), so if
 he's incorrectly composing messages then it is entirely likely this
 could be happening.

 --
 Damien McKenna - Web Developer - [EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 #include stdjoke.h

 

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


Re: Cfmail cfmailparam outlook?

2006-04-24 Thread DRE
Thanks for taking the time.  Here it is.

cfmail to=#form.email# #form.email# from=[EMAIL PROTECTED]
subject=Brochure mimeattach=#request.sitemachineroot#docs/my.pdf
server=#request.mailserver# type=HTML
cfmailparam name=mailerid value=Microsoft Outlook Express
4.72.3110.5
cfmailparam name=Reply-To value=[EMAIL PROTECTED]
cfmailparam name=MIME-Version value=1.0..


On 4/24/06, Mosh Teitelbaum [EMAIL PROTECTED] wrote:

 Andre:

 Would you mind sending along the CFMAIL code (and all of the CFMAILPARAMs)
 so we could take a look at it?

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


  -Original Message-
  From: DRE [mailto:[EMAIL PROTECTED]
  Sent: Monday, April 24, 2006 1:42 PM
  To: CF-Talk
  Subject: Re: Cfmail cfmailparam outlook?
 
 
  Al, Mosh,
  I used the mailerid key as you suggested and still get two entries
 
  X-Mailer: ColdFusion MX Application Server
  X-Mailer: Microsoft Outlook Express 4.72.3110.5
 
  Any other thoughts?
 
  DRE
 
  On 4/24/06, Damien McKenna [EMAIL PROTECTED] wrote:
  
I could be wrong, but I think his point was that he COULD send mail
 to
Gmail, but it got filtered out in the junk mail folder every time.
His assumption was that Gmail filtered his messages as spam because
 of
their header.
  
   I know from the past that SpamAssassin can filter messages that have
   funky headers, e.g. duplicate headers (two X-Mailer lines, etc), so if
   he's incorrectly composing messages then it is entirely likely this
   could be happening.
  
   --
   Damien McKenna - Web Developer - [EMAIL PROTECTED]
   The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
   #include stdjoke.h
  
  
 
 

 

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


Re: Outlook integration?

2005-10-07 Thread DRE
Thanks Cutter, I imagined it would be like this!

DRE

On 10/7/05, Cutter (CF-Talk) [EMAIL PROTECTED] wrote:

 Aw, come on now Damien. Why don't we give some good advice and possible
 recommendations, rather than off handedly trash DRE's client for poor
 program choices;)

 I do agree with Damien, Outlook is a very poor choice for this (or any
 other) type of application. That being said, what you ask is not
 entirely impossible. It really depends upon your client's internal
 architecture. Is your client using Exchange? Is their app an Exchange
 based app? Are they using a custom form Outlook application? Where is
 Outlook housed (client machine, server, etc.)? Is there currently
 scripting within Outlook to prevent double location bookings, or is this
 something you must build into the server side processing of your
 application?

 Having answered these questions, if you are still using Outlook, you'll
 want to look at the specs for vCal. You can find a great deal of
 information on programming for Outlook at 
 msdn.microsoft.comhttp://msdn.microsoft.com.
 Sue
 Mosher's slipstick.com http://slipstick.com has been a resource for
 Outlook developer's since
 the Office '97 days (she has also written several informative books).
 Doing a search, I see that she's expanded to OutlookCode.com. CFComet
 has always been a good resource for CF/MS Office integration as well
 (http://cfregex.com/cfcomet/outlook/ for outlook specific help). Chris
 Wigginton posted a vCal UDF library (http://www.cflib.org/udf.cfm?ID=385).

 I personally can't imagine why anyone would write a reservations or
 property management package based upon Outlook? But, then again, every
 music scheduling program (that I know of) for radio stations are built
 on top of Access databases (which may be part of the reason you hear the
 same 1,000 or so songs over and over again on most radio stations). In
 any event, I hope some of the above information assists you.

 Cutter

 Damien McKenna wrote:

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 
 Hi, I have a customer that has an app that manages properties. People
 can reserve rooms and auditoriums and or whatever is on various
 properties thru the site. He'd like to integrate it with outlook
 such that the location gets autmatically reserved.
 
 
 
 Please explain what the intention is regarding integrating with Outlook
 and whether Exchange Server would be part of the equation also.
 Outlook's calendar system is really quite atrocious, Microsoft have
 wasted several years of development time and it still doesn't do half of
 what Apple's iCal does for simple collaboration, so I'm really not sure
 you'll really be able to do anything.
 
 
 

 

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

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


Outlook integration?

2005-10-06 Thread DRE
Hi, I have a customer that has an app that manages properties. People can
reserve rooms and auditoriums and or whatever is on various propoerties thru
the site. He'd like to integrate it with outlook such that the location gets
autmatically reserved.

Anybody can give me an idea of how this happens? A birds eye view? Details?

Thanks!
--
DRE
www.webmachineinc.com http://www.webmachineinc.com
www.theanticool.com http://www.theanticool.com


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Idea for better hosting

2005-09-30 Thread DRE
Kerry,
Thats a rather extreme case but you would be slightly better off with the
load ballanced scheme. You'd have to set it off once on each balanced server
in very rapid succession to kill them all at the same time as opposed to
just once on the single server. Its vaguely likely but not guaranteed that
you'd get a new server each time depending on how the load balancing doles
out the requests so you might have to set it off 5 times to get each server
in a cluster of 3.

DRE

On 9/30/05, Kerry [EMAIL PROTECTED] wrote:

 some semi-ignorant questions from me:

 Here the really bad sites would hit each server 1/3 as hard
 What if I uploaded an infinite loop? wouldnt that still kill all three
 servers in turn?

 Does anyone know if setting the isolation to high in IIS will have any
 effect on the performance / memory of CF sites on a shared box? I guess
 IIS
 cant control the JVM, so no?



 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: 29 September 2005 22:09
 To: CF-Talk
 Subject: Re: Idea for better hosting


 Emmett,
 Some simple math where we're adding $ instead of things that arent
 addeable
 quantities like Coldfusion + Clustering + Affordable (WTF?).

 Consider x amount of sites that get y amount of hits and 3 servers to
 host.

 If youre a hosting company, you would split them across 3 servers.
 So, you've got 3 machines, 3 licences of coldfusion, 3 oses.

 Or, as I was suggesting, you have them all on 3 servers.
 So, you've got 3 machines, 3 licences of coldfusion, 3 oses and a load
 balancer.

 Here the really bad sites would hit each server 1/3 as hard because they
 are
 load balanced and you wouldnt get the possibility of randomly getting half
 of them on one server. So, the jrun error may not appear as often or very
 much at all and you'd generally have happier customers.

 I'm thinking that if this company http://powweb.com can do linux hosting
 like this for less than 8 dollars a month then that load balancer and the
 extra admin that you consider bizzare are probably quite acceptable costs.

 DRE

 On 9/29/05, Emmet McGovern [EMAIL PROTECTED] wrote:
 
  I hope I don't offend you but...
 
  We were talking about Coldfusion clustering. Take away Coldfusion and
 you
  can definitely find clustered hosting. And since were talking shared
  environments were also talking about affordable hosting.
 
  Coldfusion + Clustering + Affordable = Bizarre Dream World.
 
  -E
 
  -Original Message-
  From: DRE [mailto:[EMAIL PROTECTED]
  Sent: Thursday, September 29, 2005 11:01 AM
  To: CF-Talk
  Subject: Re: Idea for better hosting
 
  thought of this. So I searched for load balanced hosting and found
 588000
  results. Oops emmett, this bizzare dreamworld seems to occur in your
  world.
  ... .
 
  DRE
 
 
 
  On 9/29/05, DRE [EMAIL PROTECTED] wrote:
  
   Damn your insulting Emmett, Did you read my initial post? It would be
 a
   nice dreamworld if people read carefully.
  
   Have a nice day.
   DRE
 
 
 
 
 



 

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

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


Re: Idea for better hosting

2005-09-29 Thread DRE
Damn your insulting Emmett, Did you read my initial post? It would be a nice
dreamworld if people read carefully.

Have a nice day.
DRE

On 9/29/05, Snake [EMAIL PROTECTED] wrote:

 Yes you can.
 The Web Edition is a web server, thus the name. So it wont let you run
 certain other MS products such as SQL Server which require Windows 2003
 Server std. But it cannot stop installing any 3rd party product.


 Russ

 -Original Message-
 From: Joel Nath [mailto:[EMAIL PROTECTED]
 Sent: 29 September 2005 08:45
 To: CF-Talk
 Subject: RE: Idea for better hosting

 Hi,

 can you run CFMX on Windows Server 2003, Web Edition

 i was told you cant, that it doesnt support it ?


 -Original Message-
 From: Emmet McGovern [mailto:[EMAIL PROTECTED]
 Sent: Thursday, 29 September 2005 12:08 PM
 To: CF-Talk
 Subject: RE: Idea for better hosting


 The original post is set in some bizarre dream world. Clustering bad code
 just means bad code running on 3 servers.

 Let's look at the costs anyway. We'll cut corners when we can and look at
 sticky sessions on standard cf licenses too.

 ---WINDOWS---
 Servers x 3 $4200 - $6600
 Windows Server 2003, Standard Edition x3 $2,997
 CF Enterprise x3 $17,997
 ---
 TOTAL: $25,194 - $27,594

 Servers x 3 $4200 - $6600
 Windows Server 2003, Web Edition x3 $1,200
 CF Standard x3 $3,897
 ---
 TOTAL: $9,297 - $11,697

 ---LINUX---
 Servers x 3 $4200 - $6600
 Redhat Linux ES x3 $1,047
 CF Enterprise x3 $17,997
 ---
 TOTAL: $23,244 - $25,644

 Servers x 3 $4200 - $6600
 FEDORA x3 $FREE
 CF Standard x3 $3,897
 ---
 TOTAL: $8,097 - $10,497


 So you can budget for $8,097 - $27,594

 With 400 clients at $15-$30 a month you get $6,000 - $12,000 a month.
 I'm frickin RICH BIATCH! Lease me a BMW!

 except...
 Now you need a way to load balance.
 Hardware - $3000-$1
 Software NLB - $FREE

 Damn... Your rack is filling up fast. $1200-2000 per month per rack.
 Holy crap! We're out of room on the switch again. $600 File replication
 shut down again. Wheres Larry the tech? - $30-$80k salary $%#! CRC errors
 on the NLB!!! Where's Larry's brother Larry? $30-$80k yr Sally from
 Sallysellsseashells.com http://Sallysellsseashells.com can't get her
 mail. Support - $24-$35 yr These
 expenses are killing us. Where's Rich the sales guy? - $24k base YAY!!!
 Were growing! We need to hire some more people. 

 Shit. I just missed the lease payment on my BMW. DAMN YOU COLDFUSION


 Takin the bus to the office (if I could afford the office), Emmet









 

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

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


Re: Idea for better hosting

2005-09-29 Thread DRE
In my dreamworld, I suddenly realized that perhaps someone has already
thought of this. So I searched for load balanced hosting and found 588000
results. Oops emmett, this bizzare dreamworld seems to occur in your world.
.. .

DRE



On 9/29/05, DRE [EMAIL PROTECTED] wrote:

 Damn your insulting Emmett, Did you read my initial post? It would be a
 nice dreamworld if people read carefully.

 Have a nice day.
 DRE


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: Idea for better hosting

2005-09-29 Thread DRE
Emmett,
Some simple math where we're adding $ instead of things that arent addeable
quantities like Coldfusion + Clustering + Affordable (WTF?).

Consider x amount of sites that get y amount of hits and 3 servers to host.

If youre a hosting company, you would split them across 3 servers.
So, you've got 3 machines, 3 licences of coldfusion, 3 oses.

Or, as I was suggesting, you have them all on 3 servers.
So, you've got 3 machines, 3 licences of coldfusion, 3 oses and a load
balancer.

Here the really bad sites would hit each server 1/3 as hard because they are
load balanced and you wouldnt get the possibility of randomly getting half
of them on one server. So, the jrun error may not appear as often or very
much at all and you'd generally have happier customers.

I'm thinking that if this company http://powweb.com can do linux hosting
like this for less than 8 dollars a month then that load balancer and the
extra admin that you consider bizzare are probably quite acceptable costs.

DRE

On 9/29/05, Emmet McGovern [EMAIL PROTECTED] wrote:

 I hope I don't offend you but...

 We were talking about Coldfusion clustering. Take away Coldfusion and you
 can definitely find clustered hosting. And since were talking shared
 environments were also talking about affordable hosting.

 Coldfusion + Clustering + Affordable = Bizarre Dream World.

 -E

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 29, 2005 11:01 AM
 To: CF-Talk
 Subject: Re: Idea for better hosting

 thought of this. So I searched for load balanced hosting and found 588000
 results. Oops emmett, this bizzare dreamworld seems to occur in your
 world.
 ... .

 DRE



 On 9/29/05, DRE [EMAIL PROTECTED] wrote:
 
  Damn your insulting Emmett, Did you read my initial post? It would be a
  nice dreamworld if people read carefully.
 
  Have a nice day.
  DRE




 

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

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


Re: Idea for better hosting

2005-09-29 Thread DRE
Its an idea Emmet, the fact that no one is doing it with coldfusion yet is
the point!

Keep me posted Russ.

DRE

On 9/29/05, Russ [EMAIL PROTECTED] wrote:

 I came up with the same idea a few months ago, and we're currently in the
 process of setting up a cluster just like that. We are still beta testing
 it, but once it's ready, I will post an announcement to the list. We plan
 to keep our prices fairly low.

 Russ

 -Original Message-
 From: Emmet McGovern [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 29, 2005 6:11 PM
 To: CF-Talk
 Subject: RE: Idea for better hosting

 Actually don't. Topic closed.

 -Original Message-
 From: Emmet McGovern [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 29, 2005 5:49 PM
 To: CF-Talk
 Subject: RE: Idea for better hosting

 Powweb does not support coldfusion hosting. Find the one that does.







 

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

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


Idea for better hosting

2005-09-28 Thread DRE
Hey, I just had an idea for you guys working at hosting companies.

Instead of just running each site on one server where its depenedent on all
the other sites workign well, why not load balance between 2 or 3 servers.
If you think about it, it shouldnt cost more because you'd be able to put
twice as many sites on each machine because the load would be that
proportion smaller(other than the loadbalancer). If one goes south, then the
load balancing would work while you reboot the machine. All you'd have to do
is setup some sort of directory watching so that the user would only have to
maintain files on one machine. Presto, no more stupid the jrun service is
unavailable messages.

DRE

On 9/28/05, Taco Fleur [EMAIL PROTECTED] wrote:

 The idea works, I have it implemented in several places.
 Any more details as why it didn't work for you?

 Taco Fleur - Pacific Fox
 an industry leader with commercial IT experience since 1994 .
 http://www.pacificfox.com - Web Design and Development



  -Original Message-
  From: Matthew Small [mailto:[EMAIL PROTECTED]
  Sent: Thursday, 29 September 2005 6:58 AM
  To: CF-Talk
  Subject: RE: SQL row select?
 
 
  Not only the IN method work, but yours did not, at least on
  MSSQL. I tried it.
 
  Now that's not necessarily the most efficient solution
  around, but if you have millions and millions of records to
  parse through with CF, then you need a DBA to ensure proper
  indexing and all that jazz, so you can let him write it.
 
 
  Matthew Small
  Web Developer
  American City Business Journals
  704-973-1045
  [EMAIL PROTECTED]
 
 
  -Original Message-
  From: Taco Fleur [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, September 28, 2005 4:24 PM
  To: CF-Talk
  Subject: RE: SQL row select?
 
  I would not expect an answer like that from a proper DBA.
 
  Not sure if we are talking about MS SQL or MySQL, but the
  idea is to work with subqueries.
 
  SELECT *
  FROM (
  SELECT * TOP 20
  FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2
  FROM yourTable C
  ORDER BY C.yourOrderColumn ASC) B
  ORDER BY B.yourOrderColumn DESC ) A
  ORDER BY A.yourOrderColumn ASC
 
  Where 200 is for example the current row you are on and 20 is
  the number of records you want to retrieve. The idea is to
  first get TOP currentRow + numberOfRowToRetrieve Then order
  descending and get the top 20 Then order ascending and select all
 
  This way you only transfer from the DB over the network what
  you need to, and the query is not inefficient, especially if
  you got the right indexes.
 
  Now, its early here, so I might have made a mistake, but you
  get the general idea. I think the previous sample with IN
  does not work, especially not efficient.
 
 
  Taco Fleur - Pacific Fox
  an industry leader with commercial IT experience since 1994 .
  http://www.pacificfox.com - Web Design and Development
 
 
 
   -Original Message-
   From: Andy Matthews [mailto:[EMAIL PROTECTED]
   Sent: Thursday, 29 September 2005 2:25 AM
   To: CF-Talk
   Subject: RE: SQL row select?
  
  
   Here's a post from a DBA I'm friends with:
  
   QUOTE
   Just pull the entire query over to CF and use query of
   queries, to grab
   your paged row sets. I work with record sets of millions
   and it works
   very nicely.
   /QUOTE
  
   !//--
   andy matthews
   web developer
   ICGLink, Inc.
   [EMAIL PROTECTED]
   615.370.1530 x737
   --//-
  
   -Original Message-
   From: Greg Morphis [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, September 28, 2005 10:59 AM
   To: CF-Talk
   Subject: Re: SQL row select?
  
  
   Select top 50 * from table
   Where id not in
  
   ( select top 199 id from table
   order by date, alpha)
  
   order by date, alpha
  
   that works but what if you are paging through a million
   records as suggested before? wouldnt the inner query select
   the top 999,999 rows? IE
  
   Select top 50 * from table
   Where id not in
   (
   select top 99 id from table
   order by date, alpha
   )
   order by date, alpha
  
  
   I think thats what Mike K was talking about.
  
  
  
   On 9/28/05, Andy Matthews [EMAIL PROTECTED] wrote:
Did no one see this post? After reading, and re-reading the
   original
post, it looks like this simple SQL statement is the answer
   (assuming
that MSSQL supports the LIMIT clause:
   
SELECT *
FROM tablename
LIMIT #startrow#, #totalrecords#
   
or
   
SELECT *
FROM tablename
LIMIT 200, 50
   
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
   
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 8:57 AM
To: CF-Talk
Subject: RE: SQL row select?
   
   
I don't use MS SQL but doesn't it support the LIMIT keyword in the
SELECT statement?
   
SELECT *
FROM

Re: Idea for better hosting

2005-09-28 Thread DRE
Russ,
Certainly its not a good solution for access but by far the greatest point
of failure for most shared hosting sites I've seen is coldfusion running out
of resources. If we could stamp that out for everything but access and
filebased state managment, we'd be ahead. Or at least those of us who
sometimes develop sites that go on overextended shared hosts would be.

Any host that would do this would be at an instant competitive advantage
with minimal additional cost.

Taco,
Not aimed at you. I randomly used one of your messages and changed the
subject.

DRE

On 9/28/05, Russ [EMAIL PROTECTED] wrote:

 The problem with that would be where to put the database. If the database
 is an msaccess, or any other database running on the local machine, this
 could prove difficult. If it's a shared database on a different server,
 then that becomes the single point of failure.

 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, September 28, 2005 5:33 PM
 To: CF-Talk
 Subject: Idea for better hosting

 Hey, I just had an idea for you guys working at hosting companies.

 Instead of just running each site on one server where its depenedent on
 all
 the other sites workign well, why not load balance between 2 or 3 servers.
 If you think about it, it shouldnt cost more because you'd be able to put
 twice as many sites on each machine because the load would be that
 proportion smaller(other than the loadbalancer). If one goes south, then
 the
 load balancing would work while you reboot the machine. All you'd have to
 do
 is setup some sort of directory watching so that the user would only have
 to
 maintain files on one machine. Presto, no more stupid the jrun service is
 unavailable messages.

 DRE

 On 9/28/05, Taco Fleur [EMAIL PROTECTED] wrote:
 
  The idea works, I have it implemented in several places.
  Any more details as why it didn't work for you?
 
  Taco Fleur - Pacific Fox
  an industry leader with commercial IT experience since 1994 .
  http://www.pacificfox.com - Web Design and Development
 
 
 
   -Original Message-
   From: Matthew Small [mailto:[EMAIL PROTECTED]
   Sent: Thursday, 29 September 2005 6:58 AM
   To: CF-Talk
   Subject: RE: SQL row select?
  
  
   Not only the IN method work, but yours did not, at least on
   MSSQL. I tried it.
  
   Now that's not necessarily the most efficient solution
   around, but if you have millions and millions of records to
   parse through with CF, then you need a DBA to ensure proper
   indexing and all that jazz, so you can let him write it.
  
  
   Matthew Small
   Web Developer
   American City Business Journals
   704-973-1045
   [EMAIL PROTECTED]
  
  
   -Original Message-
   From: Taco Fleur [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, September 28, 2005 4:24 PM
   To: CF-Talk
   Subject: RE: SQL row select?
  
   I would not expect an answer like that from a proper DBA.
  
   Not sure if we are talking about MS SQL or MySQL, but the
   idea is to work with subqueries.
  
   SELECT *
   FROM (
   SELECT * TOP 20
   FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2
   FROM yourTable C
   ORDER BY C.yourOrderColumn ASC) B
   ORDER BY B.yourOrderColumn DESC ) A
   ORDER BY A.yourOrderColumn ASC
  
   Where 200 is for example the current row you are on and 20 is
   the number of records you want to retrieve. The idea is to
   first get TOP currentRow + numberOfRowToRetrieve Then order
   descending and get the top 20 Then order ascending and select all
  
   This way you only transfer from the DB over the network what
   you need to, and the query is not inefficient, especially if
   you got the right indexes.
  
   Now, its early here, so I might have made a mistake, but you
   get the general idea. I think the previous sample with IN
   does not work, especially not efficient.
  
  
   Taco Fleur - Pacific Fox
   an industry leader with commercial IT experience since 1994 .
   http://www.pacificfox.com - Web Design and Development
  
  
  
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, 29 September 2005 2:25 AM
To: CF-Talk
Subject: RE: SQL row select?
   
   
Here's a post from a DBA I'm friends with:
   
QUOTE
Just pull the entire query over to CF and use query of
queries, to grab
your paged row sets. I work with record sets of millions
and it works
very nicely.
/QUOTE
   
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
   
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 10:59 AM
To: CF-Talk
Subject: Re: SQL row select?
   
   
Select top 50 * from table
Where id not in
   
( select top 199 id from table
order by date, alpha)
   
order by date, alpha
   
that works but what if you are paging through

Re: Idea for better hosting

2005-09-28 Thread DRE
Mark, I know where the jrun message comes from, thanks but thats irrelevant.
Clients dont care why theres a jrun message. They just are pissed that there
is one and that there isnt a site.

Its an extremely competitive market and any differentiation can be the
difference between breaking even and making profit.

Just an idea.

DRE

On 9/28/05, Mark A Kruger [EMAIL PROTECTED] wrote:

 Plus - some of the code I have seen would have the potential of bringing
 down 2 servers for the price of 1. In addition, the margins on hosting are
 very small - and you just added extra admin :)

 -Mark

 P.S. When you get that JRUN message, don't blame the messenger - Usually
 it
 is either underdeveloped database programming or other poorly written
 code.



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


Re: RSS Parser

2005-09-26 Thread DRE
Not sure if its any use but I did something related. Its been available for
download for some time. Basically its a coldfusion equivalent of carp
wrapped in a cfc. You can check it out here.
http://webmachineinc.com/rss/countme.cfm. It works on all flavors of rss
that I could find and most atom.

DRE


On 9/25/05, Barney Boisvert [EMAIL PROTECTED] wrote:

 XSL'll only help you if you want to format the RSS in another text
 format, not if you want to rip it out for some other purpose (store in
 DB, or whatever).

 cheers,
 barneyb

 On 9/25/05, s. isaac dealey [EMAIL PROTECTED] wrote:
   Why would you need it? RSS is XML, you should be able to
   just write
   your own parser...
 
   Isaac: Unfortunately, there are rafts of broken
   syndication apps out there from authors who made the same
   assumption. :D
 
   RSS is a series of specifications, most of which come with
   all sorts of common practices baggage. (A number of
   which contradict one another.) If you don't know both
   specs and practices, you can't effectively write a generic
   parser. Particularly when you factor in Atom.
 
   Now, if you're just trying to make use of a single feed
   from a known, consistent producer, or if you're really,
   truly dedicated to diving into syndication minutiae, then
   rolling your own makes some sense. But I promise, it ain't
   simple. If it were, we wouldn't have spent two years
   building Atom 1.0.
 
  Well yeah, but I would expect there to be a good free free XSL sheet
 available _somewhere_ given the ubiquity of RSS.
 
 
  s. isaac dealey 954.522.6080
  new epoch : isn't it time for a change?
 
  add features without fixtures with
  the onTap open source framework
 

 --
 Barney Boisvert
 [EMAIL PROTECTED]
 360.319.6145
 http://www.barneyb.com/

 Got Gmail? I have 100 invites.

 

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

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


OT - js - determine which submit button was submitted?

2005-09-22 Thread DRE
Hi
Anybody know how to determine which submit button was pushed in a form with
multiple submit buttons in the onsubmit function in javascript?

ie

script
function me(){
what to write here to determine if its value 1 or 2?
}
/script
form onsubmt=return me()
input type=text name = me1
input type=submit name = me1 value=1
input type=submit name = me2 value=2
form

If you tell me to look in the form structure, then you didnt read the
question.

Thanks.
--
DRE
www.webmachineinc.com http://www.webmachineinc.com
www.theanticool.com http://www.theanticool.com


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


OT Free CFML version of Carp

2005-08-17 Thread DRE
Hi,
 I fiddled with trying to get carp running on a windows server and it
didnt seem to work so I redid some of carps functionality in cfml in
case anybody wants it.

Basically, you specify a rss feed and the cfc parses it and presents
it as a list of links and descriptions.  You specify how often the cfc
should reload the feed as opposed to using the cached version.

This is useful for search engine optimization so that your site
appears to change every day or so.  Additionally, some of the links
are very interesting.

It works on pretty much any rss feed and some atom feeds that are
valid.  It even tries to fix some xml that would otherwise be invalid.

I posted it here on my site.  http://webmachineinc.com/carpcfml.html.  

Have a great day!
DRE

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

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


SOT : Renamed : CFML RSS parser

2005-08-17 Thread DRE
Renamed the title as per Isaac.  Its not quite an aggregator. I'll
call it a parser.  Its main functionality is related to SEO, to
maintain active content on a site.

Hope you can use it Russ.
 
I posted it here on my site.  http://webmachineinc.com/carpcfml.html.
 
DRE

 Have a great day!
 DRE
 

On 8/17/05, Russ [EMAIL PROTECTED] wrote:
 I don't think this is very OT, and so far looks pretty good.  I was going to
 have to write something like this soon to have access to yahoo news feeds
 (and google news feeds when they release the rss feeds).
 
 Thanks for saving me the work :-)
 
 Russ
 
 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, August 17, 2005 2:05 PM
 To: CF-Talk
 Subject: OT Free CFML version of Carp
 

 
 
 

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

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


raw XML text of a node??

2005-08-13 Thread DRE
Hi, This amazes me. It seems there is no function to get the raw xml
component of a node?

See this code

cfsavecontent variable=me
me
what
divphello/p/div
/what
/me
/cfsavecontent

cfset me1 = xmlparse(me)

cfset nodes = xmlsearch(me1,//what)

cfdump var=#nodes[1]#

cfoutput#nodes[1].XMLText#/cfoutput

You can see in the cfdump the html text I want to extract
(divphello/p/div) but when I go to xmltext there is nothing
there.  It continues to treat it as xml and break it up into
structures.

Anybody know if theres a trick or missed function or do I have to go
to java and see if that implementation is more sophistocated?

DRE

On 8/11/05, Dawson, Michael [EMAIL PROTECTED] wrote:
 I wondered about that, too.  Thanks for clarifying.
 
 -Original Message-
 From: Ian Skinner [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 11, 2005 2:18 PM
 To: CF-Talk
 Subject: RE: FORM scope into SESSION
 
 IIRC I ran into that vary problem.  Session.form = form does indeed just
 create a reference and I believe it caused me problems.  Session.form =
 duplicate(form) does create a deep copy and is the solution I came to
 use, I believe.
 
 Sorry for the imprecise details.  Hectic day, oracle database not talk
 to my website, causing all sorts of problems.
 
 HTH
 
 

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

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


Re: raw XML text of a node??

2005-08-13 Thread DRE
Its not my xml.  I'm parsing a feed that I dont have control over.
DRE

On 8/13/05, Ewok [EMAIL PROTECTED] wrote:
 Wrap it with ![CDATA[]]
 
 Eg.
 
 me
 what![CDATA[divphello/p/div]/what
 /me
 
 -Original Message-
 From: Adrian Lynch [mailto:[EMAIL PROTECTED]
 Sent: Saturday, August 13, 2005 2:36 PM
 To: CF-Talk
 Subject: RE: raw XML text of a node??
 
 Throw a ToString() in there somewhere, see if that helps.
 
 Ade
 
 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: 13 August 2005 17:28
 To: CF-Talk
 Subject: raw XML text of a node??
 
 
 Hi, This amazes me. It seems there is no function to get the raw xml
 component of a node?
 
 See this code
 
 cfsavecontent variable=me
 me
 what
 divphello/p/div
 /what
 /me
 /cfsavecontent
 
 cfset me1 = xmlparse(me)
 
 cfset nodes = xmlsearch(me1,//what)
 
 cfdump var=#nodes[1]#
 
 cfoutput#nodes[1].XMLText#/cfoutput
 
 You can see in the cfdump the html text I want to extract
 (divphello/p/div) but when I go to xmltext there is nothing
 there.  It continues to treat it as xml and break it up into
 structures.
 
 Anybody know if theres a trick or missed function or do I have to go
 to java and see if that implementation is more sophistocated?
 
 DRE
 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/2005
 
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


farcry?

2005-07-19 Thread DRE
Hi,
I'm considering the farcry cms for a project but it appears that there
are only 3 plugins for the software and the site seems decidedly
barren.  Specifically, I need a polling/survey tool to go along with
it.

Anybody know anything?  

Thanks. DRE

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

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


OT sql with like as variable

2005-06-28 Thread DRE
Hey, I thought I had this down but I'm having a bit of a problem

Consider a table like so.
id, listofids
33,33,44,55,66
rr,rr,gg,cc,dd
xx,zz,ee,rr

I'm trying to get a list of all the records where the value of the
first is somewhere in the second.

I'm thinking
SELECT 
id,
listofids,
FROM 
table
WHERE 
CHARINDEX(id ,listofids)  0

Or perhaps 

SELECT 
id,
listofids
FROM 
gv_locations
WHERE 
',' + listofids + ',' LIKE '%' + id + '%'

But neither returns any records.

Any ideas?

Thanks. Andre


-- 
DRE
www.webmachineinc.com
www.theanticool.com

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

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


Re: OT sql with like as variable

2005-06-28 Thread DRE
Well, the ids are always 8 chars long so the commas arent really
neccessary.  I switched the fieldnames for easier readability and the
data structure is fixed.

However it just doesnt seem to work.

I wonder if the var char fieldlength has anything to do with it. . .  

Any other thoughts?
DRE

On 6/28/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
  SELECT
  id,
  listofids
  FROM
  gv_locations
  WHERE
  ',' + listofids + ',' LIKE '%' + id + '%'
 
  But neither returns any records.
 
  Any ideas?
 
 This would be the one I would use except, you need commas in your like
 statement...
 
 where ',' + listofids + ',' LIKE '%,' + id + ',%'
 
 the column names are horrid... assuming they're real column names...
 and the data structure is undesirable... But with or without the
 commas, I don't know why this query would produce zero records if the
 id is found in the listofids column -- I can't see any reason why it
 wouldn't return the appropriate records.
 
 s. isaac dealey 954.522.6080
 new epoch : isn't it time for a change?
 
 add features without fixtures with
 the onTap open source framework
 
 http://www.fusiontap.com
 http://coldfusion.sys-con.com/author/4806Dealey.htm
 
 
 

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

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


Re: OT sql with like as variable

2005-06-28 Thread DRE
Never mind. They've got three similar fields and I compared the wrong
ones.  [EMAIL PROTECTED]@#$% I cant bill them for my blond time now can I?
DRE

On 6/28/05, DRE [EMAIL PROTECTED] wrote:
 Well, the ids are always 8 chars long so the commas arent really
 neccessary.  I switched the fieldnames for easier readability and the
 data structure is fixed.
 
 However it just doesnt seem to work.
 
 I wonder if the var char fieldlength has anything to do with it. . .
 
 Any other thoughts?
 DRE
 
 On 6/28/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
   SELECT
   id,
   listofids
   FROM
   gv_locations
   WHERE
   ',' + listofids + ',' LIKE '%' + id + '%'
 
   But neither returns any records.
 
   Any ideas?
 
  This would be the one I would use except, you need commas in your like
  statement...
 
  where ',' + listofids + ',' LIKE '%,' + id + ',%'
 
  the column names are horrid... assuming they're real column names...
  and the data structure is undesirable... But with or without the
  commas, I don't know why this query would produce zero records if the
  id is found in the listofids column -- I can't see any reason why it
  wouldn't return the appropriate records.
 
  s. isaac dealey 954.522.6080
  new epoch : isn't it time for a change?
 
  add features without fixtures with
  the onTap open source framework
 
  http://www.fusiontap.com
  http://coldfusion.sys-con.com/author/4806Dealey.htm
 
 
  

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

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


WOT asp crap help

2005-06-23 Thread DRE
I'm sorry to sully this list with such a question but I think its
simple and basic but I cant quite find it on google.

I'm updating some older asp code from somewhere and 
this varialble Request.QueryString(mstr) sometimes appears.  I need
to set it in the asp code as opposed to actually putting it in the
query string but I cant seem to update or add the variable.  It says

Microsoft VBScript runtime error '800a01b6' 

Object doesn't support this property or method: 'Request.QueryString' 

Is there a way to set this as a variable in the code?
What do I do?

Thanks
DRE

On 6/23/05, Douglas Knudsen [EMAIL PROTECTED] wrote:
 a wild far out guess here...CFLDAP works on various LDAP platforms, eh? As
 we all know, everyone has their own interpretation of RFCs and such. Perhaps
 CFLDAP needs that other info to determine how to handle the results whilst
 translating them to a CF recordset. Just a far out guess
  Have you tried connecting with a POJO to see if this occurs?
  DK
 
  On 6/23/05, Mike Soultanian [EMAIL PROTECTED] wrote:
 
  Well, I have posted this question practically everywhere yet I have no
  answers and even worse, I really don't know where to go next. If there
  is someone that could recommend a support path, I would *really*
  appreciate it as this is causing big problems for me. Here are the
  details:
 
  When I run an LDAP query, Coldfusion is asking for a bunch of additional
  Java objects. I would hope that someone can help me explain it to my
  LDAP admin that it's normal, or at least what they are.
 
  Here's the LDAP query I'm trying to perform:
 
  cfldap action=query
  name=qCheckUsername
  server=#ldapserver#
  port=389
  attributes=uid
  maxrows=100
  start=cn=People,ou=school,dc=edu
  scope=subtree
  filter=(uid=#someuid#)
  username=uid=#myuserid#,cn=people,ou=school,dc=edu
  password=#mypassword#
 
  The problem that I'm having is instead of ColdFusion only asking for
  just the UID in the LDAP query, it is also asking for a bunch of other
  stuff. Take a look at what iPlanet shows in the logs:
 
  attrs=uid objectClass javaSerializedData javaClassName javaFactory
  javaCodebase javaReferenceAddress javaClassNames javaremotelocation
 
  Any idea why ColdFusion (and/or the java subsystem) is asking for all of
  those extra attributes? Know what they are? I really only need the uid.
  My LDAP admin is extremely tight and does not want to give access to
  those objects because he doesn't know what they are so unfortunately I
  can't get any info at all!
 
  So, I just need to figure out what those extra attributes are so then
  maybe I can convince him to allow CF to see them. Any help would be
  very much appreciated!
 
  Thanks,
  Mike
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


OT : sql server roles help

2005-05-25 Thread DRE
Hi,
I'm not that familiar with sql server but I've got a database that I
can connect to.  However, cf cant see a table.  I know this has to do
with roles and permissions and stuff like that but I just cant seem to
get it right.  Anybody got any tips?  Thanks.

-- 
DRE
www.webmachineinc.com
www.theanticool.com

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

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


Re: OT : sql server roles help

2005-05-25 Thread DRE
actually, if in the query. I give the table owners name before the
table. I can see it.  So somehow the login doesnt know enough to look
at the tables owner.  Hmm.  Anybody?

On 5/25/05, DRE [EMAIL PROTECTED] wrote:
 Hi,
 I'm not that familiar with sql server but I've got a database that I
 can connect to.  However, cf cant see a table.  I know this has to do
 with roles and permissions and stuff like that but I just cant seem to
 get it right.  Anybody got any tips?  Thanks.
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 


-- 
DRE
www.webmachineinc.com
www.theanticool.com

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

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


Re: OT : sql server roles help

2005-05-25 Thread DRE
Hmm, so how do I create a login thats the same as the table owner?

I tried the login wizard and used the same name as the table owner and
now have two users with the same name. Both seem to be the table
owners but neither seems to be a login!

I'm sure I'm close!  Thanks for any help in advance.

DRE


On 5/25/05, Dave Watts [EMAIL PROTECTED] wrote:
  actually, if in the query. I give the table owners name before the
  table. I can see it.  So somehow the login doesnt know enough to look
  at the tables owner.  Hmm.  Anybody?
 
 If the login is different from the actual table owner, you will have to
 specify the table owner within the table name reference.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


delimited file upload and parse with JAVA

2005-04-26 Thread DRE
Hi,
I need to upload a delimited file and parse it.  

Now I've done this countless times with the usual splitting on the
return charachters and then the tab chacachter.  However, I'm sick of
doing it

Now, I know that Java can do this and I know that I can call java
libraries to do this.  Has anybody done this?  Is there an existing
library that is included in the jre so that its available with
standard hosting packages?


Thanks
-- 
DRE
http://www.webmachineinc.com
http://www.theanticool.com

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

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


Re: delimited file upload and parse with JAVA

2005-04-26 Thread DRE
Ok, thats a good start!  
One more question.

Sometimes, a line item will look like this: 
hello,goodbye,today

How do I handle the quotes?  Is there  any java already created for this?

Thanks.

DRE

On 4/26/05, Adam Haskell [EMAIL PROTECTED] wrote:
 check out java.IO.FileReader and java.IO.BufferedReader
 basiaclly you create a filereader object then create a bufferedReader
 object by passing it the FileReader object then loop the
 bufferedReader...soemthing like this ( complete untested):
 cfscript
 FR = createObject('java','java.IO.FileReader').init(my_file_path.txt);
 BR = createObject('jaja','java.IO.BufferedReader').init(FR);
 
 while (BR.ready())
 {
 writeoutput(BR.readLine()+br);
 }
 BR.close()
 /cfscript
 
 That should get ya a start in the right direction.
 
 Adam H
 
 On 4/26/05, DRE [EMAIL PROTECTED] wrote:
  Hi,
  I need to upload a delimited file and parse it.
 
  Now I've done this countless times with the usual splitting on the
  return charachters and then the tab chacachter.  However, I'm sick of
  doing it
 
  Now, I know that Java can do this and I know that I can call java
  libraries to do this.  Has anybody done this?  Is there an existing
  library that is included in the jre so that its available with
  standard hosting packages?
 
  Thanks
  --
  DRE
  http://www.webmachineinc.com
  http://www.theanticool.com
 
 
 
 

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

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


Re: delimited file upload and parse with JAVA

2005-04-26 Thread DRE
Massimo, 
Thanks. THis may be what I'm looking for or I can get enough out of it
to do what I want.

ps. If you click on sample there appears to be an error on the page.

DRE

On 4/26/05, Adam Haskell [EMAIL PROTECTED] wrote:
 Off the top of my head I can't think of something in Java. I know of a
 perl library though ;) I imagine there is something (if not included
 in the JRE freely distributed) but like i said off the top of my head
 I can't recall a class to do that might checl Massimo's CFC didn't
 read the documentation for it but it looks like it pretty much does
 the same thing i posted...on it doesn;t use .ready() which I found odd
 :)
 
 Adam H
 
 On 4/26/05, DRE [EMAIL PROTECTED] wrote:
  Ok, thats a good start!
  One more question.
 
  Sometimes, a line item will look like this:
  hello,goodbye,today
 
  How do I handle the quotes?  Is there  any java already created for this?
 
  Thanks.
 
  DRE
 
  On 4/26/05, Adam Haskell [EMAIL PROTECTED] wrote:
   check out java.IO.FileReader and java.IO.BufferedReader
   basiaclly you create a filereader object then create a bufferedReader
   object by passing it the FileReader object then loop the
   bufferedReader...soemthing like this ( complete untested):
   cfscript
   FR = createObject('java','java.IO.FileReader').init(my_file_path.txt);
   BR = createObject('jaja','java.IO.BufferedReader').init(FR);
  
   while (BR.ready())
   {
   writeoutput(BR.readLine()+br);
   }
   BR.close()
   /cfscript
  
   That should get ya a start in the right direction.
  
   Adam H
  
   On 4/26/05, DRE [EMAIL PROTECTED] wrote:
Hi,
I need to upload a delimited file and parse it.
   
Now I've done this countless times with the usual splitting on the
return charachters and then the tab chacachter.  However, I'm sick of
doing it
   
Now, I know that Java can do this and I know that I can call java
libraries to do this.  Has anybody done this?  Is there an existing
library that is included in the jre so that its available with
standard hosting packages?
   
Thanks
--
DRE
http://www.webmachineinc.com
http://www.theanticool.com
   
   
  
  
 
 
 
 

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

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


cfx image?

2005-04-12 Thread DRE
Hi,
I've fiddled with some image manipulation tags and found some of them
to make jagged images on resize. Anybody know how good cfx image is at
resizing?

I previously used imagemagic which seems very good but the docs say it
doesnt work with mx because of issues with cfexecute. Anybody knows if
this is ok now?

Thanks!

-- 
DRE
http://www.webmachineinc.com
http://www.theanticool.com

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

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


Re: cfx image?

2005-04-12 Thread DRE
Nathan, 
the alagad site says imagemagic isnt so good with cfmx.  Are you on cfmx?

Brian,
Thanks, that works nicely and I can easily modify it to suite my
needs.  Question, have you every used the java stuff to write text
into an image?

Scott, 
195$!  Gasp!  I'm competing with php.  

Thanks for all the great responses. I wont waste my time with cfx image.
DRE


On Apr 12, 2005 2:19 PM, Nathan Strutz [EMAIL PROTECTED] wrote:
 Imagemagick works great, I recommend it. CFExecute doesn't have any
 problems that I know about, it works like a dream.
 
 Also alagad  tmt image cfcs are great, also recommended  works
 natively, which is cool for coding.
 
 Imagemagick has the bonus ability to read nearly any image type ever
 conceived and turn it into any other one. It's great.
 
 -nathan strutz
 http://www.dopefly.com/
 
 
 DRE wrote:
  Hi,
  I've fiddled with some image manipulation tags and found some of them
  to make jagged images on resize. Anybody know how good cfx image is at
  resizing?
 
  I previously used imagemagic which seems very good but the docs say it
  doesnt work with mx because of issues with cfexecute. Anybody knows if
  this is ok now?
 
  Thanks!
 
 
 

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

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


Re: cfx image?

2005-04-12 Thread DRE
Got any code samples?  mountaingoat ampersand gmail.com. Either way,
thanks for the info.

On 4/12/05, Nathan Strutz [EMAIL PROTECTED] wrote:
 I'm on cfmx 6.1. If there were issues with cfmx  cfexecute, it was
 probably cfmx 6.0, before updater 3 (aka, a very long time ago).
 
 Alagad had an imagemagick custom tag, it was never very good. It is 99%
 easier and more efficient to run cfexecute directly instead of going
 through their tags.
 
 The docs on the imagemagick site are easy to follow (but sparse in
 examples). Most commands are the same as you'd find in photoshop, but
 processing is a fair amount faster.
 
 
 DRE wrote:
  Nathan,
  the alagad site says imagemagic isnt so good with cfmx.  Are you on cfmx?
 
  Brian,
  Thanks, that works nicely and I can easily modify it to suite my
  needs.  Question, have you every used the java stuff to write text
  into an image?
 
  Scott,
  195$!  Gasp!  I'm competing with php.
 
  Thanks for all the great responses. I wont waste my time with cfx image.
  DRE
 
 
  On Apr 12, 2005 2:19 PM, Nathan Strutz [EMAIL PROTECTED] wrote:
 
 Imagemagick works great, I recommend it. CFExecute doesn't have any
 problems that I know about, it works like a dream.
 
 Also alagad  tmt image cfcs are great, also recommended  works
 natively, which is cool for coding.
 
 Imagemagick has the bonus ability to read nearly any image type ever
 conceived and turn it into any other one. It's great.
 
 -nathan strutz
 http://www.dopefly.com/
 
 
 DRE wrote:
 
 Hi,
 I've fiddled with some image manipulation tags and found some of them
 to make jagged images on resize. Anybody know how good cfx image is at
 resizing?
 
 I previously used imagemagic which seems very good but the docs say it
 doesnt work with mx because of issues with cfexecute. Anybody knows if
 this is ok now?
 
 Thanks!
 
 
 
 
 
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


cfc security

2005-04-07 Thread DRE
Hi, I'm fiddling with cfcs and noting that I can get all the details
by calling the page in my browser. I know this is good for webservices
but if I'm making the whole thing with cfcs, this presents a security
problem.  How would I make them unavailable?

ALso, I've noticed that if I have a request varialbe call in the cfc,
it throws an errror. .. Hmm.

DRE

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

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


plum missing mscoree.dll

2005-03-29 Thread DRE
Hi,
I'm checking out the plum ide and it doesnt load right. It gives an
error saying it cant find the file mscoree.dll on the server.

if someone is using plum, can you forward me the dll.  Of if there is
a known workaround, let me know.

Thanks.
DRE

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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


Re: Sloppy - Yahoo! Slurp throwing CFerrors

2005-02-22 Thread DRE
If you know that your id must be numeric as in your example, then why
not clean out any non numeric chars before you do anything.  That
should remove any extraneous crap added by slurp.

cfset url.id = rereplace([^0-9],url.id,,all)

Or something like that.


On Mon, 21 Feb 2005 14:31:50 -0500, Dave Watts [EMAIL PROTECTED] wrote:
  Does anyone else see CFerrors from Yahoo's spider / bot
  Slurp? We monitor all CFerrors that are generated on our
  servers. It seems that Yahoo! Slurp is responsible for over
  60% of the errors per week that are thrown by our production
  webservers. It looks like Slurp is appending almost random
  values to the query strings. id=5%E2%84%91=2 or  it may
  append an old URL var that has not been used for years like
  view=archive. (This one throws a CF_SQL_NUMERIC error
  now.)  Does anyone know of a way I can get Slurp to stop
  hitting these pages with invalid URL vars? And still keep
  Slurp indexing the site normaly?
 
 robots.txt?
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

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

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


Re: Any sites using the new Flash foms?

2005-02-21 Thread DRE
Anybody using these stupendous dhtml libraries that rival the
functionality and ease of flashforms?  I'd be interested in a link.
Thanks.
DRE


On Mon, 21 Feb 2005 10:51:39 +1100, Stephen Cowling
[EMAIL PROTECTED] wrote:
 Does anyone know if Macromedia have plans to allow skinning of the
 flash forms?
 ie. I agree with others who say they won't mesh with existing html forms
 in the UI. So why can't we skin the flash forms to look like HTML??
 
 I'd be all over flash forms if this happens. As it is, I'll be heading
 towards the XML forms and writing some custom XSL.
 
 Cheers
 Steve
 
 Irvin Gomez wrote:
  Links appreciated.
 
  Hard to believe, but I couldn't find any samples (or demos)of the actual 
  forms at the Macromedia site. (I'm not talking about their flash demos - 
  I'm talking about actual forms that can be submitted). I'm mostly 
  interested in how quickly they load, because they seem VERY slow on my 
  development machine.
 
  Thanks!
 
 
 
 

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

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


OT sql2000 : deleted and inserted tables and triggers uhhhh?

2004-12-09 Thread DRE
Hi,
I'm trying to make a trigger that checks to see if some fields were
updated and then does some thing if they were.

I've tried using the updated function which seems to just check if the
fields were in the update statement as opposed to checking to see if
the fields were actually changed.  I think anyway.

So, I'm thinking I have to use the deleted and inserted magic tables.

Is there an easy way to write a statment that checks if the value was
changed?  I guess I'm looking for some nice syntax.



-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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


Re: Tab delimited file upload Barf

2004-12-03 Thread DRE
Anybody know of any good php lists like this one?
DRE


On Thu, 2 Dec 2004 19:00:23 -0800, DRE [EMAIL PROTECTED] wrote:
 Hmm, That is an interesting solution.  Actually, I'm experiementing in
 php with this item.  I just figured the solution would translate
 easily.  Can you think of any other ways?
 
 DRE
 
 
 
 On Thu, 2 Dec 2004 17:57:17 -0600, jw [EMAIL PROTECTED] wrote:
  DRE,
 
  here is a function that I use to turn csv files into query objects.
  It is dependent on MX and this jar file ostermillerutils_1_04_00.jar
  http://ostermiller.org/utils/CSV.html
 
  It isn't the cleanest in spots, but works flawlessly with excel.
 
 cffunction name=CSV2Query returntype=query hint=convert a CSV
  file into a query object
 cfargument name=file required=true type=string 
  hint=the full
  path of the csv file /
 cfargument name=csvExporter required=true type=string
  default=excel hint=valid value is: excel, standard /
 cfargument name=heading required=false default=false
  type=boolean hint=identify whether the csv has headers/
 
 !--- read in the csv file and parse it. ---
 cffile action=read file=#arguments.file# 
  variable=csvdata /
 
 cfif lcase(trim(arguments.csvExporter)) EQ excel 
 cfscript
 csvinput = CreateObject(java, 
  java.io.StringReader);
 csvinput.init(csvdata);
 csvparse = 
  CreateObject(java,com.Ostermiller.util.ExcelCSVParser);
 results = csvparse.parse(csvinput);
 /cfscript
 cfelse
 cfscript
 csvinput = CreateObject(java, 
  java.io.StringReader);
 csvinput.init(csvdata);
 csvparse = 
  CreateObject(java,com.Ostermiller.util.CSVParser);
 results = csvparse.parse(csvinput);
 /cfscript
 /cfif
 
 !--- set up the column hearders ---
 cfset firstRow_array=results[1] /
 cfset column_header_list=  /
 cfif arguments.heading eq true
 !--- get the column headers and transfer them into 
  valid query
  column headers: using underline ---
 cfloop from=1 to=#ArrayLen(firstRow_array)# 
  index=i 
 cfset myHeader=trim(firstRow_array[i]) /
 cfset 
  myHeader=REReplaceNoCase(myHeader,[^A-Z0-9]+ , _, ALL) /
 cfif i eq 1
 cfset 
  column_header_list=column_header_listmyHeader /
 cfelse
 cfset 
  column_header_list=column_header_list,myHeader /
 /cfif
 /cfloop
 cfset startRow=2 
 cfelse
 cfloop from=1 to=#ArrayLen(firstRow_array)# 
  index=i 
 cfif i eq 1
 cfset 
  column_header_list=column_header_listcolumn_1 /
 cfelse
 cfset 
  column_header_list=column_header_list,column_#i# /
 /cfif
 /cfloop
 cfset startRow=1 
 /cfif
 !--- create a new query ---
 cfset csvQuery = QueryNew(#column_header_list#) /
 
 !--- populate the query with the data from the input csv 
  ---
  cfloop from=#startRow# to=#ArrayLen(results)# 
  index=i 
  cfset QueryAddRow(csvQuery)
  cfset myRecord=results[i] /
 cfloop  from=1 to=#ArrayLen(myRecord)# 
  index=j 
cfset columnName=ListGetAt(column_header_list, 
  j) /
cfset QuerySetCell(csvQuery, 
  columnName,myRecord[j]) /
 /cfloop
 /cfloop
 cfreturn csvQuery /
 /cffunction
 
 
 
 
  On Thu, 2 Dec 2004 15:36:31 -0800, DRE [EMAIL PROTECTED] wrote:
   Hi,
   I've been tasked to do a file upload item.  However, the data isnt
   quite as nice as I would like in this way.  Heres an example.  See my
   \t as a tab value.
  
   joe\tfred\tme
   john\thello
   this is a great piece of text\tfred
  
   Actually, its in excel like this and I turn it to .txt.  Is there a
   way to escape all the returns and such in excel or perhaps a way to
   deal with it?
  
   DRE
  
   --
   DRE
   www.webmachineinc.com
   www.theanticool.com

Tab delimited file upload Barf

2004-12-02 Thread DRE
Hi, 
I've been tasked to do a file upload item.  However, the data isnt
quite as nice as I would like in this way.  Heres an example.  See my
\t as a tab value.

joe\tfred\tme
john\thello
this is a great piece of text\tfred

Actually, its in excel like this and I turn it to .txt.  Is there a
way to escape all the returns and such in excel or perhaps a way to
deal with it?

DRE

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

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


Re: Tab delimited file upload Barf

2004-12-02 Thread DRE
Hmm, That is an interesting solution.  Actually, I'm experiementing in
php with this item.  I just figured the solution would translate
easily.  Can you think of any other ways?

DRE

On Thu, 2 Dec 2004 17:57:17 -0600, jw [EMAIL PROTECTED] wrote:
 DRE,
 
 here is a function that I use to turn csv files into query objects.
 It is dependent on MX and this jar file ostermillerutils_1_04_00.jar
 http://ostermiller.org/utils/CSV.html
 
 It isn't the cleanest in spots, but works flawlessly with excel.
 
cffunction name=CSV2Query returntype=query hint=convert a CSV
 file into a query object
cfargument name=file required=true type=string 
 hint=the full
 path of the csv file /
cfargument name=csvExporter required=true type=string
 default=excel hint=valid value is: excel, standard /
cfargument name=heading required=false default=false
 type=boolean hint=identify whether the csv has headers/
 
!--- read in the csv file and parse it. ---
cffile action=read file=#arguments.file# 
 variable=csvdata /
 
cfif lcase(trim(arguments.csvExporter)) EQ excel 
cfscript
csvinput = CreateObject(java, 
 java.io.StringReader);
csvinput.init(csvdata);
csvparse = 
 CreateObject(java,com.Ostermiller.util.ExcelCSVParser);
results = csvparse.parse(csvinput);
/cfscript
cfelse
cfscript
csvinput = CreateObject(java, 
 java.io.StringReader);
csvinput.init(csvdata);
csvparse = 
 CreateObject(java,com.Ostermiller.util.CSVParser);
results = csvparse.parse(csvinput);
/cfscript
/cfif
 
!--- set up the column hearders ---
cfset firstRow_array=results[1] /
cfset column_header_list=  /
cfif arguments.heading eq true
!--- get the column headers and transfer them into 
 valid query
 column headers: using underline ---
cfloop from=1 to=#ArrayLen(firstRow_array)# 
 index=i 
cfset myHeader=trim(firstRow_array[i]) /
cfset 
 myHeader=REReplaceNoCase(myHeader,[^A-Z0-9]+ , _, ALL) /
cfif i eq 1
cfset 
 column_header_list=column_header_listmyHeader /
cfelse
cfset 
 column_header_list=column_header_list,myHeader /
/cfif
/cfloop
cfset startRow=2 
cfelse
cfloop from=1 to=#ArrayLen(firstRow_array)# 
 index=i 
cfif i eq 1
cfset 
 column_header_list=column_header_listcolumn_1 /
cfelse
cfset 
 column_header_list=column_header_list,column_#i# /
/cfif
/cfloop
cfset startRow=1 
/cfif
!--- create a new query ---
cfset csvQuery = QueryNew(#column_header_list#) /
 
!--- populate the query with the data from the input csv ---
 cfloop from=#startRow# to=#ArrayLen(results)# index=i 
 cfset QueryAddRow(csvQuery)
 cfset myRecord=results[i] /
cfloop  from=1 to=#ArrayLen(myRecord)# index=j 
   cfset columnName=ListGetAt(column_header_list, j) 
 /
   cfset QuerySetCell(csvQuery, 
 columnName,myRecord[j]) /
/cfloop
/cfloop
cfreturn csvQuery /
/cffunction
 
 
 
 
 On Thu, 2 Dec 2004 15:36:31 -0800, DRE [EMAIL PROTECTED] wrote:
  Hi,
  I've been tasked to do a file upload item.  However, the data isnt
  quite as nice as I would like in this way.  Heres an example.  See my
  \t as a tab value.
 
  joe\tfred\tme
  john\thello
  this is a great piece of text\tfred
 
  Actually, its in excel like this and I turn it to .txt.  Is there a
  way to escape all the returns and such in excel or perhaps a way to
  deal with it?
 
  DRE
 
  --
  DRE
  www.webmachineinc.com
  www.theanticool.com
 
 
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription

email to fax?

2004-11-23 Thread DRE
Hi, I have a client that wants a super simple shopping cart that
consists of a form that sends to a fax.  Is there a secure way to
throw a credit card to a fax machine?

Thanks.

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: email to fax?

2004-11-23 Thread DRE
Yup, they are cheap.  Just a little flower shop trying to automate
life a little bit.

Hmm.  Anybody know of any low hassle online services I could use just
for the credit card portion?

DRE


On Tue, 23 Nov 2004 14:32:13 -0500, Katz, Dov B (IT)
[EMAIL PROTECTED] wrote:
 I recommend:
 
 Pre-auth via a payment gateway  (AUTH_ONLY)
 Send a fax via email (faxaway.com) to the fax number desired
 In the fax, include the Order#, the Auth Code, and TransactionID#
 
 Then when you process the faxed order, try to issue PRIOR_AUTH_CAPTURE
 with a payment gateway using the AuthCode and TransID.  This will
 complete the payment process, and never reveal a CC # in either your DB
 or the Fax.
 
 -Dov
 
 
 
 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 23, 2004 1:57 PM
 To: CF-Talk
 Subject: Re: email to fax?
 
 No that I've ever heard ofsame as telling someone your CC num over
 the phone...anybody could be listening in (or picking up the fax if in
 an office
 environment) ;-)
 
 If simple is the name of the game...
 
 1) stick order in DB using SSL
 2) send client and e-mail with a link or a text message that a new order
 has been placed
 3) client logs into simple backend to retrieve order details over SSL
 
 This way the CC num is always transmitted securely.
 
 The BIG problem with this simple process is that CC numbers would be
 stored in the DB (even if only temporarily)and that's just plain bad
 IMHO.  The cc companies would also love to get their hands on it and
 perform a rather expensive security audit to varify you are doing things
 correctly)
 
 Sounds like someone doesn't want to pay for a real system and doesn't
 care about client cc number protection...bad client...BAD ;-)
 
 HTH
 
 Cheers
 
 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 phone: 250.480.0642
 fax: 250.480.1264
 cell: 250.920.8830
 e-mail: [EMAIL PROTECTED]
 web: www.electricedgesystems.com54
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


encryption issue

2004-11-22 Thread DRE
Hi,
I'm hosting a site on cfdynamics and my client requires that I store
credit card numbers in the database.  Certainly I want to encrypt
them. I asked them if they could install either pgp8 or gnuPG.  And
they said they wouldnt install either.  So, I asked them what they
would recomend and they said not to encrypt them!  :-0!!!

Does anybody have any recomendations?

DRE

See here for more info.
http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106viewName=Exchange%20Search%20Detailsauthorid=62617416page=0scrollPos=0subcatid=0snid=sn106itemnumber=4extid=1010167catid=0

or
http://www.sys-con.com/story/?storyid=46359DE=1#RES

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: encryption issue

2004-11-22 Thread DRE
Well, its setup so that the site owner can come back and download the
data and import it into another program that will do later credit card
billing.  So, effectively, I have to store the credit card info so she
can dl it.

DRE


On Mon, 22 Nov 2004 16:53:37 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
 Only store the last 3 digits and the validation number? :)
 
 Micha Schopman
 Software Engineer
 
 Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
 Tel 033-4535377, Fax 033-4535388
 KvK Amersfoort 39081679, Rabo 39.48.05.380
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: encryption issue

2004-11-22 Thread DRE
Let me make myself clearer.  

Ideally, I want a public private key so that only the public key is on
the server. Then when the owner wants to download her data, she types
in her private key which goes to a cookie, so, its never stored on the
server which is then used to decrypt the data.

DRE


On Mon, 22 Nov 2004 11:06:40 -0500, Burns, John D
[EMAIL PROTECTED] wrote:
 It depends on how secure you're trying to make it.  If you're just
 trying to avoid casual passersby from getting to it, you could use
 encrypt() and decrypt() with a seed to make it so it's not just readable
 directly from the DB. Not sure if that helps.
 
 John
 
 
 
 -Original Message-
 From: DRE [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 22, 2004 10:46 AM
 To: CF-Talk
 Subject: encryption issue
 
 Hi,
 I'm hosting a site on cfdynamics and my client requires that I store
 credit card numbers in the database.  Certainly I want to encrypt them.
 I asked them if they could install either pgp8 or gnuPG.  And they said
 they wouldnt install either.  So, I asked them what they would recomend
 and they said not to encrypt them!  :-0!!!
 
 Does anybody have any recomendations?
 
 DRE
 
 See here for more info.
 http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn10
 6viewName=Exchange%20Search%20Detailsauthorid=62617416page=0scrollPo
 s=0subcatid=0snid=sn106itemnumber=4extid=1010167catid=0
 
 or
 http://www.sys-con.com/story/?storyid=46359DE=1#RES
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: encryption issue

2004-11-22 Thread DRE
Marvelous!  I think thats exactly what I'm looking for.  Thanks Matt!

I think standard ssl for downloading to the user should be enough no? 
How she secures her workstation is not my problem.

I was indeed a bit surprised at cfdynamics response to my encryption
question but they are supposed to be gods gift to cf hosting!  At
least according to some members of this list(I was also surprised to
get zero tech support over the weekend).  They say they will work with
cfx tags so I'm hoping not to have an issue uploading it.

We'll see.

DRE


On Mon, 22 Nov 2004 13:29:18 -0800, Matt Robertson
[EMAIL PROTECTED] wrote:
 cfx_textcrypt does that for a very reasonable fee.  I think its $40
 per server.  However if your host is behaving as you describe then it
 sounds like you want to also find a new host.
 
 Downloading that data and maintaining security is going to be fun.
 How are you planning on sending the data securely down to the user?
 
 http://developer.perthweb.com.au/
 
 --
 --Matt Robertson--
 President, Janitor
 MSB Designs, Inc.
 mysecretbase.com
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: payment gateway question

2004-11-17 Thread DRE
nobody every heard of them?


On Tue, 16 Nov 2004 15:18:56 -0800, DRE [EMAIL PROTECTED] wrote:
 Hi, I have a client who wants to run credit cards thru a processor /
 gateway called WorkSmartPros.com who uses Cornerstone as their
 Merchant processor.
 
 Anybody got any feedback on these people and how easy it is to deal
 with their system, uptime, etc?
 
 Or perhaps I should be asking for best recomendations.  She seems to
 think that authorize.net is more expensive.
 
 Thanks.
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 


-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


payment gateway question

2004-11-16 Thread DRE
Hi, I have a client who wants to run credit cards thru a processor /
gateway called WorkSmartPros.com who uses Cornerstone as their
Merchant processor.

Anybody got any feedback on these people and how easy it is to deal
with their system, uptime, etc?

Or perhaps I should be asking for best recomendations.  She seems to
think that authorize.net is more expensive.

Thanks.

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


OT sql2k question

2004-11-11 Thread DRE
Hi,
I've noted that the text fields in sql 2000 only go out to 8000 chars.
 Is there a means to increase this?

A good resource for these questions would be great as well.

Thanks. 

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: OT sql2k question

2004-11-11 Thread DRE
Dooh! I was mislead by the number next to text in the table design
area. I thought that was the max size, it only shows 16!

Thanks

DRE


On Thu, 11 Nov 2004 15:06:08 -0500, Ben Doom [EMAIL PROTECTED] wrote:
 Text fields are only limited by the OS's maximum file size.  Gigs and gigs.
 
 You're thinking of the varchar limit.  There's not way to go past the
 limit on varchars, but you can always use text instead.
 
 I hope that made sense.
 
 --Ben
 
 
 DRE wrote:
  Hi,
  I've noted that the text fields in sql 2000 only go out to 8000 chars.
   Is there a means to increase this?
 
  A good resource for these questions would be great as well.
 
  Thanks.
 
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: output listing problem

2004-11-09 Thread DRE
Thanks to Jeff, the issue is resolved. For the curious, here is the solution.

SELECT A.item, A.date, (select MIN(date) FROM yourTable B ON b.itemID
= A.itemID) AS orderDate
  FROM yourTable A
 ORDER BY orderDate, A.item, A.date

DRE

On Mon, 8 Nov 2004 10:45:39 -0800, DRE [EMAIL PROTECTED] wrote:
 Hi Jeff,
 I see what you're trying to get at it but it seems not to work for me.
 The query works but its not grouping properly in the output
 statement.  Heres why I think that is.
 
 In the group by, you have to have all of the non aggregate fields
 which include date.  Now date is the one that I need outside the
 group.  That is, each item can have multiple dates. So, if date is in
 the group, then it will create groups of every item/date combination.
 Then the order by operates on the order date which is the same as
 date.  So, effectively, there is no group.
 
 Does this make sense?  What have I missed?
 
 Thanks in advance.
 DRE
 
 
 
 On Thu, 04 Nov 2004 13:07:43 -0800, Jeff Congdon [EMAIL PROTECTED] wrote:
  sorry that should probably be ASC, not DESC, if you want it to go low-high
 
  -jc
 
 
 
  Jeff Congdon wrote:
 
  make your query like this:
  
  SELECT item, date, MIN(date) AS orderDate
  FROM yourtable
  WHERE itemID = date_itemID
  GROUP BY item, date
  ORDER BY orderDate DESC, item, date
  
  -jc
  
  DRE wrote:
  
  
  
  Nobody has any thoughts?
  
  
  On Thu, 4 Nov 2004 08:14:30 -0800, DRE [EMAIL PROTECTED] wrote:
  
  
  
  
  Hi,
  I have a tricky little issue. Maybe someone can help me.
  
  I have a query that returns a grouped output.  There are items that
  have mutiple dates and those dates have to be in order.
  
  Kinda like this.
  
  item z datea dateb datec
  item r datee datef dateg
  
  so my query is like
  select item, date
  where itemid = date_itemid
  order by itemid, date
  
  And the output looks like this
  cfoutput query=me group=item
   #item#
   cfoutput
  #date#
   /cfoutput
  /cfoutput
  
  So, in order to keep the dates outputing right, I have to order them
  after the item in the sql order by.
  
  Now my problem is this: I have to have the item with the earliest date
  first.  However, to keep the cfoutput group working, I have to have
  the date by as secondary to the item.
  
  I'm thinking I can do it by dumping it into an array of structures and
  then sorting the array of structures or something like that or perhaps
  writing a sp.  This page will be hit a lot so I'm trying to keep it
  simple and fast.
  
  cfmx and sql2000.
  
  Any ideas???
  
  Thanks in advance.
  DRE
  
  --
  DRE
  www.webmachineinc.com
  www.theanticool.com
  
  
  
  
  
  
  
  
  
  
  
  
  
 
  

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: output listing problem

2004-11-08 Thread DRE
Hi Jeff,
I see what you're trying to get at it but it seems not to work for me.
 The query works but its not grouping properly in the output
statement.  Heres why I think that is.

In the group by, you have to have all of the non aggregate fields
which include date.  Now date is the one that I need outside the
group.  That is, each item can have multiple dates. So, if date is in
the group, then it will create groups of every item/date combination. 
Then the order by operates on the order date which is the same as
date.  So, effectively, there is no group.

Does this make sense?  What have I missed?

Thanks in advance.
DRE

On Thu, 04 Nov 2004 13:07:43 -0800, Jeff Congdon [EMAIL PROTECTED] wrote:
 sorry that should probably be ASC, not DESC, if you want it to go low-high
 
 -jc
 
 
 
 Jeff Congdon wrote:
 
 make your query like this:
 
 SELECT item, date, MIN(date) AS orderDate
 FROM yourtable
 WHERE itemID = date_itemID
 GROUP BY item, date
 ORDER BY orderDate DESC, item, date
 
 -jc
 
 DRE wrote:
 
 
 
 Nobody has any thoughts?
 
 
 On Thu, 4 Nov 2004 08:14:30 -0800, DRE [EMAIL PROTECTED] wrote:
 
 
 
 
 Hi,
 I have a tricky little issue. Maybe someone can help me.
 
 I have a query that returns a grouped output.  There are items that
 have mutiple dates and those dates have to be in order.
 
 Kinda like this.
 
 item z datea dateb datec
 item r datee datef dateg
 
 so my query is like
 select item, date
 where itemid = date_itemid
 order by itemid, date
 
 And the output looks like this
 cfoutput query=me group=item
  #item#
  cfoutput
 #date#
  /cfoutput
 /cfoutput
 
 So, in order to keep the dates outputing right, I have to order them
 after the item in the sql order by.
 
 Now my problem is this: I have to have the item with the earliest date
 first.  However, to keep the cfoutput group working, I have to have
 the date by as secondary to the item.
 
 I'm thinking I can do it by dumping it into an array of structures and
 then sorting the array of structures or something like that or perhaps
 writing a sp.  This page will be hit a lot so I'm trying to keep it
 simple and fast.
 
 cfmx and sql2000.
 
 Any ideas???
 
 Thanks in advance.
 DRE
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


output listing problem

2004-11-04 Thread DRE
Hi,
I have a tricky little issue. Maybe someone can help me.

I have a query that returns a grouped output.  There are items that
have mutiple dates and those dates have to be in order.

Kinda like this.

item z datea dateb datec
item r datee datef dateg

so my query is like 
select item, date
where itemid = date_itemid
order by itemid, date

And the output looks like this
cfoutput query=me group=item
   #item#
   cfoutput
  #date#
   /cfoutput
/cfoutput

So, in order to keep the dates outputing right, I have to order them
after the item in the sql order by.

Now my problem is this: I have to have the item with the earliest date
first.  However, to keep the cfoutput group working, I have to have
the date by as secondary to the item.

I'm thinking I can do it by dumping it into an array of structures and
then sorting the array of structures or something like that or perhaps
writing a sp.  This page will be hit a lot so I'm trying to keep it
simple and fast.

cfmx and sql2000.

Any ideas???

Thanks in advance.
DRE

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


Re: output listing problem

2004-11-04 Thread DRE
Nobody has any thoughts?


On Thu, 4 Nov 2004 08:14:30 -0800, DRE [EMAIL PROTECTED] wrote:
 Hi,
 I have a tricky little issue. Maybe someone can help me.
 
 I have a query that returns a grouped output.  There are items that
 have mutiple dates and those dates have to be in order.
 
 Kinda like this.
 
 item z datea dateb datec
 item r datee datef dateg
 
 so my query is like
 select item, date
 where itemid = date_itemid
 order by itemid, date
 
 And the output looks like this
 cfoutput query=me group=item
   #item#
   cfoutput
  #date#
   /cfoutput
 /cfoutput
 
 So, in order to keep the dates outputing right, I have to order them
 after the item in the sql order by.
 
 Now my problem is this: I have to have the item with the earliest date
 first.  However, to keep the cfoutput group working, I have to have
 the date by as secondary to the item.
 
 I'm thinking I can do it by dumping it into an array of structures and
 then sorting the array of structures or something like that or perhaps
 writing a sp.  This page will be hit a lot so I'm trying to keep it
 simple and fast.
 
 cfmx and sql2000.
 
 Any ideas???
 
 Thanks in advance.
 DRE
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 


-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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


OT mssql sp

2004-10-29 Thread DRE
Hi, I have to generate a list of changes whenever someone updates an
entry on certain tables.  I'm thinking a triger would be the best
spot.

Anybody got some code that would do this?  Or perhaps a link to a good
sql2000 list?

Thanks

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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


Html Area 3 issue?

2004-10-28 Thread DRE
Hi, 
Any of you guys using the HTML Area 3 wysiwig?  I've been using it and
have found a really annoying problem that I dont know how to solve.  I
can duplicate this on 2000 and xp ie 6.

To duplicate, open a page with the wysiwig and then keep reloading it
with f5.  If I do this between 5 and 20 times, the wysiwig will not
load the icons properly and then the browser gets jammed. I cant go
back. I cant click on a link.  I have to close the browser.  This
happens often when you're using the app and is very frustrating.

This happens with the samples from the downloads as well.

Here is a screenshot : http://www.webmachineinc.com/img/notloading.gif

I'll have to go find another one if I cant solve it!  

Thanks in advance!

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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


Re: Html Area 3 issue?

2004-10-28 Thread DRE
Thanks Damien,
It is cute but amazingly enough it seems to have the same issue for me

I'm amazed!  But both my computers seem to do it for me on and off site!!!

DRE


On Thu, 28 Oct 2004 11:28:51 -0400, Damien McKenna
[EMAIL PROTECTED] wrote:
 DRE wrote:
 
 Any of you guys using the HTML Area 3 wysiwig?  I've been using it and
 have found a really annoying problem that I dont know how to solve.
 
 
 I stopped using HTMLArea when I noticed conflicts between it and some
 other JS code I use, specifically fValidate.  I've since started using
 Tiny_MCE (http://tinymce.sf.net/).
 --
 *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 Nothing endures but change. - Heraclitus
 
 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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


OT - hosting?

2004-10-28 Thread DRE
I know, its a dead horse but I've been out of the loop for a while.  I
did do a search but didnt find much.

Does cfdynamics still have the favorable reputation that it used to? 
If not, any suggestions.  MX sql2000 medium traffic site.

Thanks.
DRE

-- 
DRE
www.webmachineinc.com
www.theanticool.com

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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


Re: OT - hosting?

2004-10-28 Thread DRE
Excellent!  Thanks for the feedback!
DRE


On Thu, 28 Oct 2004 23:13:53 +0700, Paul Hastings
[EMAIL PROTECTED] wrote:
 [EMAIL PROTECTED] wrote:
  I've had nothing but good experiences with them, for what it counts.
 
 me too. i can't remember the last time i had a technical problem with
 cfdynamics.
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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


Re: OT - hosting?

2004-10-28 Thread DRE
Thanks Ian,
I would be interested in this as well.
DRE


On Thu, 28 Oct 2004 09:29:44 -0700, Ian Skinner
[EMAIL PROTECTED] wrote:
 +1 for me as well.
 
 With one small caveat; just make sure one knows that database back-ups by CFdynamics 
 are only available for 3-7 days.  Found this out when we learned that a programming 
 snafu on my part cleared an important table, seven days after it happened.  We lost 
 the data.
 
 On that note can somebody give the step-by-step, MS-SQL for dummies instructions for 
 setting up simple replication so that I can create and maintain a backup of line on 
 my home computer?
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.
 
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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


mx standalone only?

2002-06-26 Thread dre

This is pretty stupid and pretty annoying.  I'm trying to reinstall cfmx 
developer and the install wont give me the page to choose standalone or 
iis.  Heres what happened.

I installed the demo cfmx and clicked for IIS.  It installed but I think it 
had a beef with my firewall and didnt work when it was done.

So I removed then reinstalled with the firewall off.  but it doesnt give me 
the option to choose iis or standalone.   I've tried it every which way but 
it seems i'm stuck on port 8500!  Which would be greatly annoying!  

Can anybody help?
Tks.  DRE

__
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