Re: Submitting a form inside of cfdiv

[Sam Farmer]

If you have multiple cfforms and cfdivs on a page make sure to give each one
distinct names and things should work fine.  Otherwise you will get some
"interesting" behavior.

On Feb 1, 2008 11:41 AM, Dave Watts <[EMAIL PROTECTED]> wrote:

> > 
> > name 
> > yada http://ad.doubleclick.net/clk;160198600;22374440;w

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

Re: Forms within CFWINDOW

[Sam Farmer]

Yeah, your right, I see what Pete is after now.  The easiest way is to use
cfform otherwise you need to use the ColdFusion JavaScript functions.

I misread and thought you wanted a form on the main page to submit to a
cfwindow.

On Jan 8, 2008 8:01 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:

> iirc, where your form in a cfwindow submits to (that cfwindow or the
> master page) depends on if you use  or 
>
> hth
>
> ---
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com
>
>
> Pete Ruckelshaus wrote:
> > I would like to have a small form (normal HTML form) that is contained
> > within an AJAX cfwindow submit to that window so that it just loads the
> form
> > submission results page that popup window and not the parent page.  Is
> this
> > possible?
> >
> > Thanks
> >
> > Pet
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

Re: Forms within CFWINDOW

[Sam Farmer]

Pete,
You mean something like this:









function submitPoll() {

ColdFusion.navigate("pollEcho.cfm","pollResults","","","POST","pollForm");

ColdFusion.Window.show("pollResults");

}


















here




pollEcho.cfm





Cheers,


Sam


samfarmer.com


On Jan 8, 2008 1:57 PM, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:

> I would like to have a small form (normal HTML form) that is contained
> within an AJAX cfwindow submit to that window so that it just loads the
> form
> submission results page that popup window and not the parent page.  Is
> this
> possible?
>
> Thanks
>
> Pete
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

Re: Weird CF8 issue, Customer gets asked for RDS login after redirect from app login

[Sam Farmer]

That occurs when the user is requesting a cfc directly and the access
for the method is not remote.

It is strange that only one person sees this though.

On Nov 7, 2007 11:18 AM, Keith, Jeremy <[EMAIL PROTECTED]> wrote:
> Also the page that it's redirecting to is the CFC explorer
>
> CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&name=WebService
> s.ajaxCFC.core.RWGJKAjax&path=/Webservices/ajaxCFC/core/RWGJKAjax.cfc
>
>
> Jeremy Keith
> Network Administrator
> Rand-Whitney Group LLC
> One Agrand Street
> Worcester, MA 01607
> Office: (508) 890-7032
>
>
> -Original Message-
> From: Keith, Jeremy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 07, 2007 10:02 AM
> To: CF-Talk
> Subject: Weird CF8 issue, Customer gets asked for RDS login after
> redirect from app login
>
>
> OK, have a very strange issue that I've not seen before.
>
> We have literally thousands of customers, and I really think that this
> is probably a security setting on their firewall or in their IE
> settings, however I'll post this up anyways.
>
> We have a application with authentication that creates a session, when
> anyone at this location attempts to log into the application they get
> kicked to a different page that asks them to provide a login into RDS
>
> Now the only thing to note is that their public IP address is a 192.*
> IP, not in 192.168, but I'm wonder if there is something with the
> debugging in CF8 that might be causing this? Anyone else seen anything
> like this?
>
>
> Jeremy Keith
> Network Administrator
> Rand-Whitney Group LLC
> One Agrand Street
> Worcester, MA 01607
> Office: (508) 890-7032
>
>
>
> 
> CAUTION:The preceding email message and any
> attachments to it may be confidential and/or may contain proprietary
> information that is entitled to protection from disclosure under
> applicable law.  It is not intended for transmission to, or receipt by,
> any unauthorized persons.  If you are not the intended recipient or such
> recipient's employee or agent, please do not read any attachments, or
> print, copy, disseminate or otherwise
> disclose the contents of this email.   If you have
> received this message in error, please (i) notify the sender by return
> email immediately that you received the message in error, and (ii) erase
> or destroy the message.
> Thank you.
> 
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: 2 cfforms on same page problem

[Sam Farmer]

Do the forms have different names?

On Nov 7, 2007 2:16 PM, Michael Appenzellar
<[EMAIL PROTECTED]> wrote:
> ColdFusion 8: I have 2 cfforms on the same page. One in not a flash
> form, the other is. The flash form won't work because I have another
> cfform on the same page. Any thoughts on how to fix this?
>
>
>
> 
> Michael Appenzellar
> Sr. Web Applications Developer
>
>
> Mirame Interactive
>
> http://www.mirameinteractive.com
>
> 301-663-5672 x6413
>
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

Re: Custom tags per application in CF 8

[Sam Farmer]

Claude,

I wrote a blog posting on how to do it (its real easy but you do have
to use Application.cfc)

http://samfarmer.instantspot.com/blog/index.cfm/2007/6/1/ColdFusion-8-Per-App-Dynamic-Mappings-and-Custom-Tag-Paths-Create-Dropable-Applications

Cheers,

Sam

On 8/17/07, Claude Schneegans <[EMAIL PROTECTED]> wrote:
> Hi,
>
> in this page: http://www.adobe.com/products/coldfusion/features/
>
> Adobe claims that "ColdFusion 8 allows you to set ColdFusion mappings
> and custom tag paths on a per-application basis."
>
> I've been though the whole documentation and cannot find any reference
> to this statement.
>
> IMO there should be some new parameter in the CFapplication tag, but I
> see nothing.
>
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

Re: Query Result Problem

[Sam Farmer]

Can you share your code?

On 7/12/07, Bill Fears <[EMAIL PROTECTED]> wrote:
> We have a query that returns 53 records in Query Analyzer (which is correct)
> but that same query in a CF Page will only return 50 records. The query is
> not cached, no maxrows, no TOP keyword and there is nothing that stands out
> in CFAdmin.
>
> Server Specs:
> ColdFusion MX 7.0.2 Enterprise,
> Windows 2000 ,
> SQL Server 2000
>
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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

Re: reversal?

[Sam Farmer]

Isn't there a Friends episode where they discuss why on a scale of
1-10 that 10 is the highest?  I think you are going to run into that
issue here.

My suggestion would be to reverse your results via a mapping in a
structure that would take take 1 and make it 10 and 10 and make it 1.
Or perhaps making it negative and messing with the scale.

Just thinking out loud.

HTH,

Sam Farmer

On 4/19/07, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I have a ranking system in which items are scored, say 1-3. 1 being the 
> highest ranking.
>
> I'm displaying these in a bar chart, but the item with the highest ranking is 
> lowest on the chart, which is correct, but misleading at first glance. The 
> chart naturally pushes the item with the highest value to the top.
>
> Is there a way to force the lowest ranked bar to the top. I tried to scale 
> from 3 to 1 but it didn't work.
>
> Thanks,
> Will
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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

Re: changing directory

[Sam Farmer]

Daniel,

You can do this with CF:

Copy the folder to the new folder.

Do a cfdirectory call to get all files in the new (or old) folder.

Loop over and write a file to the old folder that has something like:
   

Test!

You may also want to look at using cfheader and a status code of 302
(I think) as that will tell browsers and search engines that the page
has moved permanently.  See Google for more.

Cheers,

Sam Farmer
http://samfarmer.instantspot.com/blog/

On 4/12/07, daniel kessler <[EMAIL PROTECTED]> wrote:
> I'm in a shared hosting environment, so I don't have access to the servers at 
> all.  That's why I'm trying to do this through cold fusion coding.
>
> thank you anyhoo.
>
> daniel
>
> >In IIS look at the properties for that folder and do the following.
> >
> >Redirect to: http://localhost/NewFolderName$S$Q
> >
> >Check Box for "exact URL entered above
> >
> >Check Box for permanent redirection for this resource.
> >
> >--
> >
> >Casey
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

Re: Browserhawk / browser stats generation?

[Sam Farmer]

I believe all of the stats you mention are included in the free
version of Google Analytics.

http://www.google.com/analytics/

Sam

