RE: HTTP Post o a CFM page

[D. Delcomminette]

That simple? Must be blind!

Thanks


-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: 21 August, 2003 17:42
To: CF-Talk
Subject: RE: HTTP Post o a CFM page

Have a look at GetHttpRequestData()


HTH

Mikey


 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: OT form javascript help

[jonhall]

function makeBold(elem_id) {
var start_text = '';
var end_text = '';
if (document.layers || window.opera)
return;
else if (document.all) {
selected_text = document.selection.createRange();
new_text = "" + selected_text.text + "";
selected_text.text = new_text;
}
else if (document.getSelection) {
elem = document.getElementById(elem_id);
start_pos = elem.selectionStart;
end_pos = elem.selectionEnd + start_text.length;
elem.value = elem.value.slice(0,start_pos) + start_text + 
elem.value.slice(start_pos);
elem.value = elem.value.slice(0,end_pos) + end_text + 
elem.value.slice(end_pos);


}
}


hello




Should work in IE4+(pc) and Gecko. I'd do this a bit differently if
you wanted to extend it beyond just bold tags though. Just replace
tfield with tfield_input in the onclick for it to work for the single
line input.


Adapted from:
http://placenamehere.com/Mozilla/js_textareas.html
http://www.xs4all.nl/~ppk/js/selected.html
http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_20110399.html

-- 
mailto:[EMAIL PROTECTED]
Thursday, August 21, 2003, 2:43:06 PM, you wrote:

PB> I know this can be done but I stink at java script. I want to select some
PB> text in a text field. Then click a graphic on the page and have it put an
PB> HTML tag around the selected text in the form field. Any idea on how to do
PB> this or where to find the code that does this?

PB> Phillip B.

PB> www.LoungeRoyale.com
PB> www.FillWorks.com

PB> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST

[Tony Weeg]

do you use aim?

im not sure i see whatcha mean.

if i put a date in there that is in our regular EST
then i get the right time back

that url explains it and shows that its fixedat least i thought.

let me check again...
tw


-Original Message-
From: Johan Steenkamp [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 10:51 PM
To: CF-Talk
Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST


Thanks Tony

Well the bug is still there for all of us as far as I can tell.

I get incorrect datediff() on my system even when setting it to US time
zone
and then using one date outside appropriate US region DST period and
other
date inside DST period.

If the dates are both outside or inside the DST period then no problem
no
matter what machine time zone is.

Regards

Johan


- Original Message - 
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 2:07 PM
Subject: RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST


> actually...
>
> it was a bug that was fixed, fixed to help with dst in the states, so
it
> works
> perfectly up here, however i would imagine adverse affects for
you...not
> good
> since it doesnt accomodate both places...i had submitted a bug to mm
> during
> the redsky beta, and they validated it...
>
> http://www.navtrak.net/cfmxBug.cfm
>
> has some code, and the explanation of what i found, you will see
> it...and
> that is on a 6.1 server.
>
> try that code on your machine, and see what happens.
>
> tony
>
> -Original Message-
> From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 7:01 PM
> To: CF-Talk
> Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span
DST
>
>
> Hi Tony
>
> I have tracked it down - is a bug in 6.1 in my opinion.
>
> You did not see error as the problem occurs when one of the dates is
in
> DST
> and the other is not in DST. The date range I gave has this situation
> for NZ
> time.
>
> For example if you system is set to say US Eastern time try 1 Jan 2003
> to
> end April 2003 which has one date in daylight having and one not, and
> you
> should see the problem.
>
> Otherwise choose two dates that span your regional DST dates.
>
> Testing same on 6.0 = no problem so bug introduced in 6.1
>
> Regards
>
> Johan
>
>
> - Original Message - 
> From: "Tony Weeg" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, August 22, 2003 10:25 AM
> Subject: RE: DateDiff() broken in 6.1 (Bug?)
>
>
> > johann
> >
> > 6.1 ent
> >
> > tony weeg
> > uncertified advanced cold fusion developer
> > tony at navtrak dot net
> > www.navtrak.net
> > office 410.548.2337
> > fax 410.860.2337
> >
> >
> > -Original Message-
> > From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, August 21, 2003 4:38 PM
> > To: CF-Talk
> > Subject: Re: DateDiff() broken in 6.1 (Bug?)
> >
> >
> > Hi Tony
> >
> > Thanks for testing - can you confirm your test was on CF 6.1? If so
> was
> > it Standard or Enterprise version? My testing is on Standard.
> >
> > It works on 6.0 for me but not 6.1
> >
> > Noted I can get the correct result by adding 1 hour to the second
> date.
> >
> > Displaying system getTimeZoneInfo() shows not difference between 6.0
> or
> > 6.1 systems so does not look like anything with localization/time.
> >
> > regards
> >
> > Johan
> >
> >
> > - Original Message - 
> > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, August 21, 2003 3:36 PM
> > Subject: RE: DateDiff() broken in 6.1 (Bug?)
> >
> >
> > > here is what i get...
> > >
> > > 1. {ts '2003-05-01 00:00:00'} - {ts '2003-10-01 00:00:00'} = 153
2.
> > > {ts '2003-05-01 00:00:00'} - {ts '2003-10-02 00:00:00'} = 154 3.
{ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-03 00:00:00'} = 155 4. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-04 00:00:00'} = 156 5. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-05 00:00:00'} = 157 6. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-06 00:00:00'} = 158 7. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-07 00:00:00'} = 159 8. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-08 00:00:00'} = 160 9. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-09 00:00:00'} = 161 10. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-10 00:00:00'} = 162 11. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-11 00:00:00'} = 163 12. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-12 00:00:00'} = 164 13. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-13 00:00:00'} = 165 14. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-14 00:00:00'} = 166 15. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-15 00:00:00'} = 167 16. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-16 00:00:00'} = 168 17. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-17 00:00:00'} = 169 18. {ts
> > > '2003-05-01 00:00:00'} - {ts '2003-10-18 00:00:00'} = 170 19. {ts
> > > '2003-05-01 00:00:00'} - {ts 

Re: MS SQL Server vs. MySQL

[Paul Hastings]

> I'd like to hear more about MSDE...what exactly is it?  what is missng
from
> full blown MS SQL Server? what kind of interface (i.e. like Enterprise
> Manager)?

msde, sql server's idiot brother-in-law.
- limited to 2gb db size,
- 3-5 concurrent users,
- doesn't come w/enterprise manager, etc.,
- sort of  tricky to install for use w/mx (it defaults to trusted
connections).

ms has it embedded in a whole bunch of things. we use it for development &
admin apps, etc. works fine (though we have sql server so we have all its
tools for use on msde).

> I'd also like to hear more about Postgre(s)?  It sounds as though it has
the
> features MySQL is missing?  Does it have a better/easier interface (more
> like Enterprise Manager)?  What OS does it work on?

postgreSQL is a pretty good db, implements all (??) the sql standards, its
mainly aimed at the non-windows crowd (some talk of native port, it runs
under some emulator??). jochem's the guy to ask about it.


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[info]

It'd be tough to be Access on steroids without views. :P Or I think subqueries... not 
sure if Access has anything like stored procedures -- pretty certain it doesn't have 
anything like triggers. My take is that MySQL is just a free database, so, although 
some free things are pretty good, it usually takes a while for them to become "robust" 
and MySQL is just still in those early days. 

ike 

-- Original Message -- 
From: Bryan Stevenson <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 21, 2003 10:11 AM
Subject: Re: MS SQL Server vs. MySQL

>Hey All,
>
>I'm not all that familiar with MySQL, but from what I hear it's not as good
>as MS SQL Server (which I use along with Oracle).
>
>I've tried using MyPHPAdmin to administer MySQL before and all I can say is
>it sucked eggs...security was confusing as all hell.
>
>The MySQL.com website says that upcoming features for version 5 include:
>-views
>-stored procedures
>-triggers
>-sub-queries
>
>Now if it's missing all that then what is itAccess on steroids?? ;-)
>
>Opinions please
>
>TIA
>
>Cheers
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Paul Hastings]

> It's been interesting to see the criticism over time for MySQL. It used to
> be "No transactions so it sucks" which was solved by InnoDB and BDB
tables.

its even more interesting to recall the mySQL folks' attitudes & comments on
these sorts of things way back when. these "fancy" features weren't in the
original db because they thought they weren't important. i'll always be
suspicious of mySQL because of this (unless of course like converted harlots
they become religious zealots).


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: CSS guidelines

[info]

Use the class in the table data cell if possible. The span is just an extra widget 
without any purpose of it's own (in this case), and the span tag can't receive certain 
css attributes, such as iirc borders. 

Isaac


-- Original Message -- 
From: Bosky, Dave <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 21, 2003 01:17 PM
Subject: Re: CSS guidelines

>What's the difference between using a class inside a table cell tag and
>using a span tag in a table cell?
>Something like:
>
>
>
>
>
>Thanks.
>Dave
>
>
>
>
>HTC Disclaimer:  The information contained in this message may be privileged and 
>confidential and protected from disclosure. If the reader of this message is not the 
>intended recipient, or an employee or agent responsible for delivering this message 
>to the intended recipient, you are hereby notified that any dissemination, 
>distribution or copying of this communication is strictly prohibited.  If you have 
>received this communication in error, please notify us immediately by replying to the 
>message and deleting it from your computer.  Thank you.
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Upload Problems CFFILE

[info]

I'm not sure if it's still the case (I doubt it) but with some versions of CF Server 
prior to MX there were issues with uploading large numbers of large files as a result 
of the use of a 3rd party memory management API which never released memory once 
acquired. Or so I had heard. I'm not sure if this is related to your problem, and 
unfortunately I don't have a workaround, but I thought you might like to know. 

Isaac 


-- Original Message -- 
From: Stewart McGowan <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 21, 2003 03:39 PM
Subject: Re: Upload Problems CFFILE

>*** Before acting on this e-mail or opening any attachment you are advised to read 
>the disclaimer at the end of this e-mail ***
>
>Hi Guys,
>
>We're using CFFILE to upload images to our asset management software, we're
>hitting problems with files sizes above about 10MB's, we've isolated the
>server by using a cross over cable and a client machine and attempting the
>upload, (therefore eliminating client bandwidth issues, firewalls etc), yet
>we're still not able to upload more than 10MB...the server has 3GB of RAM,
>so it shouldn't be running out with a 10MB file...any ideas?
>
>Thanks in advance
>
>Stew
>
>
>communisis one ltd
>Manston Lane, Cross Gates, Leeds. LS15 8AH
>Telephone: 0113 225 2555 Facsimile: 0113 225 2526
>Internet: www.communisis-one.co.uk email: [EMAIL PROTECTED]
>Registered Office: Wakefield Road, Leeds. LS10 1DU. Registered in England Number 
>1359040
>
>Please note: This e-mail and its attachments contain only the opinions of the sender 
>and do not necessarily reflect
>the policy(s) of the communisis group in general.
>
>Employees of the communisis group are required not to make any defamatory statements 
>and not to infringe or
>authorise any infringement of copyright or any other legal right by e-mail. Any such 
>communication is therefore
>outside the scope of employment of the individual concerned. The communisis group 
>will not accept any liability in
>respect of such a communication.
>
>Confidentiality: This e-mail and any attachments, together with their contents, are 
>confidential unless otherwise
>explicitly stated in writing by the sender of this e-mail and are for the intended 
>recipient only. If they have come to
>you in error you must not take any action in respect of them, which includes but is 
>not limited to reproducing,
>sending or storing them, other than to notifying the sender immediately of the 
>mistake, and deleting the e-mail,
>any attachments and any reproductions made by replying to it.
>
>Viruses: This e-mail and any attachments have been scanned for viruses but we cannot 
>guarantee that they are
>virus free. The recipient should check this e-mail and any attachments for viruses. 
>The communisis group accepts
>no responsibility for any damage caused by any virus transmitted by this e-mail or 
>any of its attachments. In the
>event of any unauthorised copying or forwarding, the recipient will be required to 
>indemnify the communisis group
>against any claim for loss or damage caused by any viruses or otherwise.
>
>
>
>This email has been scanned for all viruses by the MessageLabs Email
>Security System. For more information on a proactive email security
>service working around the clock, around the globe, visit
>http://www.messagelabs.com
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: WOT: Securing word docs, excel, etc in a web app

[info]

Make certain the hosting provider gives you access to directories outside of your web 
root. Store the members only files in those directories and deliver them to members 
using  

hth 

Isaac 


-- Original Message -- 
From: Griffin <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 21, 2003 02:11 PM
Subject: Re: WOT: Securing word docs, excel, etc in a web app

>Hi,
>This is off topic, but I am sure many of you have had to deal with
>issues such as these in the past.
>
>I have been living in a bubble for the past 3 years and have developped
>many web apps in CF, ASP and JSP on secure networks with no Internet
>connection. For the first time, I am building an Internet based web app
>in CF. Creating the members only portion with user authentication and so
>on is no problem.
>
>However, the site's main focus is to share research data among members.
>Most members want to upload MS Word docs, MS Excel docs and PDFs. The
>site will be hosted at an ISP, so using IIS or NT security is not an
>option.
>
>So here is my dilema, once I have uploaded documents that I only want
>members to access, how can I achieve something better than "security
>through obscurity" and prevent people from stumbling on the docs by
>guessing or as the result of a search engine search? Same question for
>images. There will be images in .jpg and .gif format which are destined
>for members eyes only.
>
>Any recommendations appreciated.
>
>Grif
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Donnie Bachan]

