CFLAP extensionAttribute1 comma

2012-09-20 Thread Bob Chang

Hello,
 
I have a need to add staff title's to the extensionAttribute1 field in Active 
Directory.  I found that titles that contain commas cause an error.  I have 
tried to escape the comma using "\," and even "\\," but no dice.
 
The CFLDAP code looks like this:
 

 
Please ad

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


RE: contentsubtype issue

2012-02-08 Thread Imperial, Bob

Well so much for that, apparently not related as I tested this same thing on a 
local box that didn't have the hotfix with the same result. These machines are 
all on the University Network so I suspect it's something that might have been 
pushed out via a policy somewhere.  Thanks for the tip though.

Bob 

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, February 07, 2012 8:54 PM
To: cf-talk
Subject: Re: contentsubtype issue


it could be something to do with  commons-fileupload-1.2.jar which was updated 
in that hotfix.
you could try rolling this back to previous version and see if that helps.



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


contentsubtype issue

2012-02-07 Thread Imperial, Bob

Hoping somebody here has run into this or can shed some light on a issue I just 
encountered with a upload tool that's been working without fail for the longest 
time; that is until last week. It looks like CF is seeing the contentSubType on 
a pdf form that gets uploaded as "XM" and it uploads but errors out. I'm 
guessing this should be seeing it as XML and not XM? I don't exactly when the 
last time was that this worked but the hotfix here 
http://kb2.adobe.com/cps/918/cpsid_91836.html was applied a short time ago. I 
suspect this might be related but honestly I'm just guessing. Has anyone out 
there run into this before or can somebody shed some light here for me please?

TIA


Bob Imperial043 Macnider Hall, CB 7005
Application SpecialistUNC  Chapel Hill, NC 27599

Department of Medicine   (919) 843-6151
DOM-IS Helpline: 919.843.2331
Support: http://medicine.med.unc.edu/dom-is-support



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


Upgraded from CFMX7 to CF9

2010-07-27 Thread Imperial, Bob

Hello folks,

I recently upgraded 2 servers we have here to CF9 from CFMX7 and noticed the 
CFMX7 was left installed. Are there any issues I might run into uninstalling 
the earlier version before I pull the trigger here? Better safe than sorry.

Thanks!

[cid:image001.gif@01CB2DAB.47FFE000]
Bob Imperial125 Macnider Hall, CB 7005
Application SpecialistUNC  Chapel Hill, NC 27599

Department of Medicine   (919) 843-6151
DOM-IS Helpline: 919.843.2331
Support: http://medicine.med.unc.edu/dom-is-support



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


upgraded to 9 standard from cfmx 7

2010-02-23 Thread Imperial, Bob

Hi folks,

I recently upgraded a couple of our windows 2003 servers from CFMX 7 to 9 and 
noticed in the services window to see both 7 and 9 running, is this something 
that I will need to disable or uninstall? Seems added weight on the box but I 
do not know enough about it to proceed one way or the other. I noticed this 
after an issue with receiving duplicate email notices for a scheduled task that 
runs nightly on one of the boxes. I've stopped the 7 instance to see if this 
affects 9 running properly and it appears to be serving up cf pages just fine.

Can someone shed some light on what should be done with this or point me in the 
right direction on what to do with this?

Thanks! Bob


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfdpfform checkboxes

2010-02-18 Thread Imperial, Bob

Ok after putzing around with some conditional logic just before the checkboxes 
I was able to get them checked using On/Off :-).

Bob


-Original Message-
From: Imperial, Bob [mailto:bob_imper...@med.unc.edu] 
Sent: Thursday, February 18, 2010 10:47 AM
To: cf-talk
Subject: cfdpfform checkboxes


Hi folks,

Can anyone shed some light on how to set a checkbox to checked in a pdfform? 
I've just started playing with populating a existing pdfform using  and query data (what a 
time saver). I've googled the checkbox deal but no love here yet. Anyone??

Thanks! Bob




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfdpfform checkboxes

2010-02-18 Thread Imperial, Bob

Hi folks,

Can anyone shed some light on how to set a checkbox to checked in a pdfform? 
I've just started playing with populating a existing pdfform using  and query data (what a 
time saver). I've googled the checkbox deal but no love here yet. Anyone??

Thanks! Bob


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Dealing With Spiders/Bots/Crawlers

2010-02-03 Thread Bob Hendren

First, sorry for dual post earlier.

Second, not a stupid question about cookies, but just trying to deal with the 
possibility that a user has cookies turned off.  I'm using URLSessionFormat on 
all of my links to pass their session info around so the system isn't 
constantly treating them like a new user.

By the way, I say MY application because I wrote it, but it's a service we 
provide as a plugin to other websites.  So, we have to try and make things as 
open as possible for all of my users' users.

>This may be a stupid question, but are cookies really not an option for
>your site users?  I would only be passing session ids around the URL as
>a last resort.  I mean, it _is_ 2010 and cookies are kind of the
>standard for maintaining session.  (Note: they preclude the necessity of
>putting session info in all your URLs)
>
>There are other pitfalls with placing the session IDs in every URL other
>than bot traffic:
>http://kb2.adobe.com/cps/172/tn_17255.html
>
>~Brad
>
>
>Bottom line: how can I make the URLs NOT pass the session management
>variables when it's a search engine? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330389
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Dealing with Spiders/Bots/Crawlers

2010-02-03 Thread Bob Hendren

I'm at an odd crossroads here. Up until now, I've kept my application 
off-limits to search engines. I've used a couple of techniques found on Ben 
Nadel's blog for giving them short sessions and such. Been working well.

With respect to human users, I've been VERY diligent about using 
URLSessionFormat to keep session variables across page requests with cookies 
disabled. Also been working well.

So here's my quandary - I now want open up my application to allow search 
engines to index. However, I've got session variables embedded everywhere in my 
URLs due to URLSessionFormat()! So what's going to occur is this: the robots 
will grab all of these URLs, index them, then pass them as hijacked sessions 
through their results and I won't be able to track new visitors!

I just ran across a recent mention by Michael Dinowitz of a technique for 
setting CFID and CFToken to 1 whenever it's a bot, mentioned here:

http://www.anujgakhar.com/2010/01/26/what-is-the-best-way-to-deal-with-spidersbotscrawlers/

Bottom line: how can I make the URLs NOT pass the session management variables 
when it's a search engine?



Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com
800-867-4707
bhend...@listingware.com

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330387
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Dealing With Spiders/Bots/Crawlers

2010-02-03 Thread Bob Hendren

I'm at an odd crossroads here. Up until now, I've kept my application 
off-limits to search engines. I've used a couple of techniques found on Ben 
Nadel's blog for giving them short sessions and such. Been working well.

With respect to human users, I've been VERY diligent about using 
URLSessionFormat to keep session variables across page requests with cookies 
disabled. Also been working well.

So here's my quandary - I now want open up my application to allow search 
engines to index. However, I've got session variables embedded everywhere in my 
URLs due to URLSessionFormat()! So what's going to occur is this: the robots 
will grab all of these URLs, index them, then pass them as hijacked sessions 
through their results and I won't be able to track new visitors!

I just ran across a recent mention by Michael Dinowitz of a technique for 
setting CFID and CFToken to 1 whenever it's a bot, mentioned here:

http://www.anujgakhar.com/2010/01/26/what-is-the-best-way-to-deal-with-spidersbotscrawlers/

Bottom line: how can I make the URLs NOT pass the session management variables 
when it's a search engine?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330385
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Turning spaghetti code into properly indented code easily

2009-11-10 Thread Bob Goff

Hey CF Developers --

Just a quick heads up that I have created a product that will easily take 
someone else's malformed, ugly code and turn it into a thing a beauty in a 
matter of seconds.

My HTML Formatter (with CF Support) fixes any HTML/CFML files in less than a 
second and can be run against entire directories of code.  It works easily with 
your favorite IDE (CFEclipse, Eclipse, Dreamweaver, Homesite, etc) and will 
literally save you hours of debugging time by formatting code so logic is easy 
to understand and will tell you when you are missing tags (this one really 
saves you on the debugging front).

You can check out the product at http://www.logichammer.com 

There is a screencast on the site so you can see how easy it is to use and see 
the entire list of features.

Some real quotes from users:
-
not what i expected... even simpler! it is a self-executing file (no 
installation) and it has virtually no interface. Configuration is easy and done 
within a single .ini text file. 

This thing is awesome. I just ran a huge directory - an entire CF application . 
It took about 20 seconds and the report showed where there might have been any 
missing tags (just a few).

Now all of the code is neatly indented, whitespace removed, comments aligned 
just right... that single use was worth the price, easy! 


I'm offering House Of Fusion users a discounted price for the next week so if 
you hit this URL when you are ready to buy, you will get the reduced price:
http://www.logichammer.com/html-formatter/houseOfFusion.php

Enjoy!




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328226
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


ColdFusion Client Variables - HITCOUNT

2009-09-03 Thread Bob Hendren

Here's an oldie but a goodie:

I long ago drank the Kool-Aid on Client variables being stored in a DB and 
disabling global client variable updates.  No problems there.  But I'm just 
wondering when exactly are HITCOUNT and LVISIT updated in this situation?  Is 
it on the first page of a return visit?  If so, exactly how does CF determine a 
'return' visit?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325988
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


ColdFusion Client Variables

2009-09-02 Thread Bob Hendren

Here's an oldie but a goodie:

I long ago drank the Kool-Aid on Client variables being stored in a DB 
and disabling global client variable updates.  No problems there.  But 
I'm just wondering when exactly are HITCOUNT and LVISIT updated in this 
situation?  Is it on the first page of a return visit?  If so, exactly 
how does CF determine a 'return' visit?

-- 
Bob Hendren
President/CEO
ListingWare, Inc.
Phone/Fax: 800.867.4707
Email: bhend...@listingware.com
http://smartcall.me/bobhendren

ListingWare Support: supp...@listingware.com


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325968
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Bob Sharp

Thanks  guys,   some useful tips that led me to this ...  
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm 

 
SELECT  concat(e.firstname, ' ', e.lastname) AS eName, 
LEFT(a.assetdescription,30) AS aTitle, 
c.assetcategory AS cCategory
FROM employees e
INNER JOIN assets a ON e.employeeID = a.employeeID
INNER JOIN assetcategories c ON a.assetcategoryID = c.assetcategoryID
ORDER BY e.lastname 
 



 Name   Asset   Category 

   
  
  

 
  
   
 
   
#qEmpAssets.eName#   
#aTitle#
#cCategory#   

 




>from this output,  I would like to eliminate repeated names    
>
>  eName   aTitle  cCategory 
>Doug Briggs  HP Omni 510Notebook PC
>Nick Heap  IBM Netfinity Server Desktop PC
>Nick Heap  HP Omni 510Notebook PC
>Nick Heap  Motorola T60Mobile Phone
>Audrey Ibbotson   Toshiba Satelite XL  Notebook PC
>Karen Kear Viglen 733   Desktop PC
>Karen Kear HP Omni 510   Notebook PC
>Office Manager HP LaserJet XLLaser Printer
>Office Manager Epson Phaser   Laser Printer
>Glyn Martin Toshiba Tecra 8000Notebook PC
>Glyn Martin  Nokia 7650  Mobile Phone Bluetooth
>
>I am trying to use a variable LastEmp  and  but the 
>output is just the same as the original. 
>
>My script is  ...  
>
>
>
> Name   Asset   Category 
>
>  
>  
>  
>
> 
>
>
> #eName#
> #aTitle#
> #cCategory#  
>   
>
>
>
>
>
>Am in anyway close to achieving it ?  
>
>
>
>-- 
>I am using the free version of SPAMfighter.
>We are a community of 6 million users fighting spam.
>SPAMfighter has removed 12747 of my spam emails to date.
>Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>The Professional version does not have this message 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF sourceless deployment tool