On 3/9/07, Andy Matthews <[EMAIL PROTECTED]> wrote:
> My company uses a product called Browserhawk. This is a middleware that runs
> on the "first" page the user hits on any site we have.
>
> It runs some tests and checks loads of things including OS, browser (and
> version), connection speed, flash player and more. We're storing those
> stats, but not really using them. We're trying to generate some reports now
> and the version we have is outdated enough that it doesn't report Flash
> player 9. We're considering upgrading, but it's $1000 per server (we have 3,
> soon to have 4). So, while we don't mind spending the money if it's
> necessary, $4000 for something we don't utilise seems a little steep.
>
> So anyway, I'm wondering if any of you out there know of a product that
> performs similar functions (we don't need all of them) that might be either
> open source or lower priced than Browserhawk. I'm going to start Googling,
> but wanted to ask this list first to see what you all thought.
>
> 
>
> Andy Matthews
> Senior Coldfusion Developer
>
> Office:  877.707.5467 x747
> Direct:  615.627.9747
> Fax:  615.467.6249
> [EMAIL PROTECTED]
> www.dealerskins.com 
>
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

pie cfchart, start with a vertical?

[Sam Farmer]

Hi,

i have the following code for a chchart:








The problem is that the first item "Used" seems to start at a random
angle and I would really like it to start at 0 degrees (straight up).

Is there anyway to do this?

Thanks,

Sam

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Re: dynamic form in SQL Server

[Sam Farmer]

Brad,

Here is a system stored proc for getting columns:






sp_tables gets tables, sp_pkeys gets primary keys.

HTH,

Sam

On 1/26/07, Brad Wood <[EMAIL PROTECTED]> wrote:
> Hey, I'm building a quick and dirty dynamic form to edit all the columns
> in a table using SQL server 2000.
>
>
>
> My select below works, but I know I should rewrite it using the
> INFORMATION_SCHEMA approach.
>
>
>
> Can anyone help me change this select to return the same info but not
> use sysobjects etc.?
>
>
>
> Thanks!
>
>
>
> ~Brad
>
>
>
> SELECT
>
> sysobjects.name AS table_name,
>
> syscolumns.name AS column_name,
>
> systypes.name AS column_type,
>
> syscolumns.length,
>
> syscolumns.prec,
>
> syscolumns.scale,
>
> syscolumns.isnullable,
>
> sysproperties.value as label,
>
> syscolumns.colstat & 1 as primary_key,
>
> CASE WHEN sysforeignkeys.rkey IS NULL THEN 0 ELSE 1 END AS
> foreign_key
>
> FROM sysobjects WITH(NOLOCK)
>
> INNER JOIN syscolumns WITH(NOLOCK) ON sysobjects.id = syscolumns.id
>
> INNER JOIN systypes WITH(NOLOCK) ON syscolumns.xtype = systypes.xtype
>
> LEFT OUTER JOIN sysforeignkeys WITH(NOLOCK) ON syscolumns.colid =
> sysforeignkeys.fkey
>
> AND sysobjects.id =
> sysforeignkeys.fkeyID
>
> LEFT JOIN sysproperties WITH(NOLOCK) ON sysproperties.id = syscolumns.id
>
>
> AND sysproperties.smallid = syscolumns.colid
>
> AND sysproperties.name = 'MS_Description'
>
> WHERE sysobjects.name = @table_name
>
> AND sysobjects.xtype = 'U' -- table
>
> ORDER BY syscolumns.colorder
>
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Re: Custom Tag in CFC not working

[Sam Farmer]

Double check that the prefix you specify in the cfimport tag is
mycustomtag otherwise CF will just ignore that mycustomtag call.

Cheers,

Sam

On 11/15/06, Chris Velevitch <[EMAIL PROTECTED]> wrote:
> On 11/15/06, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
> > What does it do
>
> It writes to a log file.
>
> > where is the tag being called from?
>
> Could be more explicit here.
>
> > What is your CFC
> > code?
>
> 
>
> 
>
> 
>  
> 
>
> 
>
> The tag mycustomtag appends the text to the end of a file.
>
>
> Chris

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

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

Question About xtreme-host.com WAS Best CF7 Hosting company

[Sam Farmer]

Dawn,

I use xtreme-host.com and am very happy with them.

However, do you have problems with keeping an FTP connection?  Its my
one gripe but I'm unsure if its my software, ISP, etc or
xtreme-host.com.

Cheers,

Sam

On 11/2/06, Dawn Sekel <[EMAIL PROTECTED]> wrote:
> I use xtreme-host.com.  I have used custom tags in my applications that I 
> have hosted there and they support CFMX 7.
>
>
> 

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

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

Re: Ajax and CF...*sigh*...again...

[Sam Farmer]

I started by working with an example like below and found it quite
useful.  For my current project I am going to use ajaxCFC which I'm
liking as it does a lot of stuff and is simple to implement.

Cheers,

Sam

On 10/6/06, Kevin Aebig <[EMAIL PROTECTED]> wrote:
> Here's a painfully simple implementation. If you are comfortable in JS, than
> all this should make sense to you and if there's something you don't
> understand, send me an offlist message... watch for wrap.
>
> Usage:
> sendAjaxRequest("myurl.cfm", JSFunction, JSObjectAsParameters)
>
>
> 
> 
> 
>
> !k
>
> -Original Message-
> From: Jeff Small [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 06, 2006 12:59 PM
> To: CF-Talk
> Subject: Ajax and CF...*sigh*...again...
>
> I know, I know...asked about a ZILLION times...but here's all I want.
>
> 1. I'm a CF programmer who doesn't use any kind of framework (okay, please
> let's not go off on THAT tangent). I'm a formally taught CompSci grad dude
> who's been using CF now for about ten years, never messed with ASP, never
> messed with PHP, etc... I'm just 100% CF and I roll all my own.
> 2. I'm a reasonably good Javascript programmer who's done what I'd call
> "intermediate" JS, but nothing really super DOM heavy.
> 3. I'm really interested in Ajax, but I want to learn it from a "CF Coder
> who uses Dreamweaver as his main IDE" point of view.
> 4. I'd love to see just a simple site or page with an overview of the
> options for a CF programmer who wants to get into Ajax. Maybe something
> comparing the various AJAX frameworks out there, or how other CF'ers who
> don't normally use any kind of existing framework are getting into it. Maybe
> some simple tutorials to get you to that "AHA" moment...
>
> Does this sound like too much to ask? Does such a thing exist, or have I
> finally discovered a reason to blog? lol... (Jeff's experience getting into
> Ajax Blog)...
>
>
> --
> Jeff Small
> LHWH Advertising
> Myrtle Beach, SC 29577
> 843-448-1123 Ext 254
>
>
>
>
> 

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

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

Re: cfchart jpg format

[Sam Farmer]

I've tried this before and it doesn't work because cfchart does not
actually return an image (of flash file) but instead the html to call
that image that is has placed on the server.

In other words what cfchart below returns is something like:

and not the actual image.

It would be very cool if you could use it like you want to below (in
addition to the current method).

Cheers,

Sam F

On 10/2/06, Richard White <[EMAIL PROTECTED]> wrote:
> Hi, i am just wondering if by using the jpg format in the cfchart whether you 
> can actually output this as an image.
>
> i have got a .cfm page named test. In that test i have a simple cfchart tag
>
> 
>   
> 
>   
> 
>
> on another page i am trying to sett the outputted image as an image as 
> follows:
>
> ;
>
> i know i must be missing something as it isnt outputting the image at all
>
> i would appreciate some help with this,
>
> thanks
>
>
> 

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

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

Re: Oracle XE & CFMX7 Standard

[Sam Farmer]

Just set this up on a dev machine.

The only trick was to use 'XE' as the SID Name.  Everything else
worked with the usual Oracle settings and the provided Oracle driver.

Cheers,

Sam

On 10/31/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> Now that Oracle has released a free database
> (http://www.oracle.com/technology/products/database/xe/index.html), is
> there anything stopping me from using it with a CF MX7 Standard
> installation?  Are the necessary drivers included with MX7 or do I
> need to use an ODBC passthrough?
>
> Thanks,
>
> Pete
>
> 

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

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

Re: Datediff help

[Sam Farmer]

The problem lies in the order that things are being executed.  The
DateDiff function is being processed by CF before it goes to the
database.  So CF is looking for a variable called MEB.MembShpDate and
ORD.ProcessedDate not the database columns!

You want to use the database function for dateDiff not CF's in this
case.  Not sure what database you are using but I think in SQLServer
the function is called DateDiff.

HTH

Sam

On 8/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I have a query where I'm performing an inner join and the cfm page is telling 
> me ...
>
> MembShpDate is an existiing column in the MemberDetails table and it's a valid
> datetime datatype. Any ideas?  Full cfquery is after error message.
>
> The following information is meant for the website developer for debugging 
> purposes.
>
> Error Occurred While Processing Request
> Element MEMBSHPDATE is undefined in MEB.
>
>
> The error occurred in 
> C:\CFusionMX7\wwwroot\PipeLine\Pipe_SchoolCoun\rm\reportMemberReg.cfm: line 31
>
> 29 : 
> 30 :SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB, 
> MEB.MembShpDate, ON ORD.UserID = MEB.MemberAutoID
> 31 :WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
> 32 :AND ORD.Deleted = 0
> 33 :AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New 
> Membership and Registration')
>
>
>
>
>
> here is the full query.
> 
>  SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB ON ORD.UserID = 
> MEB.MemberAutoID
>  WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
>  AND ORD.Deleted = 0
>  AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New 
> Membership and Registration')
>  ORDER BY MEB.MembShpDate DESC
> 
>
> 

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

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

Re: Problem with tag

[Sam Farmer]

Can you provide the code?  For both logging in and logging out.

Also livedocs provide a good background for this tag:
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0289.htm

Cheers,

Sam

On 7/24/06, Billingsley, Lewis - ETA CTR <[EMAIL PROTECTED]> wrote:
>
>
>
>
> Hi,
>
>I'm sort of a low-end intermediate developer.
>
>I'm having trouble getting the  tag to work.  I read
> somewhere that it was better to create an application.cfc file rather
> than an application.cfm file for the login framework, but with either
> one the logout tag does not work.  My book says it takes no attributes.
> Someone said something about setting a timeout somewhere, but I didn't
> get which timeout or where - or how.  It looks like the THIS scope may
> have a timeout I can set, but I can't figure it out.   I'm not even sure
> if the login framework actually uses the session scope somehow, either
> and how I would do that if it did.  As you can see, I'm in need of
> enlightenment.
>
>
>
> Thank you.
>
> Lewis
>
>
>
>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247558
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Coldspring

[Sam Farmer]

Take a look at the Factories Presentation by Sean Corfield
(http://corfield.org/blog/index.cfm).

That helped me understand it a lot.

Cheers,

Sam

On 7/10/06, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> I have been reviewing Coldspring recently and to be honest - I don't get it
> :-) even after reading all the necessary blog entries (NOT from the website
> itself I may add, which is piss poor).
>
> What if, anything does it give me? What does it do which a good solid design
> doesn't? I cannot find any solid examples which explain it all.
>
> I know MG uses it, but I am not sure why and what for..
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
> Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540.  It contains information which is
> confidential and may also be privileged.  It is for the exclusive use of the
> intended recipient(s).  If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful.  If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.comThis e-mail is from Reed
> Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United
> Kingdom), a division of Reed Business, Registered in England, Number 678540.
> It contains information which is confidential and may also be privileged.
> It is for the exclusive use of the intended recipient(s).  If you are not
> the intended recipient(s) please note that any form of distribution, copying
> or use of this communication or the information in it is strictly prohibited
> and may be unlawful.  If you have received this communication in error
> please return it to the sender or call our switchboard on +44 (0) 20
> 89107910.  The opinions expressed within this communication are not
> necessarily those expressed by Reed Exhibitions.  Visit our website at
> http://www.reedexpo.com
>
> 

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246011
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: form.fieldnames does not bring all values.

[Sam Farmer]

Any form variable ending in _date or _time is reserved.

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0188.htm

Cheers,

Sam

On 6/27/06, Brian Dumbledore <[EMAIL PROTECTED]> wrote:
> Here is a weird one unless I am missing something.
>
> I have a form with lots and lots of checkboxes, three of them are
>
> sh_buy_c_date,sh_sel_c_date,sh_mkt_time
>
> all three are checkboxes. I check ALL checkboxes on the form, submit it,
> loop over form.fieldnames list, the above three are not in the list. However, 
> when I do a isdefined() on each of them they exist.
>
> now, I changed the names to end as ...date1,...time1. Then they showup in 
> form.fieldnames list.
>
> Is this a bug? What's so special about the names ending in date,time? Do the 
> above names qualify as coldfusion reserved words? Why is coldfusion doing 
> this? Cananyone throw some light on this? Thanks for your time
>
> 

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

Re: Strip dots out of ip address

[Sam Farmer]

On 6/27/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I'm trying to use
> it as part of a unique numeric value for e-mail confirmation.
>


Be careful though.  IP addresses can change all the time.  I rebooted
today and got a different one.

Cheers,

Sam

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

Re: SOT: Getting data into a web site

[Sam Farmer]

If the spreadsheets are in a standard layout you could allow users to
upload them.

Then in CF connect to the spreadsheet via a datasource and get the
data that way.

Cheers,

Sam F

On 6/13/06, Chris Mueller <[EMAIL PROTECTED]> wrote:
> Actually, applications like Google Spreadsheets support this kind of
> interface (to some extent, at least). I suppose it would be a little
> difficult to get the Google engineers to let you at their databases,
> though. ;-)
>
> Chris
>
> On 6/13/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> > Slight rant too let loose of some tension.
> >
> > You know what would be nice is if there was a way for a user sitting in 
> > their cubicle to be able to copy data from Excel and paste this data 
> > directly into a web page then hit submit to insert it into a database
> >
> > It has to be dummy proof!  So don't tell me to have them paste in comma 
> > delimited data then parse it.
> >
> > When they paste it should look like it did in excel...
> >
> > Is there currently anything?
> >
> >
> >
>
> 

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

CFC Weird 500 Error

[Sam Farmer]

Something strange has just started happening on our production server.
 CreateObject calls to cfc's cause CF to output this and then stop:

500 cfConventionSessionUtility2ecfc1296777452$funcSEARCHSESSIONS


I can catch it using cferror and I get this stack trace:

java.lang.NoClassDefFoundError:
cfConventionSessionUtility2ecfc1296777452$funcSEARCHSESSIONS at
java.lang.Class.getDeclaredConstructors0(Native Method) at
java.lang.Class.privateGetDeclaredConstructors(Unknown Source) at
java.lang.Class.getConstructor0(Unknown Source) at
java.lang.Class.newInstance0(Unknown Source) at
java.lang.Class.newInstance(Unknown Source) at
coldfusion.runtime.TemplateClassLoader.newInstance(TemplateClassLoader.java:393)
at 
coldfusion.runtime.TemplateClassLoader.newInstance(TemplateClassLoader.java:374)
at 
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:118)
at 
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:102)
at 
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:96)
at 
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:610)
at coldfusion.runtime.CFPage.createObject(CFPage.java:5880) at
coldfusion.runtime.CFPage.CreateObject(CFPage.java:5848) at
coldfusion.runtime.CFPage.CreateObject(CFPage.java:5813) at
cfsessionConventionListAll2ecfm773335868.runPage(C:\CFusionMX\cfshare\tag\smoothpaper\session\sessionConventionListAll.cfm:12)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at
coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1918) at
cfplanner2ecfm1979905374._factor0(Z:\Web
Sites\applications\smoothPaper\planner.cfm:48) at
cfplanner2ecfm1979905374._factor1(Z:\Web
Sites\applications\smoothPaper\planner.cfm:25) at
cfplanner2ecfm1979905374._factor67(Z:\Web
Sites\applications\smoothPaper\planner.cfm:22) at
cfplanner2ecfm1979905374.runPage(Z:\Web
Sites\applications\smoothPaper\planner.cfm:1) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:204)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Any ideas?  It only just started happening.