If you are looking for a low budget solution and want to stick with a name 
that has a lot of clout in this arena try Adaptive Server Studio from 
iAnywhere Solutions (a Sybase company), in my impression it is really a lite 
version of ASE from Sybase. It has alot of easy to use tools and supports 
all of what you are looking for (Triggers, SP's, Views etc). Check it out 
http://www.ianywhere.com

Best Regards,

Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
"Nitendo Vinces - By Striving You Shall Conquer"
==
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

_
Get MSN 8 and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[webmaster]

 
"sql server's idiot brother-in-law"

That is so quote worthy.  Sorry for the OT, but way too funny!

Regards,

Eric

"The reasonable man adapts himself to the world; the unreasonable one 
persists in trying to adapt the world to himself. Therefore all 
progress depends on the unreasonable man."
-- George Bernard Shaw
 

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 11:49 PM
To: CF-Talk

> I'd like to hear more about MSDE...what exactly is it?  what is missng
from
> full blown MS SQL Server? what kind of interface (i.e. like Enterprise 
> Manager)?

msde, sql server's idiot brother-in-law.
- limited to 2gb db size,
- 3-5 concurrent users,
- doesn't come w/enterprise manager, etc.,
- sort of  tricky to install for use w/mx (it defaults to trusted
connections).

ms has it embedded in a whole bunch of things. we use it for development &
admin apps, etc. works fine (though we have sql server so we have all its
tools for use on msde).

> I'd also like to hear more about Postgre(s)?  It sounds as though it 
> has
the
> features MySQL is missing?  Does it have a better/easier interface 
> (more like Enterprise Manager)?  What OS does it work on?

postgreSQL is a pretty good db, implements all (??) the sql standards, its
mainly aimed at the non-windows crowd (some talk of native port, it runs
under some emulator??). jochem's the guy to ask about it.



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Who's migrating to CFMX 6.1 J2EE?

[Alan Ford]

We plan to over the next few weeks - moving from 6.1 single server single
instance to 6.1 single server multi instance as the first move (then on to
clustered servers). Not done anything with it yet, though.

Regards,

Alan Ford
The Mill, Abercych
0845 123 5639
www.abercych.com


  - Original Message -
  From: Earl, George
  To: CF-Talk
  Sent: Thursday, August 21, 2003 4:03 PM
  Subject: Who's migrating to CFMX 6.1 J2EE?


  Show of hands - who's making the jump from CFMX 6.0 Enterprise standalone
  (server configuration) to CFMX 6.1 Enterprise J2EE? How is it going?

  Candace, are you still playing around with J2EE?

  George
  [EMAIL PROTECTED]
  
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Okay, how could I accomplish this?

[Mike Mertsock]

>Yeah, but here's the thing. The tables hold data that can be stuck into
>"key, title, body" columns, but the display of each column is different, so
>each collection will be displayed differently, thus the "custom1" column in
>my cfsearch. I want to mix the results for display purposes, showing scores
>correctly ranked when mixed, but I want to display the results differently.
>My solution was to search each collection, place the results into a
>structure of some sort, including the "custom1" column that will determine
>how to display the data on the details page, and sort them all by "score" so
>that output results are "sorted" by "score" yet their "colum1" information
>will determine how the data is displayed on the following page.
>
>Make sense?
>
>So *can* you do that? stick each result set into some sort of data structure
>for each query returned, then sort that structure, ordering by "score", then
>outputting the results?
>
>For instance, collection 1 returns the following:
>Score - Title (custom1)
>97 - My New Title (1)
>67 - A Second Title (1)
>78 - The Fifth Title (1)
>
>And collection 2 returns the following:
>86 - The Title of This Document is This (2)
>76 - I'm Titling This Document Thusly (2)
>23 - A Whimsical Title To Enjoy (2)
>
>Then my output is as follows:
>97 - My New Title (1)
>86 - The Title of This Document is This (2)
>78 - The Fifth Title (1)
>76 - I'm Titling This Document Thusly (2)
>67 - A Second Title (1)
>23 - A Whimsical Title To Enjoy (2)
>
>See? Then, when you clicked the link, you'd know *which* collection passed
>you the results...then you could display it appropriately, if it needs to be
>displayed differently (which mine does).

Perhaps you could avoid trying to put the two queries into one structure...

What you want to do is *exactly* like the merge portion of the merge sort algorithm - 
the problem is to take two already-sorted data structures and combine them into a 
single sorted structure. Merge sorts are known to be very fast, so perhaps an 
efficient solution would be to mimic the merge part of the merge sort algorithm. 
Here's the basic idea:

list A = 1, 3, 4, 6
list B = 2, 3, 5, 7
merge into: 1 2 3 3 4 5 6 7
to merge the two lists:
loop while A and B have elements remaining
--compare the first elements of A and B
--if B is less, append to final list
--else, append A's first element instead
end loop

So to mimic this:

Initialize two counters - counterA and counterB - to 1 -- you begin by looking at the 
first record from each query

loop while both counters are LTE their respective recordcount
--compare queryA.score[counterA] and queryB.score[counterB]
--if the score from B is GT the score from A
output info for B, iterate counterB
--else
output info for A, iterate counterA
end loop

One thing to remember - you can go through all the records of one query before the 
other query is finished so you need to test for that.

Something like that. Data structures was my favorite class in college :-)

Mike Mertsock
Alfred University Web Team
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: checking for unread mail

[Michael Dinowitz]

There's a tag in the gallery called CFX_Pop3 that has the ability to check the
message count in a mailbox.


> Hello readers,
>
> We're developing a portal (intranet) and thought it would be nice if it would
display "You have X unread emails" when the user logs in. Looks like you cannot
determine whether a message is unread using . I'm sure there are tons of
things out there that will do this, maybe even some method using native CF
functionality that I'm overlooking. Anybody have a favorite way of doing this?
>
> More details on what we're trying to do:
> * We will only be hitting our in-house MS Exchange server
> * 98% of users only use an IMAP (not POP) configuration with their mail
clients, and we provide the Outlook Web Access software (also IMAP) for
web-based access
> * All we want to do is figure out how many unread messages the user has
>
> Thanks!
>
> Mike Mertsock
> Alfred University Web Team
>
>
>
> 
> Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
> http://login.mail.lycos.com/r/referral?aid=27005
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

CFMX 6.1: floats being read from DB are truncated?

[Ciaran Archer]

Thanks for the feedback.
I will look into the numberic datatype instead of float.
In terms of NumberFormat(), we use this for display purposes, but what is frustrating 
is that in the course of a script we can get an incorrect mathematical result, and so 
we have to make changes to a number of script to avoid the problem.
All because a 1.0 is being read a 1 :)
As you can imagine, it's frustrating to upgrade and have functionality 'break' a a 
result.

Ciaran

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: CF Studio/HomeSite+

[Calvin Ward]

Actively develops?

Know something we don't?

- Calvin

- Original Message - 
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 10:14 AM
Subject: RE: CF Studio/HomeSite+


> Homesite+ is the only version of 'Studio' which MM still actively supports
> and develops AFAIKit is also ONLY included with DWMX
>
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]
> Sent: 21 August 2003 10:32
> To: CF-Talk
> Subject: CF Studio/HomeSite+
>
>
> Which of the two is still being maintained, even if not sold directly, by
> Macromedia?  Would it be Homesite+, since it's included with Dreamweaver
MX?
>
> We need to purchase a couple of additional licenses for CF Studio.  We're
> not
> working with CF6 MX and have no plans to move away from CF5 Server.  We
> don't
> have much use for Dreamweaver or any of the other Studio MX components. So
> what
> would be the best (and cheapest) route to aquiring a couple of
> Studio/Homesite+
> licenses?   If contacted directly, will Macromedia sell you CF Studio
> licenses,
> even though its no longer a product available for purchase from their web
> page?
>
> Jim
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> 
> Oh, and mySQL's date handling is far, far superior to SQL Server's.  It's on a whole 
> other level.

I hope you were being cynical. But just to make sure everybody 
understands how hopelessly evil date handling in MySQL is:

> mysql> create table test (a date);
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> insert into test values (-1);
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> insert into test values ('1996-02-31');
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> insert into test values ('1996-67-31');
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> select * from test;
> ++
> | a  |
> ++
> | -00-00 |
> | 1996-02-31 |
> | -00-00 |
> ++
> 3 rows in set (0.00 sec)

That is indeed a whole other level.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:

> not sure if Access has anything like stored procedures

No. The best thing you get are parameterized queries, but they 
still can only be 1 SQL statement.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Jochem van Dieten]

Barney Boisvert wrote:
> You get foreign key support with innoDB which has been in there for quite
> some time.

No you don't. Read the fine print.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Jochem van Dieten]

Matt Robertson wrote:
> Jochem wrote:
> 
>>Do you consider data integrity fancy stuff? If so, we should 
>>probably agree to disagree.
> 
> Indeed.  I've always preferred to handle cascading deletes/referential integrity in 
> the application.

That is just referential integrity. When I mean data integrity, I 
mean much more:
- proper handling of NOT NULL constraints
- proper transaction handling (don't insert  records and let 
1 fail in a transaction because it is so hard to roll back)
- proper handling of values that that don't fit in the field
- transactional DDL
- etc.


> (..) but long ago I decided I wanted to use the db solely as a container that 
> follows the express instructions I give it.

So that is why you use a database that inserts a zero in an 
integer field if you give it the express instruction to insert a 
zero byte string?

Throwing errors to the client is a feature, but MySQL tries to 
avoid it like the plague.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Uniquely identifying a function

[Tim Blair]

It doesn't return an "instance", it returns a reference:








reference

copy



Tim.


---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---


> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED] 
> Sent: 20 August 2003 03:55
> To: CF-Talk
> Subject: RE: Uniquely identifying a function
> 
> 
> Answer my own question. It returns an instance of itself. So 
> you could do, 
> 
> x = foobar();
> y = x();
> 
> Not that you would want to, though. :)
> 
> ==
> ==
> ===
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> (www.mindseye.com)
> Member of Team Macromedia 
> (http://www.macromedia.com/go/teammacromedia)
> 
> Email: [EMAIL PROTECTED]
> Blog : www.camdenfamily.com/morpheus/blog
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -Original Message-
> > From: Raymond Camden [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 19, 2003 8:07 PM
> > To: CF-Talk
> > Subject: RE: Uniquely identifying a function
> > 
> > 
> > Interesting tip - even more so - interesting function. Your
> > UDF returns the UDF - what happens if you call it? :)
> > 
> > ==
> > ==
> > ===
> > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> > (www.mindseye.com)
> > Member of Team Macromedia
> > (http://www.macromedia.com/go/teammacromedia)
> > 
> > Email: [EMAIL PROTECTED]
> > Blog : www.camdenfamily.com/morpheus/blog
> > Yahoo IM : morpheus
> > 
> > "My ally is the Force, and a powerful ally it is." - Yoda
> > 
> > > -Original Message-
> > > From: Matt Liotta [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, August 19, 2003 7:54 PM
> > > To: CF-Talk
> > > Subject: Re: Uniquely identifying a function
> > > 
> > > 
> > > BTW, you can get the name of the CFM that the function is 
> defined in 
> > > by calling the getPagePath() method of the function. See the 
> > > following example.
> > > 
> > > 
> > >   
> > > 
> > > 
> > > 
> > > -Matt
> > > 
> > > On Tuesday, August 19, 2003, at 06:49 PM, Tim Blair wrote:
> > > 
> > > >> Obviously, your function names must be unique per CFM, so
> > > the unique
> > > >> name for all functions is a concatenation of the CFM 
> name and the 
> > > >> function name.
> > > >
> > > > Indeed that is true, the problem comes when I'm trying to
> > work out
> > > > which CFM page contains the function: I'm performing the key
> > > > generation from within the CFC, so it's a bit of a hassle
> > > to work out
> > > > where the function "came from".  Any way, the 
> toString() method I 
> > > > provided initially basically does what you have stated,
> > in a round
> > > > about kind of way.
> > > >
> > > >> Here is a quick UDF (read not tested) that does what you
> > need. ...
> > > >>return theName.hashCode();
> > > >
> > > > That's not going to identify a function uniquely - the 
> hashCode()
> > > > method will return the hashcode for the theName variable,
> > > not for the
> > > > function.  If I called the method again with exactly the
> > > same value,
> > > > it'd return a different hashcode.
> > > >
> > > > Saying that however, using hashCode() against the
> > function directly
> > > > _will_ work and also saves on the hash() call.  I can
> > > replace the key
> > > > generation line:
> > > >
> > > > 
> > > >
> > > > with the following, removing one method call per generation
> > > (not much,
> > > > but I'm sure they'll all add up, especially as it's a
> > > crypto function
> > > > call I'm removing) and guaranteeing the key is unique (and
> > > always the
> > > > same) for that function:
> > > >
> > > > 
> > > >
> > > > For those that are wondering, the hashCode() method is a
> > java method
> > > > implemented in the base Object class that all other
> > classes extend
> > > > from by default.  By definition it is guaranteed to
> > return 

RE: Uniquely identifying a function

[Tim Blair]

> Certainly many object's hash code in Java are based on their memory
> address, which means that it can change over time. However,
> java.lang.String's is computed as... [snip]

Ah yes, I actually did know that (honest!) but it had escaped me...  :)

> 

Ooh, nice, I like that.  :)  So combining both the above, doing
something like this would return a unique reference to a function:



Cool.  The only (slight) disadvantage I see with this is if the body of
the function changes then you'll still get the "old" cached version (at
least until the cache times out), because the hash code doesn't change;
using a straight myFuncRef.hashCode() call will guarantee that ant
change in the CFM page holding the function will also change the
function hash code and so will be "re-cached".  Also, it's an additional
method call over a straight myFuncRef.hashCode() call...

Good points to think about, cheers Matt.

Tim.


---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST

[Johan Steenkamp]

Hi Tony

You have to have one date outside DST period and one inside DST period from
what I can see. Certainly if setting my server time to another zone I can
replicate problem.

Have Windows Messenger not AIM

Regards

Johan

- Original Message - 
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 3:31 PM
Subject: RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST


> do you use aim?
>
> im not sure i see whatcha mean.
>
> if i put a date in there that is in our regular EST
> then i get the right time back
>
> that url explains it and shows that its fixedat least i thought.
>
> let me check again...
> tw
>
>
> -Original Message-
> From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 10:51 PM
> To: CF-Talk
> Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST
>
>
> Thanks Tony
>
> Well the bug is still there for all of us as far as I can tell.
>
> I get incorrect datediff() on my system even when setting it to US time
> zone
> and then using one date outside appropriate US region DST period and
> other
> date inside DST period.
>
> If the dates are both outside or inside the DST period then no problem
> no
> matter what machine time zone is.
>
> Regards
>
> Johan
>
>
> - Original Message - 
> From: "Tony Weeg" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, August 22, 2003 2:07 PM
> Subject: RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST
>
>
> > actually...
> >
> > it was a bug that was fixed, fixed to help with dst in the states, so
> it
> > works
> > perfectly up here, however i would imagine adverse affects for
> you...not
> > good
> > since it doesnt accomodate both places...i had submitted a bug to mm
> > during
> > the redsky beta, and they validated it...
> >
> > http://www.navtrak.net/cfmxBug.cfm
> >
> > has some code, and the explanation of what i found, you will see
> > it...and
> > that is on a 6.1 server.
> >
> > try that code on your machine, and see what happens.
> >
> > tony
> >
> > -Original Message-
> > From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, August 21, 2003 7:01 PM
> > To: CF-Talk
> > Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span
> DST
> >
> >
> > Hi Tony
> >
> > I have tracked it down - is a bug in 6.1 in my opinion.
> >
> > You did not see error as the problem occurs when one of the dates is
> in
> > DST
> > and the other is not in DST. The date range I gave has this situation
> > for NZ
> > time.
> >
> > For example if you system is set to say US Eastern time try 1 Jan 2003
> > to
> > end April 2003 which has one date in daylight having and one not, and
> > you
> > should see the problem.
> >
> > Otherwise choose two dates that span your regional DST dates.
> >
> > Testing same on 6.0 = no problem so bug introduced in 6.1
> >
> > Regards
> >
> > Johan
> >
> >
> > - Original Message - 
> > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, August 22, 2003 10:25 AM
> > Subject: RE: DateDiff() broken in 6.1 (Bug?)
> >
> >
> > > johann
> > >
> > > 6.1 ent
> > >
> > > tony weeg
> > > uncertified advanced cold fusion developer
> > > tony at navtrak dot net
> > > www.navtrak.net
> > > office 410.548.2337
> > > fax 410.860.2337
> > >
> > >
> > > -Original Message-
> > > From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, August 21, 2003 4:38 PM
> > > To: CF-Talk
> > > Subject: Re: DateDiff() broken in 6.1 (Bug?)
> > >
> > >
> > > Hi Tony
> > >
> > > Thanks for testing - can you confirm your test was on CF 6.1? If so
> > was
> > > it Standard or Enterprise version? My testing is on Standard.
> > >
> > > It works on 6.0 for me but not 6.1
> > >
> > > Noted I can get the correct result by adding 1 hour to the second
> > date.
> > >
> > > Displaying system getTimeZoneInfo() shows not difference between 6.0
> > or
> > > 6.1 systems so does not look like anything with localization/time.
> > >
> > > regards
> > >
> > > Johan
> > >
> > >
> > > - Original Message - 
> > > From: "Tony Weeg" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, August 21, 2003 3:36 PM
> > > Subject: RE: DateDiff() broken in 6.1 (Bug?)
> > >
> > >
> > > > here is what i get...
> > > >
> > > > 1. {ts '2003-05-01 00:00:00'} - {ts '2003-10-01 00:00:00'} = 153
> 2.
> > > > {ts '2003-05-01 00:00:00'} - {ts '2003-10-02 00:00:00'} = 154 3.
> {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-03 00:00:00'} = 155 4. {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-04 00:00:00'} = 156 5. {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-05 00:00:00'} = 157 6. {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-06 00:00:00'} = 158 7. {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-07 00:00:00'} = 159 8. {ts
> > > > '2003-05-01 00:00:00'} - {ts '2003-10-08 00:00:00'} = 160 9. {

Re: Business Day in SQL Query

[Paul Hastings]

> Good idea, there must be a SQL function for that maybe?  I know how to do

not that i know of, but you should probably approach this from the db
anyway. while its easy enough to find weekends (being careful about locales
where weeks don't start the same as other places) what about holidays? most
businesses here in thailand don't count holidays as business days, even
better some thai-american ones don't count either thai or us holidays. i
usually maintain a table with relevant holidays & weekends dates & work
against that.


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

ckeck for finished download

[Margrit John]

Hi

I have a page, where users can download files. It is done 
with cfheader and cfcontent. I want to receive a mail, as 
soon as the download is finished. 

I manage to send a mail (cfmail), if the user starts the 
download. That means, when I receive the mail, I am not 
shure, if the user ever finished the download.

Is there a possibility to check if a download is finished?

Thank you
Margrit
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

multiple user login

[Margrit John]

Hi

I' am using CF MX and made a login with cflogin. IE allows 
on the same computer multiple different users to login. 
Mozilla accepts only one user to login.

If I login twice with two different users in Mozilla, the 
second logedin user gets to see the page of the first 
logedin user. 

Has anyone an idea how to handle this?

Thanks for helping
Margrit
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: htaccess CF manager

[webguy]

I'd look around for a java class that does this. There is bound to be one.

WG

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 21 August 2003 18:05
To: CF-Talk
Subject: htaccess CF manager


I am about to create a web-based htaccess manager... that will allow my
client to create/delete htaccess areas on the server.

This is a Windows 2000 server... I already have a script that does this
nicely in perl on my Linux server.

Does anybody have any thoughts on how best to go about this?

--
Jillian


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: sql question

[Mark A. Kruger - CFG]

cool...

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 9:08 PM
To: CF-Talk
Subject: RE: sql question


thanks mark,

i did the addlinkedserver and addlinkedserverlogin sp's
and that didnt do it..it was mixed mode vs. sql auth only
and so i made it sql auth and now its all good :)

thanks anyhew!!
t
w

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 7:36 PM
To: CF-Talk
Subject: RE: sql question


Tony,

I'm not sure cause I'm vegging at home right now... but I think you have
to
add the linked server AND the linked server login.  There's an SP
called...

sp_addlinkedsrvlogin I think?

It goes something like...

sp_addlinkedsrvlogin 'remoteserver', 'remoteUser','remotepassword'

I believe there are some other impersonation options as  well.

-Mark



-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 6:15 PM
To: CF-Talk
Subject: sql question


im getting this error

Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

when trying to do a query from one sql server query analyzer when
referencing another
one and a db on the other one

I did sp_addlinkedserver however its barfing on a user that Im not sure
where im missing...help

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Okay, how could I accomplish this?

[Mike Mertsock]

The pseudocode below is a little off. The loop condition should be while counterA is 
LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount.

>Initialize two counters - counterA and counterB - to 1 -- you begin by 
>looking at the first record from each query
>
>loop while both counters are LTE their respective recordcount
>--compare queryA.score[counterA] and queryB.score[counterB]
>--if the score from B is GT the score from A
>output info for B, iterate counterB
>--else
>output info for A, iterate counterA
>end loop
>
>One thing to remember - you can go through all the records of one 
>query before the other query is finished so you need to test for that.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: CSS guidelines

[Kevin Graeme]

A div can take borders just fine if the browser has a proper implementation
of CSS. But with, oh, NS4.x there are some very specific cases where using a
border on a div can actually crash the browser. Pretty rare though. Whe!

-Kevin

- Original Message - 
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 3:10 PM
Subject: Re: CSS guidelines


> Use the class in the table data cell if possible. The span is just an
extra widget without any purpose of it's own (in this case), and the span
tag can't receive certain css attributes, such as iirc borders.
>
> Isaac
>
>
> -- Original Message -- 
> From: Bosky, Dave <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Aug 21, 2003 01:17 PM
> Subject: Re: CSS guidelines
>
> >What's the difference between using a class inside a table cell tag and
> >using a span tag in a table cell?
> >Something like:
> >
> >
> >
> >
> >
> >Thanks.
> >Dave
> >
> >
> >
> >
> >HTC Disclaimer:  The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader of
this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Question about cf and ldap

[Janice Zimba]

>I read somewhere that it needs to be a full name, 
>>not just the actual username, but I'm not sure what this means.  
>
>You probably need to use a full-qualified Windows domain name.  In 
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College" 
>   attributes="*" 
>   server="server_name_here" 
>   port="389" 
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as 
username="fullhostname\username" and both give me a cold fusion error: "Inappropriate 
authentication"

Do you have any examples or know where I could find one (I've done some searching) of 
cold fusion ldap accessing a microsoft active directory server?  Maybe I've missed 
something entirely.  :-(  It's made harder by the fact that I don't have any control 
over the directory settings(though in the long run, I'm probably better off--hehe), 
and my admin isn't inclined to being vast amounts of help.  

Thanks,
Janice

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[webguy]

I remember seeing a good cf ldap example here..
http://www.15seconds.com/issue/020710.htm

WG

-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name,
>>not just the actual username, but I'm not sure what this means.
>
>You probably need to use a full-qualified Windows domain name.  In
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College"
>   attributes="*"
>   server="server_name_here"
>   port="389"
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as
username="fullhostname\username" and both give me a cold fusion error:
"Inappropriate authentication"

Do you have any examples or know where I could find one (I've done some
searching) of cold fusion ldap accessing a microsoft active directory
server?  Maybe I've missed something entirely.  :-(  It's made harder by the
fact that I don't have any control over the directory settings(though in the
long run, I'm probably better off--hehe), and my admin isn't inclined to
being vast amounts of help.

Thanks,
Janice


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Zimba, Janice C.]

Thanks, I'll take a look. :)

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:35 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


I remember seeing a good cf ldap example here..
http://www.15seconds.com/issue/020710.htm

WG

-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name,
>>not just the actual username, but I'm not sure what this means.
>
>You probably need to use a full-qualified Windows domain name.  In
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College"
>   attributes="*"
>   server="server_name_here"
>   port="389"
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as
username="fullhostname\username" and both give me a cold fusion error:
"Inappropriate authentication"

Do you have any examples or know where I could find one (I've done some
searching) of cold fusion ldap accessing a microsoft active directory
server?  Maybe I've missed something entirely.  :-(  It's made harder by the
fact that I don't have any control over the directory settings(though in the
long run, I'm probably better off--hehe), and my admin isn't inclined to
being vast amounts of help.

Thanks,
Janice



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Vernaillen Tim]

are you sure the start parameter is right (o=Anne Arundel Commu...)?
I don't know for sure, but I think it's not allowed to use spaces.


-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name, 
>>not just the actual username, but I'm not sure what this means.  
>
>You probably need to use a full-qualified Windows domain name.  In 
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College" 
>   attributes="*" 
>   server="server_name_here" 
>   port="389" 
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as 
username="fullhostname\username" and both give me a cold fusion error: "Inappropriate 
authentication"

Do you have any examples or know where I could find one (I've done some searching) of 
cold fusion ldap accessing a microsoft active directory server?  Maybe I've missed 
something entirely.  :-(  It's made harder by the fact that I don't have any control 
over the directory settings(though in the long run, I'm probably better off--hehe), 
and my admin isn't inclined to being vast amounts of help.  

Thanks,
Janice


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[webguy]

You can alway use jndi easily enough too.
There is a bug with ssl/ ldap on linux cfmx, afaiRemember..

WG


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:35
To: CF-Talk
Subject: RE: Question about cf and ldap


I remember seeing a good cf ldap example here..
http://www.15seconds.com/issue/020710.htm

WG

-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name,
>>not just the actual username, but I'm not sure what this means.
>
>You probably need to use a full-qualified Windows domain name.  In
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College"
>   attributes="*"
>   server="server_name_here"
>   port="389"
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as
username="fullhostname\username" and both give me a cold fusion error:
"Inappropriate authentication"

Do you have any examples or know where I could find one (I've done some
searching) of cold fusion ldap accessing a microsoft active directory
server?  Maybe I've missed something entirely.  :-(  It's made harder by the
fact that I don't have any control over the directory settings(though in the
long run, I'm probably better off--hehe), and my admin isn't inclined to
being vast amounts of help.

Thanks,
Janice



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: htaccess CF manager

[Thomas Chiverton]

On Thursday 21 Aug 2003 18:04 pm, Jillian Carroll wrote:
> This is a Windows 2000 server... I already have a script that does this
> nicely in perl on my Linux server.
>
> Does anybody have any thoughts on how best to go about this?

Put perl and/or cygwin on your Windows box and use the same script.

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Zimba, Janice C.]

what's jndi? 

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:44 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


You can alway use jndi easily enough too.
There is a bug with ssl/ ldap on linux cfmx, afaiRemember..

WG


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:35
To: CF-Talk
Subject: RE: Question about cf and ldap


I remember seeing a good cf ldap example here..
http://www.15seconds.com/issue/020710.htm

WG

-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name,
>>not just the actual username, but I'm not sure what this means.
>
>You probably need to use a full-qualified Windows domain name.  In
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College"
>   attributes="*"
>   server="server_name_here"
>   port="389"
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as
username="fullhostname\username" and both give me a cold fusion error:
"Inappropriate authentication"

Do you have any examples or know where I could find one (I've done some
searching) of cold fusion ldap accessing a microsoft active directory
server?  Maybe I've missed something entirely.  :-(  It's made harder by the
fact that I don't have any control over the directory settings(though in the
long run, I'm probably better off--hehe), and my admin isn't inclined to
being vast amounts of help.

Thanks,
Janice




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Zimba, Janice C.]

I'm not sure at all, but I think it must be ok because I tried accessing a public one 
I found at Carnegie Mellon with the following code and it worked fine: 



Think I've maybe got a couple of things going on with mine...first, its microsoft 
(doh) and second, I might have authentication problems.

Thanks,
Janice

-Original Message-
From: Vernaillen Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:36 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


are you sure the start parameter is right (o=Anne Arundel Commu...)?
I don't know for sure, but I think it's not allowed to use spaces.


-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name, 
>>not just the actual username, but I'm not sure what this means.  
>
>You probably need to use a full-qualified Windows domain name.  In 
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College" 
>   attributes="*" 
>   server="server_name_here" 
>   port="389" 
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as 
username="fullhostname\username" and both give me a cold fusion error: "Inappropriate 
authentication"

Do you have any examples or know where I could find one (I've done some searching) of 
cold fusion ldap accessing a microsoft active directory server?  Maybe I've missed 
something entirely.  :-(  It's made harder by the fact that I don't have any control 
over the directory settings(though in the long run, I'm probably better off--hehe), 
and my admin isn't inclined to being vast amounts of help.  

Thanks,
Janice



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Who's migrating to CFMX 6.1 J2EE?

[Thomas Chiverton]

On Friday 22 Aug 2003 00:53 am, Sangeeta Karmokar wrote:
> I am new user of Mac os 10 and we are installing CFMX J2EE. On PC I used to
> save my database in bd folder and cfm pages in wwwroot folder, but on CFMX
> J2EE, I have no idea where to store database and store cfm pages to get
> website going?

Put them anywhere you like, and set a mapping up in the administrator for '/'

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Question about cf and ldap

[Matt Liotta]

I think cfldap is a one of the few examples where it is harder to use 
CFML than Java; use JNDI.

-Matt

On Friday, August 22, 2003, at 09:44 AM, webguy wrote:

> You can alway use jndi easily enough too.
> There is a bug with ssl/ ldap on linux cfmx, afaiRemember..
>
> WG
>
>
> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]
> Sent: 22 August 2003 14:35
> To: CF-Talk
> Subject: RE: Question about cf and ldap
>
>
> I remember seeing a good cf ldap example here..
> http://www.15seconds.com/issue/020710.htm
>
> WG
>
> -Original Message-
> From: Janice Zimba [mailto:[EMAIL PROTECTED]
> Sent: 22 August 2003 14:29
> To: CF-Talk
> Subject: Question about cf and ldap
>
>
>> I read somewhere that it needs to be a full name,
>>> not just the actual username, but I'm not sure what this means.
>>
>> You probably need to use a full-qualified Windows domain name.  In
>> your code snippet, it would be something like the following:
>>
>>  >  name="ldap_test"
>>  start="o=Anne Arundel Community College"
>>  attributes="*"
>>  server="server_name_here"
>>  port="389"
>>  username="mydomain\username"
>>  password="password">
>
>
> Thanks, I tried that with username="aacc\username" as well as
> username="fullhostname\username" and both give me a cold fusion error:
> "Inappropriate authentication"
>
> Do you have any examples or know where I could find one (I've done some
> searching) of cold fusion ldap accessing a microsoft active directory
> server?  Maybe I've missed something entirely.  :-(  It's made harder 
> by the
> fact that I don't have any control over the directory settings(though 
> in the
> long run, I'm probably better off--hehe), and my admin isn't inclined 
> to
> being vast amounts of help.
>
> Thanks,
> Janice
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Vernaillen Tim]

idd, it's right, i looked it up, it's possible.

are you sure you have no 'cn' or 'ou', so no subgroups

eg: o=Carnegie Mellon University, ou=group1, ou=group2

-Original Message-
From: Zimba, Janice C. [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:42
To: CF-Talk
Subject: RE: Question about cf and ldap


I'm not sure at all, but I think it must be ok because I tried accessing a public one 
I found at Carnegie Mellon with the following code and it worked fine: 



Think I've maybe got a couple of things going on with mine...first, its microsoft 
(doh) and second, I might have authentication problems.

Thanks,
Janice

-Original Message-
From: Vernaillen Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:36 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


are you sure the start parameter is right (o=Anne Arundel Commu...)?
I don't know for sure, but I think it's not allowed to use spaces.


-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name, 
>>not just the actual username, but I'm not sure what this means.  
>
>You probably need to use a full-qualified Windows domain name.  In 
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College" 
>   attributes="*" 
>   server="server_name_here" 
>   port="389" 
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as 
username="fullhostname\username" and both give me a cold fusion error: "Inappropriate 
authentication"

Do you have any examples or know where I could find one (I've done some searching) of 
cold fusion ldap accessing a microsoft active directory server?  Maybe I've missed 
something entirely.  :-(  It's made harder by the fact that I don't have any control 
over the directory settings(though in the long run, I'm probably better off--hehe), 
and my admin isn't inclined to being vast amounts of help.  

Thanks,
Janice




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: DevNet Pro watermark

[Thomas Chiverton]

On Thursday 21 Aug 2003 20:08 pm, Calvin Ward wrote:
> something of this nature. Having to spend time coding around something that

If you're not setting content-type correctly, it's hardly 'work around' to do 
it the right way.

-- 
Tom C
"Land of the free, home of the brave... you have to be brave to live there and 
enjoy the freedoms"

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Zimba, Janice C.]

*grin* im not sure about anything, really.  how do i find out about whether i have 
subgroups?  guess i need to ask the administrator (he doesn't seem to know much 
either, really).  is there any other way to find out?  

-Original Message-
From: Vernaillen Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:49 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


idd, it's right, i looked it up, it's possible.

are you sure you have no 'cn' or 'ou', so no subgroups

eg: o=Carnegie Mellon University, ou=group1, ou=group2

-Original Message-
From: Zimba, Janice C. [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:42
To: CF-Talk
Subject: RE: Question about cf and ldap


I'm not sure at all, but I think it must be ok because I tried accessing a public one 
I found at Carnegie Mellon with the following code and it worked fine: 



Think I've maybe got a couple of things going on with mine...first, its microsoft 
(doh) and second, I might have authentication problems.

Thanks,
Janice

-Original Message-
From: Vernaillen Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:36 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


are you sure the start parameter is right (o=Anne Arundel Commu...)?
I don't know for sure, but I think it's not allowed to use spaces.


-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: vrijdag 22 augustus 2003 15:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name, 
>>not just the actual username, but I'm not sure what this means.  
>
>You probably need to use a full-qualified Windows domain name.  In 
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College" 
>   attributes="*" 
>   server="server_name_here" 
>   port="389" 
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as 
username="fullhostname\username" and both give me a cold fusion error: "Inappropriate 
authentication"

Do you have any examples or know where I could find one (I've done some searching) of 
cold fusion ldap accessing a microsoft active directory server?  Maybe I've missed 
something entirely.  :-(  It's made harder by the fact that I don't have any control 
over the directory settings(though in the long run, I'm probably better off--hehe), 
and my admin isn't inclined to being vast amounts of help.  

Thanks,
Janice





~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[Zimba, Janice C.]

i found a tutorial on jndi, never mind.  i'll look into that.  i've yet to integrate 
java with cf..i hear its easy tho?

-Original Message-
From: Zimba, Janice C. 
Sent: Friday, August 22, 2003 9:43 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


what's jndi? 

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 9:44 AM
To: CF-Talk
Subject: RE: Question about cf and ldap


You can alway use jndi easily enough too.
There is a bug with ssl/ ldap on linux cfmx, afaiRemember..

WG


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:35
To: CF-Talk
Subject: RE: Question about cf and ldap


I remember seeing a good cf ldap example here..
http://www.15seconds.com/issue/020710.htm

WG

-Original Message-
From: Janice Zimba [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:29
To: CF-Talk
Subject: Question about cf and ldap


>I read somewhere that it needs to be a full name,
>>not just the actual username, but I'm not sure what this means.
>
>You probably need to use a full-qualified Windows domain name.  In
>your code snippet, it would be something like the following:
>
>  name="ldap_test"
>   start="o=Anne Arundel Community College"
>   attributes="*"
>   server="server_name_here"
>   port="389"
>   username="mydomain\username"
>   password="password">


Thanks, I tried that with username="aacc\username" as well as
username="fullhostname\username" and both give me a cold fusion error:
"Inappropriate authentication"

Do you have any examples or know where I could find one (I've done some
searching) of cold fusion ldap accessing a microsoft active directory
server?  Maybe I've missed something entirely.  :-(  It's made harder by the
fact that I don't have any control over the directory settings(though in the
long run, I'm probably better off--hehe), and my admin isn't inclined to
being vast amounts of help.

Thanks,
Janice





~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: multiple user login

[Jochem van Dieten]

Margrit John wrote:
> 
> I' am using CF MX and made a login with cflogin. IE allows 
> on the same computer multiple different users to login. 
> Mozilla accepts only one user to login.
> 
> If I login twice with two different users in Mozilla, the 
> second logedin user gets to see the page of the first 
> logedin user. 
> 
> Has anyone an idea how to handle this?

Which behaviour do you want?

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

static SSI (?) and dynamic SSI (cfinclude) with CF

[Benoit Hediard]

Hi everyone,

We were using a file-based caching system doing SSI (server side include)
based on  (to cache sections of pages).

The problem with cfinclude : it performs a dynamic SSI, not a static SSI.
Even if you include an html page, it will be still parsed and considered as
a ColdFusion template.
The results : with trusted cache turned on, it will never serve new
includes... (even if you delete the html cache file).

In order to solve this problem, we are now using  and
 to include the content of the html cache file.

My questions are :

1. Is there a more efficient way to perform a static SSI with CF?

2. Don't you think that a new attribute to  could be added :
 (default, dynamic SSI for CF
pages, included content is parsed and executed)
or  (static SSI, content is not
parsed, just included)


Benoit Hediard




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: ckeck for finished download

[Jochem van Dieten]

Margrit John wrote:
> 
> I have a page, where users can download files. It is done 
> with cfheader and cfcontent. I want to receive a mail, as 
> soon as the download is finished. 
> 
> I manage to send a mail (cfmail), if the user starts the 
> download. That means, when I receive the mail, I am not 
> shure, if the user ever finished the download.
> 
> Is there a possibility to check if a download is finished?

Check the number of bytes sent in te webserver logfile. You need 
to run that as a batch operation, you can't do it realtime.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Question about cf and ldap

[webguy]

Java Naming and Directory Interface (JNDI)
http://java.sun.com/products/jndi/

Dead simple to use.

Learn all about it here: http://java.sun.com/products/jndi/tutorial/


~ WG

-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 14:44
To: CF-Talk
Subject: Re: Question about cf and ldap


I think cfldap is a one of the few examples where it is harder to use
CFML than Java; use JNDI.

-Matt

On Friday, August 22, 2003, at 09:44 AM, webguy wrote:

> You can alway use jndi easily enough too.
> There is a bug with ssl/ ldap on linux cfmx, afaiRemember..
>
> WG
>
>
> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]
> Sent: 22 August 2003 14:35
> To: CF-Talk
> Subject: RE: Question about cf and ldap
>
>
> I remember seeing a good cf ldap example here..
> http://www.15seconds.com/issue/020710.htm
>
> WG
>
> -Original Message-
> From: Janice Zimba [mailto:[EMAIL PROTECTED]
> Sent: 22 August 2003 14:29
> To: CF-Talk
> Subject: Question about cf and ldap
>
>
>> I read somewhere that it needs to be a full name,
>>> not just the actual username, but I'm not sure what this means.
>>
>> You probably need to use a full-qualified Windows domain name.  In
>> your code snippet, it would be something like the following:
>>
>>  >  name="ldap_test"
>>  start="o=Anne Arundel Community College"
>>  attributes="*"
>>  server="server_name_here"
>>  port="389"
>>  username="mydomain\username"
>>  password="password">
>
>
> Thanks, I tried that with username="aacc\username" as well as
> username="fullhostname\username" and both give me a cold fusion error:
> "Inappropriate authentication"
>
> Do you have any examples or know where I could find one (I've done some
> searching) of cold fusion ldap accessing a microsoft active directory
> server?  Maybe I've missed something entirely.  :-(  It's made harder
> by the
> fact that I don't have any control over the directory settings(though
> in the
> long run, I'm probably better off--hehe), and my admin isn't inclined
> to
> being vast amounts of help.
>
> Thanks,
> Janice
>
>
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Kwang Suh]

Yes, mySQL does have problems with data typing, and not just with dates.

Let's hope they fix this in later versions.

- Original Message - 
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 2:38 AM
Subject: Re: MS SQL Server vs. MySQL


> [EMAIL PROTECTED] wrote:
> >
> > Oh, and mySQL's date handling is far, far superior to SQL Server's.
It's on a whole other level.
>
> I hope you were being cynical. But just to make sure everybody
> understands how hopelessly evil date handling in MySQL is:
>
> > mysql> create table test (a date);
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> insert into test values (-1);
> > Query OK, 1 row affected (0.01 sec)
> >
> > mysql> insert into test values ('1996-02-31');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> insert into test values ('1996-67-31');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select * from test;
> > ++
> > | a  |
> > ++
> > | -00-00 |
> > | 1996-02-31 |
> > | -00-00 |
> > ++
> > 3 rows in set (0.00 sec)
>
> That is indeed a whole other level.
>
> Jochem
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: static SSI (?) and dynamic SSI (cfinclude) with CF

[Matt Liotta]

Have you tried including the HTML file using JSP:include?

-Matt

On Friday, August 22, 2003, at 09:54 AM, Benoit Hediard wrote:

> Hi everyone,
>
> We were using a file-based caching system doing SSI (server side 
> include)
> based on  (to cache sections of pages).
>
> The problem with cfinclude : it performs a dynamic SSI, not a static 
> SSI.
> Even if you include an html page, it will be still parsed and 
> considered as
> a ColdFusion template.
> The results : with trusted cache turned on, it will never serve new
> includes... (even if you delete the html cache file).
>
> In order to solve this problem, we are now using  action="read"> and
>  to include the content of the html cache file.
>
> My questions are :
>
> 1. Is there a more efficient way to perform a static SSI with CF?
>
> 2. Don't you think that a new attribute to  could be added :
>  (default, dynamic SSI for CF
> pages, included content is parsed and executed)
> or  (static SSI, content is not
> parsed, just included)
>
>
> Benoit Hediard
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

CFREPORT

[Kris Pilles]

Do you need Crystal Reports Enterprise to use CFREPORT???

We have verion 9 of the report application server  and I get the
following error:

Error Occurred While Processing Request 
The Crystal Reports Engine (CRPE32.DLL) could not be located on this
server. ColdFusion's reporting functionality requires the Crystal
Engine. Please verify that you have installed this component before
using the CFREPORT tag. 


Please try the following: 
*   Enable Robust Exception Information to provide greater detail
about the source of errors. In the Administrator, click Debugging &
Logging > Debugging Settings, and select the Robust Exception
Information option. 
*   Check the ColdFusion documentation
  to verify that you are
using the correct syntax. 
*   Search the Knowledge Base
  to find a solution to
your problem.   
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
CLR 1.0.3705; .NET CLR 1.1.4322)
Remote Address  7.1.1.4 
Referrerhttp://webmaster.wsboces.org/Crystal/index.cfm  
Date/Time   22-Aug-03 10:10 AM  


Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Jochem van Dieten]

Bryan Stevenson wrote:
> 
> I'd also like to hear more about Postgre(s)?  It sounds as though it has the
> features MySQL is missing?  Does it have a better/easier interface (more
> like Enterprise Manager)?  What OS does it work on?

The proper name is PostgreSQL. http://www.postgresql.org/

It has many of the more advanced SQL feautures, including views, 
triggers, UDFs, schema's, subqueries, referential integrity, 
domains etc.
It runs on all mainstream Unices, but if you want to run it on 
Windows you will have to use Cygwin compatibility software or you 
have to compile your own native version (7.2.1, main tree is at 
7.3.4).

Probably the best free interface around is pgAdmin3 (Windows, OS 
X, Linux), http://www.pgadmin.org/pgadmin3/ (currently in beta, 
but I have been using it for months because it works with unicode 
(not just unicode DML, also unicode DDL)).

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: static SSI (?) and dynamic SSI (cfinclude) with CF

[Benoit Hediard]

Indeed, it might work.
Unfortunately, we're using CFMX 6.1 Standard (ex. Pro), so we don't have
access to JSP features/taglib.

Benoit

-Message d'origine-
De : Matt Liotta [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 22 août 2003 16:08
À : CF-Talk
Objet : Re: static SSI (?) and dynamic SSI (cfinclude) with CF


Have you tried including the HTML file using JSP:include?

-Matt

On Friday, August 22, 2003, at 09:54 AM, Benoit Hediard wrote:

> Hi everyone,
>
> We were using a file-based caching system doing SSI (server side
> include)
> based on  (to cache sections of pages).
>
> The problem with cfinclude : it performs a dynamic SSI, not a static
> SSI.
> Even if you include an html page, it will be still parsed and
> considered as
> a ColdFusion template.
> The results : with trusted cache turned on, it will never serve new
> includes... (even if you delete the html cache file).
>
> In order to solve this problem, we are now using  action="read"> and
>  to include the content of the html cache file.
>
> My questions are :
>
> 1. Is there a more efficient way to perform a static SSI with CF?
>
> 2. Don't you think that a new attribute to  could be added :
>  (default, dynamic SSI for CF
> pages, included content is parsed and executed)
> or  (static SSI, content is not
> parsed, just included)
>
>
> Benoit Hediard
>
>
>
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFREPORT

[Douglas.Knudsen]

I don't use Crystal, but I did see this when researching the upgrade to CFMX
http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_crystal85.htm

hth

Doug

>-Original Message-
>From: Kris Pilles [mailto:[EMAIL PROTECTED]
>Sent: Friday, August 22, 2003 10:11 AM
>To: CF-Talk
>Subject: CFREPORT
>
>
>Do you need Crystal Reports Enterprise to use CFREPORT???
>
>We have verion 9 of the report application server  and I get the
>following error:
>
>Error Occurred While Processing Request 
>The Crystal Reports Engine (CRPE32.DLL) could not be located on this
>server. ColdFusion's reporting functionality requires the Crystal
>Engine. Please verify that you have installed this component before
>using the CFREPORT tag.
>   
>   
>Please try the following: 
>*  Enable Robust Exception Information to provide greater detail
>about the source of errors. In the Administrator, click Debugging &
>Logging > Debugging Settings, and select the Robust Exception
>Information option. 
>*  Check the ColdFusion documentation
>  to verify that you are
>using the correct syntax. 
>*  Search the Knowledge Base
>  to find a solution to
>your problem.  
>BrowserMozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
>CLR 1.0.3705; .NET CLR 1.1.4322)   
>Remote Address 7.1.1.4 
>Referrer   http://webmaster.wsboces.org/Crystal/index.cfm  
>Date/Time  22-Aug-03 10:10 AM  
>
>
>Kris Pilles
>Website Manager
>Western Suffolk BOCES
>507 Deer Park Rd., Building C
>Phone: 631-549-4900 x 267
>E-mail: [EMAIL PROTECTED]
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Jeff]

1. Query a verity collection, return the results as "key, title, body" (also
get back a score)
2. Query a 2nd verity collection, return the results as "key, title, body"
(also get back a score)
3. Create a structure to hold the results.
4. Create an Array to hold the structure.
5. Loop over the first set of results, storing everything AND the score in
the struct, then storing that as an entry in the array
6. Loop over the second set of results storing everything AND the score in
the struct, then storing that as an entry in the *SAME* array.
7. Now I should have an array that has a structure containing a key, a
title, a score and a body for each result (it's not a lot of information,
just a string).
8. Sort the array by the score, combining the results of both collections
and outputting them with the high scores at the top (naturally).

Is that so hard to do? Am I thinking of it wrong? Is my approach somehow
wrong?

Each collection (and once I figure it out for two collections, there will be
MANY collections eventually added) contains a small amount of data that will
need to be displayed differently, depending on which collection it came
from. I want to *present* the results, sorted by score as "one" result, but
each link will be passing a variable that will determine how it's displayed
on the following linked page.

Make sense? That's why I can't just search a bunch of collections, because
*which* collection the result came from will determine how it's going to be
displayed.

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFREPORT

[Josh Remus]

I could never get CFREPORT to work for me, but this tech note explains what
needs to be done to correct THAT problem.
51249
Crystal Reports 9 no longer installs the crpe32.dll file in the
C:\Winnt\system32 directory; it installs the file in the C:\Program
Files\Common Files\Crystal Decisions\2.0\bin directory. ColdFusion looks for
this file in the C:\Winnt\system32 directory. If the wrong version of the
crpe32.dll is in theC:\Winnt\system32 directory, users receive the error "An
unexpected error occurred while using the Crystal Engine.Error number 525
occurred."

If you use Crystal Reports 9, copy the crpe32.dll file from the C:\Program
Files\Common Files\Crystal Decisions\2.0\bin directory to the
C:\Winnt\system32 directory.


> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 10:11 AM
> To: CF-Talk
> Subject: CFREPORT
>
>
> Do you need Crystal Reports Enterprise to use CFREPORT???
>
> We have verion 9 of the report application server  and I get the
> following error:
>
> Error Occurred While Processing Request
> The Crystal Reports Engine (CRPE32.DLL) could not be located on this
> server. ColdFusion's reporting functionality requires the Crystal
> Engine. Please verify that you have installed this component before
> using the CFREPORT tag.
>
>
> Please try the following:
> * Enable Robust Exception Information to provide greater detail
> about the source of errors. In the Administrator, click Debugging &
> Logging > Debugging Settings, and select the Robust Exception
> Information option.
> * Check the ColdFusion documentation
>   to verify that you are
> using the correct syntax.
> * Search the Knowledge Base
>   to find a solution to
> your problem.
> Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
> CLR 1.0.3705; .NET CLR 1.1.4322)
> Remote Address7.1.1.4
> Referrer  http://webmaster.wsboces.org/Crystal/index.cfm
> Date/Time 22-Aug-03 10:10 AM
>
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: static SSI (?) and dynamic SSI (cfinclude) with CF

[Matt Liotta]

You don't need to use the tag itself, just do 
getPageContent().include("path here").

-Matt

On Friday, August 22, 2003, at 10:14 AM, Benoit Hediard wrote:

> Indeed, it might work.
> Unfortunately, we're using CFMX 6.1 Standard (ex. Pro), so we don't 
> have
> access to JSP features/taglib.
>
> Benoit
>
> -Message d'origine-
> De : Matt Liotta [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 22 août 2003 16:08
> À : CF-Talk
> Objet : Re: static SSI (?) and dynamic SSI (cfinclude) with CF
>
>
> Have you tried including the HTML file using JSP:include?
>
> -Matt
>
> On Friday, August 22, 2003, at 09:54 AM, Benoit Hediard wrote:
>
>> Hi everyone,
>>
>> We were using a file-based caching system doing SSI (server side
>> include)
>> based on  (to cache sections of pages).
>>
>> The problem with cfinclude : it performs a dynamic SSI, not a static
>> SSI.
>> Even if you include an html page, it will be still parsed and
>> considered as
>> a ColdFusion template.
>> The results : with trusted cache turned on, it will never serve new
>> includes... (even if you delete the html cache file).
>>
>> In order to solve this problem, we are now using > action="read"> and
>>  to include the content of the html cache file.
>>
>> My questions are :
>>
>> 1. Is there a more efficient way to perform a static SSI with CF?
>>
>> 2. Don't you think that a new attribute to  could be added 
>> :
>>  (default, dynamic SSI for CF
>> pages, included content is parsed and executed)
>> or  (static SSI, content is 
>> not
>> parsed, just included)
>>
>>
>> Benoit Hediard
>>
>>
>>
>>
>>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFREPORT

[Kris Pilles]

Thanks... I copied over the DLLnow lets hope the rest works

-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2003 10:23 AM
To: CF-Talk
Subject: RE: CFREPORT


I could never get CFREPORT to work for me, but this tech note explains
what needs to be done to correct THAT problem. 51249
Crystal Reports 9 no longer installs the crpe32.dll file in the
C:\Winnt\system32 directory; it installs the file in the C:\Program
Files\Common Files\Crystal Decisions\2.0\bin directory. ColdFusion looks
for this file in the C:\Winnt\system32 directory. If the wrong version
of the crpe32.dll is in theC:\Winnt\system32 directory, users receive
the error "An unexpected error occurred while using the Crystal
Engine.Error number 525 occurred."

If you use Crystal Reports 9, copy the crpe32.dll file from the
C:\Program Files\Common Files\Crystal Decisions\2.0\bin directory to the
C:\Winnt\system32 directory.


> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 10:11 AM
> To: CF-Talk
> Subject: CFREPORT
>
>
> Do you need Crystal Reports Enterprise to use CFREPORT???
>
> We have verion 9 of the report application server  and I get the 
> following error:
>
> Error Occurred While Processing Request
> The Crystal Reports Engine (CRPE32.DLL) could not be located on this 
> server. ColdFusion's reporting functionality requires the Crystal

> Engine. Please verify that you have installed this component before 
> using the CFREPORT tag.
>
>
> Please try the following:
> * Enable Robust Exception Information to provide greater detail
> about the source of errors. In the Administrator, click Debugging & 
> Logging > Debugging Settings, and select the Robust Exception 
> Information option.
> * Check the ColdFusion documentation
>   to verify that you are 
> using the correct syntax.
> * Search the Knowledge Base
>   to find a solution to

> your problem.
> Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
> CLR 1.0.3705; .NET CLR 1.1.4322)
> Remote Address7.1.1.4
> Referrer  http://webmaster.wsboces.org/Crystal/index.cfm
> Date/Time 22-Aug-03 10:10 AM
>
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
>
>
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[webguy]

why not do this

1. Query a verity collection, return the results as "key, title, body" (also
get back a score)

2. Query a 2nd verity collection, return the results as "key, title, body"
(also get back a score)




SELECT * FROM Query1
UNION
SELECT * FROM Query2
order  scores desc



WG


-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 15:23
To: CF-Talk
Subject: Arrrgh, this is driving me crazy, and I know it's so simple to
do...


1. Query a verity collection, return the results as "key, title, body" (also
get back a score)
2. Query a 2nd verity collection, return the results as "key, title, body"
(also get back a score)
3. Create a structure to hold the results.
4. Create an Array to hold the structure.
5. Loop over the first set of results, storing everything AND the score in
the struct, then storing that as an entry in the array
6. Loop over the second set of results storing everything AND the score in
the struct, then storing that as an entry in the *SAME* array.
7. Now I should have an array that has a structure containing a key, a
title, a score and a body for each result (it's not a lot of information,
just a string).
8. Sort the array by the score, combining the results of both collections
and outputting them with the high scores at the top (naturally).

Is that so hard to do? Am I thinking of it wrong? Is my approach somehow
wrong?

Each collection (and once I figure it out for two collections, there will be
MANY collections eventually added) contains a small amount of data that will
need to be displayed differently, depending on which collection it came
from. I want to *present* the results, sorted by score as "one" result, but
each link will be passing a variable that will determine how it's displayed
on the following linked page.

Make sense? That's why I can't just search a bunch of collections, because
*which* collection the result came from will determine how it's going to be
displayed.


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Jeff]

on 8/22/03 10:32 AM, webguy at [EMAIL PROTECTED] wrote:
> why not do this
> 
> 1. Query a verity collection, return the results as "key, title, body" (also
> get back a score)
> 
> 2. Query a 2nd verity collection, return the results as "key, title, body"
> (also get back a score)
> 
> 
>  
> SELECT * FROM Query1
> UNION
> SELECT * FROM Query2
> order  scores desc
> 

Okay, I haven't even tried it yet, but I damn near fainted when I saw it...I
KNEW it would be something easy like this. I KNEW it!

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFREPORT

[Kris Pilles]

OK.  I got it to work.  Now, is there a way with CFREPORT to print the
report or generate it as a pdf?

KP

-Original Message-
From: Kris Pilles 
Sent: Friday, August 22, 2003 10:28 AM
To: CF-Talk
Subject: RE: CFREPORT


Thanks... I copied over the DLLnow lets hope the rest works

-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2003 10:23 AM
To: CF-Talk
Subject: RE: CFREPORT


I could never get CFREPORT to work for me, but this tech note explains
what needs to be done to correct THAT problem. 51249
Crystal Reports 9 no longer installs the crpe32.dll file in the
C:\Winnt\system32 directory; it installs the file in the C:\Program
Files\Common Files\Crystal Decisions\2.0\bin directory. ColdFusion looks
for this file in the C:\Winnt\system32 directory. If the wrong version
of the crpe32.dll is in theC:\Winnt\system32 directory, users receive
the error "An unexpected error occurred while using the Crystal
Engine.Error number 525 occurred."

If you use Crystal Reports 9, copy the crpe32.dll file from the
C:\Program Files\Common Files\Crystal Decisions\2.0\bin directory to the
C:\Winnt\system32 directory.


> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 10:11 AM
> To: CF-Talk
> Subject: CFREPORT
>
>
> Do you need Crystal Reports Enterprise to use CFREPORT???
>
> We have verion 9 of the report application server  and I get the
> following error:
>
> Error Occurred While Processing Request
> The Crystal Reports Engine (CRPE32.DLL) could not be located on this
> server. ColdFusion's reporting functionality requires the Crystal

> Engine. Please verify that you have installed this component before
> using the CFREPORT tag.
>
>
> Please try the following:
> * Enable Robust Exception Information to provide greater detail
> about the source of errors. In the Administrator, click Debugging &
> Logging > Debugging Settings, and select the Robust Exception 
> Information option.
> * Check the ColdFusion documentation
>   to verify that you are 
> using the correct syntax.
> * Search the Knowledge Base
>   to find a solution to

> your problem.
> Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
> CLR 1.0.3705; .NET CLR 1.1.4322)
> Remote Address7.1.1.4
> Referrer  http://webmaster.wsboces.org/Crystal/index.cfm
> Date/Time 22-Aug-03 10:10 AM
>
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
>
>
> 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Okay, how could I accomplish this?

[Andrew Golden]

At 06:43 PM 8/21/2003 -0400, you wrote:
>Let's say I query two collections. I know for each collection from a 
>Table, I'll be getting #key#, #title#, #custom1#, #body#. I also know I'll 
>be returning "Score" as well, and I'd like to somehow combine the query 
>results and output them sorted by score. That way, the output, which would 
>be identical:
>#score# - 
>Can you put them in a struct, then somehow sort the struct contents by 
>score, then output? Am I on the right track?

I would create a blank query and write the results from both of your 
queries to it. Then do a query-of-query with ORDER BY score. That should do 
it...Just from a quick glance anyway.

Andrew Golden


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: static SSI (?) and dynamic SSI (cfinclude) with CF

[Benoit Hediard]

This morning, I thought I've tested getPageContext().include("path here")
and it didn't work.
I've re-tested it and now it works (probably not very well awake this
morning...).

jsp:include allows you to include eihter a static or dynamic file (it
handles automatically both types of files), so it solves the problem.

Thanks Matt.

Benoit

-Message d'origine-
De : Matt Liotta [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 22 août 2003 16:24
À : CF-Talk
Objet : Re: static SSI (?) and dynamic SSI (cfinclude) with CF


You don't need to use the tag itself, just do
getPageContent().include("path here").

-Matt

On Friday, August 22, 2003, at 10:14 AM, Benoit Hediard wrote:

> Indeed, it might work.
> Unfortunately, we're using CFMX 6.1 Standard (ex. Pro), so we don't
> have
> access to JSP features/taglib.
>
> Benoit
>
> -Message d'origine-
> De : Matt Liotta [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 22 août 2003 16:08
> À : CF-Talk
> Objet : Re: static SSI (?) and dynamic SSI (cfinclude) with CF
>
>
> Have you tried including the HTML file using JSP:include?
>
> -Matt
>
> On Friday, August 22, 2003, at 09:54 AM, Benoit Hediard wrote:
>
>> Hi everyone,
>>
>> We were using a file-based caching system doing SSI (server side
>> include)
>> based on  (to cache sections of pages).
>>
>> The problem with cfinclude : it performs a dynamic SSI, not a static
>> SSI.
>> Even if you include an html page, it will be still parsed and
>> considered as
>> a ColdFusion template.
>> The results : with trusted cache turned on, it will never serve new
>> includes... (even if you delete the html cache file).
>>
>> In order to solve this problem, we are now using > action="read"> and
>>  to include the content of the html cache file.
>>
>> My questions are :
>>
>> 1. Is there a more efficient way to perform a static SSI with CF?
>>
>> 2. Don't you think that a new attribute to  could be added
>> :
>>  (default, dynamic SSI for CF
>> pages, included content is parsed and executed)
>> or  (static SSI, content is
>> not
>> parsed, just included)
>>
>>
>> Benoit Hediard
>>
>>
>>
>>
>>
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Benorama.com

[Fetter, Brad]

Hi Benoit,

I would interested in best practices word doc. Thanks for a great website.

Thanks,
Brad Fetter
[EMAIL PROTECTED]
FLIR Systems Inc.


-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 7:00 AM
To: CF-Talk
Subject: RE: Benorama.com


Hi,

I'll put benorama.com online by the end of the month...
We just launch our new MX app so I don't have the time to work on benorama.

Till then, if you want, I can send you the .doc version of the articles
(CFMX best practices).
FYI, you still have access to the presentation I did on MVC at CF-Europe :
http://www.cf-europe.org/preso/bhediard/168409/index.html


Thanks!

Benoit Hediard
www.benorama.com (dead link...;) )

PS : for people in charge of cf-europe website, there is a big CF error on
the home page.

-Message d'origine-
De : Jim Campbell [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 6 août 2003 15:46
À : CF-Talk
Objet : Re: Benorama.com


Google cache?

- Jim

Brad Roberts wrote:

>Anyone know if the site will be up soon?  Is there another way to get to
the
>site?
>
>-Brad
>
>
>


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[webguy]

To be reallt cool , create a cfc, that allows you to n amount of collections

[psuedocode time ]






add collection to collections Array














order by score








x = my.cfc
x.addcollection("whatever1")
x.addcollection("whatever2")
rs = x.query("`film{ing,ed}`")

WG




-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 15:40
To: CF-Talk
Subject: Re: Arrrgh, this is driving me crazy, and I know it's so simple
to do...


on 8/22/03 10:32 AM, webguy at [EMAIL PROTECTED] wrote:
> why not do this
>
> 1. Query a verity collection, return the results as "key, title, body"
(also
> get back a score)
>
> 2. Query a 2nd verity collection, return the results as "key, title, body"
> (also get back a score)
>
>
> 
> SELECT * FROM Query1
> UNION
> SELECT * FROM Query2
> order  scores desc
> 

Okay, I haven't even tried it yet, but I damn near fainted when I saw it...I
KNEW it would be something easy like this. I KNEW it!


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: form/javascript help

[Phillip B]

Where can I find the drop-in HTML editor in DWMX? 

Phillip B.

www.LoungeRoyale.com
www.FillWorks.com
- Original Message - 
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 9:00 PM
Subject: RE: form/javascript help


> Oops, I totally overlooked that part of the requirement. You could dig
> into some of the HTML editors that are floating around out there. I
> noticed recently that DWMX has a drop-in HTML editor as an object.

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

oracle datasource as OLEDB

[Sheila Handler]

Even if Oracle is not one of the choices on the drop-down in the CF5Pro Admin ODBC 
data sources page?

>> Actually the clients have pro; from the documentation, it 
>> seemed to me that only Enterprise supports Oracle, and I told 
>> them they'd have to upgrade. Is that true? Or can they use MS 
>> ODBC drivers for Oracle on CF5 Pro?
>
>You should be able to use any ODBC drivers, including those for Oracle, from
>CF 5 Professional.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: opening a word document

[Michael Traher]

You might want to check out Allen Manning's presentation from cfEurope
on the uses of CFCONTENT and CFHEADER to control this kind of thing.  It
does not give you complete control (as already mentioned) since there
are client controlled issues.

http://www.cf-europe.org/preso/amanning/169406/index.html 

Michael Traher 
Systems Manager
ICLP (London)
Tel: UK +44 (0) 20 8256 9072
Fax: UK +44 (0) 20 8681 0234 

This e-mail may contain privileged and confidential information and/or
copyright material and is intended for the use of the addressee only. If
you receive this e-mail by mistake please advise the sender immediately
by using the reply facility in your e-mail software and delete this
e-mail from your computer system. You may not deliver, copy or disclose
its contents to anyone else. Any unauthorised use may be unlawful. Any
views expressed in this e-mail are those of the individual sender and
may not necessarily reflect the views of ICLP. 
 
 

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: 21 August 2003 23:58
To: CF-Talk
Subject: opening a word document

Hello all,
 
I'm have an anchor that points to a word document.. How would I get the
browser to open that word doc and not prompt whether to open or save it?
 
Thanks,
Tim
 
 
 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Bryan Stevenson]

Thanks for actually answering my questions Jochem ;-)

and many thanks to everyone else that put in their 2 centsmuch
appreciated...opions may take longer to filter...but still way better than
the docs ;-)

I'm going to have to dive into the non-Windows development environment
someday soon (not that I love MS by any stretchbut I know the tools and
rarely have a problem with them).  I don't think it will be for this project
as I don't need a learning curve mid-project ;-)

So soon I'll be back on looking for all the info I need to install
Unix/Linux with Apache and probably PostgreSQL.

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 7:13 AM
Subject: Re: MS SQL Server vs. MySQL


> Bryan Stevenson wrote:
> >
> > I'd also like to hear more about Postgre(s)?  It sounds as though it has
the
> > features MySQL is missing?  Does it have a better/easier interface (more
> > like Enterprise Manager)?  What OS does it work on?
>
> The proper name is PostgreSQL. http://www.postgresql.org/
>
> It has many of the more advanced SQL feautures, including views,
> triggers, UDFs, schema's, subqueries, referential integrity,
> domains etc.
> It runs on all mainstream Unices, but if you want to run it on
> Windows you will have to use Cygwin compatibility software or you
> have to compile your own native version (7.2.1, main tree is at
> 7.3.4).
>
> Probably the best free interface around is pgAdmin3 (Windows, OS
> X, Linux), http://www.pgadmin.org/pgadmin3/ (currently in beta,
> but I have been using it for months because it works with unicode
> (not just unicode DML, also unicode DDL)).
>
> Jochem
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do...

[Dave Watts]

> 1. Query a verity collection, return the results as "key, 
> title, body" (also get back a score)
> 2. Query a 2nd verity collection, return the results as "key, 
> title, body" (also get back a score)
> 3. Create a structure to hold the results.
> 4. Create an Array to hold the structure.
> 5. Loop over the first set of results, storing everything AND 
> the score in the struct, then storing that as an entry in the 
> array
> 6. Loop over the second set of results storing everything AND 
> the score in the struct, then storing that as an entry in the 
> *SAME* array.
> 7. Now I should have an array that has a structure containing 
> a key, a title, a score and a body for each result (it's not 
> a lot of information, just a string).
> 8. Sort the array by the score, combining the results of both 
> collections and outputting them with the high scores at the 
> top (naturally).
> 
> Is that so hard to do? Am I thinking of it wrong? Is my 
> approach somehow wrong?

It seems to be much more complicated than it needs to be.

> Each collection (and once I figure it out for two collections, 
> there will be MANY collections eventually added) contains a
> small amount of data that will need to be displayed differently, 
> depending on which collection it came from. I want to *present* 
> the results, sorted by score as "one" result, but each link will 
> be passing a variable that will determine how it's displayed
> on the following linked page.
> 
> Make sense? That's why I can't just search a bunch of collections, 
> because *which* collection the result came from will determine 
> how it's going to be displayed.

You can probably do this all with one single collection, if you like. You
can probably also do it with multiple collections, but with a single search.
All you have to do is store some differentiating factor in Verity, then use
it to determine how you'll display things. If you're storing indexed
database queries, you can easily do this when constructing your key. For
example, let's say you have two tables, and you want to index both into a
single collection. You could differentiate them by including the table name
within the key that you give to Verity:


SELECT mykey = "person:" + CONVERT(varchar, PersonID), ...
FROM person


Then, within your display code, you could parse the key - in the above case,
using the colon as a separator - to find both the table and the primary key
within the table. Alternatively, you could store information in the CUSTOM1
and CUSTOM2 fields - that might be a little easier, but wouldn't allow you
to index more than one table within the same collection if you're using
surrogate keys generated by identity columns or the like.

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

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[John Paul Ashenfelter]

Yeah, but try inserting a date into MS-SQL. Wait there's no date
datatype, just datetime. Much harder to deal with intervals (especially
since developers don't take the time to learn DateDiff() in T-SQL) when
you've got times appended to the date.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message - 
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 4:38 AM
Subject: Re: MS SQL Server vs. MySQL


> [EMAIL PROTECTED] wrote:
> >
> > Oh, and mySQL's date handling is far, far superior to SQL Server's.
It's on a whole other level.
>
> I hope you were being cynical. But just to make sure everybody
> understands how hopelessly evil date handling in MySQL is:
>
> > mysql> create table test (a date);
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> insert into test values (-1);
> > Query OK, 1 row affected (0.01 sec)
> >
> > mysql> insert into test values ('1996-02-31');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> insert into test values ('1996-67-31');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select * from test;
> > ++
> > | a  |
> > ++
> > | -00-00 |
> > | 1996-02-31 |
> > | -00-00 |
> > ++
> > 3 rows in set (0.00 sec)
>
> That is indeed a whole other level.
>
> Jochem
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

MS DTS and MySQL [was Re: RE: MS SQL Server vs. MySQL]

[John Paul Ashenfelter]

I actually frequently use DTS to convert MS Access dbs to MySQL :)

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message - 
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 7:36 PM
Subject: Re: RE: MS SQL Server vs. MySQL


> Yes, very true.  Especially things like DTS, the various export
functionality (although some of the mySQL front ends do this for you), and
the Query Analyser.
>
> - Original Message -
> From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
> Date: Thursday, August 21, 2003 5:27 pm
> Subject: RE: MS SQL Server vs. MySQL
>
> > Not to play devils advocate but... IMO - MSSQL is really NOT that
> > expensivewhen you consider the overall cost of development for a
> > high quality
> > Application.  In my opinion it can defray development costs by
> > shifting some
> > tasks (referential integrity, data routines etc) to the db
> > platform.  Yes,
> > using MySQL saves you money on the platform, but you end up
> > shoveling it out
> > to developers on the other end for more complex code base (which
> > incedentally leads to higher code maintenanance cost - an
> > reoccuring drain).
> >
> > -Original Message-
> > From: Matt Robertson [EMAIL PROTECTED]
> > Sent: Thursday, August 21, 2003 3:35 PM
> > To: CF-Talk
> > Subject: Re: MS SQL Server vs. MySQL
> >
> >
> > > Now if it's missing all that then what is itAccess on
> > > steroids?? ;-)
> >
> > Yes, precisely.  All the basics and none of the fancy stuff, plus
> > speed.  If
> > you've outgrown Access and your budget is not ready for the MSSQL
> > hit then
> > mySQL is a viable alternative.
> >
> > I use it myself quite a bit, and I do love it, but its not a full-
> > featureproduct.
> >
> > --
> > ---
> > Matt Robertson, [EMAIL PROTECTED]
> > MSB Designs, Inc. http://mysecretbase.com
> > ---
> >
> > --
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Dave Watts]

> MSDE is basically SQL server version 7

This isn't exactly correct. When SQL Server 7 was the latest version, the
then-available MSDE was essentially the same thing as SQL Server 7. Now that
SQL Server 2000 is out, MSDE is essentially the same thing as SQL Server
2000.

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

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Haggerty, Mike]