2009-03-02 Thread Bob

@James
I don't think such tools exist for PHP , only for Java and .NET applications.

but i didn't mention PHP cause it has them ...
just to point out how much i prefer CF over other popular languages ,
and would like to see it as capable in terms of Deployment as it is in other 
areas .

@Peter
extension manager , would be great if it was supported by Adobe .


 




From: James Holmes 
To: cf-talk 
Sent: Monday, March 2, 2009 9:55:23 AM
Subject: Re: CF sourceless deployment tool


Can you point out the tools available for PHP that fulfill these
criteria so we can compare?

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

2009/3/2 Bob :
>
> Why isn’t there a tool to help deploy (compile and obfuscate) coldfusion 
> applications???
> Cfencrypt is not secure or practical since you can decrypt and deployment is 
> a mess.
> Cfcompile is not secure or practical since you can decompile into servlets 
> and deployment is a mess



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319987
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF sourceless deployment tool

2009-03-01 Thread Bob

Hello ,

Every developer who uses Coldfusion gets addicted to it’s power !
I am one of those developers who develop apps in PHP/JSP/.NET and other 
languages
But I always prefer CF and enjoy using it , that being said , brings the reason 
for my Question :

Why isn’t there a tool to help deploy (compile and obfuscate) coldfusion 
applications???
Cfencrypt is not secure or practical since you can decrypt and deployment is a 
mess.
Cfcompile is not secure or practical since you can decompile into servlets and 
deployment is a mess.

I agree with Jason Delmore,
"When all you want is a wiki or a blog... all you want to do is check a box and 
have it work. I think we need to make applications in general easier to 
install. No offense to Ray Camden, BlogCFC is a very cool app, but it should 
only take me 1 minute to install and I shouldn't need to understand the 
slightest bit about how the code works! Adobe, along with the community, needs 
to work on a standard method for installing and managing applications that is 
flexible enough to support all the different ways of creating applications... 
but consistent enough to just work."
http://www.cfinsider.com/index.cfm/2007/11/1/Key-Market-Trends-Surrounding-ColdFusion

as a developer i ask , what is the best practice to neatly and securely deploy 
a CF application ?
your feedback and suggestions are highly appreciated .

regards
Bob


  

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: annoying issue

2009-02-17 Thread Bob

I think what you need is as follows :







 
 header
 
 
  
  
  
  This is text in layout area 2: left
  You can close and collapse this area.
  
  
  This is text in layout area 3: center
  
  
  This is text in layout area 4: right
  You can collapse this, but not close it.
  It is initially collapsed.
  
  
   
  
 
 
    
 footer
 
    






regards
Bob




From: MS 
To: cf-talk 
Sent: Wednesday, February 18, 2009 12:41:43 AM
Subject:  annoying issue


Hi all

Quick cflayout question. I have a normal layout (positions = TOP,
LEFT, CENTER, RIGHT, BOTTOM) page.

Problem: if the center inside the CENTER  is larger than
the screen, I'm getting a scroll bar just in that CENTER
. Instead, the whole page should expand to accommodate
the height of CENTER. I tried playing with height:100% everywhere and
I can't do the trick.


    
        Top
    
    
        Left
    
    
        BIG CONTENT (in height)
        BIG CONTENT (in height)
        BIG CONTENT (in height)
        ** I want this to expand and cause scrollbars to appear on the whole
page, not just on this DIV
    

        Right
    



Hope it makes sense.

Cheers,

MS



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319464
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Flat File as a Database?

2009-01-26 Thread Bob Wright
>You never did clarify if by "flat file" you mean "text file"?

Yes, you are correct about that, sorry. I mean a delimited text file.

Specifically, I am precluded from installing any database, including using 
access database files.

bob


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318546
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
Hi Kym, thanks for the reply.

Very good question. The criteria is really "No Database".  There is more 
detailed and specific language than that, but it pretty much sums it up.

As you pointed out, a filesystem is certainly a database, of sorts.  I have 
been pondering it.  It seems a bit messy though.  Still, it is my fall-back 
plan, if I can't get find a flat file solution. But, it is not my preference. 

We expect not more than ten thousand entries.  Likely not more than a few 
thousand. 

I would not want to risk keeping the data in memory, with periodic writes to 
disc.  Not with this project.

Thanks again.

bob


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318514
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
Thanks all for the replies.

It sounds like some of you are in a position to fire clients. But since I get 
paid by the job, I can't just do that. Maybe someday, but not today.  Besides, 
the client is not an idiot. 

I'm sorry, I can't go into detail about the reasons why we are limited to a 
flat file. But the reasons are legitimate, and cannot be circumvented.  
Absolutely no database can be installed. It is what it is.

Yes, I get that if I can find a solution here, the flat file will be 
effectively a database. But hey, it's all about meeting the criteria.  And a 
flat file absolutely will do just that.

As far as what we need to accomplish, it is nothing more than basic CRUD via 
web forms with data download capabilities.  Nothing fancy.  No interface to 
other applications or products.  Just simple CRUD on a stand-alone application.

Gerald, I had not thought of ODBC text file thing.  I have seen it over the 
years, but never messed with it.  I'll look into that, thanks.

Nitai, H2 looks interesting, but I can't use it here. Thanks anyway.

Peter, I did reply to you earlier (from the house of fusion website). Not sure 
what happened.  Basically, I said that all I had available to me was CF7.
 
bob



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318512
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
> Why can't you use a database?
> 
> Is the client just being an idiot, or is there a legitimate reason for 
> it?
> 
> 
> If you're on CF8 or Railo, you can serialize/deserialize your query 
> objects, so you could store the data as a flat CFML/JSON file, but act 
> on it using Query of Queries.
> 
> 
> But first I would explore why you apparently can't use a database. 


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318486
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Flat File as a Database?

2009-01-25 Thread Bob Wright
Hello everyone,

I have a need to build a site which will not have access to a database.  
Instead, the client has specified that I must use a flat file.  On this flat 
file, I need to be able insert, update, and select

Honestly, I don't even know where to start.

Anyone have any idea how to go about this?  

Is there a udf or cfc out there that would help me?

Thank you for your time.

bob 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318484
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF Express ... Syntax error - CFQUERY -> UPDATE Options

2008-12-28 Thread Bob Sharp
Can anyone tell me exactly what is causing this error ?   

 
 
UPDATE  GuestBook 
SET (GuestName = '#Form.GuestName#', 
Email = '#Form.Email#', 
FirstVisit = #Form.FirstVisit#, 
GotHere = '#Form.GotHere#', 
Rating = '#Form.Rating#', 
Comments = '#trim(Form.Comments)#') 
WHERE   GuestBook_ID = #Form.GuestBook_ID# 
 


ODBC Error Code = 37000 (Syntax error or access violation) 
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE 
statement. 


The error occurred while processing an element with a general 
identifier of (CFQUERY), occupying document position (43:5) to 
(43:88). 


Date/Time: 12/28/08 12:20:44 
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) 
Gecko/2008120122 Firefox/3.0.5 
Remote Address: 127.0.0.1 
HTTP Referer: http://localhost/tt380/GuestMaint.cfm?op=u&gid=1 
Template: c:\inetpub\wwwroot\tt380\GuestUpdate.cfm 



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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Coldfusion 8 developer edition installation issue

2008-09-12 Thread Bob Imperial
it's a 32bit and coldfusion-801-win64.exe  is what I've been try to install,
pulling down the correct version now. We'll see how it goes :)

Thanks!



-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2008 4:15 AM
To: CF-Talk
Subject: Re: Coldfusion 8 developer edition installation issue

The standard computer properties will tell you what processor you are
running, and what version of the OS.

RMB on the my computer icon, select properties and you'll see the
information you require.


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

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


Re: Coldfusion 8 developer edition installation issue

2008-09-12 Thread Bob Imperial
to be honest I don't know, I can tell you it has 4gig ram so from what I've 
read it's 64bit? Vista is new to me so I'm having to hunt for everything in 
this new UI. This was so much easier with an XP box.

>Is your Vista machine 32 bit or 64 bit?
>
>
>
>
>-- 
>mxAjax / CFAjax docs and other useful articles:
>http://www.bifrost.com.au/blog/ 

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

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


Coldfusion 8 developer edition installation issue

2008-09-11 Thread Bob Imperial
I posted something here last week about this but never saw any response to my 
post. I'm thinking maybe the subject line may have thrown some off so I'm 
posting the issue again here in hopes I can get this resolved as it's driving 
me nuts trying to get CF8 installed. 

This is CF 8 developer edition and I am trying to install it on a new box I 
have running Vista Ultimate. When I try to run the installation the package 
makes it to 99% extraction then bombs out with "Windows error 216 occurred 
while loading the Java VM" and never makes any further. I did google this and 
found this bit here 
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=2&threadid=1381512&enterthread=y
 . According to the couple of posts I found there supposedly installing Java SE 
was the path they took but they really weren't very specific about which Java 
SE package was needed. 

This has me confused as I have the JDK 6 Update 7 w/NetBeans 6.1 installed and 
NetBeans installed and runs fine. Am I not installing the correct package to 
get this dog to install? Can anyone out there please enlighten me as to the 
specific java se package thats needed so I can get on with actually getting 
some work done.

Thanks in advance!

Bewildered Bob 

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

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


Windows error 216 occurred while loading the Java VM

2008-09-07 Thread Bob Imperial
Hoping somebody can shed a little more light on this issue I'm having trying to 
install CF8 developer edition on Vista Ultimate. I googled it and found a 
tidbit about it here 
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=2&threadid=1381512&messid=5037067
 and I've tried installing the following packages with no change and no 
install, only the error message. I don't know if I've just not hit the right 
Java SE package or what but any help would be greatly appreciated.

jre-6u10-rc-windows-i586-p-iftw
jdk-6u7-nb-6_1-windows-ml
jxpiinstall

TIA!

Bob 

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

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


Re: Coldfusion Install Hangs on Installing Web Connectors

2008-08-22 Thread Bob Wright
> First install CF with the builtin webserver and verify that everything 
> 
> works correctly, then install the connectors from the command line 
> with 
> the verbose option to see some debug output.
> 

Thank you for the reply, Jochem.

I can't find anywhere how to install the web connectors from the command line.  
Might you be able to  point me in the right direction?

The stand-alone install appears to work correctly.

Thank you very much for your help! 

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

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


Re: Coldfusion Install Hangs on Installing Web Connectors

2008-08-21 Thread Bob Wright
Hello again.  I am sorry to re-post this, but I am at my wits end, and I have 
to get this server up tomorrow.  Can anyone here please help me?

-Bob

> Hello everyone.  I am stuck and am hoping someone here can help.
> 
> I am trying to install CF8 x64 on a Windows Server 2008 x64 box. 
> Unfortunately, The installer hangs when trying to install the web 
> connectors.
> 
> Before the install, I disabled Windows' firewall.  I also made sure 
> that ISAPI Filters and IIS 6 Management Compatibility roles were 
> installed.
> 
> Anyone here know how to get through this?  The deadline looms... 


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

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