Cheers,

Sam

(Cross posted to cfcDev)

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

Re: Question about counting in SQL

[Sam Farmer]

Chris,

You can use the WHERE clause.

This should work fine:

SELECT Author.AuthorID, Author.AuthorName, COUNT(*) AS NumBooks
FROM Author RIGHT JOIN Book ON Author.AuthorID = Book.AuthorID
WHERE Book.Active =1
GROUP BY Author.AuthorID

Cheers,

Sam F

On 4/27/06, Chris Mueller <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'm wondering about doing an advanced SQL joined query that includes
> counting records matching a certain criteria. An example probably
> illustrates best.
>
> I have a table of authors, and a table of books. They are joined on an
> AuthorID. I am trying to display a page that contains a list of
> authors and the number of books that each author has written, and the
> only way I've found to do this seems entirely inelegant.
>
> Here's is essentially how I have these queries set up:
>
> 
> SELECT AuthorID, AuthorName
> FROM Authors
> 
>
> 
> 
> SELECT COUNT(*) AS NumBooks
> FROM Books
> WHERE Book.AuthorID = #qAuthors.AuthorID#
> AND Book.Active = 1
> 
> #qAuthors.AuthorName# (#qBooks.NumBooks#)
> 
>
> But I don't like doing this because in a list of a hundred or authors,
> this amounts to a hundred separate queries for the number of books for
> each author. It seems like there should be an SQL-based solution,
> maybe using the COUNT() function. But from what I can tell, I cannot
> perform a COUNT() when I also need to use a WHERE clause. Below is
> something that almost works, but fails because it can't filter on
> Book.Active = 1, so the count ends up wrong.
>
> 
> SELECT Author.AuthorID, Author.AuthorName, COUNT(*) AS NumBooks
> FROM Author RIGHT JOIN Book ON Author.AuthorID = Book.AuthorID
> GROUP BY Author.AuthorID
> 
>
> http://www.houseoffusion.com/lists.cfm/link=i:4:238872
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Why is there query.recordcount with non-SELECT queries?

[Sam Farmer]

On 4/18/06, Mike Klostermeyer <[EMAIL PROTECTED]> wrote:
> I wouldn't say that.  Sometimes it is helpful to know how many records were
> updated or deleted without having to do a select query beforehand.  Is there
> a Java service factory way of getting at this information?
>

CF7 has a result attribute on the query tag.

It returns a structure of information including the SQL, number of
records affected, time and some other stuff.

Cheers,

Sam

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

Re: Any way to suppress a tag at the applicaiton level?

[Sam Farmer]

The cftimer tag only runs when debugging is turned on AND the option
called 'Timer Information' is checked.

And hopefully you have debugging turned off in production.

Cheers,

Sam F

On 3/16/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > I was wondering if it's possible to suppress the
> > processing of a CF
> > tag at the application.cfc/cfm level?  I use cfdump and
> > cftimer quite
> > a bit and would like to be able to suppress the processing
> > of those
> > tags when the server isn't localhost.
>
> > Thanks
>
> > Pete
>
> Not using either of application.cfm or application.cfc... You could
> create a wrapper method/tag for cfdump, which wouldn't be terribly
> difficult to accomplish. I don't think that's possible with cftimer
> except in certain controlled circumstances, such as around existing
> custom tags.
>
>
>
> s. isaac dealey 434.293.6201
> new epoch : isn't it time for a change?
>
> add features without fixtures with
> the onTap open source framework
>
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
>
>
> 

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

Re: Strange, strange CFC Error: Null Pointer

[Sam Farmer]

Thanks M!ke.  I've passed the info on to my host.

On 3/15/06, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> Sam, I had the exact same problem after I updated to the CF HotFix2.
>
> I had to completely uninstall CF, then reinstall before it would work
> again.
>
> It's not your code.
>
> M!ke
>
> -Original Message-
> From: Sam Farmer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 15, 2006 8:10 AM
> To: CF-Talk
> Subject: Strange, strange CFC Error: Null Pointer
>
> I am getting the strangest CFC error on the code below (and all cfc's I
> have on this site).  They work in development but not in production.
>  Any ideas what is going on?
>
> Code:
> 
>   
> 
>   
> 
>
>
> URL:
> http://www.mountvernonsquare.org/test.cfc?method=out
>
> Error:
> The system has attempted to use an undefined value, which usually
> indicates a programming error, either in your code or some system code.
>
> Null Pointers are another name for undefined values.
>
> Cheers,
>
> Sam
>
>
>
> 

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

Strange, strange CFC Error: Null Pointer

[Sam Farmer]

I am getting the strangest CFC error on the code below (and all cfc's
I have on this site).  They work in development but not in production.
 Any ideas what is going on?

Code:

  

  



URL:
http://www.mountvernonsquare.org/test.cfc?method=out

Error:
The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system
code.

Null Pointers are another name for undefined values.

Cheers,

Sam

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

Re: getDate()

[Sam Farmer]

Its probably because in SQLServer getDate() returns a full date with
time information down to the millisecond.

Depending on how accurate your dates are this might be a simple fix:

dateAdded BETWEEN getDate()-1 and getDate()

Cheers,

Sam F

On 3/6/06, Richard Cooper <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Does anyone know why this works in access but not in SQL Server
>
> 
> SELECT  viewID, views
> FROMeventViews
> WHERE   active = '1'
> AND eventID = '#theEventID#'
> AND dateAdded = getdate()
> 
>
>
> 

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

Re: cfdocument how to use on a .cfm to print a form?

[Sam Farmer]

Something like this is, I think, what you are looking for:









Then have a link
a href="#cgi.script_name#?print=">Print This/a>

Cheers,

Sam F

On 2/15/06, carol Tobey <[EMAIL PROTECTED]> wrote:
> What I need to do is have basically two versions of a .cfm one that has 
>  wrapped around the code that I want output as either flashpaper 
> of pdf.  But I do not want to keep to different .cfm files one with the 
>  tag and one without. I want to put the  tag around my 
> code but only want it to execute when they click a button that says printable 
> format.  Otherwise if I wrap the  around my code all the time my 
> form will never be able to accept input. An example would be mapquest they 
> have a link that says printer friendly I want to do this on my form and have 
> it call it's self so the user can then  print out either the flashpaper or 
> pdf file.  Does that help clarify what I want to do?
>
> 

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

Re: page layout: cfmodule vs customtags

[Sam Farmer]

cfimport is quicker I believe than cfmodule from a processing point of view.

On 2/12/06, dave <[EMAIL PROTECTED]> wrote:
> you know what i mean ray.
> ok lets rephrase thats
>
> cfmodule vs cfimport
>
> ~Dave the disruptor~

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

Re: Smallest, coolest function I ever wrote: Struct()

[Sam Farmer]

You could use the built in listToArray

myarray = listToArray('homer,marge,bart');

Cheers,

Sam F

On 1/4/06, Ryan Guill <[EMAIL PROTECTED]> wrote:
> How about one for an array?
>
> This is pretty cool.
>

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

Re: CF Flash Forms and FCKeditor - do they work together?

[Sam Farmer]

It won't work.

In Flash forms you can only use simple html and nothing anywhere near
as complex as required for FCK Editor.

Flex has a built in WYSIWYG editor but its not availible to flash
forms (though maybe in a future release?)

Cheers,

Sam F

On 12/19/05, David Adams <[EMAIL PROTECTED]> wrote:
> Has anyone been able to get the FCKeditor to work within a CFFORM with format 
> set to "Flash"?
>
> I haven't tried it yet but I am wondering if there is any point because CF 
> will be compiling the code behind the FCKeditor into an swf.  This will 
> likely cause problems.
>
> Any experiences that anyone wants to share would be appreciated.
>
> DA
>
> 

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

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

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

Re: Dumb CF methodology question

[Sam Farmer]

I wrote about a framework we use, CFMVC, for CFDJ:

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

Cheers,

Sam F


On 12/16/05, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On 12/16/05, Phill B <[EMAIL PROTECTED]> wrote:
> > I know there is Mach II and Model-Glue out there but are there any
> > other MVC style methodologies available for CF?
>
> MVCF (?) from Benoit Hedard probably also fits the bill (and that's
> more of a methodology than a framework - which is what Mach II and
> Model-Glue are). I'm sure there are others but I would hazard that in
> terms of popularity and support the list goes:
>
> 1. Fusebox
> 2. Mach II
> 3. Model-Glue
> 4. ...
> --
> Sean A Corfield -- http://corfield.org/
> Got frameworks?
>
> "If you're not annoying somebody, you're not really alive."
> -- Margaret Atwood
>
> 

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

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

Best Practice: Additional Functions in Application.cfc

[Sam Farmer]

Working on a website where cfc's will go in a cfc folder.  In an
effort to not cause additional mappings I created a function called
newObj that I want to put in the application scope.

The easiest way to do this is to put the function in the
Application.cfc.  What are peoples thoughts on a best practice for
this?

Should additional functions go in the Application.cfc or should be it
exclusive of the various onStart and onEnd functions
(onApplicationEnd, onApplicationStart, onError, onRequest,
onRequestEnd, onRequestStart, onSessionEnd, onSessionStart)?


  











Cheers,

Sam F

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

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

Re: Custom Tags Folder

[Sam Farmer]

Take a look at using , that may solve your
problem, although you will have to change how you call each tag.

You can define a custom tag folder in the administrator but they are
global settings so would affect all code you run on that machine.

Cheers,

Sam F

On 12/7/05, Brian Peddle <[EMAIL PROTECTED]> wrote:
> Not sure this is possible.
>
> We have a version of an application and we are releasing an updated version.
> Some of the Custom Tags have been updated along with code. We plan on
> rolling this out a few clients at a time.
>
> Is it possible to set some type of application variable to override the
> customtag directory in CFADMIN?
>
> Thanks
>
>
>
>
>
> 

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

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

Re: Bar Code Scanners & ColdFusion

[Sam Farmer]

Our registration system prints a bar code on the back of attendees
name badges.  Attendees can then let exhibitors scan their barcode to
get all their contact information.  We use TBarCode software to create
the bar code (it produces an image that we put in a web page).  There
are also fonts that you can install that will do this as well.

Do you want CF to produce bar codes or read input from a bar code
reader or both?

Cheers,

Sam F


On 12/1/05, jonese <[EMAIL PROTECTED]> wrote:
> Anyone have experiance with tying in a bar code scanner and an online
> inventory app in CF? Basicaly i have a prospect who is looking to use
> the speed of a bar code reader to fill orders for there online shop.
>
> don't really know where to begin so any help would be awesome.
>
> jonese
>
> 

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

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