Bryan - 

I am getting in a little late on all this, but there is a true
enterprise class open source database you might want to take a look at
called SAPDB. 

http://www.sapdb.org/

Supports stored procedures, triggers, transactions, views, etc. and it
is blazingly fast. I have been using it for more than a year with no
issues. We are moving things from Oracle over to SAP left and right.

It is definitely not as popular as mysql, and I have heard a lot of
people complain about the UI. Granted, the database could be a lot more
user friendly, but I think it is no more / less confusing than Oracle on
a linux box.

M

> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, August 21, 2003 4:28 PM
> To: CF-Talk
> Subject: Re: MS SQL Server vs. MySQL
> 
> 
> OK..Clint...but what about all the Enterprise DB stuff that's 
> missing...triggers/SPs/views and even simple sub-queries etc.??
> 
> From what I've been reading MySQL just isn't at the 
> enterprise level yet...am I missing something?
> 
> Cheers
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
> 
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Clint Tredway" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, August 21, 2003 11:09 AM
> Subject: Re: MS SQL Server vs. MySQL
> 
> 
> > I will add my 2 cents..
> >
> > In my tests, MySQL is faster than MSSQL. PHPMyAdmin is 
> great from my 
> > view. It has a learning curve, but it keeps getting better 
> and better.
> >
> > Clint
> >
> > - Original Message -
> > From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, August 21, 2003 12:11 PM
> > Subject: MS SQL Server vs. MySQL
> >
> >
> > > Hey All,
> > >
> > > I'm not all that familiar with MySQL, but from what I 
> hear it's not 
> > > as
> > good
> > > as MS SQL Server (which I use along with Oracle).
> > >
> > > I've tried using MyPHPAdmin to administer MySQL before 
> and all I can 
> > > say
> > is
> > > it sucked eggs...security was confusing as all hell.
> > >
> > > The MySQL.com website says that upcoming features for version 5 
> > > include: -views -stored procedures
> > > -triggers
> > > -sub-queries
> > >
> > > Now if it's missing all that then what is itAccess on 
> steroids?? 
> > > ;-)
> > >
> > > Opinions please
> > >
> > > TIA
> > >
> > > Cheers
> > >
> > > Bryan Stevenson B.Comm.
> > > VP & Director of E-Commerce Development
> > > Electric Edge Systems Group Inc.
> > > t. 250.920.8830
> > > e. [EMAIL PROTECTED]
> > >
> > > -
> > > Macromedia Associate Partner
> > > www.macromedia.com
> > > -
> > > Vancouver Island ColdFusion Users Group
> > > Founder & Director
> > > www.cfug-vancouverisland.com
> > >
> > >
> > 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Benorama.com