Coldfusion Install Hangs on Installing Web Connectors

2008-08-20 Thread Bob Wright
Hello everyone.  I am stuck and am hoping someone here can help.

I am trying to install CF8 x64 on a Windows Server 2008 x64 box. Unfortunately, 
The installer hangs when trying to install the web connectors.

Before the install, I disabled Windows' firewall.  I also made sure that ISAPI 
Filters and IIS 6 Management Compatibility roles were installed.

Anyone here know how to get through this?  The deadline looms... 

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

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


RE: Mail problem

2008-08-14 Thread Bob Imperial
And there's only so much stupidity you can program for :)

-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2008 4:30 PM
To: CF-Talk
Subject: Re: Mail problem

>>>Can people be this stupid?

There is sadly no limit on how stupid people can get... If you need to see
it for yourself, go work in retail for a weekend...

=]





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

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


cfpod overflow in IE

2008-07-21 Thread Bob Walasek
Good day!
I'm having a problem with the cfpod tag in coldfusion 8 - seems to be an issue 
in IE only. When the pod contents exceed the pod's defined width, Firefox 
correctly maintains the width of the pod and adds a horizontal scroll bar to 
the bottom of the pod. IE, on the other hand, displays the full width of the 
content, causing the pod body to be wider than it should be (although the 
header maintains the defined width.) The culprit in IE appears to be the 'ypod' 
class on the 1st  that coldfusion generates - it has an inline style which 
includes an "overflow: visible;" attribute. If I change that in the generated 
code so that first  has "overflow:auto" and view with IE, it looks the way 
it should, i.e. it stays within the defined pod boundaries. Any ideas on how I 
can override this to get pods to display correctly in IE? Here is some sample 
coldfusion code that demonstrates the problem:


this is a test of pod size
   
   
   test - this is a test of a long line in a small pod
   


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

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


RE: Need help with restoring from .bak

2008-07-03 Thread Bob Imperial
Thanks for the quick reply Jochem, but after trying to run the following I
get an error(see below)


RESTORE DATABASE [DCCRegistry]
FROM  DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\DCCRegistry_db_200806110200.BAK'
WITH  FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10



Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.

The error occurred in D:\WebNew\centers\dump.cfm: line 1

1 : 
2 : RESTORE DATABASE [DCCRegistry]
3 : FROM  DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\DCCRegistry_db_200806110200.BAK'

Don't know if it makes any difference here but this MSSQL Server 2k and
running CF Standard 7,0,2,142559

Any ideas?

Bewildered Bob


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2008 2:34 PM
To: CF-Talk
Subject: Re: Need help with restoring from .bak

Imperial, Robert wrote:
> Scrambling here trying to restore a db on a ms sql server and cannot
> connect with Enterprise Manager (another story). Is there a command line
> utility out there anywhere that will let me restore a db from a .bak
> file on a windows box? Or is there a way to do this from a CF query? TIA


RESTORE DATABASE [database_name] FROM  DISK =
N'path_to_full_backup_file' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10


Make sure you connect to a database that is not the one you are trying
to restore.

Jochem





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

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


RE: Error in url parameter

2008-06-04 Thread Bob Imperial
I don't think Gerald meant it as a solution but a step in identifying where 
there problem might be. You know it's being passed, I would check the db to 
see what datatype that field is to be sure of what it's expecting?

Bob

-Original Message-
From: Shivhare Yogendra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2008 3:14 PM
To: CF-Talk
Subject: Re: Error in url parameter

I tried and below is the result so I do have values but error is still there

struct
FORM_ID 67
IO_MODE 1
KEY_ID 71241
KEY_TYPE VPMO_ID
SBCUID dw4694
UIID 86972628
WINSIZE 1000x690


 ThanksÂYogendra Shivhare  Programmer Analyst  INFOSYS TECHNOLOGIES Ltd. 
â?~Life is what happens when youâ?Tre making other plansâ?¦!â?T


--- On Wed, 6/4/08, Gerald Guido <[EMAIL PROTECTED]> wrote:

> From: Gerald Guido <[EMAIL PROTECTED]>
> Subject: Re: Error in url parameter
> To: "CF-Talk" 
> Date: Wednesday, June 4, 2008, 11:09 PM
> try this Put this before the cfquery and see if you are
> passing the correct
> URL vars.
> 
> 
>
>
>
> On Wed, Jun 4, 2008 at 12:25 PM, Yogendra Shivhare <
> [EMAIL PROTECTED]> wrote:
>
> > I am getting following error in my applicationElement
> FORM_ID is undefined
> > in URL.
> >



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

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


Best Coldfusion Formatters or Coldfusion Beautifiers

2008-05-30 Thread Bob Goff
Hey there --

I'm wondering if other folks have recommendations for Coldfusion code 
formatters? When you inherit code from other folks and it isn't indented 
properly, it can be very hard to understand the flow of the page.

I found the HTML Formatter which has ColdFusion support and works really well 
but am wondering what folks normally do in the situation? Do you spend a lot of 
time formatting the code?

Here's the link if you are curious:
http://www.logichammer.com/html-formatter/

Thanks,
Bob 

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

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


RE: digital signatures

2008-05-28 Thread Bob Imperial
Thanks Dave this is exactly the kind of kick-start I need on this as it is
all new to me at this point. These utilities are running on windows server
2003 standard w/CF7 standard at the moment. I have full access to the box so
this should help speed things along for me I would think. Currently I have
107 users/physicians using these utilities and I don't see that list getting
much longer for now. Any suggested reading on this would help out here as
well since I am so new to this, so anything you can recommend would be a
good thing.

Thanks!

Bob

PDF supports digital signatures to sign and certify documents. Certification
prevents the document from being changed; if the document is changed, the
certification breaks. Signing simply attests that the user with that
certificate did in fact interact with that document at a specific time,
providing nonrepudiation, etc.

To use digital signatures, each signer will have to have a certificate
installed locally. You can either purchase individual certificates for your
users, or you can create a certificate infrastructure. Your certificate
infrastructure can be completely internal, or it can be based upon a root
certificate from a public certificate vendor like Verisign. If your
certificate infrastructure doesn't have a public root certificate from a
third-party vendor, you will be able to verify signatures within your
organization, but when you pass a signed PDF to someone outside your
organization the certificate will not verify for those external users -
it'll still show the document as signed, but the signature itself will be
unverifiable.

If you have a Windows server infrastructure (AD, etc), you can add a
certificate authority (CA) server to that fairly easily. This will allow you
to generate and issue client certificates to all your users very easily.

If you have a fairly small number of users, you could simply purchase
individual certificates for them to use directly. These are about $20 per
user per year. Verisign has a specific certificate product for PDF signing.

You can build a server interface for programmatically signing PDFs using the
Adobe LiveCycle ES rights management server. This can be integrated with
other LiveCycle products to build a workflow process that includes digital
signatures.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



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

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


Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]

2008-05-13 Thread Bob Wright
Right: east coast server's offset of 4+1 = 5, the offset for the mid-west 
client. Well, actually it's -5, but you get the point. :)

>If you are getting the offset from the gettimezoneinfo(), that is the
>servers offset, not the remote locations offset.
>
>.:.:.:.:.:.:.:.:.:.:.:.:.
>Bobby Hartsfield
>http://acoderslife.com
>http://cf4em.com
>
>SPAMTRAP]
>
>Thanks to all for the replies. It really shockes me that a simple mechanism
>to change the timezone of a particular app was never added to CF.  I'm sure
>this has been a problem for many over the years. 
>
>Dave pointed me to a simple UDF that did the trick.  Thanks Dave!
>
>Regarding the question about remembering to change the offset when we go
>back to standard time, I don't  think this that is an issue, is it?  As long
>as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can
>just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right?
>
>Again, thanks all for your replies.  
>
>Bob 

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

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


Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]

2008-05-13 Thread Bob Wright
Thanks to all for the replies. It really shockes me that a simple mechanism to 
change the timezone of a particular app was never added to CF.  I'm sure this 
has been a problem for many over the years. 

Dave pointed me to a simple UDF that did the trick.  Thanks Dave!

Regarding the question about remembering to change the offset when we go back 
to standard time, I don't  think this that is an issue, is it?  As long as 
timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just 
use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right?

Again, thanks all for your replies.  

Bob


>If you know of a bandage that doesn't need changing, please do share.
>
>.:.:.:.:.:.:.:.:.:.:.:.:.
>Bobby Hartsfield
>http://acoderslife.com
>http://cf4em.com
>
>SPAMTRAP]
>
>When applying a bandage over a 'wound' (beware, analogy here), you must be
>prepared to need change the bandage from time to time
>
>--
>William Seiter
>ColdFusion Web Developer / Consultant
>http://william.seiter.com
>
> 
>Have you ever read a book that changed your life?
>Go to: http://www.winninginthemargins.com
>Use PassKey: GoldenGrove
>You'll be glad you did.
> 
> 
>::-Original Message-
>::
>::Sent: Monday, May 12, 2008 4:32 PM
>::To: CF-Talk
>::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur
>::SPAMTRAP]
>::
>::Bobby Hartsfield wrote:
>::> You could store the time offset within an application variable then use
>::that
>::> along with dateadd() within all of your dateformat and tiemformat calls
>::> throughout the application.
>::
>::what about DST changes?
>::
>::
>:: 

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

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


Help! Can't I set a specific time zone for a CF App?

2008-05-12 Thread Bob Wright
Hi... I'm new here. I've been programming CF for a while but I have never come 
across this problem yet.  I am really hoping someone here can help me.

I built an application for a client in the mid-west, but serve it on a shared 
server on the east coast.  The client wants all the times on the site to show 
in central time not eastern time.  But I can't change the time on the server. 
And, I use time-math in so many places in this particular application.

Isn't there some way to easily change the time zone of a particular application 
- like in the  or something?  Surely I can't be the first person 
to deal with this problem!  There must be an easy fix yes?

Help?

Bob




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

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


Re: Accessing SSIS package

2008-04-20 Thread Bob Clingan
You should be able to run it using CFEXECUTE to run an app called DTEXEC.exe. 
Check out the docs here:

http://msdn2.microsoft.com/en-us/library/ms162810.aspx

--Bob


>Happy Saturday!
>I created an SSIS package and deployed it to my SQL Server, but what I am
>trying to figure out is how to trigger it using ColdFusion. Do I need to
>create an SP or a trigger to do this? I know in the past with DTS packages
>we would use the CFOBJECT tag to invoke it.
>
>Thanks,
>
>Bruce 

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

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


Re: Accessing SSIS package

2008-04-20 Thread Bob Clingan
>Happy Saturday!
>I created an SSIS package and deployed it to my SQL Server, but what I am
>trying to figure out is how to trigger it using ColdFusion. Do I need to
>create an SP or a trigger to do this? I know in the past with DTS packages
>we would use the CFOBJECT tag to invoke it.
>
>Thanks,
>
>Bruce 

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

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


RE: CF 8.0.1 Update and CFMENU

2008-04-14 Thread Bob Hendren
Bhakti -

Thanks for the reply.  I've gone through your responses and provided further
info of my own below, denoted by >.

------
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com
800-867-4707 x 706
[EMAIL PROTECTED]