Re: Get path of page calling cfinvoke?

[Sam Farmer]

GetCurrentTemplatePath() might get you what you want.  But Barney's
second paragraph hits the nail on the head.  CFC's should never need
this type of information (except _perhaps_ for logging?? and if you
needed that).

Cheers,

Sam F



On 11/28/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> You could thow an exception and examine the stack trace, but that
> won't help for inherited methods, only for inherited methods called
> from methods defined in the subclass.
>
> Of course, if your functionality is dependant on knowing who's calling
> you, you likely have some flaw in your design.  Environment
> non-neutrality is a pretty consistent warning flag for "bad things".
> In particular, an object should never know or care what it's
> subclasses are.
>
> cheers,
> banreyb
>

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

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

Re: PDF Question

[Sam Farmer]

Thats a great start. I'm on CF 7 so didn't install iText but was able to get
your code to work fine and display the number of pages.

I then created an object to the concat_pdf class and get it to return
methods. I can call all methods except main which is the one I want. Error
says The selected method main was not found.But a cfdump of the object lists
the method main...

Here's the code:


pdfObject = createObject("java","com.lowagie.tools.concat_pdf");
pdfObject.main("1.pdf 2.pdf result.pdf");




Cheers,

Sam

On 11/18/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
wrote:
>
> Well, I did a CFC to do all the work of a PDF; it isn't that hard.
>
> First, you need to get the iText jar 2installed"
>
> An example of say, get the number of pages within a PDF is below...
>
> pdfObject = createObject("java","com.lowagie.text.pdf.PdfReader");
> vcPDFfile= vcPDFfile; // full path to the PDF
> pdfObject.init(vcPDFfile);
> iNumberOfPages = pdfObject.getNumberOfPages();
>
> if you dump iNumberOfPages you will get the number of pages in vcPDFfile.
>
> Obviously iText is far far more advanced but you get the idea...
>
> Any more help, let me know.
>
> N
>
>
>
>
>
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
> Sent: 18 November 2005 00:43
> To: CF-Talk
> Subject: Re: PDF Question
>
> Wow, iText looks to be far more powerful than what cfdocument has
> implemented. Has anyone created a friendlier "translation layer" for
> those of us without Java experience?
>
> Pete
>
>
>
> 

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

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

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

Re: PDF Question

[Sam Farmer]

Yeah, I'm familiar with both createObject and Java.  It looks like
com.lowagie.tools is the package needed for concatenating.  I'll see
what I can do.

Cheers,

Sam F

On 11/17/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> I haven't done itbut I've seen the docs on SourceForge (and have use
> iText to generate complex PDFs on the fly pre MX 7) ;-)
>
> Perhaps you should let us know if you are familiar with CreatObject() and
> using Java in CF.if so...go read the iText tutorials on concantenating
> PDFs and you'll see it's not that tough.
>
> If CreateObject() and the use of Java in CF is new...then we can show you
> the basics to get ya heading in the right direction.
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
> 

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

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

Re: PDF Question

[Sam Farmer]

Bryan and Neil,

Is there any chance you could post some code showing how you did this? I'm
about to start a project where I will need to do exactly this.

Thanks,

Sam

On 11/17/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> iText from SourceForge will do thatand iText is installed as part of
> CF
> 7 (behind CFDOCUMENT)...so if yer on 7 you have it already.
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com 
>
>
> 

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

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

Re: Is this possible

[Sam Farmer]

It sounds like you already have next Monday worked out after that do
something like this:


#dateAdd("ww",variables.ii,variables.firstMonday)#


Cheers,

Sam

On 10/27/05, Kurt Kaptein <[EMAIL PROTECTED]> wrote:
>
>
> I need quick advice on if this is possible.
>
> I need to have the users put in a ship date on an ecommerce site
>
>
> The first one will be next Monday which they will set the value them
> selves
> - (No problem)
>
> The second one if they select it will drop down a calendar where only
> Mondays are available to select
>
> And this needs to be required that they select one
>
> Is this doable?
>
> Sincerely,
>
> Kurt Kaptein
>
>
>
>
> 

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

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

Re: will cfimport slow down your page?

[Sam Farmer]

I use it all the time and have seen no change in performance.

Cheers,

Sam

On 10/14/05, Johnny Le <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> If you have a library of custom tags, should you use  prefix='ct'/> to import the whole library in? This way, I can use
>  like in Java instead of . I thought it is a neat
> idea, but I wonder if the site would take a performance hit.
>
> Johnny
>
> 

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

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

Re: security suggestions?

[Sam Farmer]

On 10/14/05, Ian Vaughan <[EMAIL PROTECTED]> wrote:

> --snippet---
> WHERE Password = '#Hash("form.Password", "SHA-512")#'
> 
>
> Any ideas on where I am going wrong?



Its hashing the string "form.Password" not the value of
form.passwordbecause of the quotes.

Try:
WHERE Password = '#Hash(form.Password, "SHA-512")#'

Cheers,

Sam


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

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

Re: cferror problem

[Sam Farmer]

Most likely you have an error in CustomError.cfm. If CF can't call the error
template page it gives the error of the original page.

Cheers,

Sam

On 10/14/05, Chad McCue <[EMAIL PROTECTED]> wrote:
>
> I am running CF7on windows 2003.
>
> I am trying to use  in my application.cfm file and it never calls
> my template I give it.
>
>
> here is my call.
>  type="Exception" exception="Any" >
>
>
>
> Here is the error the page has.
>
> 13:00:28.028 - Expression Exception - in
> D:\Inetpub\wwwroot\AgentSite\FunctionPages\AccountFunctions.cfc : line 841
> Element CustomerID is undefined in a CFML structure referenced as part of
> an expression.
>
>
>
>
>
>
> 

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

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

CFDocument, FlashPaper and Table Borders

[Sam Farmer]

I am having problems with CFDocument creating a Flashpaper and then
displaying table cell borders.

The pure html in a browser shows borders but Flashpaper completely ignores
the Styles whether in the td or in a style block.

Any ideas?

Here is the code:



TD {
border-right : 1px dotted Gray;
border-bottom : 1px dotted Gray;
font : 0.7em Verdana, Geneva, Arial, Helvetica, sans-serif;
}



Afternoon Chair 
6/17/06


All in
6/17/06




Thanks,

Sam


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

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

Re: QueryNew() question

[Sam Farmer]

In CF7 you can specify the column type:

*QueryNew*(*columnlist *[, *columntypelist*])

Sam


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

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

Re: ListAppend and delimiter question

[Sam Farmer]

I'll leave it to others to classify it as a bug or a feature.

I get around it by doing this: 

and then when done with all my list appends:


Cheers,

Sam

On Wed, 30 Mar 2005 11:07:53 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I have a strange question, I think. Can a delimiter be only one character?
> I'm trying to do a sql statement and I wanted to use ListAppend and specify
> the delimiter as "AND"
> 
> Example ...
> 
> 
> 
> But when I view the list I only see "A" as the delimiter.
> 
> Is this a bug or is this how it should be?
> 
> Thanks,
> - Charles
> 
> 

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

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

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

Re: Empty list for an IN clause

[Sam Farmer]

That will work fine but if there is an empty list you are asking the
database to search for a clause that you know it will not find. 
Depending on your set up this could cause a performance hit.

Sam


On Mon, 28 Mar 2005 09:27:27 -0800, Ian Skinner
<[EMAIL PROTECTED]> wrote:
> Ok, this seems to be working.
> 
> RDT_MOBLID IN ( value="#listAppend(valueList(Safetrace.R_MDL_MOBLID),'0')#" list="yes" 
> cfsqltype="cf_sql_varchar">) AND
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> -Original Message-
> From: Ian Skinner
> Sent: Monday, March 28, 2005 9:20 AM
> To: CF-Talk
> Subject: Empty list for an IN clause
> 
> What is the simplest way to handle the possibility of an empty list for
> an IN clause.
> 
> For Example:
> RDT_MOBLID IN ( list="yes" cfsqltype="cf_sql_varchar">)
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
> 
> 
> 
> 
> 
> 

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

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

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

Re: Empty list for an IN clause

[Sam Farmer]

Put the whole clause in a cfif statement:


   RDT_MOBLID IN ()


Sam



On Mon, 28 Mar 2005 09:19:35 -0800, Ian Skinner
<[EMAIL PROTECTED]> wrote:
> What is the simplest way to handle the possibility of an empty list for an IN 
> clause.
> 
> For Example:
> RDT_MOBLID IN ( list="yes" cfsqltype="cf_sql_varchar">)
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
> 
> 

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

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

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

Re: randomize

[Sam Farmer]

How about:

#queryName.questID[randRange(1,queryName.recordCount)]#

Haven't tested it so the randRange may need to be pulled out and set
to a variable.


Cheers,

Sam


On Fri, 25 Mar 2005 12:31:51 -0500, CFDEV <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have a query and i want to display the results randomize at each load of
> the page.
> 
> query :
> 
> select questID from quest order by questID
> 
> There is 50 questID.
> 
> I'm under CF5 for this one.
> 
> Thanks
> 
> Pat
> 
> 

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

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

Re: Looping through lines in a file

[Sam Farmer]

You could also use ListToArray instead of multiple listgetat calls.





  



- Original Message -
From: joe velez <[EMAIL PROTECTED]>
Date: Fri, 27 Aug 2004 14:53:16 -0400
Subject: Re: Looping through lines in a file
To: CF-Talk <[EMAIL PROTECTED]>

i know you said cfscript, but why not cfloop?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: ColdFusion and MVC model...

[Sam Farmer]

In addition to others mentioned I have found this site to be very
useful:
http://www.benorama.com/coldfusion/index.htm

Personally I don't like Fusebox and have been trying out other MVC
implementations before deciding on one to go forward with.

Thanks,

Sam
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL UNION Trouble

[Sam Farmer]

What error message are you getting?

Also your column order is different in the two queries which will cause problems.  Make them the same order (email, firstname, lastname) and see if that works.

Sam

>>> [EMAIL PROTECTED] 12/09/03 11:39AM >>>
In the following query I want the email addresses from two different tables
to be grouped together (for sending in CFMail), can't get it to work, what
am I missing? (BTW: the individual queries work just not as a UNION)


username="#REQUEST.dsnUID#" password="#REQUEST.dsnPWD#">
SELECT L.email, L.firstname, L.lastname 
FROM #REQUEST.prefix#_Members_List L
WHERE L.email IS NOT NULL 

UNION 

SELECT A.assistantfirstname, A.assistantLastName,
A.assistantEmail AS A.email 
FROM #REQUEST.prefix#_Members_AssistantInfo A
WHERE A.email IS NOT NULL

ORDER BY email
 

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

cfstoredproc yields no response

[Sam Farmer]

This is a bizzare one.  I have a stored procedure that updates a status field as soon as it is called and when called through SQLPlus works just fine.  When I call it from ColdFusion I get neither an error message nor any indication the procedure runs.  Any ideas?

Here is the code:

	
	
	
	
	
	
	
	
	
	


Thanks,

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

Re: Shall I start Pulling my Hair

[Sam Farmer]

I've used aliases longer than 11 characters in the same set up as you have
so thats not it.

My guess is some sort of reserved word issue?

Cheers,

Sam

- Original Message -
From: "Shahzad.Butt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 10:23 AM
Subject: Shall I start Pulling my Hair