[Benoit Hediard]

Hi,

www.benorama.com is back online now.

Have fun!

Benoit Hediard
www.benorama.com

-Message d'origine-
De : Fetter, Brad [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 22 août 2003 17:04
À : CF-Talk
Objet : RE: Benorama.com


Hi Benoit,

I would interested in best practices word doc. Thanks for a great website.

Thanks,
Brad Fetter
[EMAIL PROTECTED]
FLIR Systems Inc.


-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 7:00 AM
To: CF-Talk
Subject: RE: Benorama.com


Hi,

I'll put benorama.com online by the end of the month...
We just launch our new MX app so I don't have the time to work on benorama.

Till then, if you want, I can send you the .doc version of the articles
(CFMX best practices).
FYI, you still have access to the presentation I did on MVC at CF-Europe :
http://www.cf-europe.org/preso/bhediard/168409/index.html


Thanks!

Benoit Hediard
www.benorama.com (dead link...;) )

PS : for people in charge of cf-europe website, there is a big CF error on
the home page.

-Message d'origine-
De : Jim Campbell [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 6 août 2003 15:46
À : CF-Talk
Objet : Re: Benorama.com


Google cache?

- Jim

Brad Roberts wrote:

>Anyone know if the site will be up soon?  Is there another way to get to
the
>site?
>
>-Brad
>
>
>



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Ben Doom]