-Original Message-
From: Bhakti Pingale [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 14, 2008 9:12 AM
To: CF-Talk
Subject: RE: CF 8.0.1 Update and CFMENU


Hi Bob,

Please find my comments inline.
Hope these inputs help you.
Thanks for your feedback.

Thanks,
Bhakti

-Original Message-
From: Bob Hendren [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 12, 2008 4:40 PM
To: CF-Talk
Subject: CF 8.0.1 Update and CFMENU

Has anyone experience trouble with CFMENU since the 8.0.1 Updater?  I've
noticed a few of things:
 
1)  The submenu indicator arrow appears beneath the display text in a
vertical menu in Internet Explorer. 

- Setting the menu width appropriately should solve this problem for you. I
am however not able to repro this one. May be you can give me some more
inputs.

> Try viewing http://lw1dbserver1.listingware.com in IE and then another
browser.  The vertical menu on the left side has the submenu indicators
underneath the text.  A horizontal menu in a similar site is rendering
properly.
 
2)  There seems to be an improperly nested DIV that causes a thick top
border in vertical format. 

- We did a YUI upgrade in CF 8.0.1 because of which there have been small
little UI changes. This is one of them. 
I am not too sure if I have understood you perfectly, but I also see a
border added which can be removed.Under the
/CFIDE/scripts/ajax/resources/yui/yui.css file, the line border-width (as
shown below) has to be changed to "border-width:0 0 0 0;"  

...yuimenu ul {

list-style-type:none;
border:solid 1px #c4c4be;
border-width:1px 0 0 0;
margin:0;
padding:4px 0;

}

If this is not the one you are talking about then could you please explain
it again so that I can give you a workaround.
 
> This did fix the issue.

3)  The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase
-
'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect.
-Agreed. I will log a bug for this one.

> OK, thanks.  I can live without images until fixed.
 
4)  If I use an image in a top-level CFMENUITEM, it will also try to display
that same image as part of a group of child CFMENUITEMs, so that if there
are 5 child items, a single image of the parent menu item will display once
for all 5 items.  (It's obviously not supposed to be there, because as you
mouseover the child menu items, the mouseover color appears over the
image.) 

- This one is a known bug. I guess we have documented it.
 
5)  An underline now appears for the active menu item.  The behavior of
having a mouseover color for the active menu item is desired, and I supposed
I could live with the underline, but I'd rather not. 

- This again is because of the YUI upgrade. The workaround is as follows.

The css change is required to correct the underline issue

Under the /CFIDE/scripts/ajax/resources/yui/yui.css file, the line
"text-decoration" has to be taken off 

...yuimenuitem a.selected,
...yuimenubaritem a.selected {

background-color:#AADEFF;
text-decoration:underline;
color:#fff;

}

> I did this, but it's still a problem.  If you View Source on that same web
site, you see the statement where the YUI CSS file is included, then
directly after it is a new STYLE statement that had never been there before.
That seems to be where the underline is coming from.  I found that if I took
all attributes except type="vertical" out of the CFMENU declaration, the new
STYLE element went away and so did the underline.  However, the submenu
indicator issue from above still exists.

 
There could be others, but I was SO bummed!  The update fixed a couple of
things that were a problem, but introduced other issues!  I might be able to
solve a couple of these by tinkering with the YUI CSS, but a couple are
clearly beyond that.
 
One thing that DOES seem to be fixed is the odd behavior you got on a
horizontal menu, where it would be rendered vertically (mostly in IE) to
begin with, then resolve to horizontal - it was a weird and distracting
behavior, but seems OK now.
 
--
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com <http://www.listingware.com/> 
800-867-4707 x 706
[EMAIL PROTECTED]
 






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

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


RE: CF 8.0.1 Update and CFMENU

2008-04-14 Thread Bob Hendren
I asked this over the weekend, but didn't see any responses.  Anyone have
ANY clues?  Thanks!

------
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com
800-867-4707 x 706
[EMAIL PROTECTED]


-Original Message-
From: Bob Hendren [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 12, 2008 7:10 AM
To: CF-Talk
Subject: CF 8.0.1 Update and CFMENU


Has anyone experience trouble with CFMENU since the 8.0.1 Updater?  I've
noticed a few of things:
 
1)  The submenu indicator arrow appears beneath the display text in a
vertical menu in Internet Explorer.
 
2)  There seems to be an improperly nested DIV that causes a thick top
border in vertical format.
 
3)  The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase -
'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect.
 
4)  If I use an image in a top-level CFMENUITEM, it will also try to display
that same image as part of a group of child CFMENUITEMs, so that if there
are 5 child items, a single image of the parent menu item will display once
for all 5 items.  (It's obviously not supposed to be there, because as you
mouseover the child menu items, the mouseover color appears over the image.)
 
5)  An underline now appears for the active menu item.  The behavior of
having a mouseover color for the active menu item is desired, and I supposed
I could live with the underline, but I'd rather not.
 
There could be others, but I was SO bummed!  The update fixed a couple of
things that were a problem, but introduced other issues!  I might be able to
solve a couple of these by tinkering with the YUI CSS, but a couple are
clearly beyond that.
 
One thing that DOES seem to be fixed is the odd behavior you got on a
horizontal menu, where it would be rendered vertically (mostly in IE) to
begin with, then resolve to horizontal - it was a weird and distracting
behavior, but seems OK now.
 
--
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com <http://www.listingware.com/> 
800-867-4707 x 706
[EMAIL PROTECTED]
 




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

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


CF 8.0.1 Update and CFMENU

2008-04-12 Thread Bob Hendren
Has anyone experience trouble with CFMENU since the 8.0.1 Updater?  I've
noticed a few of things:
 
1)  The submenu indicator arrow appears beneath the display text in a
vertical menu in Internet Explorer.
 
2)  There seems to be an improperly nested DIV that causes a thick top
border in vertical format.
 
3)  The TYPE attribute for 'vertical' or 'horizontal' MUST be lowercase -
'Vertical/Horizontal' or 'VERTICAL/HORIZONTAL' cause it to render incorrect.
 
4)  If I use an image in a top-level CFMENUITEM, it will also try to display
that same image as part of a group of child CFMENUITEMs, so that if there
are 5 child items, a single image of the parent menu item will display once
for all 5 items.  (It's obviously not supposed to be there, because as you
mouseover the child menu items, the mouseover color appears over the image.)
 
5)  An underline now appears for the active menu item.  The behavior of
having a mouseover color for the active menu item is desired, and I supposed
I could live with the underline, but I'd rather not.
 
There could be others, but I was SO bummed!  The update fixed a couple of
things that were a problem, but introduced other issues!  I might be able to
solve a couple of these by tinkering with the YUI CSS, but a couple are
clearly beyond that.
 
One thing that DOES seem to be fixed is the odd behavior you got on a
horizontal menu, where it would be rendered vertically (mostly in IE) to
begin with, then resolve to horizontal - it was a weird and distracting
behavior, but seems OK now.
 
--
Bob Hendren
President/CEO
ListingWare, Inc.
http://www.listingware.com <http://www.listingware.com/> 
800-867-4707 x 706
[EMAIL PROTECTED]
 


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

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


Re: Open Source CF Shopping Carts

2008-04-10 Thread Bob Dronski
> Forgot to mention All the source is open and available.  I've been 
> doing a lot of customizing the code for 

Damned Enter key ;-)

Anyway, you get the idea.

bob






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

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


Re: Open Source CF Shopping Carts

2008-04-10 Thread Bob Dronski
Forgot to mention All the source is open and available.  I've been doing a 
lot of customizing the code for 


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

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


Re: Open Source CF Shopping Carts

2008-04-10 Thread Bob Dronski
Dave,

I originally thought about writing my own shell until I found CFWebstore.  The 
bang for the buck is great.  And their yahoo group is a great source of 
support.  Between the community and CFWebstore quickly responding to all 
questions, it's the best way to get tech support.

I have no affiliation with the company--just a satisfied user.

Bob 

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

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


RE: qoq date formating

2008-04-10 Thread Bob Imperial
Will DateFormat() give you what you need?

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 10, 2008 11:59 AM
To: CF-Talk
Subject: qoq date formating

Is there any dateformating functions when doing a query of a query?

Like in MS SQL I can use the CONVERT function.

SELECT JOBNOTE, CONVERT(varchar, DateCreated, 108) AS DateCreatedAsTime
FROM JobNotes




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

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


Re: Controlling the font output in a created pdf

2008-04-08 Thread Bob Imperial
Ditto on that, I resorted to wrapping everything in divs then using inline 
style attributes to set whatever I need for formatting. My 2 cents.

Bob

>Ian,
>I have had formatting problems with cfdocument in the past.  I remember
>reading somewhere that cfdocument has it's own html/css rendering engine, or
>something to that effect. You may want to try wrapping it with something
>else like a  or a  tag or maybe even (shudder) a font tag .
>
>hth
>G
>
>
>
>
>On Tue, Apr 8, 2008 at 2:14 PM, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
>> 

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

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


RE: New To CF

2008-03-22 Thread Bob Imperial
Just responded to the same posting on cf-newbie but will that response in
here as well.

Bruce,

That will get you started with basic CF but to build data driven sites
you'll also need some sort of RDMS such as MSSQL, Access, MySQL or some
other such product. If you're a visual learner, MS Access is great for
getting started as it lends itself to creating visual models or prototyping
if you will.

As for the "best" way to learn CF really depends on your learning style, if
you're more a visual learner then perhaps what is offered at
http://lynda.com/ would be a good starting point for you. If you're fine
with have printed materials as a guide then I would suggest purchasing a
copy of the latest CF WACK http://www.forta.com/books/0321125169/ will work
for you. IMHO having a copy of WACK is a tool worth having in your box and
well worth the investment.

There are a number of sites out there that can help you jump right in a get
up a running quickly. One site I used a good bit to start with was
easycfm.com http://www.easycfm.com/ with lots of real world examples and
tutorials.

The short answer to "what is the best way to learn CF" is by doing :)

I might add that http://cflearn.com might also provide an opportunity to
learn about debugging :)

HTH

Bob

Imperial art design development
6204 Lead Mine Road
Raleigh, NC 27612
919-602-3118
www.imperialart.com