> Whats wrong with this simple code
>
> 
> Select J_Sname.AccountNumber AS DetailField1
> From J_Sname
> Where ID = '12'
> 
>
> 
> #myQuery.DetailField1#
> 
>
> It gives error
>
> 'Element DETAILFIELD1 is undefined in myQuery. '
>
> But if I use DETAILFIE1 (or anyother letter not more than 10 characters)
> instead of DETAILFIELD1 it works. As I pop in 11th character for my
> alias it gives error. Is there any limit of characters in AS inside
> query in CFMX?
>
> Application Server: Coldfusion MX
> DB: SQLServer 2000
>
>
>
> Shahzad Butt (Development Engineer)
>
> JJ FastFood Distribution Ltd.
> Office:  +44 (0) 1992 701 722
> Mobile: +44 (0) 7803 584 873
> Fax: +44 (0) 1992 701 604
>
> 7 Solar Way, Innova Park, Enfield, London, EN3 7XY
>
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Can a form pass a structured variable to target template? (EBW)

[Sam Farmer]

Look into using wddx and the cfwddx tag.

In short you would create a structure, use the cfwddx to convert it to wddx,
use a hidden variable to pass the wddx packet to the receiving page and then
use cfwddx to convert the packet back to a structure.

Its exactly what wddx and cfwddx is designed for.

HTH,

Sam


- Original Message -
From: "Erik Britt-Webb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 2:52 AM
Subject: Can a form pass a structured variable to target template? (EBW)


> If my form has 15 fields in it, rather than passing all 15 fields to the
> target template, could I...
>  - create a struct variable (e.g. UserProfile),
>  - name each form field as a variable under the struct (e.g.,
> UserProfile.FirstName, UserProfile.LastName)
>  - still be able to use the struct variable (UserProfile) in the target
> template??
>
> I've tried this, but it doesn't seem to work.  Any assistance would be
> great!
>
> Thanks,
> Erik
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

SOT: 2D Barcodes

[Sam Farmer]

All,

Has anyone any experience printing 2d barcodes in the pdf417 format with
CFMX?  Not finding too much on the web about it.

Cheers,

Sam




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

Re: Hidden frame in frameset

[Sam Farmer]

In the example above the second frame will be "hidden"

HTH

Sam


- Original Message -
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 2:28 PM
Subject: Hidden frame in frameset


> Anyone have the code to put a hidden frame in a frameset???
>
> I know I did it once but I cannot find the code
>
>
> Thanks for any help
>
>
> 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/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: Need assistance with listbox on a form

[Sam Farmer]

Or you can use

StructKeyExists(form,"fieldname")

HTH,

Sam

- Original Message -
From: "CF-DEV" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 2:31 PM
Subject: RE: Need assistance with listbox on a form


> On the action page test to see if the value exists:
> ISDEFINED()
>
> -Original Message-
> From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com]
> Sent: Thursday, October 31, 2002 2:14 PM
> To: CF-Talk
> Subject: Need assistance with listbox on a form
>
>
> I have a page in which employees can update information that is contained
in
> their record in my SQL table. I recently added a multi-select list box
with
> a list of foreign languages that they can choose from if it's applicable
to
> them.
>
> If a user selects a foreign language and submits their changes, it works.
>
> If they change their address, but don't speak a foreign language and the
> list box doesn't have anything selected, then they get this lovely error
> message:
>
> GetOld.FLanaguage IS ""
>
>
> Error near line 126, column 24.
>   _
>
>
> Error resolving parameter GETOLD.FLANAGUAGE
>
>
>
> The column FLANAGUAGE is not present in the query named GETOLD. It is
likely
> that you have misspelled the name of the column.
>
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFIF), occupying document position (126:1) to (126:30).
>
> Ok, so FLangauge is a field in the query, so it isn't that. Here's the
piece
> of the page where it's failing at:
>
> 
>  
> 
>  
> 
>
> Is the reason why I am having this problem have to do with the fact that
> this is a multi-select list box and if so, how do I correct this to make
> this work correctly?
>
> For anyone who wants to see the code for the list box it is:
>
>  
> Foriegn Languages You May Speak:
> 
>   
>ListFindNoCase(EditNameQry.FLanguage,GetLanguages.LanguageName)>
> 
> 
>   
> 
> value="#LanguageName#">#LanguageName#
>   
> 
> 
>
> Thank you,
>
> Aimee Clark
> Web Developer
> Stinson Morrison Hecker LLP
> [EMAIL PROTECTED]
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Sending multi-part messgaes with CFMAIl and CFMX

[Sam Farmer]

This should work for html and plain text.


variables.boundary=Replace(CreateUUID(), "-", "", 'all');
variables.contenttype="multipart/alternative; boundary=""#boundary#""";







--#variables.boundary#
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

#getEmailInfo.plainText#

--#variables.boundary#
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit




#getEmailInfo.htmlText#



--#variables.boundary#--



- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 1:19 PM
Subject: Sending multi-part messgaes with CFMAIl and CFMX


> In regards to this thread. I have script that works in pre-CFMX for
sending
> multi-part messages but not in CFMX. Can any one point me in the right
> direction for sending multi-part messages with CFMX.
>
> -Brook
>
> At 09:41 AM 22/10/02 -0700, you wrote:
> >W2k_jdk1.4.1_IIS5_THX1138
> >
> >If you have a cfmail and are using something like:
> >
> >
> >  >VALUE="text/html">
> > ...message...
> >
> >
> >to reuse the same code but flip between html and plain text - it doesn't
> >seem to change the content-type anymore like it used to in CF5. In other
> >words, it always send mail in plain text using that block.
> >
> >Pretty simple work around though, you can just do something like:
> >
> > > 
> > TYPE="#Replace(Replace(attributes.html,'1','HTML'),'0','')#"
> > >
> > ...message...
> >
> >
> >Which is probably the way most have it already, but just so you know the
> >first way worked in 5, and in my opinion is a bit more intuitive.
> >
> >Rob
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: How Good is the Job Market for ColdFusion?

[Sam Farmer]

Not surprising really when you consider it takes an asp programmer about 4
times longer to do something!!

 :)


- Original Message -
From: "Mike Brunt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 2:06 PM
Subject: RE: How Good is the Job Market for ColdFusion?


> Trey, I just did a very simple search on Google looked for ".cfm" got 25.5
> million results, ".asp" 89.2 million, ".php" 106 million, ".jsp" 13.6
> million.
>
> Kind Regards - Mike Brunt, CTO
> Webapper
> http://www.webapper.com
> Downey CA Office
> 562.243.6255
> AIM - webappermb
>
> "Webapper - Making the NET work"
>
>
> -Original Message-
> From: Trey Rouse [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 16, 2002 10:48 AM
> To: CF-Talk
> Subject: RE: How Good is the Job Market for ColdFusion?
>
>
> I would challenge your 'Deployed' numbers.
>
> Your 'Facts' don't hold much water with me.
>
> More than 10,000 organizations have purchased ColdFusion
> More than 125,000 ColdFusion servers deployed
>
> The average organization purchases and deploys 12.5 licenses of CF?
> Where are the numbers of deployment of CFMX? Or how about 5.0+?
>
> Are the dozen licenses we own but are collecting dust being counted in
> your numbers?  And how many others like us?
>
> I would be very surprised if 90% of your customer base purchases and
> deploys more than 3 servers, and of those, I bet at most 50% are
> production.
>
> If you expect us to believe this PR dribble, I think some more
> supporting information is needed.  At least a basis from where these
> numbers are coming from?
>
> Trey Rouse
>
>
> > -Original Message-
> > From: Vernon Viehe [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 15, 2002 6:25 PM
> > To: CF-Talk
> > Subject: RE: How Good is the Job Market for ColdFusion?
> >
> > >The enterprise penetration of MX has been weak. MM would blame this
> > on the marketplace, but I'm not sold on this.
> >
> > Server version upgrade cycles in the enterprise app-server space is
> around
> > 12 months, according to those I've discussed it with. We're really
> only
> > about halfway through the cycle at this time. The overall installed CF
> > base is pretty healthy, and growing. Here's a partial list of existing
> CF
> > sites we use for PR/marketing:
> > http://www.macromedia.com/software/coldfusion/proven/
> >
> > Even considering the upgrade cycle in the enterprise app-server world,
> the
> > list of CFMX enterprise sites is growing every day. The following are
> a
> > few of the CFMX sites recently sent to me:
> >
> > http://www.ecoprimalquest.com/
> > http://www.logitech.com/index.cfm?countryid=19&languageid=1
> > http://www.panasonic.com.au/hometheatre
> > http://abclocal.go.com/kgo/ (some CF, some dynamic Flash content, some
> > just plain HTML)
> > http://www.reservations.broadmoor.com
> >
> > We know a lot of enterprise-level customers have upgraded to CFMX and
> are
> > in the upgrade cycle - but they don't always report back to us when
> they
> > go live with CFMX, so feel free to send me sites that you know of too!
> >
> > In addition to this stuff, consider the ways Macromedia is expanding
> the
> > CF market:
> >
> > *Ground-up rewrite in Java: This expands CF capabilities, as well as
> makes
> > CF an option to the enterprise-level sites which want the benefits of
> > deploying on a the Java platform and the rapid app dev (RAD) offered
> by
> > CF. It also means current CF customers have a way to move up to the
> Java
> > platform without requiring they abandon their existing apps (or their
> CF
> > developers). Admittedly, this has been a challenging release of CF for
> > some, but once the dust settles, CF and the CF community will enjoy
> this
> > huge leap forward.
> >
> > *We're working to deliver the information developers need to help them
> be
> > successful with ColdFusion and our other technology offerings:
> > www.macromedia.com/desdev
> >
> > *We're tappiing into new markets for CF:
> >
> > -With Flash remoting, the HUGE Flash community is getting turned on to
> CF.
> > While one can purchase Flash remoting for ASP, Flashers taking to CF
> > readily because of it's shorter learning curve and RAD capabilities.
> >
> > -Dreamweaver users: OK, before you pile on me about this one, I'm not
> > trying to debate the CFStudio/HS+ vs. Dreamweaver issue for CFers.
> > Dreamweaver is ~80% of the HTML editor market, and these folks are
> moving
> > into the dynamic application/web app development space in droves.
> > Dreamweaver MX makes their entry into the CF arena a snap with its
> built
> > in server behaviors that cover the most basic stuff, and CF's shorter
> > learning curve and tagged based syntax makes CF a very attractive for
> > these new application developers.
> >
> > *We've delivered innovative products that are more integrated and work
> > more smoothly with each other than ever before, offering "one-stop"
> > shopping for industry leading technologi

Re: group by in cfoutput

[Sam Farmer]

look at the group attribute of cfoutput.

Should do what you want.

HTH,

Sam


- Original Message -
From: "Dowdell, Jason G" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 2:30 PM
Subject: group by in cfoutput


> Hi all,
>
> Here's a bit of a challenge.  I have a single table storing category
> information similar to any search engine.  The table structure looks
> like this
> ID Name ParentID Level
> 1 Computers 0 1
> 2 Laptop 1 2
> 3 Desktop 1 2
>
> Since I have to display this information I must join the table back to
> itself.  All joining has gone fine :)  My problem is in the display of the
> information to the users.  I want to display the Parent category
> and then only 3 children from each category.  Sounds easy but
> I'm not sure if I can do this in sql or not.  If sql could accomplish
> this then super, if not then it's a good CF challenge.
>
> Any ideas?
>
>
> -
> Jason Dowdell
> IM-AES Web Developer
> 321.799.6845
> [EMAIL PROTECTED]
> -
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: HTML2PDF3 on CFMX