Maybe I'm missing something.  I currently have code up in CF 5 as such:



where request.collections can contain more than one collection, and it
searches all of them.  I just tested this and it works fine.

Has something changed in MX or RedSky?  Or is this just a problem of habit
making people look for complicated solutions?


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: webguy [mailto:[EMAIL PROTECTED]
: Sent: Friday, August 22, 2003 11:08 AM
: To: CF-Talk
: Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple
: to do...
:
:
: To be reallt cool , create a cfc, that allows you to n amount of
: collections
:
: [psuedocode time ]
:
: 
:   
:
:   
:   
:   add collection to collections Array
:   
:
:   
:   
:   
:
:
:
:
:   
:
:   
:   
:   
:   order by score
:   
:
:   
:   
:
:
: 
:
: x = my.cfc
: x.addcollection("whatever1")
: x.addcollection("whatever2")
: rs = x.query("`film{ing,ed}`")
:
: WG
:
:
:
:
: -Original Message-
: From: Jeff [mailto:[EMAIL PROTECTED]
: Sent: 22 August 2003 15:40
: To: CF-Talk
: Subject: Re: Arrrgh, this is driving me crazy, and I know it's so simple
: to do...
:
:
: on 8/22/03 10:32 AM, webguy at [EMAIL PROTECTED] wrote:
: > why not do this
: >
: > 1. Query a verity collection, return the results as "key, title, body"
: (also
: > get back a score)
: >
: > 2. Query a 2nd verity collection, return the results as "key,
: title, body"
: > (also get back a score)
: >
: >
: > 
: > SELECT * FROM Query1
: > UNION
: > SELECT * FROM Query2
: > order  scores desc
: > 
:
: Okay, I haven't even tried it yet, but I damn near fainted when I
: saw it...I
: KNEW it would be something easy like this. I KNEW it!
:
:
: 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do...

[Ryan Emerle]

This is precisely why we created our own search engine.  We can actually index 
arbitrary field names (removing the need for anything like CUSTOM1/2) and have them 
returned with the search results.  We have a very powerful suite of tags based on an 
opensource project that replaces verity and extends the searching abilities of CF 
10-fold (with about 3 times the speed).

This suite of tags will be publicly released relatively soon, free of charge.  It 
should prove to be an extremely potent, FREE, replacement for Verity.

Example,
We have an index of 75,000 articles.  Most searches take about 200ms at most, AND we 
dont need to parse out the additional information (such as articleIDs, headlines, 
release dates, etc) as they have their respective fields in the search result 
recordset.

Sorry for the ~OT, but i felt it was relevant.

-Ryan

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 11:19 AM
To: CF-Talk
Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple
t o do...

Then, within your display code, you could parse the key - in the above case,
using the colon as a separator - to find both the table and the primary key
within the table. Alternatively, you could store information in the CUSTOM1
and CUSTOM2 fields - that might be a little easier, but wouldn't allow you
to index more than one table within the same collection if you're using
surrogate keys generated by identity columns or the like.

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


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: CFREPORT

[Marlon Moyer]

No, but Crystal Decisions will sell you a piece of software that does 
for only the price of a small car. :-)

Marlon

Kris Pilles wrote:

>OK.  I got it to work.  Now, is there a way with CFREPORT to print the
>report or generate it as a pdf?
>
>KP
>
>-Original Message-
>From: Kris Pilles 
>Sent: Friday, August 22, 2003 10:28 AM
>To: CF-Talk
>Subject: RE: CFREPORT
>
>
>Thanks... I copied over the DLLnow lets hope the rest works
>
>-Original Message-
>From: Josh Remus [mailto:[EMAIL PROTECTED] 
>Sent: Friday, August 22, 2003 10:23 AM
>To: CF-Talk
>Subject: RE: CFREPORT
>
>
>I could never get CFREPORT to work for me, but this tech note explains
>what needs to be done to correct THAT problem. 51249
>   Crystal Reports 9 no longer installs the crpe32.dll file in the
>C:\Winnt\system32 directory; it installs the file in the C:\Program
>Files\Common Files\Crystal Decisions\2.0\bin directory. ColdFusion looks
>for this file in the C:\Winnt\system32 directory. If the wrong version
>of the crpe32.dll is in theC:\Winnt\system32 directory, users receive
>the error "An unexpected error occurred while using the Crystal
>Engine.Error number 525 occurred."
>
>If you use Crystal Reports 9, copy the crpe32.dll file from the
>C:\Program Files\Common Files\Crystal Decisions\2.0\bin directory to the
>C:\Winnt\system32 directory.
>
>
>  
>
>>-Original Message-
>>From: Kris Pilles [mailto:[EMAIL PROTECTED]
>>Sent: Friday, August 22, 2003 10:11 AM
>>To: CF-Talk
>>Subject: CFREPORT
>>
>>
>>Do you need Crystal Reports Enterprise to use CFREPORT???
>>
>>We have verion 9 of the report application server  and I get the
>>following error:
>>
>>Error Occurred While Processing Request
>>The Crystal Reports Engine (CRPE32.DLL) could not be located on this
>>server. ColdFusion's reporting functionality requires the Crystal
>>
>>
>
>  
>
>>Engine. Please verify that you have installed this component before
>>using the CFREPORT tag.
>>
>>
>>Please try the following:
>>* Enable Robust Exception Information to provide greater detail
>>about the source of errors. In the Administrator, click Debugging &
>>Logging > Debugging Settings, and select the Robust Exception 
>>Information option.
>>* Check the ColdFusion documentation
>>  to verify that you are 
>>using the correct syntax.
>>* Search the Knowledge Base
>>  to find a solution to
>>
>>
>
>  
>
>>your problem.
>>Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
>>CLR 1.0.3705; .NET CLR 1.1.4322)
>>Remote Address7.1.1.4
>>Referrer  http://webmaster.wsboces.org/Crystal/index.cfm
>>Date/Time 22-Aug-03 10:10 AM
>>
>>
>>Kris Pilles
>>Website Manager
>>Western Suffolk BOCES
>>507 Deer Park Rd., Building C
>>Phone: 631-549-4900 x 267
>>E-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>>
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFREPORT

[Kris Pilles]

Lol I know... That's what I was trying to avoid

-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2003 11:46 AM
To: CF-Talk
Subject: Re: CFREPORT


No, but Crystal Decisions will sell you a piece of software that does 
for only the price of a small car. :-)

Marlon

Kris Pilles wrote:

>OK.  I got it to work.  Now, is there a way with CFREPORT to print the 
>report or generate it as a pdf?
>
>KP
>
>-Original Message-
>From: Kris Pilles
>Sent: Friday, August 22, 2003 10:28 AM
>To: CF-Talk
>Subject: RE: CFREPORT
>
>
>Thanks... I copied over the DLLnow lets hope the rest works
>
>-Original Message-
>From: Josh Remus [mailto:[EMAIL PROTECTED]
>Sent: Friday, August 22, 2003 10:23 AM
>To: CF-Talk
>Subject: RE: CFREPORT
>
>
>I could never get CFREPORT to work for me, but this tech note explains 
>what needs to be done to correct THAT problem. 51249
>   Crystal Reports 9 no longer installs the crpe32.dll file in the 
>C:\Winnt\system32 directory; it installs the file in the C:\Program 
>Files\Common Files\Crystal Decisions\2.0\bin directory. ColdFusion 
>looks for this file in the C:\Winnt\system32 directory. If the wrong 
>version of the crpe32.dll is in theC:\Winnt\system32 directory, users 
>receive the error "An unexpected error occurred while using the Crystal

>Engine.Error number 525 occurred."
>
>If you use Crystal Reports 9, copy the crpe32.dll file from the 
>C:\Program Files\Common Files\Crystal Decisions\2.0\bin directory to 
>the C:\Winnt\system32 directory.
>
>
>  
>
>>-Original Message-
>>From: Kris Pilles [mailto:[EMAIL PROTECTED]
>>Sent: Friday, August 22, 2003 10:11 AM
>>To: CF-Talk
>>Subject: CFREPORT
>>
>>
>>Do you need Crystal Reports Enterprise to use CFREPORT???
>>
>>We have verion 9 of the report application server  and I get the 
>>following error:
>>
>>Error Occurred While Processing Request
>>The Crystal Reports Engine (CRPE32.DLL) could not be located on this 
>>server. ColdFusion's reporting functionality requires the Crystal
>>
>>
>
>  
>
>>Engine. Please verify that you have installed this component before 
>>using the CFREPORT tag.
>>
>>
>>Please try the following:
>>* Enable Robust Exception Information to provide greater detail
>>about the source of errors. In the Administrator, click Debugging & 
>>Logging > Debugging Settings, and select the Robust Exception 
>>Information option.
>>* Check the ColdFusion documentation
>>  to verify that you are
>>using the correct syntax.
>>* Search the Knowledge Base
>>  to find a solution to
>>
>>
>
>  
>
>>your problem.
>>Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
>>CLR 1.0.3705; .NET CLR 1.1.4322)
>>Remote Address7.1.1.4
>>Referrer  http://webmaster.wsboces.org/Crystal/index.cfm
>>Date/Time 22-Aug-03 10:10 AM
>>
>>
>>Kris Pilles
>>Website Manager
>>Western Suffolk BOCES
>>507 Deer Park Rd., Building C
>>Phone: 631-549-4900 x 267
>>E-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>>
>
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do...

[webguy]

lucene is another option. http://jakarta.apache.org/lucene/docs/index.html
AFAIK there is a cf tag in the DRK that using lucene

-Original Message-
From: Ryan Emerle [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 16:45
To: CF-Talk
Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple
t o do...


This is precisely why we created our own search engine.  We can actually
index arbitrary field names (removing the need for anything like CUSTOM1/2)
and have them returned with the search results.  We have a very powerful
suite of tags based on an opensource project that replaces verity and
extends the searching abilities of CF 10-fold (with about 3 times the
speed).

This suite of tags will be publicly released relatively soon, free of
charge.  It should prove to be an extremely potent, FREE, replacement for
Verity.

Example,
We have an index of 75,000 articles.  Most searches take about 200ms at
most, AND we dont need to parse out the additional information (such as
articleIDs, headlines, release dates, etc) as they have their respective
fields in the search result recordset.

Sorry for the ~OT, but i felt it was relevant.

-Ryan

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 11:19 AM
To: CF-Talk
Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple
t o do...

Then, within your display code, you could parse the key - in the above case,
using the colon as a separator - to find both the table and the primary key
within the table. Alternatively, you could store information in the CUSTOM1
and CUSTOM2 fields - that might be a little easier, but wouldn't allow you
to index more than one table within the same collection if you're using
surrogate keys generated by identity columns or the like.

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



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Jeff]

on 8/22/03 11:38 AM, Ben Doom at [EMAIL PROTECTED] wrote:

> Maybe I'm missing something.  I currently have code up in CF 5 as such:
> 
>  criteria="#request.searchstring#">
> 
> where request.collections can contain more than one collection, and it
> searches all of them.  I just tested this and it works fine.
> 
> Has something changed in MX or RedSky?  Or is this just a problem of habit
> making people look for complicated solutions?

There's nothing wrong with what you're doing. It's just that each of these
collections contain WILDLY different data that will determine which page the
results are displayed on. I was following Dave Watts' Solution, but the
Union of Queries seems like the best one so far, and it's working perfectly.
See, each collection is a Collection on a Query, and I'm assigning "Key,
Title, Body, Custom1, Custom2" wildly different values. I'm assigning
custom2 a value when the index is created to flag which table it's coming
from, then I'm using the key value, the title, and the custom2 to pass
combined results to a "redirect" page which will perform additional queries
(if necessary, some may be able to simply be passed on with the information
they contain, others may have to have additional queries run to get
additional information that's required to display that particular
information).

I was just planning on putting it in a switch statement that will do the
appropriate redirecting to the appropriate display page.

See, I'm hip to what you're saying, and I *hope* I'm not making it more
complicated than it needs to be, but I'm indexing about ten collections that
will all contain wildly different information contained in tables that will
need to almost all be displayed differently, but need to be searched from a
single, common interface.

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: DWMX Madness!!!

[John Wilker]

Having just fixed it or so I think

If you go to properties, code coloring. Whatever profile you use. Look for
Javascript string. Make it not be italic. Seems to have worked for me.

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 19, 2003 7:34 AM
To: CF-Talk
Subject: Re: DWMX Madness!!!


oi Massimo!!

ah  it  does sound better, but I could not get it to work. In the preview
window that is shown... it immediately  fixed  the  problem.  but  when I
went back into my code same thing "blah"; becomes "blah';

then  when  i  went back into edit it again the preview that
showed.showed incorrectly again too. oh well

thanks for the effort.


-- 



Tuesday, August 19, 2003, 10:18:18 AM, you wrote:

>> aye,  that  did  fix  it  but it made my display look extremely 
>> jagged... ah well now i've got a decision to make jagged fonts or 
>> funky double quote weirdness :)

MF> Dan Short has another way to fix it:

Edit >> Preferences
MF> Click Code Coloring
MF> Choose HTML and Click Edit Coloring Scheme.

MF> Choose Javascript String and change it to not be italic.


MF> Sounds much better to me...

MF> 
MF> Massimo Foti
MF> Certified Dreamweaver MX Developer
MF> Certified Advanced ColdFusion MX Developer
MF> http://www.massimocorner.com/
MF> 


MF> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

CFPOP and unicode-1-1-utf-7 Charset

[Watson, Nicholas]

I am getting an error when using CFPOP to retireve messages with the
unicode-1-1-utf-7 Charset. The error is as follows: 

"java.security.PrivilegedActionException: javax.mail.MessagingException:
unicode-1-1-utf-7; nested exception is:
java.io.UnsupportedEncodingException: unicode-1-1-utf-7"
Any ideas, fixes or workarounds for the problem.

Thanks,
Nicholas W. Watson
Software Engineer
Concurrent Technologies Corporation
Phone: (814) 269-2653
Email: [EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: CFPOP and unicode-1-1-utf-7 Charset

[Jochem van Dieten]

Watson, Nicholas wrote:

> I am getting an error when using CFPOP to retireve messages with the
> unicode-1-1-utf-7 Charset. The error is as follows: 
> 
> "java.security.PrivilegedActionException: javax.mail.MessagingException:
> unicode-1-1-utf-7; nested exception is:
> java.io.UnsupportedEncodingException: unicode-1-1-utf-7"
> Any ideas, fixes or workarounds for the problem.

Java bug. You can vote for it in the Sun Java bugparade.

Jochem



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: oracle datasource as OLEDB

[Dave Watts]

> > > Actually the clients have pro; from the documentation, it 
> > > seemed to me that only Enterprise supports Oracle, and I told 
> > > them they'd have to upgrade. Is that true? Or can they use MS 
> > > ODBC drivers for Oracle on CF5 Pro?
> >
> > You should be able to use any ODBC drivers, including those 
> > for Oracle, from CF 5 Professional.
>
> Even if Oracle is not one of the choices on the drop-down in 
> the CF5Pro Admin ODBC data sources page?

If I recall correctly, you should have a Merant Oracle 8 ODBC driver in your
select box. As I recall, the significant difference with Oracle between CF 5
Professional and Enterprise is that with Enterprise, you can use the Oracle
native driver, which is supposed to work better than the ODBC driver.

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

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Ben Doom]

*shrugs*  Obviously, you've got something more complicated than what I'm
seeing in my head.

What I was imagining is something more like my situation, where there's
essentially the same information being returned, but from selectable
sources.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Jeff [mailto:[EMAIL PROTECTED]
: Sent: Friday, August 22, 2003 11:54 AM
: To: CF-Talk
: Subject: Re: Arrrgh, this is driving me crazy, and I know it's so simple
: to do...
:
:
: on 8/22/03 11:38 AM, Ben Doom at [EMAIL PROTECTED] wrote:
:
: > Maybe I'm missing something.  I currently have code up in CF 5 as such:
: >
: >  criteria="#request.searchstring#">
: >
: > where request.collections can contain more than one collection, and it
: > searches all of them.  I just tested this and it works fine.
: >
: > Has something changed in MX or RedSky?  Or is this just a
: problem of habit
: > making people look for complicated solutions?
:
: There's nothing wrong with what you're doing. It's just that each of these
: collections contain WILDLY different data that will determine
: which page the
: results are displayed on. I was following Dave Watts' Solution, but the
: Union of Queries seems like the best one so far, and it's working
: perfectly.
: See, each collection is a Collection on a Query, and I'm assigning "Key,
: Title, Body, Custom1, Custom2" wildly different values. I'm assigning
: custom2 a value when the index is created to flag which table it's coming
: from, then I'm using the key value, the title, and the custom2 to pass
: combined results to a "redirect" page which will perform
: additional queries
: (if necessary, some may be able to simply be passed on with the
: information
: they contain, others may have to have additional queries run to get
: additional information that's required to display that particular
: information).
:
: I was just planning on putting it in a switch statement that will do the
: appropriate redirecting to the appropriate display page.
:
: See, I'm hip to what you're saying, and I *hope* I'm not making it more
: complicated than it needs to be, but I'm indexing about ten
: collections that
: will all contain wildly different information contained in tables
: that will
: need to almost all be displayed differently, but need to be
: searched from a
: single, common interface.
:
: 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: Arrrgh, this is driving me crazy, and I know it's so simple to do...

[Jeff]

on 8/22/03 12:14 PM, Ben Doom at [EMAIL PROTECTED] wrote:

> *shrugs*  Obviously, you've got something more complicated than what I'm
> seeing in my head.
> 
> What I was imagining is something more like my situation, where there's
> essentially the same information being returned, but from selectable
> sources.

Oh no...I understand what you're saying. Just think of it this way, you're
pretty much going to have to go to a different page for each collection
searched, but you're searching from one, common, search form, with one
search field.

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

SOT: NN6+ document.all

[John Wilker]

So I have a little menu that is populated by CF (hence the only sorta OT :)
)
 
in IE it works using document.all.divname but in netscape there is no
document.all
 
the JS bible uses Node.prototype._defineGetter_("all", function() {some
stuff.}
 
Netscapes javascript console says it doesn't recognize _defineGetter_. I
found another example using just something.propname getter= funciton() {}
 
That one seems to bomb out when I get to the line that reads
menu=eval("document.all.d" + n)  saying menu has nothing in it.
 
Any thoughts? I can cut and paste code if anyone wants to see all that.
 
John Wilker
Software Engineer, Technical Writer
Sequent Technologies.
 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

CFObject Class?

[Jeff Chastain]

This is getting beyond my everyday CF workings ...  I am working with
another application whose documentation is written for Java or .NET.   Being
a CF person, I would like to use their developers kit using ColdFusion
instead of having to take the time to learn .NET right now.   So, can
anybody give me some pointers about how to instantiate the following object
in ColdFusion?
 
Java Example Code -

<%@ page language="java" import="rgdk.*,java.util.*" %>
<%
IPortletContext edk =
PortletContextFactory.createPortletContext(request,response);
%>
 
.NET Example Code - 

Dim edk As IPortletContext
edk = PortletContextFactory.CreatePortletContext(Request, Response)
 
I am attempting to create the object using CFObject, but I am not sure what
to put for the class?
 
Thanks for any pointers.
-- Jeff


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: NN6+ document.all

[Heald, Tim]

document.getElementById() instead of document.all

Timothy Heald
Information Systems Specialist
Overseas Security Advisory Council
U.S. Department of State
571.345.2235


-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 12:38 PM
To: CF-Talk
Subject: SOT: NN6+ document.all 


So I have a little menu that is populated by CF (hence the only sorta OT :)
)
 
in IE it works using document.all.divname but in netscape there is no
document.all
 
the JS bible uses Node.prototype._defineGetter_("all", function() {some
stuff.}
 
Netscapes javascript console says it doesn't recognize _defineGetter_. I
found another example using just something.propname getter= funciton() {}
 
That one seems to bomb out when I get to the line that reads
menu=eval("document.all.d" + n)  saying menu has nothing in it.
 
Any thoughts? I can cut and paste code if anyone wants to see all that.
 
John Wilker
Software Engineer, Technical Writer
Sequent Technologies.
 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Doug White]

fascinating -   I have a client who initially developed a complicated web site
using Win2003, SQL2000, CFMX 6.1 and then decided to go to a co-located server
with another provider.  They installed Win2k, MSDE, and CFMX 6.0
When they tried to convert the SQL2k database to the MSDE installation - serious
compatibility problems arose. and their contract developers in India are
screaming about it., and demanding more $$ for the development.  MSDE and SQL 7
are mentioned prominently.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 10:33 AM
Subject: RE: MS SQL Server vs. MySQL


| > MSDE is basically SQL server version 7
|
| This isn't exactly correct. When SQL Server 7 was the latest version, the
| then-available MSDE was essentially the same thing as SQL Server 7. Now that
| SQL Server 2000 is out, MSDE is essentially the same thing as SQL Server
| 2000.
|
| Dave Watts, CTO, Fig Leaf Software
| http://www.figleaf.com/
| voice: (202) 797-5496
| fax: (202) 797-5444
|
| 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: MS SQL Server vs. MySQL

[Doug White]

SAP has been around for a long time, especially used in HR applications, etc for
large enterprises.
They just recently released a crippled version to open source, presumably to
encourage more developers to become familiar with the product, as SAP developers
are in very short supply, and are commanding six figure fees.

It is a very good product, even in the open source version, and we support it on
our hosting plans.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Haggerty, Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 10:31 AM
Subject: RE: MS SQL Server vs. MySQL


| Bryan -
|
| I am getting in a little late on all this, but there is a true
| enterprise class open source database you might want to take a look at
| called SAPDB.
|
| http://www.sapdb.org/
|
| Supports stored procedures, triggers, transactions, views, etc. and it
| is blazingly fast. I have been using it for more than a year with no
| issues. We are moving things from Oracle over to SAP left and right.
|
| It is definitely not as popular as mysql, and I have heard a lot of
| people complain about the UI. Granted, the database could be a lot more
| user friendly, but I think it is no more / less confusing than Oracle on
| a linux box.
|
| M
|
| > -Original Message-
| > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
| > Sent: Thursday, August 21, 2003 4:28 PM
| > To: CF-Talk
| > Subject: Re: MS SQL Server vs. MySQL
| >
| >
| > OK..Clint...but what about all the Enterprise DB stuff that's
| > missing...triggers/SPs/views and even simple sub-queries etc.??
| >
| > From what I've been reading MySQL just isn't at the
| > enterprise level yet...am I missing something?
| >
| > Cheers
| >
| > Bryan Stevenson B.Comm.
| > VP & Director of E-Commerce Development
| > Electric Edge Systems Group Inc.
| > t. 250.920.8830
| > e. [EMAIL PROTECTED]
| >
| > -
| > Macromedia Associate Partner
| > www.macromedia.com
| > -
| > Vancouver Island ColdFusion Users Group
| > Founder & Director
| > www.cfug-vancouverisland.com
| > - Original Message -
| > From: "Clint Tredway" <[EMAIL PROTECTED]>
| > To: "CF-Talk" <[EMAIL PROTECTED]>
| > Sent: Thursday, August 21, 2003 11:09 AM
| > Subject: Re: MS SQL Server vs. MySQL
| >
| >
| > > I will add my 2 cents..
| > >
| > > In my tests, MySQL is faster than MSSQL. PHPMyAdmin is
| > great from my
| > > view. It has a learning curve, but it keeps getting better
| > and better.
| > >
| > > Clint
| > >
| > > - Original Message -
| > > From: "Bryan Stevenson" <[EMAIL PROTECTED]>
| > > To: "CF-Talk" <[EMAIL PROTECTED]>
| > > Sent: Thursday, August 21, 2003 12:11 PM
| > > Subject: MS SQL Server vs. MySQL
| > >
| > >
| > > > Hey All,
| > > >
| > > > I'm not all that familiar with MySQL, but from what I
| > hear it's not
| > > > as
| > > good
| > > > as MS SQL Server (which I use along with Oracle).
| > > >
| > > > I've tried using MyPHPAdmin to administer MySQL before
| > and all I can
| > > > say
| > > is
| > > > it sucked eggs...security was confusing as all hell.
| > > >
| > > > The MySQL.com website says that upcoming features for version 5
| > > > include: -views -stored procedures
| > > > -triggers
| > > > -sub-queries
| > > >
| > > > Now if it's missing all that then what is itAccess on
| > steroids??
| > > > ;-)
| > > >
| > > > Opinions please
| > > >
| > > > TIA
| > > >
| > > > Cheers
| > > >
| > > > Bryan Stevenson B.Comm.
| > > > VP & Director of E-Commerce Development
| > > > Electric Edge Systems Group Inc.
| > > > t. 250.920.8830
| > > > e. [EMAIL PROTECTED]
| > > >
| > > > -
| > > > Macromedia Associate Partner
| > > > www.macromedia.com
| > > > -
| > > > Vancouver Island ColdFusion Users Group
| > > > Founder & Director
| > > > www.cfug-vancouverisland.com
| > > >
| > > >
| > >
| >
| 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Dave Watts]