>>-Original Message-
>>From: William Seiter [mailto:[EMAIL PROTECTED]
>>Sent: Saturday, March 22, 2008 3:37 PM
>>To: CF-Talk
>>Subject: RE: New To CF
>>
>>Welcome to CF.  You are on your way and in the right direction.  I would
>>suggest, before you do any 'major' reading on the subject, that:
>>1.  First you create a very simple .cfm page and test to verify your
>>installation is working.
>>   Open a text editor, type in "#now()#" and save
>>it as index.cfm in the webroot of your local site.
>>  Open that new page in a browser and verify that you do not see the
>>actual text you typed in, but you see the current time in 'timestamp'
>>format.
>>
>>2.  Go to a good online tutorial site and follow the steps exactly so that
>>you can get a feel for the language.
>>  I have heard some good things about http://cflearn.com/
>>
>>3.  If you are an experienced web developer, take a page you have built in
>>another language (PHP, .NET, ASP, etc) and translate its functionality
>>into
>>ColdFusion.
>>
>>Feel free to ask any questions of us here.  This list and the house of
>>fusion's CF-Newbie list can be very helpful to you.
>>
>>Good Luck!!
>>
>>William
>>


~|
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:301801
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Server performance problem since upgrading to CF8

2007-12-14 Thread Bob Hendren
>Every since upgrading to CF8 I've been having a frustrating problem.  After
>starting CF, it will run for a while (sometimes serveral hours, sometimes
>less than an hour) at about 1% - 3% in terms of processor load.  (It's a 2
>cpu - 4 core system.)  Then, all of a sudden, the processor load will jump
>up to about 25% and stay there until CF is restarted. Pages then start
>loading very sluggishly.  This never happened with CF7 and I haven't made
>any code changes since upgrading.
>Also, the CF code that this server runs is very light.
>

I have had this EXACT problem!  Have you found a solution?  A fire-breathing, 
quad-processor, dual core Dell that just locks up - weird!

>
>Anyone seen this, or have any ideas.  BTW, I'm running the standard edition
>of CF so I don't have access to the server monitor. 

~|
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:294762
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SOT: Where to buy CF8 WACK (probably again)

2007-11-06 Thread Bob Clingan
Sometimes it pays to wait a little. I know for Part 1, I was able to buy it 
used from Amazon and with shipping it still only cost me $20- less than half 
price!

--Bob


~|
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:292731
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SOT: Where to buy CF8 WACK (probably again)

2007-11-06 Thread Bob Clingan
Sometimes it pays to wait a little. I know for Part 1, I was able to buy it 
used from Amazon and with shipping it still only cost me $20- less than half 
price!

--Bob


>I just got a notice from Amazon.com that Parts 2 and 3 of the CF8 WACK
>are being delayed -
>
>Part 2 is scheduled to arrive between 11/29 and 12/1.
>Part 3 is scheduled to arrive between 12/28 and 12/31
>
>This represents almost a month's delay!
>
>I did a quick look at BN.com and they're showing November ship
>dates... have they just not updated their product info or would it be
>worth it for me to tell Amazon to cancel the order and re-order from
>BN?
>
>Or is there a better place to order from?
>
>Thanks!
>Hatton 

~|
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:292730
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Link Generator Tool / Problem solved

2007-08-24 Thread Bob Heinz
I'm a little late here, but you could also do

link

>Problem solved. The trick was to get rid of the href altogether. This string
>works in all browsers and passes around fine in CF and DBs or static HTML. 
>
>onclick="openPopUp('http://myurl.com/glossary.cfm?glossary=1&term=2','glossa
>ry','410','300','110','35')" style="cursor: pointer;">This Term 
>
>Of course, you need the OpenPopUp script as a global for the site... but
>that's easy enough.
>
>
>Robert B. Harrison
>Director of Interactive services
>Austin & Williams
>125 Kennedy Drive, Suite 100 Hauppauge NY 11788
>T : 631.231.6600 Ext. 119 
>F : 631.434.7022
>www.austin-williams.com
>
>Great advertising can't be either/or... It must be &. 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


RE: Time for another CF hosting site thread...

2007-07-16 Thread Bob Imperial
Mark ... their response times have always been within an hour or so during
regular business hours. As I said they're not terribly touchy feely, but I
like them. There are 3 principals and all 3 are involved in what they do.
They are Coldfusion developers as well as web hosts so they know the
product. You won't get any automated responses from them, just answers to
your questions toot sweet. My site is running 7,0,2,142559 and all the
others I have hosted there. Drop them a line, I think you'll be surprised
what they allow. 

Bob

> -Original Message-
> From: Mark Mandel [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 16, 2007 7:29 PM
> To: CF-Talk
> Subject: Re: Time for another CF hosting site thread...
> 
> Bob -
> 
> Dantor looks like it might be decent, a few quick questions (I'll
> contact them directly too)
> 
> - Does it run cfmx7? it only seems to list 6.1 on the site?
> - can you run createObject? I see cfobject is disabled? (can that be
> turned on?)
> - What is their support response time like?
> 
> Mark


~|
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:283832
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Time for another CF hosting site thread...

2007-07-16 Thread Bob Imperial
I have several clients hosted with dantor.com with all the bells and whistles 
at a fraction of what you'll find elsewhere. They're hosting wholesalers and 
have a nice reseller matrix. I've used these guys for about 6 years now with 
very few issues and are always ready to help even though they're wholesalers. 
Dantor.com not a lot of warm fuzzies on their site design, but I really don't 
care about glitz and glamour, their service has been such that I haven't even 
looked elsewhere. Oh, I have about 40 domains hosted there and roughly half are 
active sites.

My two cents ... Bob

> -Original Message-
> From: Brian Yager [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 16, 2007 5:07 PM
> To: CF-Talk
> Subject: Time for another CF hosting site thread...
> 
> I have a client that wants a fairly simple website.  I REALLY want to use
> CFdynamics but I am not going to tell him it's $50/month just for CFFILE.
> So...If you all can direct me to who you use, I will gladly look at them
> and give you the referal.
> 
> 
> Thanks,
> 
> Brian Yager
> 
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


Re: Can't see the trees for the forest here ...

2007-07-11 Thread Bob Imperial
Resolved ..

I have seen the error of my way ... ;) found a single variable nested inside a 
collapsed if statement that was spelled differently.

Bob

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


Re: css not working in CF file

2007-07-08 Thread Bob Imperial
Setting the #navBar{   margin: 0 0 0 79%; to 78% allows it room to display at 
the top of that div, or at least it does locally ;)

Bob

> I have two different pages:
> 
> http://www.ocbin.org/index.cfm
> 
> And 
> 
> http://www.ocbin.org/index.html
> 
> They are EXACTLY the same (checked page source). 
> 
> When I run them (.cfm and html) in firefox, they render exactly the 
> same - no problem.
> When I run them in Explorer 7, note that the sidebar is screwed up on 
> the right in the CFM version, but not in the html version.
> 
> Since the page source is exactly the same, I am at a loss to explain 
> how this is happenening.
> 
> Any help greatly appreciated.
> 
> Richard 
Colman

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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


RE: css not working in CF file

2007-07-08 Thread Bob Imperial
Ditto , might even play around with navbar a bit
#navBar{

margin: 0 0 0 79%; <<<

> -Original Message-
> From: Will Tomlinson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 08, 2007 11:21 PM
> To: CF-Talk
> Subject: Re: css not working in CF file
> 
> It looks almost as if the width of the left side floated item is too wide
> to accomodate the right. So it pushes it down below it. Just for the
> heckuvit, shrink the width of the left side to see if it brings the right
> back up.
> 
> 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:283215
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: video gallery / audio gallery?

2007-06-30 Thread Bob Imperial
Dwayne,

Take a little time to go through the tutorials at the bottom of this page.
I'm sure you'll find it worth the time spent as it explains much better than
I can how to accomplish what you're after ... I think ;). I could be wrong,
but I don't think you'll find a solution for what you want that works right
out of the box. You may find that you can build what you want, tailored to
your specific needs.

http://gotoandlearn.com/download.php

HTH Bob

> -Original Message-
> From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 29, 2007 1:06 PM
> To: CF-Talk
> Subject: RE: video gallery / audio gallery?
> 
> I'm a newbie, nobie, better yet tried-to-be user of Flash, so are you
> saying I should just import the movie file into flash, save it as a .swf
> file then configure the xml to pull in the .swf file instead of the .jpg
> files?   Well what about the play back controlls etc.
> 
> 
> ------ Original Message --
> From: "Bob Imperial" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date:  Fri, 29 Jun 2007 11:56:13 -0400
> 
> >
> >You can simply import your video clips into a flash movie clip, then pull
> >those into slideshow pro via the xml file?
> >
> >> -Original Message-
> >> From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> >> Sent: Friday, June 29, 2007 10:11 AM
> >> To: CF-Talk
> >> Subject: RE: video gallery / audio gallery?
> >>
> >> Almost. I use slideShowPro but it's a "photo Gallery"  I'm looking for
> a
> >> video gallery and an audio gallery.
> >>
> >>
> >> -- Original Message --
> >> From: "Imperial, Robert" <[EMAIL PROTECTED]>
> >> Reply-To: cf-talk@houseoffusion.com
> >> Date:  Fri, 29 Jun 2007 09:52:33 -0400
> >>
> >> >
> >> >Sounds like something you could probably do with SlideShow Pro
> >> >http://www.slideshowpro.net/
> >> >
> >> >
> >> >Bob Imperial
> >> >DOM-IS Web Developer
> >> >Department of Medicine
> >> >125 Macnider Hall, CB 7005
> >> >UNC at Chapel Hill Chapel Hill, NC 27599
> >> >Phone: (919) 843-6151
> >>
> >> >-Original Message-
> >> >From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> >> >Sent: Friday, June 29, 2007 9:41 AM
> >> >To: CF-Talk
> >> >Subject: video gallery / audio gallery?
> >> >
> >> >I am working on a site for a small church that would like to broacast
> >> >video excerpts of the pastor's sermons and audio excerpts of the churh
> >> >chior.
> >> >
> >> >Does any one know of a "video display gallery" of the likes of
> cnn.com,
> >> >video.yahoo.com, or youTube.  I do not need a full application, I just
> >> >need something that I can feed an xml file.
> >> >
> >> >Likewise I am looking for a similar audio gallery that supports mp3
> >> >files.
> >> >
> >> >Dwayne
> >> >
> >>
> >>
> >>
> >
> >
> 
> 

~|
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:282620
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: video gallery / audio gallery?

2007-06-29 Thread Bob Imperial
You can simply import your video clips into a flash movie clip, then pull
those into slideshow pro via the xml file?

> -Original Message-
> From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 29, 2007 10:11 AM
> To: CF-Talk
> Subject: RE: video gallery / audio gallery?
> 
> Almost. I use slideShowPro but it's a "photo Gallery"  I'm looking for a
> video gallery and an audio gallery.
> 
> 
> -- Original Message --
> From: "Imperial, Robert" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date:  Fri, 29 Jun 2007 09:52:33 -0400
> 
> >
> >Sounds like something you could probably do with SlideShow Pro
> >http://www.slideshowpro.net/
> >
> >
> >Bob Imperial
> >DOM-IS Web Developer
> >Department of Medicine
> >125 Macnider Hall, CB 7005
> >UNC at Chapel Hill Chapel Hill, NC 27599
> >Phone: (919) 843-6151
> 
> >-Original Message-
> >From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> >Sent: Friday, June 29, 2007 9:41 AM
> >To: CF-Talk
> >Subject: video gallery / audio gallery?
> >
> >I am working on a site for a small church that would like to broacast
> >video excerpts of the pastor's sermons and audio excerpts of the churh
> >chior.
> >
> >Does any one know of a "video display gallery" of the likes of cnn.com,
> >video.yahoo.com, or youTube.  I do not need a full application, I just
> >need something that I can feed an xml file.
> >
> >Likewise I am looking for a similar audio gallery that supports mp3
> >files.
> >
> >Dwayne
> >
> 
> 
> 

~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

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


retrieve mac address with CF?

2007-06-25 Thread Bob Imperial
Good morning folks ... or at least it's morning here ;)
I was just asked if I could retrieve mac addresses via coldfusion and have no 
idea. Is this possible with cf, if so or if someone knows of a good reference 
to point me in the direction of, I would appreciate it greatly.

Thanks! Bob

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: CF training

2007-06-14 Thread Bob Imperial
Aye, been there done that, just thought somebody from the area might be aware 
of something new available here.

Bob

> -Original Message-
> From: Eric Roberts [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 13, 2007 9:45 PM
> To: CF-Talk
> Subject: RE: CF training
> 
> Go to the adobe site and they should have a listing of classes...
> 
> Eric
> 
> -----Original Message-
> From: Bob Imperial [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 13, 2007 10:06 AM
> To: CF-Talk
> Subject: CF training
> 
> Does anyone out there know of any instructor led CF courses in the
> Raleigh/Durham/Chapel Hill area of NC?
> 
> Bob
> 
> 
> 
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


CF training

2007-06-13 Thread Bob Imperial
Does anyone out there know of any instructor led CF courses in the 
Raleigh/Durham/Chapel Hill area of NC?

Bob

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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


Re: need help with updating date field

2007-05-30 Thread Bob Imperial
Thanks all for the quick responses, I've changed the field name from Date to 
AccessDate, makes more sense too. I used cfqueryparam on my insert and just 
trying to get this thing to work in the raw first ;). As for using jdbc instead 
of odbc, I have yet to get cf to register the ds using the SQL driver it 
offers. I'm not an admin and have very little to go on where configuring cf is 
concerned since there's not anyone here that has the know how to get it working 
correctly using jdbc drivers. 

Thank you all for the help, update statement working now ;)

Bob

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: CF Server connecting to MySQL v5

2007-05-29 Thread Bob Imperial
Yes, though I don't think it's released yet, was on the beta program ;) I
can hardly wait, lots of new goodies to play with.