[Sam Farmer]

I have it working fine on two different machines running cfmx.

Make sure when you installed the htmldoc.exe file that you ran it...its a
self-extracting file.  That got me for about an hour.

Heres a sample of the tag:


   #variables.invoiceContent#
  


Cheers,

Sam


- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 2:54 PM
Subject: HTML2PDF3 on CFMX


> I can't get HTML2PDF3 to work with CFMX ... I get a java.io.IOException
> error. The documentation seems a bit flaky too ... It refers to using
> the path to the executable wihtout the .exe or filename, then the sample
> file uses the full path and filename to the executable - it errors
> either way, using the sample file right out of the ZIP or modifying it
> as the directions say it should work. It generates the HTML templates,
> then doesn't convert - it errors when accessing the executable file.
>
> Anyone know of anything else? Or anyone have any experience with
> HTML2PDF3 on CFMX?
>
> Thanks,
>
> Joshua Miller
> [EMAIL PROTECTED]
>
>



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

Re: PDF to HTML on-the-fly

[Sam Farmer]

There is the html2pdf3 tag in the gallery that works quite well.  And its
free.

Sam


- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 1:13 PM
Subject: RE: PDF to HTML on-the-fly


> How about the other way around? Anyone know of a good product (not
> ActivePDF at $1200+) that converts HTML to PDF?
>
> Joshua Miller
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 10:15 AM
> To: CF-Talk
> Subject: RE: PDF to HTML on-the-fly
>
>
> The adobe site has facilities to submit pdf and get back html
>
> > -Original Message-
> > From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
> > Sent: 15 October 2002 14:48
> > To: CF-Talk
> > Subject: RE: PDF to HTML on-the-fly
> >
> >
> > I've heard really good things about Active PDF for converting html TO
> > pdf. I'm not sure if you can use it in reverse. May be worth a look.
> >
> > http://www.activepdf.com/
> >
> >
> >
> > -Original Message-
> > From: FlashGuy [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 15, 2002 9:29 AM
> > To: CF-Talk
> > Subject: OT: PDF to HTML on-the-fly
> >
> >
> > Hi,
> >
> > I'm doing a project that requires PDF to HTML on-the-fly for the
> > Save/Print document function on our web page,
> > which allows the user to select documents from the Table of Contents
> for
> > printing or saving.
> >
> > Would anyone know what the best package out there is?
> >
> >
> >
> > ---
> > Colonel Nathan R. Jessop
> > Commanding Officer
> > Marine Ground Forces
> > Guatanamo Bay, Cuba
> > ---
> >
> >
> >
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: cfflush on mx small data pools

[Sam Farmer]

Thanks Raymond.  Glad to know it wasn't CFMX's fault.  I think I will stop
supporting Microsoft now. :)

Sam


- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 8:46 AM
Subject: RE: cfflush on mx small data pools


> Internet Explorer has a 'feature' where even if you flush, it will not
> display the text until it gets 'enough' text. What is enough text?
> Around 250 chars I think. If I'm flushing and now I won't have more than
> that, I add this BEFORE the flush:
>
> #repeatString(" ",x)#
>
> where x is between 150 - 200 or so. This normally 'forces' IE to display
> the text before the repeatString.
>
> ===
> Raymond Camden, ColdFusion Jedi Master for Hire
>
> Email: [EMAIL PROTECTED]
> WWW  : www.camdenfamily.com/morpheus
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 08, 2002 6:07 PM
> > To: CF-Talk
> > Subject: cfflush on mx small data pools
> >
> >
> > I am trying to flush a very small amount of data on mx but
> > don't seem to be
> > able to get the following to flush:
> >
> > 
> >  
> >  
> >   Processing.
> >  
> >  
> >  processing
> >  
> >  
> >
> > I would like it to flush immeadiately--its a payment page and
> > I want to let
> > users know something is happening.  The text does not appear
> > until the page
> > loads (15-30 seconds later).
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Sam
> >
> >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

cfflush on mx small data pools

[Sam Farmer]

I am trying to flush a very small amount of data on mx but don't seem to be
able to get the following to flush:


 
 
  Processing.
 
 
 processing
 
 

I would like it to flush immeadiately--its a payment page and I want to let
users know something is happening.  The text does not appear until the page
loads (15-30 seconds later).

Any ideas?

Thanks,

Sam




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

Re: CF 5 Hack

[Sam Farmer]

Yeah, change the registry setting.  Either with the cfregistry tag or
regedit.



Cheers,

Sam


- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 12:30 PM
Subject: CF 5 Hack


> Folks,
>
> We have a new client with a self-hosted server who has asked us to make
some
> emergency changes. He lost his previous developer and does not know where
to
> find him (.. and no - the site is not littlebopeep.com).  He does not know
> the cf administrator password and it's important that we get in to the
> administrator. Short of re-installing, does anyone remember the hack to
> reset the password?
>
> -mk
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Converting new lines to

[Sam Farmer]

paragraphFormat() function

cheers,

Sam


- Original Message -
From: "Luis Lebron" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 5:52 PM
Subject: Converting new lines to 


> I'm new to Cold Fusion so bear with me. Is there a way of converting new
> lines in a string to html line breaks . If you are familiar with PHP
I'm
> looking for something like the nl2br function.
>
>
> thanks,
>
> Luis
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Query of Queries Error

[Sam Farmer]

Thanks for you help Raymond.  I have it working by giving it a default value
of -100.  Not ideal as really want it to be null.  As a suggestion it would
be nice if the QueryAddColumn function took datatype as an argument.

Cheers,

Sam


- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 10:11 AM
Subject: RE: Query of Queries Error


> It sounds like you are trying to link up a non integer and integer
> column from 2 queries. Can you make the added column have some default
> integer values?
>
> ===
> Raymond Camden, ColdFusion Jedi Master for Hire
>
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 01, 2002 10:00 AM
> > To: CF-Talk
> > Subject: Re: Query of Queries Error
> >
> >
> > CF MX Enterprise.
> >
> > I have narrowed it down to one column and get the following message:
> >
> > All resulting columns of queries in a SELECT statement
> > containing a UNION
> > operator must have corresponding types.
> > Columns with index number equal "2" have diffent types
> > (INTEGER, VARCHAR).
> >
> > The column with an index of 2 in the second query is a column
> > I have added,
> > however, in this case it has no value.  In the first query
> > the column is not
> > added and its an integer column.
> >
> > Any suggestions?
> >
> > Thanks,
> >
> > Sam
> >
> >
> > - Original Message -
> > From: "Raymond Camden" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, October 01, 2002 8:40 AM
> > Subject: RE: Query of Queries Error
> >
> >
> > > What version?
> > >
> > > Can you limit your select statement to one query that can cause the
> > > error? That will pinpoint the exact column.
> > >
> > >
> > ==
> > =
> > > Raymond Camden, ColdFusion Jedi Master for Hire
> > >
> > > Email: [EMAIL PROTECTED]
> > > Yahoo IM : morpheus
> > >
> > > "My ally is the Force, and a powerful ally it is." - Yoda
> > >
> > > > -Original Message-
> > > > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, September 30, 2002 12:22 PM
> > > > To: CF-Talk
> > > > Subject: Query of Queries Error
> > > >
> > > >
> > > > Hi,
> > > >
> > > > I have a query of queries that has been working fine until
> > > > today when I
> > > > started getting the following error:
> > > >
> > > > Query Of Queries runtime error.
> > > > Unsupported Numeric type conversion in Query of Queries.
> > > >
> > > > Thats the extent of the error message provided!  The columns
> > > > seem to match
> > > > up exactly on database type and length.
> > > >
> > > > Can anyone help provide some insight?
> > > >
> > > > Thanks,
> > > >
> > > > Sam
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query of Queries Error

[Sam Farmer]

CF MX Enterprise.

I have narrowed it down to one column and get the following message:

All resulting columns of queries in a SELECT statement containing a UNION
operator must have corresponding types.
Columns with index number equal "2" have diffent types (INTEGER, VARCHAR).

The column with an index of 2 in the second query is a column I have added,
however, in this case it has no value.  In the first query the column is not
added and its an integer column.

Any suggestions?

Thanks,

Sam


- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 8:40 AM
Subject: RE: Query of Queries Error


> What version?
>
> Can you limit your select statement to one query that can cause the
> error? That will pinpoint the exact column.
>
> ===
> Raymond Camden, ColdFusion Jedi Master for Hire
>
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 30, 2002 12:22 PM
> > To: CF-Talk
> > Subject: Query of Queries Error
> >
> >
> > Hi,
> >
> > I have a query of queries that has been working fine until
> > today when I
> > started getting the following error:
> >
> > Query Of Queries runtime error.
> > Unsupported Numeric type conversion in Query of Queries.
> >
> > Thats the extent of the error message provided!  The columns
> > seem to match
> > up exactly on database type and length.
> >
> > Can anyone help provide some insight?
> >
> > Thanks,
> >
> > Sam
> >
> >
> >
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Query of Queries Error

[Sam Farmer]

Hi,

I have a query of queries that has been working fine until today when I
started getting the following error:

Query Of Queries runtime error.
Unsupported Numeric type conversion in Query of Queries.

Thats the extent of the error message provided!  The columns seem to match
up exactly on database type and length.

Can anyone help provide some insight?

Thanks,

Sam




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

Re: Can't use UNION

[Sam Farmer]

Use Q of Q.  It provides support for UNIONS.

HTH,

Sam


- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 8:50 PM
Subject: Re: Can't use UNION


> It is a distributed app ..
>
> Paul Giesenhagen
> QuillDesign
>
> - Original Message -
> From: "Ken Wilson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 24, 2002 7:50 PM
> Subject: RE: Can't use UNION
>
>
> > >I need a query that works in both MySQL and MS SQL 2000
> >
> >
> >
> > Why?
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Referencing a dynamically named form field

[Sam Farmer]

My first question is, what are you trying to do with the data that is
returned from the form?

I think you are on the right path but might be getting muddled along the
way.  For instance, by giving each radio button a different name you are
negating the use of radio buttons because it becomes possible for the user
to select each one on the page.

Sam


- Original Message -
From: "Adams, Stephen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 10:18 AM
Subject: Referencing a dynamically named form field


> **
> WESTMINSTER CITY COUNCIL
> Please refer to the disclaimer beneath this message
> **
>
> Hi,
>
> I have created a form that is populated by a query, like this:
>
>
> 
> 
> First Name: 
> Last Name: 
>  checked
>  value="MyDepartment" checked>
>  value="MyWesminster" checked>
>
> 
> 
>
> As you can see I have used an cfif statement to see which radio button
> should be checked according to the queries results.  I have had to use the
> CurrentRow to give each set of checkboxes an individual name, so that they
> don't over write each other when selected.  This gives me a set of form
> fields with names like linkSection1 and linkSection2, depending on how
many
> results are returned by my query.
>
> The problem I am having is referencing these checkboxes in my form action
> page.  I could just go #FORM.linkSection1# or
> #FORM.linkSection2#, but the problems is I don't know
> how many there will be.  My query could return either 2 different results
or
> 50, that means I need to output either #FORM.linkSection1# to
> #FORM.linkSection50#.
>
> My question is how can I call the form field no matter how many are
passed.
>
> I have tried this:
>
> 
>   
>   #FORM.linksSection#
> 
>
> but it failed.
>
> Any one got any ideas?
>
> Thanks
>
> Stephen
>
>
> **
> Westminster City Council switchboard:
> +44 20 7641 6000
> **
> This E-Mail may contain information which is
> privileged, confidential and protected from
> disclosure.  If you are not the intended recipient
> of this E-mail or any part of it, please telephone
> Westminster City Council immediately on receipt.
> You should not disclose the contents to any other
> person or take copies.
> **
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfinclude, how granular can you make it?