> fascinating -   I have a client who initially developed a 
> complicated web site using Win2003, SQL2000, CFMX 6.1 and 
> then decided to go to a co-located server with another provider.  
> They installed Win2k, MSDE, and CFMX 6.0. When they tried to 
> convert the SQL2k database to the MSDE installation - serious
> compatibility problems arose. and their contract developers 
> in India are screaming about it., and demanding more $$ for 
> the development. MSDE and SQL 7 are mentioned prominently.

They probably used the older version of MSDE then. I can imagine it being
difficult to move from SQL Server 2000 (or MSDE 2000) to SQL Server 7 (or
MSDE 7) if you're using features new in SQL Server 2000.

>From a licensing standpoint, too, I'm not sure whether you can use MSDE for
any sort of production use with a web application, and if you can, whether
there are any limitations on its use.

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

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Josh Remus]

The answer to that question:

Q.  Can I use MSDE as a database for Web applications?

A.  MSDE is an ideal solution for low-end Web applications. The following
products and services enable you to redistribute MSDE as a database server
for Web applications:

ASP.NET Web Matrix*
MSDN Universal, Enterprise, and Professional subscriptions
Office XP Developer Edition
SQL Server 2000 Developer, Standard, and Enterprise Editions
Visual Studio .NET Architect, Developer, and Professional Editions
Visual FoxPro 7.0 or 8.0
* When obtained by downloading ASP.NET Web Matrix, MSDE is provided only
for use in conjunction with an application developed by using ASP.NET Web
Matrix.