> -Original Message-
> From: Pete [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 6:33 PM
> To: CF-Talk
> Subject: RE: CF Server connecting to MySQL v5
> 
> Coldfusion 8 ???
> 
> Is that the new release of CF.
> 
> I had CF7 standard running perfectly, just cant get enterprise to talk to
> MySQL.  Not sure whether I should be including the jar file in the same
> place as standard or including it in a similar place in the jrun folder or
> both.
> 
> 
> 
> -Original Message-
> From: Bob Imperial [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 30 May 2007 6:47 AM
> To: CF-Talk
> Subject: RE: CF Server connecting to MySQL v5
> 
> I was using 7 standard at the time I found the blog entry on it, though I
> am
> running 8 at the moment and copied the jar to C:\ColdFusion8\lib and still
> works here for the moment, though I hadn't seen anything specifically on
> enterprise edition.
> 
> B
> 
> > -Original Message-
> > From: Pete [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, May 29, 2007 4:24 PM
> > To: CF-Talk
> > Subject: RE: CF Server connecting to MySQL v5
> >
> > Are you using CF 7 Standard or enterprise.
> >
> > Where did you copy the jar file to if using Enterprise version?
> >
> > Regards
> >
> >
> >
> > -Original Message-
> > From: Bob Imperial [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, 30 May 2007 1:15 AM
> > To: CF-Talk
> > Subject: RE: CF Server connecting to MySQL v5
> >
> > This worked for me ...
> > http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7
> >
> > HTH
> >
> > Bob
> >
> > > -Original Message-
> > > From: Pete [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, May 29, 2007 7:17 AM
> > > To: CF-Talk
> > > Subject: CF Server connecting to MySQL v5
> > >
> > > Hi All
> > >
> > >
> > >
> > > I have been using CF v7.02 standard for some time and have recently
> > > installed CF 7 enterprise.
> > >
> > >
> > >
> > > I am unable to connect to a MySQL v5 database.
> > >
> > >
> > >
> > > I have added the mysql-connector-java file as I had to in CF v7.02.
> But
> > I
> > > am still however unable to connect to a MySQL datasource.
> > >
> > >
> >
> >
> >
> >
> >
> 
> 
> 
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: CF Server connecting to MySQL v5

2007-05-29 Thread Bob Imperial
I was using 7 standard at the time I found the blog entry on it, though I am
running 8 at the moment and copied the jar to C:\ColdFusion8\lib and still
works here for the moment, though I hadn't seen anything specifically on
enterprise edition.

B

> -Original Message-
> From: Pete [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 4:24 PM
> To: CF-Talk
> Subject: RE: CF Server connecting to MySQL v5
> 
> Are you using CF 7 Standard or enterprise.
> 
> Where did you copy the jar file to if using Enterprise version?
> 
> Regards
> 
> 
> 
> -Original Message-
> From: Bob Imperial [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 30 May 2007 1:15 AM
> To: CF-Talk
> Subject: RE: CF Server connecting to MySQL v5
> 
> This worked for me ...
> http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7
> 
> HTH
> 
> Bob
> 
> > -Original Message-
> > From: Pete [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, May 29, 2007 7:17 AM
> > To: CF-Talk
> > Subject: CF Server connecting to MySQL v5
> >
> > Hi All
> >
> >
> >
> > I have been using CF v7.02 standard for some time and have recently
> > installed CF 7 enterprise.
> >
> >
> >
> > I am unable to connect to a MySQL v5 database.
> >
> >
> >
> > I have added the mysql-connector-java file as I had to in CF v7.02.  But
> I
> > am still however unable to connect to a MySQL datasource.
> >
> >
> 
> 
> 
> 
> 

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

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


RE: CF Server connecting to MySQL v5

2007-05-29 Thread Bob Imperial
This worked for me ...
http://www.mikemedia.eu/blog/index.cfm/2006/3/2/MySQL-5-and-CFMX-7
 
HTH

Bob

> -Original Message-
> From: Pete [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 29, 2007 7:17 AM
> To: CF-Talk
> Subject: CF Server connecting to MySQL v5
> 
> Hi All
> 
> 
> 
> I have been using CF v7.02 standard for some time and have recently
> installed CF 7 enterprise.
> 
> 
> 
> I am unable to connect to a MySQL v5 database.
> 
> 
> 
> I have added the mysql-connector-java file as I had to in CF v7.02.  But I
> am still however unable to connect to a MySQL datasource.
> 
> 


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


Re: MS SQL 2000 and ntext

2007-05-25 Thread Bob Imperial
I ran into something similar a week or so ago, don't know if this will work for 
your issue, but instead of SELECT *, try selecting the specific fields you need 
and put the ntext field as the very last in your select statement. Maybe maybe 
not 

Bob

>Hi there,
>
>I'm running CF7 and MS SQL 2000 on this project I'm working on.
>
>I'm using a simple cfquery to get a row of data.
>
>SELECT *
>FROM datatable
>WHERE id = 439
>
>
>Very, very simple query
>
>Now, one of these fields is of type ntext. It contains xml data.
>
>What I'm trying to do is to retrieve the xml data from this field... what
>seems to happen, is that the xml isn't returned in it's entirety.
>It's cut off at a certain point.
>
>Any ideas?
>
>This table is actually used by (and created with) a .NET program my employer
>purchased, and the data is used in this program without a problem.
>
>I know this is slightly vague
>
>Thanks,
>
>-- 
>Yves Arsenault
>
>"Love is the only force capable of transforming an enemy into a friend".
>--Martin Luther King, Jr.

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

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


Re: Edit excel on line

2007-05-22 Thread Bob Imperial
Meant to say "My wife uses" ...fat fingers, slow brian ;)

> I was hoping to find something with this functionality that could be 
> installed within a site and administer it myself, though I don't know 
> if this even exists in the open source community yet. My uses this 
> functionality via a company called HyperOffice at the moment. They've 
> not been all that happy with the support thus far so I was really 
> hoping to find something to work with myself.
> 
> Bob
> >
> >
> >
> >I'd take a look at  docs.google.com
> >
> >Depending on what you are trying to do, this works fairly well for 
> most
> >excel functions.

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

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


Re: Edit excel on line

2007-05-22 Thread Bob Imperial
I was hoping to find something with this functionality that could be installed 
within a site and administer it myself, though I don't know if this even exists 
in the open source community yet. My uses this functionality via a company 
called HyperOffice at the moment. They've not been all that happy with the 
support thus far so I was really hoping to find something to work with myself.

Bob
>
>
>
>I'd take a look at  docs.google.com
>
>Depending on what you are trying to do, this works fairly well for most
>excel functions.

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


RE: GUI for WebApplications

2007-05-19 Thread Bob Imperial
Don't know that I've ever seen any galleries specific to admin ui stuff, but
it seems you could adapt any layout to suit your need. Email me off list
about this if you like, not a solicitation for work ;) just help.

Bob

> -Original Message-
> From: Dwayne Cole [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 19, 2007 3:54 AM
> To: CF-Talk
> Subject: GUI for WebApplications
> 
> I am ready to redesign the user interface for a content management system
> that I built about 4 years ago.  I looking for some nice layouts.  I am
> aware of plenty of front end web gallery sites but but I don't know of any
> galleries of admin panels.  Are there any suggestions?
> 
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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


RE: query of query - clob error

2007-05-18 Thread Bob Imperial
These settings are found under the advanced setting tab when you register
your datasource. Not sure what the default setting is for your buffer, 64k
maybe? It's been suggested to me to double that, at any rate mine is set to
128. Hope this helps.


CLOB -- Enable long text retrieval (CLOB).
BLOB   -- Enable binary large object retrieval (BLOB).

Long Text Buffer (chr)  
Blob Buffer(bytes)


Bob


> -Original Message-
> From: daniel kessler [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 18, 2007 9:34 AM
> To: CF-Talk
> Subject: Re: query of query - clob error
> 
> >Just a shot in the dark here, did you enable that setting in the cf
> >administrator and have you tried listing the specific fields that are in
> >fact CLOB/BLOB last in your query? I ran into a slightly different issue
> but
> >somewhat similar a week or so ago and doing this solved my issue.
> 
> Yes, I did try listing the two of them last.  I also removed one, just for
> testing, and the last field is a CLOB and it still fails.
> I can ask to have a setting enabled.  What setting would that be?
> 
> Any other thoughts?
> 
> thanks so far.



~|
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:278646
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 of query - clob error

2007-05-18 Thread Bob Imperial
Just a shot in the dark here, did you enable that setting in the cf
administrator and have you tried listing the specific fields that are in
fact CLOB/BLOB last in your query? I ran into a slightly different issue but
somewhat similar a week or so ago and doing this solved my issue.

HTH Bob

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 18, 2007 8:07 AM
> To: CF-Talk
> Subject: query of query - clob error
> 
> I have a nice little query of query going (brilliant little tool query of
> queries are).
> 
> Unfortunately, it seems that if my SELECT specifies a field that's a CLOB,
> then I
> receive an error. Here's the error:
> Query Of Queries runtime error.
> Unsupported SQL type "java.sql.Types.CLOB".
> 
> Oddly, If I don't specify a list of fields and only do SELECT * then
> everything works
> a-okay.  Whatup with that?  Any help?
> 
> 
> daniel
> 
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: Scorpio to help with "CFMyAdmin"

2007-05-15 Thread Bob Imperial
Ok Rick ;), I was there last night as well and I'm trying to put names with
faces, which one were you? LOL 

Bob

> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 15, 2007 7:58 AM
> To: CF-Talk
> Subject: Scorpio to help with "CFMyAdmin"
> 
> The "new feature" mentioned at the TACFUG/RDAUG user group meeting
> last night involved updated database drivers across the board, and a
> new tag called  which will provide all kinds of database
> introspection stuff.
> 
> So whoever was planning to write a CFMyAdmin type utility... it might
> be a whole lot easier in CF8!
> 
> Rick
> 
> --



~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: Blob/clob issue

2007-05-10 Thread Bob Imperial
Well ... looks like there might be an issue with TCP/IP although it is
enabled, in fact, I unchecked it a rechecked it, restarted SQL Server.
Couldn't connect trying to telnet in using the IP of the box it's on and the
standard 1433 on the port ... I'm going to reboot the server in a bit after
everyone has left for the day and see what if any effect that might have.

Bob

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 10, 2007 5:08 PM
> To: CF-Talk
> 
> Your problem is likely one of these things:
> - you don't have the TCP/IP listener enabled on the database server,
> - you are specifying the wrong server and/or port in the CF datasource,
> - there is a firewall blocking either your application server's outbound
> traffic or your database server's inbound traffic on the port in question.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
user=22382.15322.4



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: Blob/clob issue

2007-05-10 Thread Bob Imperial
It is enabled, although I'm definitely not a db admin by a long shot. I know
the basics of to get around and work within enterprise manager and such. But
I'm always willing to break things ;)

Bob

> -Original Message-
> From: Peterson, Chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 10, 2007 3:23 PM
> To: CF-Talk
> Subject: RE: Blob/clob issue
> 
> Check your SQL server configuration and make sure that TCP/IP access is
> enabled (its off by default)
> 
> Chris Peterson



~|
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:277665
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Blob/clob issue

2007-05-10 Thread Bob Imperial
Dave this is what I've run into with every attempt so far:
Connection verification failed for data source: Faculty_Profile2
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket. Connection refused: connect

> If you're unable to use the DataDirect drivers that come with CF to
> connect,
> you will likely not be able to use any other JDBC drivers to connect,
> either. What error do you get when you try to set up the connection?
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
> 
> This email has been processed by SmoothZap - www.smoothwall.net
> 
..com/cf_lists/unsubscribe.cfm?user=28108.19997.4


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: Blob/clob issue

2007-05-10 Thread Bob Imperial
Unfortunately, I've not been able to successfully register a ds in cf w/ms
sql drivers, yet another story ;). So, off to pull down jdbc drivers from ms
and see what I can break. 

Gracias!

> -Original Message-
> From: Peterson, Chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 10, 2007 8:57 AM
> To: CF-Talk
> Subject: RE: Blob/clob issue
> 
> Bob,
> 
> First I would try the built in MS SQL driver, and if that still fails
> give the Microsoft JDBC driver a shot.
> 
> Chris
> 
> -Original Message-
> From: Bob Imperial [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 10, 2007 8:56 AM
> To: CF-Talk
> Subject: Blob/clob issue
> 
://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=22382.15322.4



~|
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:277612
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Blob/clob issue

2007-05-10 Thread Bob Imperial
Well . it's almost Friday and none to soon for me. I have an issue I've run
into I'm hoping someone out there might have a solution for. First off I'm
working with CFMX 7, MSSQL 2k on a Win 2003 Web Server and using an ODBC
driver. I have an ntext field that's not returning any data to me for
display, I've dumped my query and there are actually a couple of ntext
fields that just return and empty string. The thing is, this ntext field
displays fine in an aspx page within an old site I am rebuilding (or trying
to anyway) using ColdFusion. Anyone ever run into this and more importantly,
can anyone offer a solution? I've done a google or two on it with no real
luck on a solution yet. Oh and the query is as simple as it gets, doing
SELECT *

 

Thanks!

 

Tired Bob



~|
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:277604
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: iSeries point to ColdFusion server direction...

2007-04-03 Thread Bob Johnson
Thank you for the reply Russ.

So, how in Apache to I actually point it to the ColdFusion server? Is there a 
line in the config where I would say that it needs to go to the W2K3 server for 
ColdFusion pages.

Thanks again. This is new to me.

Bob

> Bob, 
> 
> I'm not familiar with the iSeries Apache Web server, but if you are 
> using a standard apache web server, you would use the wsconfig program 
> that gets installed with apache to connect to coldfusion.  You can 
> also manually copy over the mod_jrun22.so or mod_jrun2.so files and 
> manually put in the configuration.  Something like this:
> 
> LoadModule jrun_module "C:/JRun4/lib/wsconfig/mod_jrun22.so"
> 
> # JRun Settings
> 

>   JRunConfig Verbose true

>   JRunConfig Apialloc false

>   JRunConfig Ssl false

>   JRunConfig Ignoresuffixmap false

>   JRunConfig Serverstore "C:/JRun4/lib/wsconfig/1/jrunserver.
> store"

>   JRunConfig Bootstrap x.x.x.x:51002

>   #JRunConfig Errorurl 

>   #JRunConfig ProxyRetryInterval 600

>   #JRunConfig ConnectTimeout 15

>   #JRunConfig RecvTimeout 300

>   #JRunConfig SendTimeout 15

>   AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf 
> 
> 
> Hope this helps,
> 
> Russ

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

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


Re: iSeries point to ColdFusion server direction...

2007-04-03 Thread Bob Johnson
> Bob, 
> 
> I'm not familiar with the iSeries Apache Web server, but if you are 
> using a standard apache web server, you would use the wsconfig program 
> that gets installed with apache to connect to coldfusion.  You can 
> also manually copy over the mod_jrun22.so or mod_jrun2.so files and 
> manually put in the configuration.  Something like this:
> 
> LoadModule jrun_module "C:/JRun4/lib/wsconfig/mod_jrun22.so"
> 
> # JRun Settings
> 

>   JRunConfig Verbose true

>   JRunConfig Apialloc false

>   JRunConfig Ssl false

>   JRunConfig Ignoresuffixmap false

>   JRunConfig Serverstore "C:/JRun4/lib/wsconfig/1/jrunserver.
> store"

>   JRunConfig Bootstrap x.x.x.x:51002

>   #JRunConfig Errorurl 

>   #JRunConfig ProxyRetryInterval 600

>   #JRunConfig ConnectTimeout 15

>   #JRunConfig RecvTimeout 300

>   #JRunConfig SendTimeout 15

>   AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf 
> 
> 
> Hope this helps,
> 
> Russ
> 
> > -Original Message-
> > From: Bob Johnson [mailto:[EMAIL PROTECTED]
> > Sent: Monday, April 02, 2007 4:24 PM
> > To: CF-Talk
> > Subject: Re: iSeries point to ColdFusion server direction...
> > 
> > I found an article on Adobe's site talking about Distributed 
> configuration
> > but it was for version 5. Anyone have anything newer that they've 
> seen and
> > what I would need to do to the Apache on the iSeries to point 
> correctly to
> > ColdFusion on W2K3?
> > 
> > Thanks.
> > 
> > > I hope someone can point me in the right direction or fill me in...
> 
> > >
> > > Currently where I work we don’t use ColdFusion but I’m 
> putting
> > > together a presentation as to why we should move to ColdFusion. 
> My
> > > question is, how would one setup up an iSeries Apache Web server 
> to
> > > use a Windows 2003 Server running ColdFusion for ColdFusion pages. 
> We
> > > don’t want to change our main Web server from the iSeries we 
> just want
> > > to point to the W2K3 server running ColdFusion when needed. Any 
> info
> > > or direction would be appreciated.
> > >
> > > Thank you
> > Bob
> > 
> > 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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


Re: iSeries point to ColdFusion server direction...

2007-04-02 Thread Bob Johnson
I found an article on Adobe's site talking about Distributed configuration but 
it was for version 5. Anyone have anything newer that they've seen and what I 
would need to do to the Apache on the iSeries to point correctly to ColdFusion 
on W2K3?

Thanks.

> I hope someone can point me in the right direction or fill me in...
> 
> Currently where I work we don’t use ColdFusion but I’m putting 
> together a presentation as to why we should move to ColdFusion. My 
> question is, how would one setup up an iSeries Apache Web server to 
> use a Windows 2003 Server running ColdFusion for ColdFusion pages. We 
> don’t want to change our main Web server from the iSeries we just want 
> to point to the W2K3 server running ColdFusion when needed. Any info 
> or direction would be appreciated.
> 
> Thank you 
Bob

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

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


Re: iSeries point to ColdFusion server direction...

2007-04-02 Thread Bob Johnson
> I hope someone can point me in the right direction or fill me in...
> 
> Currently where I work we don’t use ColdFusion but I’m putting 
> together a presentation as to why we should move to ColdFusion. My 
> question is, how would one setup up an iSeries Apache Web server to 
> use a Windows 2003 Server running ColdFusion for ColdFusion pages. We 
> don’t want to change our main Web server from the iSeries we just want 
> to point to the W2K3 server running ColdFusion when needed. Any info 
> or direction would be appreciated.
> 
> Thank you 
Bob

~|
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:274345
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


iSeries point to ColdFusion server direction...

2007-04-02 Thread Bob Johnson
I hope someone can point me in the right direction or fill me in...

Currently where I work we don’t use ColdFusion but I’m putting together a 
presentation as to why we should move to ColdFusion. My question is, how would 
one setup up an iSeries Apache Web server to use a Windows 2003 Server running 
ColdFusion for ColdFusion pages. We don’t want to change our main Web server 
from the iSeries we just want to point to the W2K3 server running ColdFusion 
when needed. Any info or direction would be appreciated.

Thank you Bob

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: Multiple Query Totals

2007-03-30 Thread Bob Johnson
Thanks Chris!

I am going to remember this. This is extremely useful!!

Bob
On Fri, 30 Mar 2007 11:39:47 -0400, "Peterson, Chris"
<[EMAIL PROTECTED]> said:
> You don't have to do it that way.  Try using sub-selects to get the
> child data.  I do this in DB2 all the time, here is an example.
> 
> 
> SELECT
>   Col1,
>   Col2,
>   Col3,
>   (SELECT SUM(Revenue) FROM rev WHERE Order = A.Order) as
> TotalRevenue
> FROM
>   ORDER A
> WHERE
>   Col1 = 'Whatever'
> 
> 
> You can do as many of those sub-select as columns you need.  Just ensure
> that the data set is returning only a single record.
> 
> 
> Also, you could do a nice Union All on your QoQ, if the fields are the
> same.
> 
> 
> If we still are not getting what your trying to do, maybe post some
> code?
> 
> Chris
> 
> 

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

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


RE: Multiple Query Totals

2007-03-30 Thread Bob Johnson
Thanks everyone. I misunderstood the last "UNION" post. 

The UNION ALL is working perfectly.

Thanks for helping me out.

Bob


On Fri, 30 Mar 2007 11:30:55 -0400, "Peterson, Chris"
<[EMAIL PROTECTED]> said:
> Yea, in DB2 you can just do
> 
> SELECT col1, col2, col3 FROM file 
> 
> UNION ALL
> 
> SELECT col1, col2, col3 FROM file2
> 
> ORDER BY col1
> 
> Note the order by goes after all your UNION's, and sorts the entire
> result set.
> 
> Chris 
> 
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
> Sent: Friday, March 30, 2007 11:28 AM
> To: CF-Talk
> Subject: Re: Multiple Query Totals
> 
> Bob Johnson wrote:
> > 
> > How to I take two queries and combine them so they paging will work?
> 
> Check your database manual for UNION.
> 
> Jochem
> 
> 
> 
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


Re: Multiple Query Totals

2007-03-30 Thread Bob Johnson
Thanks, but that is not what I am asking. The queries have multiple
tables combined with the UNION command.

I can't get all of the data from one query. I have to create a query to
get the child/parent relationship and then use another query to extract
record info.

Bob

On Fri, 30 Mar 2007 17:28:04 +0200, "Jochem van Dieten"
<[EMAIL PROTECTED]> said:
> Bob Johnson wrote:
> > 
> > How to I take two queries and combine them so they paging will work?
> 
> Check your database manual for UNION.
> 
> Jochem
> 
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


Multiple Query Totals

2007-03-30 Thread Bob Johnson
Hello!

I have a page setup that lists data about certain records in a DB2 database.

The user can choose between two different methods of showing data. The first 
(ONLY Mode) shows orders for a specific account. (This is working fine)

The second "mode" (Called Normal) shows all of the order for the specific 
account along with orders from the parent company and any other children 
companies associated with the parent company.

This is working fine except for the "paging" feature. The user can page back an 
forward to see a user defined amount of records on each page. I've modified the 
code so that it properly shows "Showing 1 - 20 of 913Next 20". But, 
it is listing the first 20 of the first query and then the first 20 of the 
second query. Then when the user clicks next it shows the next 20 of each query.

How to I take two queries and combine them so they paging will work? Should I 
use an array and stick all of the results into this array?

Thanks for any direction.

Bob

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: Debugging?

2007-03-19 Thread Bob Imperial
Sure is, in cfadmin under debugging settings Debugging & Logging > Debugging
IP List , add the IP address for debug output.

Bob 

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 19, 2007 10:30 AM
To: CF-Talk
Subject: Debugging?

Is there a way to have Debugging turned OFF for one site but on for
everything else?
 
I am building an internal application and would like the Debugging on that
site off.
 
Since developers are using the same server for other applications, the
debugging (CF Admin settings) is turned on.

TIA!
 
 




~|
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:273002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfhttp/xml help

2007-03-17 Thread Bob Imperial
Hi Folks,
 
I'm just getting started with learning the basics on pulling xml feeds with
cfhttp and am in need of some help with an error I get with some feeds I'm
playing with. Here's the code block I'm working with and I get the following
error on this feed and a couple of others...
 
 Content is not allowed in prolog.  
 
The error occurred in C:\Inetpub\wwwroot\testing\rss.cfm: line 10


8 : 

9 : http://www.nranews.com/rss/rss.xml"; method="GET"
resolveurl="No" >

10 : http://www.nranews.com/rss/rss.xml"; method="GET"
resolveurl="No" >

 





Title: #MyXML.rss.channel.item[x].title.xmlText#  click here
#MyXML.rss.channel.item[x].description.xmlText#



 
While this same block of code works fine using the feed from
http://www.tfc.edu/radio/podcasting/music.xml 
 
I'm confused here, any help in understanding this is appreciated!
 
Bob


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: need insert help please

2007-03-10 Thread Bob Imperial
I got it, or at least it did what I've been trying to get it to do ;) May
not be elegant but it worked

For some reason it didn't like #form.week_of# so I tried this and it worked

 


INSERT INTO current_week (week_of,song_title)
VALUES ('#thisWeek#','#item#')



Thanks for your patience and feedback Dave! It is much appreciated!

Bob


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Saturday, March 10, 2007 8:03 PM
To: CF-Talk
Subject: RE: need insert help please

> > I am passing this to:
> >   > name="current_week" datasource="#dsdata#" username="myname"
> > password="mypwd">
> > INSERT INTO current_week (song_title) VALUES ('#item#')  
> > 
> 
> I'm not seeing where to shoe-horn the week_of value into the above 
> loop, there may be 5 or 6 song_title(s) just not seeing the syntax for 
> it..

Is "week_of" a field in the current_week table? If so, you can add it to
that INSERT statement. If it's a field in another table, and you want to
update the value, put another query outside your CFLOOP to do this.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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


RE: need insert help please

2007-03-10 Thread Bob Imperial
This was copied from a separate display page I setup for band members to
download their songs from, just hadn't pulled out the link refs yet. This
isn't for the public, actually it's for members of a worship band from
church...to make It a little easier for folks to get to their material for
the coming week.

This will be displayed on another page, probably only 5 or 6 as opposed to
150+ on my archive page, so the whole week_of thing comes into play there,
displaying songs for that date..yada yada yada.

This is a bit off your point, but why do you have links in there? If someone
clicks on one of the links, they'll leave your form without finishing it.

> I am passing this to:
>   name="current_week" datasource="#dsdata#" username="myname"
> password="mypwd">
> INSERT INTO current_week (song_title)
> VALUES ('#item#')
> 
> 

I'm not seeing where to shoe-horn the week_of value into the above loop,
there may be 5 or 6 song_title(s) just not seeing the syntax for it..
Thanks Dave.wellat least I survived the 60s. Which may explain
some of my difficulty here ;)

I'm not sure what you're doing with "week_of", but it doesn't matter whether
the field is inside or outside your loop if you only want it to have one
value. In your action page, you'll have "week_of" along with "songTitle".

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

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


RE: need insert help please

2007-03-10 Thread Bob Imperial
 
Dave...sorry for the lack of information, after read what I posted I thought
I should have given a little more information. My form looks like this:




This is generated from doing a read with cfdirectory

#name# 

 


I am passing this to:


INSERT INTO current_week (song_title)
VALUES ('#item#')



Working with mysql, song_id(pk) week_of, song_title and doc_title are all 3
varchars, I hope this enough information to get a better understanding of
what I'm trying to do. In addition to the form above, I also have a second
form setup the same way for the accompanying docs, this also built from a
cfdirectory read. I guess my main question is, since the week_of field in my
form is outside the loop, how do I handle that value? I sure hope this is
making sense to someone ;)

Thanks ...Bob


What exactly do you mean by a group of songs? More information about your
form and database schema would be helpful here.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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


need insert help please

2007-03-10 Thread Bob Imperial
First off...shouldn't you all be out doing something other than working? ;-)
Since you're not out somewhere having way too much fun, I could use some
enlightenment here.
I have a form passing multiple values via some checkboxes, I think I've got
the insert down ok for that with the following: I'm working with MySql and
the week_of field I have set to unique in the db.
 

  
   INSERT INTO current_week (song_title)
   VALUES ('#item#')
  

 
My question comes in with a form field that only needs to be inserted once
for each group of songs, this value is also being passed via the form, how
would I go about handling this? To muddy this up a tad more, I have a second
for that handles song docs that need to be inserted and associated with the
week_of insert from the first insert statement. Any help would of course be
greatly appreciated! I work alone so my only source for
feedback/help/direction is this and a few other lists.
 
Thanks! Bob


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

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


RE: query on cfdirectory

2007-03-10 Thread Bob Imperial
Thanks for the quick response! This will keep me from cleaning out the shed
for a while ;) unless of course the wife decides we need to do 

Bob 

-Original Message-
From: Coldfusion [mailto:[EMAIL PROTECTED] 
Sent: Saturday, March 10, 2007 11:28 AM
To: CF-Talk
Subject: RE: query on cfdirectory

To see all elements returned in a query structure:


You are on track with the form/checkbox option by storing the filename in a
db to be displayed later. 



~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

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


query on cfdirectory

2007-03-10 Thread Bob Imperial
Hi folks,
 
in need of some help with a couple of things here that I'm wanting to do.
Not really sure where or how to start ..Firstly, I have a couple of
directories (songs,docs) that I do a simple display of with cfdirectory and
cfloop query to display names. What I am attempting to do is provide a way
for people to select a number of songs/docs from each of these directories
to store or write to a file for others to view as a current song type thing.

I'm thinking about just doing a simple form/checkbox scenario to flag the
items, then store in a db and pulling those for display on the other end? I
guess I'm asking what might be the best approach for this? Secondly, my mind
is wandering/wondering and trying to get a better understanding of what is
returned by a query in this situation, are the only things returned, the
elements outlined in livedocs?? I'm needing a somewhat visual between the
whole array/query thing and what I've been reading so far seems too vague
for my feeble mind to figure out. Any help or direction on any of the above
would be greatly appreciated.
 
TIA Bob


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

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


RE: writing xml files

2007-02-16 Thread Bob Imperial
Ben,

This isn't something I see being under a constant load with multiple calls,
so this may be something for me to explore, if nothing else, it will be an
opportunity for me to learn another way to do this.

Thanks!

Bob

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 16, 2007 2:33 PM
To: CF-Talk
Subject: RE: writing xml files

Bob,

You could also just have the flash movie call the CFM page directly and have
the CFM page return XML data. The downside to that though is that is
requires CF processing every time the flash movie loads. The upside is that
it cuts out the middle man and you don't have to worry about the XML file
being created PRIOR to the flash movie being loaded.




 

Just trying to give you options.


...
Ben Nadel




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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


RE: writing xml files

2007-02-15 Thread Bob Imperial
Thanks Michael.I'll play around with that and the dataset returned from
my query, looks like just what I'm after ;-) 

Bob

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 16, 2007 1:12 AM
To: CF-Talk
Subject: RE: writing xml files

Bob,

It'll be something along these lines... to get you started.


   
...cfstuff here...
   





Hope that helps.

Michael



> -Original Message-
> From: Bob Imperial [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 15, 2007 10:06 PM
> To: CF-Talk
> Subject: RE: writing xml files
> 
> Aye...playing around with that nowwas hoping for a tutorial of sorts.
> Thanks for the reply ;)
> 
> -Original Message-
> From: Michael E. Carluen [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 16, 2007 12:56 AM
> To: CF-Talk
> Subject: RE: writing xml files
> 
> > I want to write the XML file with CF.
> 
> 
> 
> cfxml?
> 
> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/
> html
> /w
> whelp.htm?context=ColdFusion_Documentation
> <http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common
> /htm
> l/
> wwhelp.htm?context=ColdFusion_Documentation&file=0352.htm>
> &file=0352.htm
> 
> 
> 
> 
> 
> 
> 
> 
> 
> > -Original Message-
> 
> > From: Bob Imperial [mailto:[EMAIL PROTECTED]
> 
> > Sent: Thursday, February 15, 2007 9:46 PM
> 
> > To: CF-Talk
> 
> > Subject: writing xml files
> 
> >
> 
> > Working on a little flash slideshow here for a client and at 
> > present, I'm
> 
> > pulling the images and some captions in via an XML file. What I'm 
> > looking
> 
> > to
> 
> > do is make it easy for them to upload their images and use a text 
> > field to
> 
> > pass their captions along as well. I want to write the XML file with CF.
> 
> > Has
> 
> > anyone out there done this or something like it that can offer some
> 
> > direction or point me in the direction of some decent tutorials on this?
> 
> > TIA
> 
> >
> 
> >
> 
> > Bob
> 
> >
> 
> >
> 
> >
> 
> 
> 
> 



~|
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:269982
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: writing xml files

2007-02-15 Thread Bob Imperial
Aye...playing around with that nowwas hoping for a tutorial of sorts.
Thanks for the reply ;) 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 16, 2007 12:56 AM
To: CF-Talk
Subject: RE: writing xml files

> I want to write the XML file with CF.

 

cfxml?

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/w
whelp.htm?context=ColdFusion_Documentation
<http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/
wwhelp.htm?context=ColdFusion_Documentation&file=0352.htm>
&file=0352.htm

 

 

 

 

> -Original Message-

> From: Bob Imperial [mailto:[EMAIL PROTECTED]

> Sent: Thursday, February 15, 2007 9:46 PM

> To: CF-Talk

> Subject: writing xml files

> 

> Working on a little flash slideshow here for a client and at present, 
> I'm

> pulling the images and some captions in via an XML file. What I'm 
> looking

> to

> do is make it easy for them to upload their images and use a text 
> field to

> pass their captions along as well. I want to write the XML file with CF.

> Has

> anyone out there done this or something like it that can offer some

> direction or point me in the direction of some decent tutorials on this?

> TIA

> 

> 

> Bob

> 

> 

> 



~|
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:269980
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


  1   2   3   4   5   6   >