[Sam Farmer]

A complete cfif block has to be on the same page.  You can of course use
includes/custom tags/components between the cfif statements.

Also for better performance you almost never nead to use pound signs in if
statements and you will also get better performance by scoping variables.
For example:


To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 11:15 AM
Subject: cfinclude, how granular can you make it?


> How granular can you make your includes? I ask because I'm unable to
breakup
> an if-else clause. If I pull out the  and put it into an include
I
> get a "Just in time compilation error." If I put the entire
>  into the include everything works fine.
>
> I'm not finding information on "just in time complitation error" in either
> google, or forta's book or the macromedia site.
>
>
> WHAT EXISTS :  // if today is a holiday do this else do that
>
>
>  ... snip ...
> #year# EQ "2002" AND #month# EQ "9" AND #ThisDay# EQ "2" OR
> ... snip ...
> >
>
> #ThisDay#
>
> 
>
> #ThisDay#
>
> 
>
>
>
>
> WHAT I WOULD LIKE TO BE ABLE TO DO:
>
>
> 
>
> #ThisDay#
>
> 
>
> #ThisDay#
>
> 
>
>
>
> thx
>
> // gilbert midonnet
>
>
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF_VerisignEZ & CFMX

[Sam Farmer]

Has anyone used the CF_VerisignEZ with CFMX?  Just want to make sure it
works before forking over 70 bucks.  Also a little suspicious as the
download from Macromedia's Devex produces a completely different tag.

Thanks,

Sam




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

Re: Many or Minimal CFOUTPUTS

[Sam Farmer]

Don't think anyone has mentioned the issue of how much whitespace you may be
sending to the browser.  By just putting an cfoutput at the top and close at
the bottom you run the risk of sending a lot of whitespace to the browser.
And, yes, the browser will ignore it but it still has to be sent over the
network/internet, etc.

Personally I prefer to just cfoutput around the html I am sending to the
browser.  Performance tests for 4.5 and 5 showed this to be faster I
believe.

Cheers,

Sam


- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 26, 2002 3:26 PM
Subject: Re: Many or Minimal CFOUTPUTS


> I myself find covering as much ground as possible with one set of
CFOUTPUT,
> but if I have any grouping or other considerations I will add in more ...
> plus trying to make things easier to read is a plus.
>
> I was just curious if there was a speed issue on having alot of them ...or
> not ... I didn't think that if there was a difference it would be very
> great.
>
> Thanks for some interesting input!
>
> Paul Giesenhagen
> QuillDesign
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: days between function in Oracle...

[Sam Farmer]