We use MSDE to power one of our websites.  We're MSDN, so no problem then.
And MSDE for the version 7 SQL Server is definately much more common out
there (I believe you can even d/l it off of the Microsoft web site), but to
get the 2k version, you need either MSDN, Sql server 2k, or Office XP.

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 12:59 PM
> To: CF-Talk
> Subject: RE: MS SQL Server vs. MySQL
>
>
> > fascinating -   I have a client who initially developed a
> > complicated web site using Win2003, SQL2000, CFMX 6.1 and
> > then decided to go to a co-located server with another provider.
> > They installed Win2k, MSDE, and CFMX 6.0. When they tried to
> > convert the SQL2k database to the MSDE installation - serious
> > compatibility problems arose. and their contract developers
> > in India are screaming about it., and demanding more $$ for
> > the development. MSDE and SQL 7 are mentioned prominently.
>
> They probably used the older version of MSDE then. I can imagine it being
> difficult to move from SQL Server 2000 (or MSDE 2000) to SQL Server 7 (or
> MSDE 7) if you're using features new in SQL Server 2000.
>
> From a licensing standpoint, too, I'm not sure whether you can
> use MSDE for
> any sort of production use with a web application, and if you can, whether
> there are any limitations on its use.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Barney Boisvert]

The only fine print I've seen is that the key in the parent table isn't
forced to be unique by the engine, but if you're designing foreign keys that
aren't this way, then you've got far greater problems.

If there is more fine print, I'd love to hear it, but I've yet to have a
problem with using them.

barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 1:43 AM
> To: CF-Talk
> Subject: Re: MS SQL Server vs. MySQL
>
>
> Barney Boisvert wrote:
> > You get foreign key support with innoDB which has been in there
> for quite
> > some time.
>
> No you don't. Read the fine print.
>
> Jochem
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFObject Class?

[webguy]

Is this jetspeed??

If so, the full class is
org.apache.jetspeed.container.PortletContextFactory

However there is more to it then just that.

Luckly for you, Ben forta / drew falkman 's book has an example application
that uses bits of jetspeed.
which is avaialbe here http://www.forta.com/books/0321129482/


anyway something like

  

 

I expect u might need to pass in some props






or whatever, you'll be needing to get your feet wet in java I think...

WG


-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 17:36
To: CF-Talk
Subject: CFObject Class?


This is getting beyond my everyday CF workings ...  I am working with
another application whose documentation is written for Java or .NET.   Being
a CF person, I would like to use their developers kit using ColdFusion
instead of having to take the time to learn .NET right now.   So, can
anybody give me some pointers about how to instantiate the following object
in ColdFusion?

Java Example Code -

<%@ page language="java" import="rgdk.*,java.util.*" %>
<%
IPortletContext edk =
PortletContextFactory.createPortletContext(request,response);
%>

.NET Example Code -

Dim edk As IPortletContext
edk = PortletContextFactory.CreatePortletContext(Request, Response)

I am attempting to create the object using CFObject, but I am not sure what
to put for the class?

Thanks for any pointers.
-- Jeff



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

Re: DevNet Pro watermark

[Calvin Ward]

It's a work around if it is an additional requirement.

Setting content-type is not necessarily required in all forms of output.

- Calvin


- Original Message - 
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 9:51 AM
Subject: Re: DevNet Pro watermark


> On Thursday 21 Aug 2003 20:08 pm, Calvin Ward wrote:
> > something of this nature. Having to spend time coding around something
that
>
> If you're not setting content-type correctly, it's hardly 'work around' to
do
> it the right way.
>
> -- 
> Tom C
> "Land of the free, home of the brave... you have to be brave to live there
and
> enjoy the freedoms"
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: MS SQL Server vs. MySQL

[Barney Boisvert]

MySQL is taking over sapDB.  they are rebranding it right now, and then will
begin developing further versions.  For more info, check out www.mysql.com.

barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Haggerty, Mike [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 8:32 AM
> To: CF-Talk
> Subject: RE: MS SQL Server vs. MySQL
>
>
> Bryan -
>
> I am getting in a little late on all this, but there is a true
> enterprise class open source database you might want to take a look at
> called SAPDB.
>
> http://www.sapdb.org/
>
> Supports stored procedures, triggers, transactions, views, etc. and it
> is blazingly fast. I have been using it for more than a year with no
> issues. We are moving things from Oracle over to SAP left and right.
>
> It is definitely not as popular as mysql, and I have heard a lot of
> people complain about the UI. Granted, the database could be a lot more
> user friendly, but I think it is no more / less confusing than Oracle on
> a linux box.
>
> M
>
> > -Original Message-
> > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, August 21, 2003 4:28 PM
> > To: CF-Talk
> > Subject: Re: MS SQL Server vs. MySQL
> >
> >
> > OK..Clint...but what about all the Enterprise DB stuff that's
> > missing...triggers/SPs/views and even simple sub-queries etc.??
> >
> > From what I've been reading MySQL just isn't at the
> > enterprise level yet...am I missing something?
> >
> > Cheers
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > t. 250.920.8830
> > e. [EMAIL PROTECTED]
> >
> > -
> > Macromedia Associate Partner
> > www.macromedia.com
> > -
> > Vancouver Island ColdFusion Users Group
> > Founder & Director
> > www.cfug-vancouverisland.com
> > - Original Message -
> > From: "Clint Tredway" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, August 21, 2003 11:09 AM
> > Subject: Re: MS SQL Server vs. MySQL
> >
> >
> > > I will add my 2 cents..
> > >
> > > In my tests, MySQL is faster than MSSQL. PHPMyAdmin is
> > great from my
> > > view. It has a learning curve, but it keeps getting better
> > and better.
> > >
> > > Clint
> > >
> > > - Original Message -
> > > From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, August 21, 2003 12:11 PM
> > > Subject: MS SQL Server vs. MySQL
> > >
> > >
> > > > Hey All,
> > > >
> > > > I'm not all that familiar with MySQL, but from what I
> > hear it's not
> > > > as
> > > good
> > > > as MS SQL Server (which I use along with Oracle).
> > > >
> > > > I've tried using MyPHPAdmin to administer MySQL before
> > and all I can
> > > > say
> > > is
> > > > it sucked eggs...security was confusing as all hell.
> > > >
> > > > The MySQL.com website says that upcoming features for version 5
> > > > include: -views -stored procedures
> > > > -triggers
> > > > -sub-queries
> > > >
> > > > Now if it's missing all that then what is itAccess on
> > steroids??
> > > > ;-)
> > > >
> > > > Opinions please
> > > >
> > > > TIA
> > > >
> > > > Cheers
> > > >
> > > > Bryan Stevenson B.Comm.
> > > > VP & Director of E-Commerce Development
> > > > Electric Edge Systems Group Inc.
> > > > t. 250.920.8830
> > > > e. [EMAIL PROTECTED]
> > > >
> > > > -
> > > > Macromedia Associate Partner
> > > > www.macromedia.com
> > > > -
> > > > Vancouver Island ColdFusion Users Group
> > > > Founder & Director
> > > > www.cfug-vancouverisland.com
> > > >
> > > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: CFObject Class?

[Jeff Chastain]

Nope, not JetSpeed.  This is the developers kit for Plumtree Software's
Enterprise portal.

Another Java example I found has the following code ...

IPortletContext oPortletContext =
com.plumtree.remote.portlet.PortletContextFactory.createPortletContext(reque
st, response);
IPortletResponse oPortletResponse = oPortletContext.getResponse();

So, based on this, I setup a cfobject call like this ...





... but, I am getting an 'exception occurred when instantiating a com
object', so something is still not right.

Thanks for the help.
-- Jeff


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2003 12:06 PM
To: CF-Talk
Subject: RE: CFObject Class?


Is this jetspeed??

If so, the full class is
org.apache.jetspeed.container.PortletContextFactory

However there is more to it then just that.

Luckly for you, Ben forta / drew falkman 's book has an example application
that uses bits of jetspeed.
which is avaialbe here http://www.forta.com/books/0321129482/


anyway something like

  

 

I expect u might need to pass in some props






or whatever, you'll be needing to get your feet wet in java I think...

WG


-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: 22 August 2003 17:36
To: CF-Talk
Subject: CFObject Class?


This is getting beyond my everyday CF workings ...  I am working with
another application whose documentation is written for Java or .NET.   Being
a CF person, I would like to use their developers kit using ColdFusion
instead of having to take the time to learn .NET right now.   So, can
anybody give me some pointers about how to instantiate the following object
in ColdFusion?

Java Example Code -

<%@ page language="java" import="rgdk.*,java.util.*" %>
<%
IPortletContext edk =
PortletContextFactory.createPortletContext(request,response);
%>

.NET Example Code -

Dim edk As IPortletContext
edk = PortletContextFactory.CreatePortletContext(Request, Response)

I am attempting to create the object using CFObject, but I am not sure what
to put for the class?

Thanks for any pointers.
-- Jeff




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

RE: Quick Reg Ex Question

[Brook Davies]

Ben,

This worked really well, I can't thank you enough!

Brook

At 07:33 PM 8/21/2003 -0400, you wrote:
>At a guess, it's because you're grabbing (potentially) the whole string.
>
>If you are using MX+ you should use a non-greedy match.  I'd combine the two
>char classes into one, which will allow you to drop all the parens (which
>are needlessly creating backreferences).
>
>You'll end up with something like
>\[[[:print:][:space:]]*?\]
>for your regex.
>
>For a deeper discussion, feel free to bring it up on
>http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21
>The HoF RegEx list.
>
>HTH.
>
>
>--  Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
>: -Original Message-
>: From: Brook Davies [mailto:[EMAIL PROTECTED]
>: Sent: Thursday, August 21, 2003 3:03 PM
>: To: CF-Talk
>: Subject: Quick Reg Ex Question
>:
>:
>: 
>:
>: Using CF4.5 this regex worked fine on all lengths of strings. Moving to
>: CFMX this generated the infamous "null null" errors until the
>: string being
>: parsed was shortened to 12,500 chars. After the redsky update, this code
>: again started to bug out and the length of the string being parsed had to
>: be shortened again to 8300 characters. With 6.1 I get an error that says
>: "java.lang.StackOverflowError" and nothing more, no stack trace.
>:
>: Is this a problem with my regex?
>:
>: What the regex does, is find any value inside square brackets like [First
>: Name] or [First
>: Name].
>:
>: Maybe there is some way to improve the regex so these errors do not keep
>: happening.
>:
>: Brook
>:
>:
>:
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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