Use the Ceiling or Ceil function (can't remember exactly which one it is)

Cheers,

Sam


- Original Message -
From: "Alex Ninan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 11:32 AM
Subject: days between function in Oracle...


> Hi,
>
> Does anyone know of a function I can use to get the number of days between
2
> dates in Oracle. My basic problem is I can get the dates but on using the
> round function it's screws up...
>
> e.g
> round(18.12) = 18 days
> round(18.82) = 19 days
>
> What I want is a function which does
>
> function(18.12) = 19 days
> function(18.82) = 19 days
>
> Thanks
>
> Alex
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Calling Queries

[Sam Farmer]

Thanks, think I tried just about every other combination

We had a long discussion here over whether it would be better to pass the
query in as opposed to just the name.  Our concearn with passing in the
query was that we would be duplicating the query in memory--just in
different places.  With a small query this would be no real concearn, but
with a big query we thought it might be a problem.  Especially as we are
already passing the query from a cfc into a cfm page.  Does this make sense
or are we worrying about the memory too much/incorrectly??

Thanks,

Sam

- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 9:35 AM
Subject: RE: Calling Queries


> Sure, instead of
>
> 
>
> you would do
>
> 
>
> Query - why are you passing the name of the query instead of the query
> itself??
>
> ===
> Raymond Camden, ColdFusion Jedi Master for Macromedia
>
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, August 02, 2002 9:31 AM
> > To: CF-Talk
> > Subject: Re: Calling Queries
> >
> >
> > Thanks Raymond.
> >
> > I am on MX is there a magic cure on that?
> >
> > Thanks,
> >
> > Sam
> >
> >
> > - Original Message -
> > From: "Raymond Camden" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, August 01, 2002 5:53 PM
> > Subject: RE: Calling Queries
> >
> >
> > > In this case, I believe you do need to use evaluate (unless
> > you are on
> > > MX!). However, your code will use N evaluates, where N is
> > the rowcount.
> > > You can get around this by doing one:
> > >
> > > 
> > >
> > > Then your code gets MUCH easier:
> > >
> > > 
> > >  > >
> > >
> > ==
> > =
> > > Raymond Camden, ColdFusion Jedi Master for Macromedia
> > >
> > > Email: [EMAIL PROTECTED]
> > > Yahoo IM : morpheus
> > >
> > > "My ally is the Force, and a powerful ally it is." - Yoda
> > >
> > > > -Original Message-
> > > > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, August 01, 2002 5:48 PM
> > > > To: CF-Talk
> > > > Subject: Calling Queries
> > > >
> > > >
> > > > Hi,
> > > >
> > > > I am trying to rewrite an old custom tag of ours that takes
> > > > in a query and
> > > > outputs it with right options selected.  Nothing too
> > > > tricky...except that I
> > > > can not work out how to get around using evaluate.
> > > >
> > > > Anyone got any pointers?
> > > >
> > > > This is the code:
> > > >
> > > > 
> > > >> > > listfind(attributes.selected,evaluate("#attributes.value#"))>S
> > > > ELECTED
> > > > >#evaluate("#attributes.display#")#
> > > >  
> > > >
> > > > Thanks,
> > > >
> > > > Sam
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Calling Queries

[Sam Farmer]

Thanks Raymond.

I am on MX is there a magic cure on that?

Thanks,

Sam


- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 01, 2002 5:53 PM
Subject: RE: Calling Queries


> In this case, I believe you do need to use evaluate (unless you are on
> MX!). However, your code will use N evaluates, where N is the rowcount.
> You can get around this by doing one:
>
> 
>
> Then your code gets MUCH easier:
>
> 
> 
> ===
> Raymond Camden, ColdFusion Jedi Master for Macromedia
>
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Sam Farmer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 01, 2002 5:48 PM
> > To: CF-Talk
> > Subject: Calling Queries
> >
> >
> > Hi,
> >
> > I am trying to rewrite an old custom tag of ours that takes
> > in a query and
> > outputs it with right options selected.  Nothing too
> > tricky...except that I
> > can not work out how to get around using evaluate.
> >
> > Anyone got any pointers?
> >
> > This is the code:
> >
> > 
> >> listfind(attributes.selected,evaluate("#attributes.value#"))>S
> > ELECTED
> > >#evaluate("#attributes.display#")#
> >  
> >
> > Thanks,
> >
> > Sam
> >
> >
> >
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Calling Queries

[Sam Farmer]

Hi,

I am trying to rewrite an old custom tag of ours that takes in a query and
outputs it with right options selected.  Nothing too tricky...except that I
can not work out how to get around using evaluate.

Anyone got any pointers?

This is the code:


  SELECTED
>#evaluate("#attributes.display#")#
 

Thanks,

Sam




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

Re: update table

[Sam Farmer]

You are almost there:

update people
set num = num + 5

That will work.

Cheers,

SAm


- Original Message -
From: "Bruce, Rodney S HQISEC/SIGNAL" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 4:04 PM
Subject: update table


> Hello all
>
> Is there any way of doing this in one query?
>
> i.e. I want to update a number field say people,  If the current number in
> the table is 10 and I want to add 5 I can do two querys
>
> Select people.num
> from people
>
> update people
> Set num = (Q.num + newnum)
>
> have tried
> update people
> Setnum = (select num from people) + newnum
>
> can this be done in one query?
>
> thanks
> Rodney
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Mac Editors with RDS or equivilant?

[Sam Farmer]

Mac users,

Does anyone have any suggestions for an editor that runs on Mac OS that has
something like RDS?

Cheers,

Sam




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

Mail MIME Talks

[Sam Farmer]

Anyone know a good custom tag that will send email in both HTML and plain
format (with the correct MIME type) that allows the users email reader to
display the email in the correct format?

Thanks,

Sam




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

Re: hosting

[Sam Farmer]

They look really good.  Out of interest which version of ColdFusion do they
run?

Thanks,

Sam


- Original Message -
From: "Matthew R. Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 9:48 AM
Subject: RE: hosting


> Yes, I use Advances.com for about 6 websites.  These guys have the best
> tech support I've ever seen.  You can get them via ICQ and they'll
> actually answer back.  Their prices are reasonable as well.
>
> - Matt Small
>
> -Original Message-
> From: Yager, Brian T Contractor/NCCIM
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 08, 2002 9:36 AM
> To: CF-Talk
> Subject: RE: hosting
>
> www.advances.com
>
>
> Brian Yager
> President - North AL Cold Fusion Users Group
> Sr. Systems Analyst
> NCCIM/CIC
> [EMAIL PROTECTED]
> (256) 842-8342
>
>
> -Original Message-
> From: Heidi Belal [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 07, 2002 11:31 AM
> To: CF-Talk
> Subject: hosting
>
>
> didn't get an replies about web-x.net and i sent them
> and email and they never replied - doesn't portray a
> good image
> so i've looked for another hosting company and have
> come up with burst.net...anybody got any reviews?
> Thanks,
>
> =
> Heidi Belal
> www.code-corner.com
> ICQ# 32127109
>
> A bus stops at a bus station.
> A train stops at a train station.  On my desk
> I have a work station...
>
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
>
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

gettickcount() in 10 milliseconds

[Sam Farmer]

I am getting in to some serious optimization and using gettickcount quite
extensively to see how long some loops are taking.  getTickCount, however,
only seems to go up in 10 millisecond intervals.  As an example I have two
loops taking 0 seconds and then one loop taking 10 on a consistant basis.
This seems weird.

Anyone else come accross this?

Platform is Win2000 and CF5.

Thanks,

Sam




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

VTML Builder

[Sam Farmer]

I am proud to announce the availability of our VTML Builder tool for
both use on our site and download.

Create your own ColdFusion Studio tag editors and make your custom tags
more user friendly with our simple wizard style interface.

http://www.smartsoftools.com/vtmlbuilder/

So, what is VTML? Its the language that all tag editors in ColdFusion
studio are written in.

Thanks,

Sam

Sam Farmer
Senior Developer
INTELIX, Inc.

12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
www.intelixinc.com <http://www.intelixinc.com>

Intelix Gains Washington TECHWAY Magazine's "FAST 50" Recognition 
...Debuting at #19!!!

_

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.

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cflocations, macs, and IE

[Sam Farmer]

My advice is not to use cflocation at all.

Sam


- Original Message -
From: "David Schmidt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 5:47 PM
Subject: RE: cflocations, macs, and IE


> BTW, someserver.com is not really the server name (no offense to
> www.someserver.com )
>
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Why no error.type in CF5

[Sam Farmer]

Yeah I just found it again...debugging cferror errors ain't much fun!


- Original Message -
From: "chris.alvarado" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 4:48 PM
Subject: Re: Why no error.type in CF5


> the type attribute is there for me.
>
> what leads you to believe otherwise?
>
> -chris.alvarado
> [application developer]
> 4|Guys Interactive, Inc.
> 
> http://www.4guys.com
>
> - Original Message -
> From: "Samuel Farmer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 05, 2002 3:42 PM
> Subject: Why no error.type in CF5
>
>
> > Does anyone know why Macromedia decided to drop the key "type" from the
> > error structure created by ??
> >
> > Was a pretty useful feature.
> >
> > Off to rewrite some code,
> >
> > Sam
> >
> >
> >
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQLServer Stored Proc Permissions

[Sam Farmer]

- Original Message -
From: "Andrew Tyrone" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 23, 2002 4:25 PM
Subject: RE: SQLServer Stored Proc Permissions
>
> Stored Procedures in the master database can be accessed globally, that is
> why you can perform the operation in query analyzer using sp_fkeys with
the
> 'mydb' database selected.  The problem sounds like you're calling the
> procedure with wrong/insufficient parameters.  Post the code so we can
> analyze it, and also tell us the desired result.
>
> Andy


Here's the CF code:
 



   

It should return one record for these parameters.  Instead this is all I get
from debugging:

 (Records=0, Time=16ms)
SQL =
sp_fkeys

Any ideas?

Thanks,

Sam

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Software with Partner Programs

[Sam Farmer]

In some places the Macromedia site seems to suggest that partners get
developer only copies of all their software and in others that partners get
only CF Server and JRUN.  Can any current partners let me know which it is?

Thanks,

Sam


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: RegExp help needed

[Sam Farmer]

Don't forget to cflock the call to cffile! :)

Sam


- Original Message -
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 2:18 PM
Subject: RE: RegExp help needed


> Holy cow, Don - I was hoping for some tips - you wrote the whole darn
> thingy!
>
> I'll test it right away - thanks mucho for the assist!!
>
> Regards,
>
> Jeff
>
> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 08, 2002 1:29 PM
> To: CF-Talk
> Subject: Re: RegExp help needed
>
>
> Try this:
> 
> 
>  startpos=1;
>  stTime=refindnocase("DateTime\:[ ]*(\{[^\}]*\})",mf,startpos,"yes");
> while(startpos LT len(mf) and startpos GT 0 and stTime.pos[1] GT 0){
>   if(arraylen(stTime.pos) GT 1)
> timeval=mid(mf,stTime.pos[2],stTime.len[2]);
>   else timeval="";
>   writeoutput(timeval & "---");
>startpos=stTime.pos[1]+stTime.len[1];
>   if(startpos GT 0){
>
>
>
>
   stId=refindnocase("Message_Id\:[ ]*([^<]*)   if(arraylen(stId.pos) GT 1)
> idval=mid(mf,stId.pos[2],stId.len[2]);
>  else idval="";
>  writeoutput(idval &"");
>  startpos=stId.pos[1]+stId.len[1];
>   }
>   if (startpos GT 0)
> stTime=refindnocase("DateTime\:[ ]*(\{[^\}]*\})",mf,startpos,"yes");
> }
> 
>
> HTH
>
> - Original Message -
> From: "Jeff Beer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 08, 2002 10:43 AM
> Subject: RegExp help needed
>
>
> > Hello all,
> >
> > I have a text file that's a save of a bunch of messages from Outlook.
The
> > messages are error reports from CF sent with CFMail.  The formatting
> sucks -
> > I never expected to get a bunch - I was using it for debugging.. anyway,
I
> > have several hundred I need to parse.  Silly transaction logs
> >
> > The layout is below.  What I need to do is get the datetime string and
the
> > message ID from each instance of an error message in that file so I can
> > update our database.
> >
> >  start 'record' -
> >
> > x:\inetpub\domain\subdir\errorfile.cfm
> >
> > DateTime: {ts '2002-01-06 00:44:09'}
> >
> > URL Message_ID: 23660 
> >
> >
> > Message: ODBC Error Code = 37000 (Syntax error or access
> > violation)
> > Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for
> > database 'dsdb' is full. Back up the transaction log for the database to
> > free up some log space.
> >
> >  end 'record' -
> >
> > The file has this format several hundred times over.
> >
> > Reading it in with cffile is simple.  What I can't figure out is how to
> > write the pattern matching code to extract the two variables.  Also, the
> > logic to make sure I have matching pairs is pretty easy - it's just the
> > RegExps that are killing me.
> >
> > This is probably simple; I could write this in Perl but can't seem to do
> it
> > in CF.
> >
> > Thanks in advance,
> >
> > Jeff
> >
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Stupid Back Button

[Sam Farmer]

Try putting this in the head:


If that doesn't solve it then its a "feature" of IE.

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
<http://www.intelixinc.com>
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500


- Original Message -
From: "Dave Carabetta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 10:46 AM
Subject: Stupid Back Button


> I have a question concerning the stupid Back button on a browser.
>
> We have a site where a user sees one home page if they are logged in and
> another if they are not. On the logged-in home page, the user has the
option
> to "Change User." They are then sent to a login page for the new user. On
> this page, a cookie and a few client variables which personalize the
user's
> experience are deleted. My problem is this: How can I make it so that if
the
> user hits the Back button after coming to the Change User page, they are
> automatically sent to the regular home page for users who are not logged
in?
> I have tried the  method on both
> the home page and the change user page (just as a test), and while it
works
> the first time (the user is properly redirected upon hitting the back
> button), if I log in again, go to change the user, and then hit the Back
> button, the logged-in page appears. However, if I simply hit the Refresh
> button or click on any link on the logged-in page, the regular home page
for
> non-logged in users correctly appears. This obviously must be a caching
> issue, but the cfheader method doesn't seem to be working.
>
> Any ideas?
>
> Thanks,
> Dave.
>
> _
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: pb with cfmail, in plain text.

[Sam Farmer]

Try using #chr(10)##chr(13)# where you want a line break.  Those characters
are the ascii characters for line breaks.  Example:

#sel_cmde.firstname# #sel_cmde.lastname# #chr(10)##chr(13)#
#sel_cmde.address# #chr(10)##chr(13)#
#sel_cmde.zip# #sel_cmde.city# #chr(10)##chr(13)#

Thanks,

Sam


- Original Message -
From: "loic jegouzo" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 9:42 AM
Subject: Re: pb with cfmail, in plain text.


> - Original Message -
> From: "Tom Espen Pedersen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 03, 2002 2:59 PM
> Subject: Re: pb with cfmail, in plain text.
>
>
> > I've had the same problem, think it's due to the #variables# try putting
> an
> > ekstra " " after the vars
> > or use and ekstra
> >
> >
> > enter between, I dont remember how we solved it.
> >
> > Tom Espen Pedersen
>
>
> i tried it but still have the pb. i follow searching in this way
>
> ps : ekstra = extra ??
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Disable form field based on select box

[Sam Farmer]

Another solution is to use a combination of onFocus=this.blur() or take the
focus elsewhere with a function.  Will be cross browser more than the nicer,
easier disabled feature (IE only?).

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
<http://www.intelixinc.com>
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500


- Original Message -
From: "BILLY CRAVENS" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 2:22 PM
Subject: Re: Disable form field based on select box


> In some browsers, you can set a text field to readonly.  However, for a
> version that is cross-browser, I would look at hiding/showing layers based
> on what the value of the select box.
>
> ---
> Billy Cravens
>
> - Original Message -
> From: "Paul Ihrig" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 20, 2001 12:26 PM
> Subject: Disable form field based on select box
>
>
> > hello all!
> > i have a select box called 
> > i would like to Disable a text field called
> >  >
>
value="#DollarFormat(RS_Update_PG2.Contract_Amount)#">
> > if the selecton in the select box IS
> > 
> > but leave the text field enable if it is not selected
> >
> > I have tried this, but it dosnt seem to work
> >
> >  > onChange="
> > 
> > 
> >  >
>
value="#DollarFormat(RS_Update_PG2.Contract_Amount)#">
> > ">
> >
> >
> > any help would be great!
> > -paul
> >
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Address Verification

[Sam Farmer]

Doing some research on address verification software and was wondering if
anyone had used some in the past?  There seem to be several that provide a
COM interface.

Has anyone used this?
How much did it cost?

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
<http://www.intelixinc.com>
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500


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

Re: QUASI OT: Opening Office Documents in a spawned browser.

[Sam Farmer]

I think you will find that it depends on how each browser is set up.  Users
are given the option of how they want to handle non-web files such as Word,
Excel, etc.  These options generally are: Open, Save, Always Prompt.  Each
browser and version is normally a little different in their implementation.

In short though you will always run in to problems and the best solution I
would offer is to provide some help text explaining how to always have it
open.

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
<http://www.intelixinc.com>
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500

- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 1:00 PM
Subject: QUASI OT: Opening Office Documents in a spawned browser.


> This is an intranet page, so IE5.5 is the controlled environment.
>
> I'm opening an office document in a spawned window ( target="_Blank">).
> The spawned window pops up, but I'm still prompted with an Open/Save
dialog.
> Anyway I can just have it open without the prompt.  I think this happens
> when you open it in the same browser window, but that's not an option.
>
> Any ideas would be appreciated :)
>
> Thanks,
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SOAP and Java Objects

[Sam Farmer]

I was wondering if anyone had dealt with a similar situation and/or had some
advice.

We are going to be "talking" to a java server via SOAP and have a Java
Object returned via SOAP.  For the communication to the java server we are
probably going to use either CFX_SOAP or the method suggested by Dave Watts.

Does anyone have any info on how to then get information from the Java
Object that is passed back?  I've used cfobject type="java" a bit before and
was wondering if I could use this on the object passed back--the
documentation seems to flip back and forth between object and class.

Thanks,

Sam


Sam Farmer - Senior Developer
Macromedia Advanced Certified ColdFusion Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
<http://www.intelixinc.com>
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: 10 Step Program

[Sam Farmer]

This is a great solution and one we use.  I would suggest making them
request variables though (easy access in custom tags)

Sam

- Original Message -
From: "Rich Wild" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 12:31 PM
Subject: RE: 10 Step Program


> Rather than eliminate all your session and application variables you could
> write a custom tag that does all the locking for you and copies whatever
> session or application variables you want into a local scope for your
> delectation.
>
> eg:
>
> 
>
> creates
>
> local.adminID
> local.name
> local.dsn
>
> without you having to expressly lock.
>
> I did this for an app that contained a *lot* of information in the app and
> session scopes. It meant that I didn't have to write one lock in the
entire
> app (save for the initial custom tag). Worked a charm, and very fast
too...
>
>
> > -Original Message-
> > From: Won Lee [mailto:[EMAIL PROTECTED]]
> > Sent: 29 November 2001 17:19
> > To: CF-Talk
> > Subject: 10 Step Program
> >
> >
> > Hi my name is Won Lee and I'm addicted to session variables.
> >
> > In an attempt to rid myself of all locking, I'm trying to
> > stay away from
> > application and session variables.
> > One of the most common things is used for session variables is
> > session.userID.
> > How does one now emulate this functionality without using
> > session variables.
> > I thought about just using cookies, but that would hinder use
> > of cflocation.
> > Any ideas?
> >
> > How do HTML websites handle session states?
> >
> > =
> > Not being a materialist in the U.S. is kind of like not
> > appreciating opera
> > if you live in Milan or art if you live in Paris. We support
> > materialism
> > better than any other culture. Because retailing and
> > distribution are so
> > efficient here, stuff is cheaper than anywhere else in the
> > world. And then
> > we have huge houses in which to archive our stuff.
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists