SABRE Web Services

[Frank Priest]

Hi,
Has anybody connected to SABRE Web services with Coldfusion? I need to get
this started and would like to talk to people who have already done this

Thanks in advance for your time!

Frank


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

Re: FTPS

[Christopher Hinkle]

Adrian -- Thanks much!

chris.

>Chris,
>
>I contacted Drew and gave him your email address. It's his work, so I
>left it to him to give it away.
>
>A. 
>
>Adrian -- I'd be really interested in this CFX with FTPS capabilities...
>unfortunately the link you gave had an "X-ed" out email address.  Could
>you provide more information?  Perhaps off-list, if necessary?
>
>Thanks,
>chris.
>
>>I used Drew's CFX - while you usually just read about it's SFTP 
>>capabilities, there actually is a FTPS (which we use and can recommend)
>
>>version of it.
>>
>>http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Col
>>d-Fusion-98733.aspx (The reference to his email address is at the end 
>>of the thread).
>>
>>Adrian

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

RE: FTPS

[Adrian Wagner]

Chris,

I contacted Drew and gave him your email address. It's his work, so I
left it to him to give it away.

A. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 19 July 2007 8:17 AM
To: Adrian Wagner; CF-Talk; [EMAIL PROTECTED]
Subject: Re: FTPS 

Adrian -- I'd be really interested in this CFX with FTPS capabilities...
unfortunately the link you gave had an "X-ed" out email address.  Could
you provide more information?  Perhaps off-list, if necessary?

Thanks,
chris.

>I used Drew's CFX - while you usually just read about it's SFTP 
>capabilities, there actually is a FTPS (which we use and can recommend)

>version of it.
>
>http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Col
>d-Fusion-98733.aspx (The reference to his email address is at the end 
>of the thread).
>
>Adrian



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

Re: HostMySite: Linux Builder + CF No Longer Offered

[James Holmes]

You can include CF or BD as part of the monthly cost of the VPS, you
don't need to bring your own.

On 7/19/07, Greg Fuller <[EMAIL PROTECTED]> wrote:
> Rick:  Yep. Bummer.
>
> Jordon: Thanks for the info. Do you think 512mb is enough for CF and Verity?
>
> James:  Thanks, it's under consideration.  I think I would need my own
> copy of CF with  Vivio VPS, but in the long run that may be a better
> option.

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

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

Re: FTPS

[Christopher Hinkle]

Adrian -- I'd be really interested in this CFX with FTPS capabilities... 
unfortunately the link you gave had an "X-ed" out email address.  Could you 
provide more information?  Perhaps off-list, if necessary?

Thanks,
chris.

>I used Drew's CFX - while you usually just read about it's SFTP
>capabilities, there actually is a FTPS (which we use and can recommend)
>version of it.
>
>http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Cold-Fusion-98733.aspx
>(The reference to his email address is at the end of the thread).
>
>Adrian 

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

Re: Text file created on windows published to unix

[Jordan Michaels]

Occasionally windows/dos characters get in the way when read in *nix
environments. To "correct" a file like that, try running "dos2unix" on
it. It's a command-line utility designed to translate any
dos-differences to their *nix equivalents. dos2unix ships with most
common distros.

>From the command-line:

# dos2unix myfile.xslt

You can use this to rule out any potential *nix problems from files
created on a windows machine.

Hope this helps!

Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
BlueDragon Alliance Member
[EMAIL PROTECTED]


Ian Skinner wrote:
> And causing me some grief.
> 
> I get this error when my CF app tries to work with an XSLT file created 
> on my Windows workstation and published to a UNIX/Apache server.  Can 
> anybody give me the quickest and easiest way to fix this?  I presume 
> this is related to the difference between Win and Unix text end of 
> line|file characters.
> 
> An error occured while Parsing an XML document.
> Premature end of file.
>  
> The error occurred in 
> /export/home/tools/troublelog/Model/troubleLogDAO.cfc: line 85
> 
> 85 : troubleEntryXML = 
> xmlParse(xmlTransform(xmlData,replace(variables.readXSLT,'~idString~',arguments.id)));
> 
> 
> 
> 
> 
> 

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

Text file created on windows published to unix

[Ian Skinner]

And causing me some grief.

I get this error when my CF app tries to work with an XSLT file created 
on my Windows workstation and published to a UNIX/Apache server.  Can 
anybody give me the quickest and easiest way to fix this?  I presume 
this is related to the difference between Win and Unix text end of 
line|file characters.

An error occured while Parsing an XML document.
Premature end of file.
 
The error occurred in 
/export/home/tools/troublelog/Model/troubleLogDAO.cfc: line 85

85 : troubleEntryXML = 
xmlParse(xmlTransform(xmlData,replace(variables.readXSLT,'~idString~',arguments.id)));





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

Re: Stopping a Screen Scrape

[Paul Ihrig]

gif's are your friend.
animated.
with a tranprarent 2 pixel deal bouncing back & fors.
with content in same said gif, animatinting in oposit dir..


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

Re: Stopping a Screen Scrape

[Cameron Childress]

Recourse against what?

Once a company gets to the point of intentionally breaking their product 
to make it less useful to their customers, it's a very bad sign.  I have 
no idea why either party would still want to be in  such a business 
relationship unless one is holding the other's data hostage, which is 
what it sounds like is happening.

There may be no legal recourse, but that doesn't make it right.

-Cameron

Randy Johnson wrote:
> I am not sure I agree with your statement. If I choose to make my 
> printer friendly page a graphic instead of a standard html table as long 
> as it still prints fine you would have no recourse. About the only thing 
> you could do is take your business elsewhere. Right?
>
> -Randy
>
> Cameron Childress wrote:
>   
>> Does this application contain financial data for the company?  Are they 
>> attempting to get access to their own financial information in order to 
>> put it into QB and run their business?  Your employer wants to prevent 
>> them from doing this?  This raises a ton of ethical and moral 
>> questions.  I know you are not the one making the call here, but 
>> seriously, if a company I was doing business with was ACTIVELY 
>> preventing me from gaining access to my own financial data things could 
>> escalate very quickly.
>>
>> Having said that - if this company is actually doing something that 
>> violates a legal agreement you have with them somehow, simply shutting 
>> off access to the site should fix the problem.  If this is data going 
>> into QB, they much be authenticating to get to it (unless the financial 
>> data is out in the open for all to see).  Just shut them off and resolve it.
>>
>> -Cameron
>>
>> Jason Liebgott wrote:
>>   
>> 
>>> Just started working on a legacy application built in CF5. It appears that 
>>> one of the users is screen scraping printer friendly HTML output and moving 
>>> the data into quick books in order to avoid paying for the export upgrade.
>>>
>>> Ideas I've had to muck up the data to stop the scraper:
>>> 1. random white chars that wouldn't be visible to the user in Printer 
>>> Friendly, but would alter the values enough to make it a pain in quick 
>>> books. Might have issues w/ printing.
>>> 2. random # of empty  cells
>>> 3. convert text to .gif
>>>
>>> Has anybody dealt w/ this issue? What did you do?
>>>
>>> Thanks,
>>> Jason
>>>


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

Re: cfheader filename problem

[Randy Johnson]

Dave,

I am not totally sure here but I think replacing it with %20 would be 
the only way to keep it from truncating.  I think the truncating is 
happening on the browser side.

-Randy

Dave Francis wrote:
> Hi,
>
> I'm trying to download files with this:
>
>  
>
> 
>
> 
>
>  
>
> Whenever the filename contains spaces, the "What do you want to
> do with this file" prompt truncates the filename. I can obviously replace
> the spaces with underscore, %20 or something, but wondered if there was a
> way to preserve the filename as is, and get the full name in the prompt?
>
>  
>
>  
>
>
>
> 

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

Re: Stopping a Screen Scrape

[Phillip M. Vector]

I believe Cameron was questioning the morality of designing something 
like that instead of the technical issues.

Personally, I think that if I provide data to your company, I should be 
able to scrape it back if I'm already paying for your service. It's kind 
of ass-hatish to do what you are considering doing.

However, I know it's not your decision to make. Just sayin. :)

Randy Johnson wrote:
> I am not sure I agree with your statement. If I choose to make my 
> printer friendly page a graphic instead of a standard html table as long 
> as it still prints fine you would have no recourse. About the only thing 
> you could do is take your business elsewhere. Right?
> 
> -Randy
> 
> Cameron Childress wrote:
>> Does this application contain financial data for the company?  Are they 
>> attempting to get access to their own financial information in order to 
>> put it into QB and run their business?  Your employer wants to prevent 
>> them from doing this?  This raises a ton of ethical and moral 
>> questions.  I know you are not the one making the call here, but 
>> seriously, if a company I was doing business with was ACTIVELY 
>> preventing me from gaining access to my own financial data things could 
>> escalate very quickly.
>>
>> Having said that - if this company is actually doing something that 
>> violates a legal agreement you have with them somehow, simply shutting 
>> off access to the site should fix the problem.  If this is data going 
>> into QB, they much be authenticating to get to it (unless the financial 
>> data is out in the open for all to see).  Just shut them off and resolve it.
>>
>> -Cameron
>>
>> Jason Liebgott wrote:
>>   
>>> Just started working on a legacy application built in CF5. It appears that 
>>> one of the users is screen scraping printer friendly HTML output and moving 
>>> the data into quick books in order to avoid paying for the export upgrade.
>>>
>>> Ideas I've had to muck up the data to stop the scraper:
>>> 1. random white chars that wouldn't be visible to the user in Printer 
>>> Friendly, but would alter the values enough to make it a pain in quick 
>>> books. Might have issues w/ printing.
>>> 2. random # of empty  cells
>>> 3. convert text to .gif
>>>
>>> Has anybody dealt w/ this issue? What did you do?
>>>
>>> Thanks,
>>> Jason
>>> 
>>
> 
> 

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

Re: Stopping a Screen Scrape

[Randy Johnson]

I am not sure I agree with your statement. If I choose to make my 
printer friendly page a graphic instead of a standard html table as long 
as it still prints fine you would have no recourse. About the only thing 
you could do is take your business elsewhere. Right?

-Randy

Cameron Childress wrote:
> Does this application contain financial data for the company?  Are they 
> attempting to get access to their own financial information in order to 
> put it into QB and run their business?  Your employer wants to prevent 
> them from doing this?  This raises a ton of ethical and moral 
> questions.  I know you are not the one making the call here, but 
> seriously, if a company I was doing business with was ACTIVELY 
> preventing me from gaining access to my own financial data things could 
> escalate very quickly.
>
> Having said that - if this company is actually doing something that 
> violates a legal agreement you have with them somehow, simply shutting 
> off access to the site should fix the problem.  If this is data going 
> into QB, they much be authenticating to get to it (unless the financial 
> data is out in the open for all to see).  Just shut them off and resolve it.
>
> -Cameron
>
> Jason Liebgott wrote:
>   
>> Just started working on a legacy application built in CF5. It appears that 
>> one of the users is screen scraping printer friendly HTML output and moving 
>> the data into quick books in order to avoid paying for the export upgrade.
>>
>> Ideas I've had to muck up the data to stop the scraper:
>> 1. random white chars that wouldn't be visible to the user in Printer 
>> Friendly, but would alter the values enough to make it a pain in quick 
>> books. Might have issues w/ printing.
>> 2. random # of empty  cells
>> 3. convert text to .gif
>>
>> Has anybody dealt w/ this issue? What did you do?
>>
>> Thanks,
>> Jason
>> 
>
> 

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

Re: Stopping a Screen Scrape

[Randy Johnson]

we know that they are downloading it for quickbooks import to the 
easiest way to stop that would be to save it as a graphic.  You may be 
able to import the graphic into quickbooks but it is not going to import 
the information line by line.  They would have to manually enter the data.

-Randy

Robertson-Ravo, Neil (RX) wrote:
> Regardless I think there is no way you can stop anyone from taking content be 
> it via scraping automaticall or by pressing print screen.   You can no doubt 
> make it harder but I doubt you will be able to prevent it.
>
>  
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, 
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, 
> Registered in England, Number 678540.  It contains information which is 
> confidential and may also be privileged.  It is for the exclusive use of the 
> intended recipient(s).  If you are not the intended recipient(s) please note 
> that any form of distribution, copying or use of this communication or the 
> information in it is strictly prohibited and may be unlawful.  If you have 
> received this communication in error please return it to the sender or call 
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within this 
> communication are not necessarily those expressed by Reed Exhibitions." 
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Jason Liebgott
> To: CF-Talk
> Sent: Wed Jul 18 18:53:19 2007
> Subject: Re: Stopping a Screen Scrape
>
> I don't charge anybody anything. I'm a programmer. I don't make up the sales 
> rules or talk to clients.
>
> This company has offered clients a "Lite" version for a reduced price and one 
> of the features is a print friendly of a report. 
>
> I have no idea how much the upgrade costs - but it comes with export 
> functionality - ports it into flat file or whatever you want. Again, I didn't 
> make this decision... I'm just the guy trying to make it work. Good or bad 
> business? I'm like switzerland on this stuff.
>
>   
>> You charge people to export content from a web app?!?
>>
>> It would seem these users are wise enough to realise that no matter what
>> approach you take, they will get the content from the page.
>> Print Screen, CTRL-V etc etc etc.
>> 
>
>
>
> 

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

Re: Stopping a Screen Scrape

[Randy Johnson]

MS Excel will allow you to copy and paste a table into it and it will 
magically convert it, so it will take more than a hidden div with funky 
characters to stop them from scraping it.   If the data is in table 
format, unless you some how managed to randomize the columns and keep 
the formatting straight I don't see how you could stop them.

-Randy

Alan Rother wrote:
> I think as an intellectual challenge it would be fun to try to thwart
> the screen scraper, but how much does the upgrade cost?
>
> I don't really personally care or want to know what you charge for the
> upgrade, but think of it in terms of, "We charge $xx.xx for the
> upgrade, the fix is going to take me x hours to do and they might find
> a way around it once I'm done. Is it worth my time to make this
> change"
>
>
> If you still want to do it, I would recommend adding a hidden div with
> a big ole chunk of random chars in it. It won't show up to the user,
> but the scraper will choke on it.
>
> =]
>
> On 7/18/07, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
>   
>> You charge people to export content from a web app?!?
>>
>>  It would seem these users are wise enough to realise that no matter what
>> approach you take, they will get the content from the page.
>>
>> Print Screen, CTRL-V etc etc etc.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
>> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
>> Registered in England, Number 678540.  It contains information which is
>> confidential and may also be privileged.  It is for the exclusive use of the
>> intended recipient(s).  If you are not the intended recipient(s) please note
>> that any form of distribution, copying or use of this communication or the
>> information in it is strictly prohibited and may be unlawful.  If you have
>> received this communication in error please return it to the sender or call
>> our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
>> communication are not necessarily those expressed by Reed Exhibitions."
>> Visit our website at http://www.reedexpo.com
>>
>> -Original Message-
>> From: Jason Liebgott
>> To: CF-Talk
>> Sent: Wed Jul 18 17:59:23 2007
>> Subject: Stopping a Screen Scrape
>>
>> Just started working on a legacy application built in CF5. It appears that
>> one of the users is screen scraping printer friendly HTML output and moving
>> the data into quick books in order to avoid paying for the export upgrade.
>>
>> Ideas I've had to muck up the data to stop the scraper:
>> 1. random white chars that wouldn't be visible to the user in Printer
>> Friendly, but would alter the values enough to make it a pain in quick
>> books. Might have issues w/ printing.
>> 2. random # of empty  cells
>> 3. convert text to .gif
>>
>> Has anybody dealt w/ this issue? What did you do?
>>
>> Thanks,
>> Jason
>>
>>
>>
>>
>>
>> 
>
> 

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

RE: cfheader filename problem

[Ben Nadel]

Try wrapping the filename in single quotes:




..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 1:23 PM
To: CF-Talk
Subject: cfheader filename problem

Hi,

I'm trying to download files with this:

 





 

Whenever the filename contains spaces, the "What do you want
to do with this file" prompt truncates the filename. I can obviously
replace the spaces with underscore, %20 or something, but wondered if
there was a way to preserve the filename as is, and get the full name in
the prompt?

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

Re: Session Variable Types

[Jochem van Dieten]

Dave Watts wrote:
> 
> For example, in a database, you may want to determine the average value of a
> column, in a table that has a million rows. The SQL to do this is quite
> easy, but by default it will prevent write access to those rows while the
> query is running.

Only in MS SQL Server. In databases that use multiversioning (Oracle, 
PostgreSQL, MySQL/InnoDB, Firebird etc.) writers do not block readers.

Jochem

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

RE: XLS to SQL using CF

[Dawson, Michael]

Use SQL's DTS or the simple Data Import tool. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, July 18, 2007 3:43 PM
To: CF-Talk
Subject: XLS to SQL using CF

What has everyone successfully used as a method for getting xls file
data into a SQL Server 2000?
Say it's for a spreadsheet with 1200 entries, 12 columns.

Your thoughts?


Thanks

D

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:284041
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: XLS to SQL using CF

[Billy Cox]

DTS package.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 3:43 PM
To: CF-Talk
Subject: XLS to SQL using CF


What has everyone successfully used as a method for getting xls file data
into a SQL Server 2000? Say it's for a spreadsheet with 1200 entries, 12
columns.

Your thoughts?


Thanks

D



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

Re: Javascript problem with IE

[Claude Schneegans]

 >>Could that possibly be an IIS thing

Yes it is; FF makes no problem.

I've just found that the same problem was found by the FCK Editor 
developers.
I'm implementing their solution int my own editor. Not really simple :-(

Thanks.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


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

XLS to SQL using CF

[coldfusion . developer]

What has everyone successfully used as a method for getting xls file data into 
a SQL Server 2000?
Say it's for a spreadsheet with 1200 entries, 12 columns.

Your thoughts?


Thanks

D

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

Re: ANN: Learn about the Coldbox framework: starts in 2 hours

[Nick Tong]

for those that missed it:
http://www.cfframeworks.com/blog/index.cfm/2007/7/18/cfFrameworks-workshop-Luis-Majano-on-Coldbox--recording

On 18/07/07, Nick Tong <[EMAIL PROTECTED]> wrote:
>
> If you would like to learn about the Coldbox framework you can in a
> workshop starting in 2 hours. More information here: 
> http://www.cfframeworks.com/blog/index.cfm/2007/7/6/Workshop-Luis-Majano-on-Coldbox
>
>
> --
> Nick Tong
>
> web: http://talkwebsolutions.co.uk
> blog: http://succor.co.uk
> f..works: http://cfframeworks.com
> short urls:  http://wapurl.co.uk
> green link: http://wapurl.co.uk/?4Z2YDLX




-- 
Nick Tong

web: http://talkwebsolutions.co.uk
blog: http://succor.co.uk
f..works:http://cfframeworks.com
short urls:  http://wapurl.co.uk
green link: http://wapurl.co.uk/?4Z2YDLX


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

Re: Javascript problem with IE

[Christopher Jordan]

Could that possibly be an IIS thing (or Apache if that's what you're using)?
I've never had IE put something other than what I told it to when I
manipulate the DOM like that. Of course, I'm using
jQuerythese days to accomplish this sort of thing,
but even before that when I
wasn't I never saw this happen before. I have to admit to not using anchor
tags in my apps too much. I typically bind an element to the click event, so
I could be wrong about all this.

Good luck!
Chris

On 7/18/07, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I know this is a CF list, but who uses CF without Javascript? ;-)
>
> Here is the problem:
>
> I have an online HTML editor which works pretty well, except that any
> relative href addresses are
> transformed into absolute addresses, ie : href="mypage.htm" becomes
> href="http://mySite/directoryOfTheTextEditor/mypage.htm";
>
> Apparently, setting the innerHTML is the source of the problem.
>
> The code below illustrates the problem:
>
> 
> function setHTML()
> {
> var div = document.getElementById("testDiv");
> div.innerHTML = 'Test href'
> alert(div.innerHTML)
> }
> 
>  onClick="setHTML()">
> test
>
> When someone clicks on the button,  is inserted into
> the innerHTML of the div,
> however, the alert then shows http://localhost/test/test.htm";>
>
> This problem is with IE 6, with FireFox the address is unchanged; under
> IE 7, I don't know.
>
> Does someone know some way I could get IE to mind its own business?
>
> I'm able to manage my addresses myself ;-)
>
> 

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

Re: Any idea how to introduce CF in my area?

[Christopher Jordan]

That's what I'd do (or find out if there is already a CFUG chapter in your
area). Also, this is sort of the coal of RIAForge.org, GotCFM.com, and sites
like that. I guess another way to introduce it would be to (if you're a
contractor) suggest to all of your clients that they make the switch. You
could point to the laundry list of *huge* companies and government
(including military) entities who already use ColdFusion. Ben Forta's blog
is also another great place that has a list of folks who use CF.

Maybe you could have a parade too. ;o)

Good luck, and spread the word my brotha!
Chris

On 7/18/07, Cameron Childress <[EMAIL PROTECTED]> wrote:
>
> You could always start a local CFUG chapter:
> http://www.adobe.com/cfusion/usergroups/
>
> -Cameron
>
> Ali Majdzadeh wrote:
> > Hey people:
> > CF is not popular in my area and the main reason is .Net adds and PHP
> open source reputation. Do u have any idea how I can iontroduce it to
> people? I am planing to make a website (my personal blog) to introduce it
> more but I need new ideas.
> > Thanks
> > Benign
> >
> >
>
> 

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

Re: Any idea how to introduce CF in my area?

[Christopher Jordan]

Bah! stupid fingers! "coal" = "goal"... sheesh! ;o)

Chris

On 7/18/07, Christopher Jordan <[EMAIL PROTECTED]> wrote:
>
> That's what I'd do (or find out if there is already a CFUG chapter in your
> area). Also, this is sort of the coal of RIAForge.org, GotCFM.com, and
> sites like that. I guess another way to introduce it would be to (if you're
> a contractor) suggest to all of your clients that they make the switch. You
> could point to the laundry list of *huge* companies and government
> (including military) entities who already use ColdFusion. Ben Forta's blog
> is also another great place that has a list of folks who use CF.
>
> Maybe you could have a parade too. ;o)
>
> Good luck, and spread the word my brotha!
> Chris
>
> On 7/18/07, Cameron Childress < [EMAIL PROTECTED]> wrote:
> >
> > You could always start a local CFUG chapter:
> > http://www.adobe.com/cfusion/usergroups/
> >
> > -Cameron
> >
> > Ali Majdzadeh wrote:
> > > Hey people:
> > > CF is not popular in my area and the main reason is .Net adds and PHP
> > open source reputation. Do u have any idea how I can iontroduce it to
> > people? I am planing to make a website (my personal blog) to introduce it
> > more but I need new ideas.
> > > Thanks
> > > Benign
> > >
> > >
> >
> > 

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

Re: Any idea how to introduce CF in my area?

[Raymond Camden]

Specifically in regards to OS, show them RIAForge.org. It isn't as
large as the PHP OS world, but it is growing.

On 7/18/07, Ali Majdzadeh <[EMAIL PROTECTED]> wrote:
> Hey people:
> CF is not popular in my area and the main reason is .Net adds and PHP open 
> source reputation. Do u have any idea how I can iontroduce it to people? I am 
> planing to make a website (my personal blog) to introduce it more but I need 
> new ideas.
> Thanks
> Benign
>
> 

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

RE: Any idea how to introduce CF in my area?

[Dawson, Michael]

Install the 30-day trial and start building something.  You can re-build
an existing application, or build a new one.

M!ke 

-Original Message-
From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 2:37 PM
To: CF-Talk
Subject: Any idea how to introduce CF in my area?

Hey people:
CF is not popular in my area and the main reason is .Net adds and PHP
open source reputation. Do u have any idea how I can iontroduce it to
people? I am planing to make a website (my personal blog) to introduce
it more but I need new ideas.
Thanks
Benign

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

Re: Stopping a Screen Scrape

[Cameron Childress]

Does this application contain financial data for the company?  Are they 
attempting to get access to their own financial information in order to 
put it into QB and run their business?  Your employer wants to prevent 
them from doing this?  This raises a ton of ethical and moral 
questions.  I know you are not the one making the call here, but 
seriously, if a company I was doing business with was ACTIVELY 
preventing me from gaining access to my own financial data things could 
escalate very quickly.

Having said that - if this company is actually doing something that 
violates a legal agreement you have with them somehow, simply shutting 
off access to the site should fix the problem.  If this is data going 
into QB, they much be authenticating to get to it (unless the financial 
data is out in the open for all to see).  Just shut them off and resolve it.

-Cameron

Jason Liebgott wrote:
> Just started working on a legacy application built in CF5. It appears that 
> one of the users is screen scraping printer friendly HTML output and moving 
> the data into quick books in order to avoid paying for the export upgrade.
>
> Ideas I've had to muck up the data to stop the scraper:
> 1. random white chars that wouldn't be visible to the user in Printer 
> Friendly, but would alter the values enough to make it a pain in quick books. 
> Might have issues w/ printing.
> 2. random # of empty  cells
> 3. convert text to .gif
>
> Has anybody dealt w/ this issue? What did you do?
>
> Thanks,
> Jason

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:284031
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Javascript problem with IE

[Claude Schneegans]

Hi,

I know this is a CF list, but who uses CF without Javascript? ;-)

Here is the problem:

I have an online HTML editor which works pretty well, except that any 
relative href addresses are
transformed into absolute addresses, ie : href="mypage.htm" becomes 
href="http://mySite/directoryOfTheTextEditor/mypage.htm";

Apparently, setting the innerHTML is the source of the problem.

The code below illustrates the problem:


function setHTML()
 {
 var div = document.getElementById("testDiv");
 div.innerHTML = 'Test href'
 alert(div.innerHTML)
 }


test

When someone clicks on the button,  is inserted into 
the innerHTML of the div,
however, the alert then shows http://localhost/test/test.htm";>

This problem is with IE 6, with FireFox the address is unchanged; under 
IE 7, I don't know.

Does someone know some way I could get IE to mind its own business?

I'm able to manage my addresses myself ;-)

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

Re: Any idea how to introduce CF in my area?

[Cameron Childress]

You could always start a local CFUG chapter:
http://www.adobe.com/cfusion/usergroups/

-Cameron

Ali Majdzadeh wrote:
> Hey people:
> CF is not popular in my area and the main reason is .Net adds and PHP open 
> source reputation. Do u have any idea how I can iontroduce it to people? I am 
> planing to make a website (my personal blog) to introduce it more but I need 
> new ideas.
> Thanks
> Benign
>
> 

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

Any idea how to introduce CF in my area?

[Ali Majdzadeh]

Hey people:
CF is not popular in my area and the main reason is .Net adds and PHP open 
source reputation. Do u have any idea how I can iontroduce it to people? I am 
planing to make a website (my personal blog) to introduce it more but I need 
new ideas.
Thanks
Benign

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

Re: apache -> iis gotchas?

[J.J. Merrick]

wow it's amazing what companies will fall for... most consumers don't know
any difference and the encryption is still the same.

Oh and the fact some $4 hour Indian tech support guy can pull up the full CC
number doesn't seem to really matter :-)


J.J.


On 7/18/07, John Paul Ashenfelter <[EMAIL PROTECTED]> wrote:
>
> On 7/18/07, Russ <[EMAIL PROTECTED]> wrote:
> > > -Original Message-
> > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, July 17, 2007 11:15 PM
> > > To: CF-Talk
> > > Subject: Re: apache -> iis gotchas?
> > >
> > > > > * get an IIS SSL cert instead of our Apache one (at least
> > > > > that's what Verisign tells us)
> > > >
> > > > If Verisign is willing to reissue the cert without charging you,
> yes. If
> > > > not, I suspect you can convert certificate formats easily enough
> with
> > > > OpenSSL.
> > >
> > > FWIW, they'll do it for $100 (unless it's in the first 30 days). Or so
> > > they tell me today :)
> > >
> >
> > Isn't the godaddy cert only $20?
>
> Something like that -- but lots of businesses (or at least this one)
> wants Verisign. Period. At least they're not pushing for the "extended
> validation" one that's $1495 and gives you a green bar in Vista or
> whatever marketing nonsense.
>
> >
> > 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:284027
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stopping a Screen Scrape

[David McCan]

I am not sure how they are doing the screen scraping, but perhaps something 
like a clear gif stretched over the page would be an impediment (to cut and 
paste).

Good luck.

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

Re: Stopping a Screen Scrape

[Michael michaeldavid]

I have had to deal with the scraping of reports problem before.  I solved it by 
presenting report content with a flash object.

Cheers!

Michael David

> Printing is the point of the report... hitting print screen would be 
> fine. I am just looking for a way to obfuscate the printer friendly 
> from scrape technology that would convert the output HTML to say a CSV 
> or pipe delimited. 
> 
> I agree that "stopping" somebody intent on this is improbable. they 
> could scan the print out w/ a fax reader if they so desired. I'm just 
> trying to add enough of a pain in the butt that it'll make the easily 
> dettered quit.
> 
> 
> > Regardless I think there is no way you can stop anyone from taking 
> > content be it via scraping automaticall or by pressing print screen.   
> 
> > You can no doubt make it harder but I doubt you will be able to 
> > prevent it.

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

Re: apache -> iis gotchas?

[John Paul Ashenfelter]

On 7/18/07, Russ <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, July 18, 2007 1:54 PM
> > To: CF-Talk
> > Subject: Re: apache -> iis gotchas?
> >
> > On 7/18/07, Russ <[EMAIL PROTECTED]> wrote:
> > > > -Original Message-
> > > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> > > > Sent: Tuesday, July 17, 2007 11:15 PM
> > > > To: CF-Talk
> > > > Subject: Re: apache -> iis gotchas?
> > > >
> > > > > > * get an IIS SSL cert instead of our Apache one (at least
> > > > > > that's what Verisign tells us)
> > > > >
> > > > > If Verisign is willing to reissue the cert without charging you,
> > yes. If
> > > > > not, I suspect you can convert certificate formats easily enough
> > with
> > > > > OpenSSL.
> > > >
> > > > FWIW, they'll do it for $100 (unless it's in the first 30 days). Or so
> > > > they tell me today :)
> > > >
> > >
> > > Isn't the godaddy cert only $20?
> >
> > Something like that -- but lots of businesses (or at least this one)
> > wants Verisign. Period. At least they're not pushing for the "extended
> > validation" one that's $1495 and gives you a green bar in Vista or
> > whatever marketing nonsense.
> >
>
> Godaddy has those for $500...


Right, but it's still not Verisign -- sometimes there's no choice. I
just generate the CSR :)
>
> Russ
>
>
>
>
> 

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

Re: Stopping a Screen Scrape

[Jason Liebgott]

Printing is the point of the report... hitting print screen would be fine. I am 
just looking for a way to obfuscate the printer friendly from scrape technology 
that would convert the output HTML to say a CSV or pipe delimited. 

I agree that "stopping" somebody intent on this is improbable. they could scan 
the print out w/ a fax reader if they so desired. I'm just trying to add enough 
of a pain in the butt that it'll make the easily dettered quit.


> Regardless I think there is no way you can stop anyone from taking 
> content be it via scraping automaticall or by pressing print screen.   
> You can no doubt make it harder but I doubt you will be able to 
> prevent it.


~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:284022
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stopping a Screen Scrape

[J.J. Merrick]

I was going to suggest sending the report to a PDF and turning off copy and
pasting... but then I read it was CF5 so yeah you are just going to have to
make it HARDER to do but I don't think you can prevent it totally.


J.J.

On 7/18/07, Jason Liebgott <[EMAIL PROTECTED]> wrote:
>
> Just started working on a legacy application built in CF5. It appears that
> one of the users is screen scraping printer friendly HTML output and moving
> the data into quick books in order to avoid paying for the export upgrade.
>
> Ideas I've had to muck up the data to stop the scraper:
> 1. random white chars that wouldn't be visible to the user in Printer
> Friendly, but would alter the values enough to make it a pain in quick
> books. Might have issues w/ printing.
> 2. random # of empty  cells
> 3. convert text to .gif
>
> Has anybody dealt w/ this issue? What did you do?
>
> Thanks,
> Jason
>
>
> 

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

Re: Stopping a Screen Scrape

[Jerry Johnson]

As we all know, the bane of scraping is inconsistency, and changing specs.

So, make sure your page is inconsistent and changes constantly.

Add extra divs, change the id and names of the divs, change the style
and other attributes on each page load, Change the number and
attributes or div, span, tr, td, table calls.

You dont need to make it crack proof, just need to make it harder than
the upgrade costs.

It is not a print screen you are worried about, it is converting the
html print data to a db cheaply and easily.

If they want to rekey the data, fine. If they can way more cost
effectively "steal" it, they often will.

On 7/18/07, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Regardless I think there is no way you can stop anyone from taking content be 
> it via scraping automaticall or by pressing print screen.   You can no doubt 
> make it harder but I doubt you will be able to prevent it.

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

RE: apache -> iis gotchas?

[Russ]

> -Original Message-
> From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 18, 2007 1:54 PM
> To: CF-Talk
> Subject: Re: apache -> iis gotchas?
> 
> On 7/18/07, Russ <[EMAIL PROTECTED]> wrote:
> > > -Original Message-
> > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, July 17, 2007 11:15 PM
> > > To: CF-Talk
> > > Subject: Re: apache -> iis gotchas?
> > >
> > > > > * get an IIS SSL cert instead of our Apache one (at least
> > > > > that's what Verisign tells us)
> > > >
> > > > If Verisign is willing to reissue the cert without charging you,
> yes. If
> > > > not, I suspect you can convert certificate formats easily enough
> with
> > > > OpenSSL.
> > >
> > > FWIW, they'll do it for $100 (unless it's in the first 30 days). Or so
> > > they tell me today :)
> > >
> >
> > Isn't the godaddy cert only $20?
> 
> Something like that -- but lots of businesses (or at least this one)
> wants Verisign. Period. At least they're not pushing for the "extended
> validation" one that's $1495 and gives you a green bar in Vista or
> whatever marketing nonsense.
> 

Godaddy has those for $500...  

Russ




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

CFR compatibility between CF7 and CF8?

[John Paul Ashenfelter]

Folks,

I'm sure I'm just not looking in the right place in the beta docs for
CF8, but I'm curious if I can build reports in CF8 Report Builder (on
Windows, of course) and then run the resulting report successfully on
CF7.

Any advice?

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

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

Re: Stopping a Screen Scrape

[Robertson-Ravo, Neil (RX)]

Regardless I think there is no way you can stop anyone from taking content be 
it via scraping automaticall or by pressing print screen.   You can no doubt 
make it harder but I doubt you will be able to prevent it.

 




"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, 
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, 
Registered in England, Number 678540.  It contains information which is 
confidential and may also be privileged.  It is for the exclusive use of the 
intended recipient(s).  If you are not the intended recipient(s) please note 
that any form of distribution, copying or use of this communication or the 
information in it is strictly prohibited and may be unlawful.  If you have 
received this communication in error please return it to the sender or call our 
switchboard on +44 (0) 20 89107910.  The opinions expressed within this 
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Jason Liebgott
To: CF-Talk
Sent: Wed Jul 18 18:53:19 2007
Subject: Re: Stopping a Screen Scrape

I don't charge anybody anything. I'm a programmer. I don't make up the sales 
rules or talk to clients.

This company has offered clients a "Lite" version for a reduced price and one 
of the features is a print friendly of a report. 

I have no idea how much the upgrade costs - but it comes with export 
functionality - ports it into flat file or whatever you want. Again, I didn't 
make this decision... I'm just the guy trying to make it work. Good or bad 
business? I'm like switzerland on this stuff.

>You charge people to export content from a web app?!?
>
> It would seem these users are wise enough to realise that no matter what
>approach you take, they will get the content from the page.
>Print Screen, CTRL-V etc etc etc.



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

Re: Stopping a Screen Scrape

[Jason Liebgott]

>I think as an intellectual challenge it would be fun to try to thwart
>the screen scraper, but how much does the upgrade cost?
>
>I don't really personally care or want to know what you charge for the
>upgrade, but think of it in terms of, "We charge $xx.xx for the
>upgrade, the fix is going to take me x hours to do and they might find
>a way around it once I'm done. Is it worth my time to make this
>change"

Exactly. I have been thinking in these terms as well.

>If you still want to do it, I would recommend adding a hidden div with
>a big ole chunk of random chars in it. It won't show up to the user,
>but the scraper will choke on it.

That could work nicely. Thanks.

~|
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:284017
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: managing multiple dev environments

[John Paul Ashenfelter]

On 7/18/07, Kris Jones <[EMAIL PROTECTED]> wrote:
> The data is quite volatile. The schema typically has some changes
> during each release cycle. We currently point at shared DBs, which I'm
> thinking is the direction we'll stick with. But we are talking about
> all of the suggestions mentioned here. I can see the benefit in having
> local DB as well--in fact this is how I've developed in the past, and
> understand how easily this scenario can break the app for other
> developers (who may not be in a position to update their local
> code-base for whatever reason).

What it seems to sound like is that the database differences need to
be managed somewhat like the code -- with the capability to
branch/merge/etc. There are ways to set that up, ranging from db
scripts to storing the appropriate version of the actual database (in
this case, a .BAK file perhaps) in the source control system. For
example, using SVN, you can define an external link from a particular
codebase to a particular branch or even revision of the database
repository/tree/branch and lock the two (code and data) together. Add
a generic osql load script to load the db into your local MSSQL and
you're set (though a naming convention probably helps keep running the
multiple versions in check)

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

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

Re: Stopping a Screen Scrape

[Jason Liebgott]

I don't charge anybody anything. I'm a programmer. I don't make up the sales 
rules or talk to clients.

This company has offered clients a "Lite" version for a reduced price and one 
of the features is a print friendly of a report. 

I have no idea how much the upgrade costs - but it comes with export 
functionality - ports it into flat file or whatever you want. Again, I didn't 
make this decision... I'm just the guy trying to make it work. Good or bad 
business? I'm like switzerland on this stuff.

>You charge people to export content from a web app?!?
>
> It would seem these users are wise enough to realise that no matter what
>approach you take, they will get the content from the page.
>Print Screen, CTRL-V etc etc etc.

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

Re: SOT: managing multiple dev environments

[John Paul Ashenfelter]

On 7/18/07, Tom Chiverton <[EMAIL PROTECTED]> wrote:
> On Tuesday 17 Jul 2007, [EMAIL PROTECTED] wrote:
> > also pony up the $50/per head for MSSQL Developer edition
>
> Or just more to a freeier database like MySQL or PostgreSQL.

Of course MySQL (which I'm a huge fan of) now effectively charges for
the Windows version (or at least they're not compiling it) so you need
their Enterprise subscription, which is really cool, or the patience
to compile it under Windows.

And it's all a moot point if you've got multiple clients with MSSQL
databases -- you'll need a way to manage MSSQL on the developer's side
and that's MSSQL Dev Edition.

-- 
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]

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

Re: apache -> iis gotchas?

[John Paul Ashenfelter]

On 7/18/07, Russ <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, July 17, 2007 11:15 PM
> > To: CF-Talk
> > Subject: Re: apache -> iis gotchas?
> >
> > > > * get an IIS SSL cert instead of our Apache one (at least
> > > > that's what Verisign tells us)
> > >
> > > If Verisign is willing to reissue the cert without charging you, yes. If
> > > not, I suspect you can convert certificate formats easily enough with
> > > OpenSSL.
> >
> > FWIW, they'll do it for $100 (unless it's in the first 30 days). Or so
> > they tell me today :)
> >
>
> Isn't the godaddy cert only $20?

Something like that -- but lots of businesses (or at least this one)
wants Verisign. Period. At least they're not pushing for the "extended
validation" one that's $1495 and gives you a green bar in Vista or
whatever marketing nonsense.

>
> Russ
>
>
>
>
> 

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

Re: Stopping a Screen Scrape

[Alan Rother]

I think as an intellectual challenge it would be fun to try to thwart
the screen scraper, but how much does the upgrade cost?

I don't really personally care or want to know what you charge for the
upgrade, but think of it in terms of, "We charge $xx.xx for the
upgrade, the fix is going to take me x hours to do and they might find
a way around it once I'm done. Is it worth my time to make this
change"


If you still want to do it, I would recommend adding a hidden div with
a big ole chunk of random chars in it. It won't show up to the user,
but the scraper will choke on it.

=]

On 7/18/07, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> You charge people to export content from a web app?!?
>
>  It would seem these users are wise enough to realise that no matter what
> approach you take, they will get the content from the page.
>
> Print Screen, CTRL-V etc etc etc.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540.  It contains information which is
> confidential and may also be privileged.  It is for the exclusive use of the
> intended recipient(s).  If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful.  If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Jason Liebgott
> To: CF-Talk
> Sent: Wed Jul 18 17:59:23 2007
> Subject: Stopping a Screen Scrape
>
> Just started working on a legacy application built in CF5. It appears that
> one of the users is screen scraping printer friendly HTML output and moving
> the data into quick books in order to avoid paying for the export upgrade.
>
> Ideas I've had to muck up the data to stop the scraper:
> 1. random white chars that wouldn't be visible to the user in Printer
> Friendly, but would alter the values enough to make it a pain in quick
> books. Might have issues w/ printing.
> 2. random # of empty  cells
> 3. convert text to .gif
>
> Has anybody dealt w/ this issue? What did you do?
>
> Thanks,
> Jason
>
>
>
>
> 

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

Re: HostMySite: Linux Builder + CF No Longer Offered

[Greg Fuller]

Rick:  Yep. Bummer.

Jordon: Thanks for the info. Do you think 512mb is enough for CF and Verity?

James:  Thanks, it's under consideration.  I think I would need my own
copy of CF with  Vivio VPS, but in the long run that may be a better
option.

On 7/17/07, James Holmes <[EMAIL PROTECTED]> wrote:
> I'd recommend a Viviotech VPS if cost is a concern. It's a hell of a
> lot cheaper than $116 per month. Or conversely, you could build a
> massive VPS (or two) for that money.
>
> On 7/18/07, Greg Fuller <[EMAIL PROTECTED]> wrote:
> > Linux CF hosting is scarce.  I've been looking, and haven't had much
> > success.  I'm considering a HostMySite VPS or just going to
> > ServerBeach with my own copy of CF.
> >
> > The HostMySite decision would be upon verification that they will
> > offer CF8 at about the same rates.
> >
> > HostMySite Linux VPS + CF starts at $116 a month, and that's with only
> > 512mb memory.  Does anyone have any idea of what performance might be
> > expected with a 512mb VPS account?
>
> --
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
> 

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

cfheader filename problem

[Dave Francis]

Hi,

I'm trying to download files with this:

 





 

Whenever the filename contains spaces, the "What do you want to
do with this file" prompt truncates the filename. I can obviously replace
the spaces with underscore, %20 or something, but wondered if there was a
way to preserve the filename as is, and get the full name in the prompt?

 

 



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

Re: Stopping a Screen Scrape

[Robertson-Ravo, Neil (RX)]

You charge people to export content from a web app?!?

 It would seem these users are wise enough to realise that no matter what
approach you take, they will get the content from the page.

Print Screen, CTRL-V etc etc etc.















"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Jason Liebgott
To: CF-Talk
Sent: Wed Jul 18 17:59:23 2007
Subject: Stopping a Screen Scrape

Just started working on a legacy application built in CF5. It appears that
one of the users is screen scraping printer friendly HTML output and moving
the data into quick books in order to avoid paying for the export upgrade.

Ideas I've had to muck up the data to stop the scraper:
1. random white chars that wouldn't be visible to the user in Printer
Friendly, but would alter the values enough to make it a pain in quick
books. Might have issues w/ printing.
2. random # of empty  cells
3. convert text to .gif

Has anybody dealt w/ this issue? What did you do?

Thanks,
Jason




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

Stopping a Screen Scrape

[Jason Liebgott]

Just started working on a legacy application built in CF5. It appears that one 
of the users is screen scraping printer friendly HTML output and moving the 
data into quick books in order to avoid paying for the export upgrade.

Ideas I've had to muck up the data to stop the scraper:
1. random white chars that wouldn't be visible to the user in Printer Friendly, 
but would alter the values enough to make it a pain in quick books. Might have 
issues w/ printing.
2. random # of empty  cells
3. convert text to .gif

Has anybody dealt w/ this issue? What did you do?

Thanks,
Jason


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

ANN: Learn about the Coldbox framework: starts in 2 hours

[Nick Tong]

If you would like to learn about the Coldbox framework you can in a workshop
starting in 2 hours. More information here:
http://www.cfframeworks.com/blog/index.cfm/2007/7/6/Workshop-Luis-Majano-on-Coldbox

-- 
Nick Tong

web: http://talkwebsolutions.co.uk
blog: http://succor.co.uk
f..works:http://cfframeworks.com
short urls:  http://wapurl.co.uk
green link: http://wapurl.co.uk/?4Z2YDLX


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

RE: preserving session for web services

[Chad Gray]

Ya...  I was experimenting with an AIR app a while back and it connected to a 
Coldfusion CFC.  The session was created when the AIR app hit the CFC and the 
session expired at the predetermined time.

You might have to build a cfc for the distributors web service calls to create 
your session objects, but once created then the future webservice calls will be 
able to access the session objects.  Like Brad said... IF it can accept a 
cookie.

Setup a test application.cfm and cfc with session stuff in it and with 
access=remote on the functions and have them hit the CFC WSDL and see what 
happens.
http://demo.dev/login.cfc?WSDL




-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 12:04 PM
To: CF-Talk
Subject: RE: preserving session for web services

As long as your distributors program can accept cookies, then you can
use session management just like you would with a browser.

~Brad

-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 10:23 AM
To: CF-Talk
Subject: preserving session for web services

Greetings,

I have a question for the list. A distributor wants to connect to our
ecommerce system, which is an OO setup using cfc's. Their site however
is an asp.net site.  What we are looking at is using web services to
send the results back to the browser on the distributor's site. However
our ecommerce system uses session variables to hold various objects,
like a user object, a shopping cart object etc. This obviously may be a
problem. So how do we maintain session between the different web service
calls to our site? 

Any help or suggestions on this is most appreciated.

thx,

larry





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

Cfchart Pie

[Troy Montour]

Hello everyone,
 is there an issue doing custom xml files for Pie Charts for cfchart?.

normally I just create a custom xml file and put it in the 
/charting/styles/ directory.

then I call it like this
style="Bar_3D_SLANTED_2Axis" = Bar_3D_SLANTED_2Axis.xml in directory above
and when I create a bar chart this works fine.

but as soon as I create a custom Pie chart it gives me the error 
Could not locate the style file Pie_3D.in Pie_3D.xml








if I map to it with a relative path it works fine but calling it as I normally 
do with a bar chart it doesn't work.

any help would be great cause I don't want to use relative paths since its 
called at different locations thru out our application.

Thank You
Troy 



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

Re: Encrypting database information

[Eric Haskins]

md5 (one way encrypt) Hash pretty much standard way for passwords. I know
alot of people that dont even encrypt passwords any more. The thought is if
they have hacked your database what do they need the password for :)

As for credit cards,customer details and such Usually requires something
around the lines of an (nChiper Key storage box which you would need a
backup in case one breaks) to be PCI compliant.

I have a cheap way I use for my Web Hosting Billing Software.  I have a
Ioncube encoded/encrypted php file that Accepts a value and returns an
encrypted value.  The key for the hash is stored in the file. If my site is
compromised they would have to break ioncube's encryption before they can
decode any database values.   Its just one more step. Ioncube has been
broken before but it takes alot of time and money :)

Eric


On 7/18/07, Tom Chiverton <[EMAIL PROTECTED]> wrote:
>
> On Wednesday 18 Jul 2007, [EMAIL PROTECTED] wrote:
> > Can anyone recommend a good encryption method for sensitive
> > information(login details, etc...) stored in database tables?
>
> Does simply hashing the value before insert solve your problem ?
>
> --
> Tom Chiverton
>
> 
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at St James's Court Brown Street Manchester M2 2JF.  A list of members is
> available for inspection at the registered office. Any reference to a
> partner in relation to Halliwells LLP means a member of Halliwells LLP.
> Regulated by the Law Society.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee you
> must not read it and must not use any information contained in nor copy it
> nor inform any person other than Halliwells LLP or the addressee of its
> existence or contents.  If you have received this email in error please
> delete it and notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
> 

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

RE: preserving session for web services

[Brad Wood]

As long as your distributors program can accept cookies, then you can
use session management just like you would with a browser.

~Brad

-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 10:23 AM
To: CF-Talk
Subject: preserving session for web services

Greetings,

I have a question for the list. A distributor wants to connect to our
ecommerce system, which is an OO setup using cfc's. Their site however
is an asp.net site.  What we are looking at is using web services to
send the results back to the browser on the distributor's site. However
our ecommerce system uses session variables to hold various objects,
like a user object, a shopping cart object etc. This obviously may be a
problem. So how do we maintain session between the different web service
calls to our site? 

Any help or suggestions on this is most appreciated.

thx,

larry



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

RE: apache -> iis gotchas?

[Russ]

> -Original Message-
> From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 17, 2007 11:15 PM
> To: CF-Talk
> Subject: Re: apache -> iis gotchas?
> 
> > > * get an IIS SSL cert instead of our Apache one (at least
> > > that's what Verisign tells us)
> >
> > If Verisign is willing to reissue the cert without charging you, yes. If
> > not, I suspect you can convert certificate formats easily enough with
> > OpenSSL.
> 
> FWIW, they'll do it for $100 (unless it's in the first 30 days). Or so
> they tell me today :)
> 

Isn't the godaddy cert only $20?

Russ




~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:284002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

preserving session for web services

[Larry Lyons]

Greetings,

I have a question for the list. A distributor wants to connect to our ecommerce 
system, which is an OO setup using cfc's. Their site however is an asp.net 
site.  What we are looking at is using web services to send the results back to 
the browser on the distributor's site. However our ecommerce system uses 
session variables to hold various objects, like a user object, a shopping cart 
object etc. This obviously may be a problem. So how do we maintain session 
between the different web service calls to our site? 

Any help or suggestions on this is most appreciated.

thx,

larry

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

RE: cfc question

[Chad Gray]

Thank Matt, Jim and Dan.

I see where you guys are going with this.

As far as security im not sure how using the array is any better.

I suppose once things are broken out using the array I could then validate the 
data coming in with .

This would keep people from tacking on sub-queries and injecting their own SQL 
statements.

Thanks for the help!
Chad



-Original Message-
From: Matt Quackenbush [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 11:25 AM
To: CF-Talk
Subject: Re: cfc question

Chad,

 is indeed escaping your single quotes.  You can get around this in
a couple of ways.  The first is to use preserveSingleQuotes() in your
function, like so:

WHERE #preserveSingleQuotes(arguments.criteria)#

While that is a very easy "solution", you will be opening yourself up to all
sorts of security risks.  Therefore, I would strongly urge that you do *not*
use this "solution".

Another solution would be to add an argument that would accept an array, or
an array of structs that would hold your criteria.  Here is a quick example
of what I mean.



   myArray = arrayNew(1);
   myArray[1] = structNew();
   myArray[1].field = "FileName";
   myArray[1].value = "PLATES.zjf";
   myArray[1].quote = true;
   myArray[2].field = "FileModificationDate";
   myArray[2].value = "09/30/2005 12:34:01 PM";
   myArray[2].quote = true;






   WHERE 0 = 0
   
  AND #arguments.criteria[i].field# =
 
'#arguments.criteria[i].value#'
 
#arguments.criteria[i].value#
 
   


Hope that helps.


Matt


I have a CRUD CFC that has this function and I load the CFC into the
> application scope:
>
> 
> 
>
> 
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE #arguments.criteria#
> 
>
> 
> 
>
> I want to be able to pass in the "WHERE" statement into it.  So it could
> be:
> FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01
> PM'
>
> So I run something like this to call the function:
>
>  '#getZJF_files.name#' AND FileModificationDate =
> '#getZJF_files.dateLastModified#'")>
>
> What I get back is an error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '
> PLATES.zjf'.
>
> Then I look at the SQL that was run in debugging.
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005
> 12:34:01 PM''
>
> Why did it take my single quotes and add another single quote?  Is it
> trying to escape the single quote?  How do I keep it from doing this?
>




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

Re: OT - Screen Capture Video

[Andrew Peterson]

> 
> http://www.jingproject.com/

Wow. Jing has got to be the easiest thing I've ever done. :-) Thanks for the 
link.


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

Re: cfc question

[Matt Quackenbush]

Chad,

 is indeed escaping your single quotes.  You can get around this in
a couple of ways.  The first is to use preserveSingleQuotes() in your
function, like so:

WHERE #preserveSingleQuotes(arguments.criteria)#

While that is a very easy "solution", you will be opening yourself up to all
sorts of security risks.  Therefore, I would strongly urge that you do *not*
use this "solution".

Another solution would be to add an argument that would accept an array, or
an array of structs that would hold your criteria.  Here is a quick example
of what I mean.



   myArray = arrayNew(1);
   myArray[1] = structNew();
   myArray[1].field = "FileName";
   myArray[1].value = "PLATES.zjf";
   myArray[1].quote = true;
   myArray[2].field = "FileModificationDate";
   myArray[2].value = "09/30/2005 12:34:01 PM";
   myArray[2].quote = true;






   WHERE 0 = 0
   
  AND #arguments.criteria[i].field# =
 
'#arguments.criteria[i].value#'
 
#arguments.criteria[i].value#
 
   


Hope that helps.


Matt


I have a CRUD CFC that has this function and I load the CFC into the
> application scope:
>
> 
> 
>
> 
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE #arguments.criteria#
> 
>
> 
> 
>
> I want to be able to pass in the "WHERE" statement into it.  So it could
> be:
> FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01
> PM'
>
> So I run something like this to call the function:
>
>  '#getZJF_files.name#' AND FileModificationDate =
> '#getZJF_files.dateLastModified#'")>
>
> What I get back is an error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '
> PLATES.zjf'.
>
> Then I look at the SQL that was run in debugging.
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005
> 12:34:01 PM''
>
> Why did it take my single quotes and add another single quote?  Is it
> trying to escape the single quote?  How do I keep it from doing this?
>


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

Re: Encrypting database information

[Tom Chiverton]

On Wednesday 18 Jul 2007, [EMAIL PROTECTED] wrote:
> Can anyone recommend a good encryption method for sensitive
> information(login details, etc...) stored in database tables?

Does simply hashing the value before insert solve your problem ?

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


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

RE: cfc question

[Jim Rising]

Have you tried: PreserveSingleQuotes() ?

Jim Rising
Sr. Cold Fusion Developer
ICGLink Inc.
www.icglink.com
 

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 10:04 AM
To: CF-Talk
Subject: cfc question

I have a CRUD CFC that has this function and I load the CFC into the
application scope:





SELECT *
FROM FlexoDirectConfigFiles
WHERE #arguments.criteria#


  


I want to be able to pass in the "WHERE" statement into it.  So it could be:
FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01 PM'

So I run something like this to call the function:



What I get back is an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near
'PLATES.zjf'.

Then I look at the SQL that was run in debugging.
SELECT *
FROM FlexoDirectConfigFiles
WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005
12:34:01 PM''

Why did it take my single quotes and add another single quote?  Is it trying
to escape the single quote?  How do I keep it from doing this?




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

Re: cfc question

[Charlie Griefer]

#preserveSingleQuotes(arguments.criteria)#

On 7/18/07, Chad Gray <[EMAIL PROTECTED]> wrote:
> I have a CRUD CFC that has this function and I load the CFC into the 
> application scope:
>
> 
> 
>
> 
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE #arguments.criteria#
> 
>
> 
> 
>
> I want to be able to pass in the "WHERE" statement into it.  So it could be:
> FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01 PM'
>
> So I run something like this to call the function:
>
>  '#getZJF_files.name#' AND FileModificationDate = 
> '#getZJF_files.dateLastModified#'")>
>
> What I get back is an error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 
> 'PLATES.zjf'.
>
> Then I look at the SQL that was run in debugging.
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005 
> 12:34:01 PM''
>
> Why did it take my single quotes and add another single quote?  Is it trying 
> to escape the single quote?  How do I keep it from doing this?
>
>
> 

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283995
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfc question

[Kris Jones]

Try preservesinglequotes()?

> What I get back is an error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 
> 'PLATES.zjf'.
>
> Then I look at the SQL that was run in debugging.
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005 
> 12:34:01 PM''
>
> Why did it take my single quotes and add another single quote?  Is it trying 
> to escape the single quote?  How do I keep it from doing this?

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

Re: cfc question

[Tom Chiverton]

On Wednesday 18 Jul 2007, [EMAIL PROTECTED] wrote:
> I have a CRUD CFC that has this function and I load the CFC into the
> application scope:
>
> 
>   



>   
>   SELECT *
>   FROM FlexoDirectConfigFiles
>   WHERE #arguments.criteria#
>   


SELECT *
FROM FlexoDirectConfigFiles
WHERE #presserveSingleQuotes(arguments.criteria)#
/cfquery>

>   
> 

> I want to be able to pass in the "WHERE" statement into it.  So it could
> be: FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01
> PM'

Beaware that if this CFC is to be called remotely, you want to tidy it up by 
having explicit name and modification date parameters, to prevent people 
manipulating the SQL.
Even if not, you should do that anyway, so you can make use of cfqueryparam.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


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

Re: cfc question

[Dan Vega]

Chad,
Here is what I do in that situation. First my select statement by default
will return all rows

SELECT *
FROM FlexoDirectConfigFiles
WHERE 1=1

1 will always be eqal to 1 so this is an easy way of getting all records and
allowing for optional and clauses then you can do this; Pass in optional
arguments to your function. You want to make these arguments not required
that way can pass as many or as few filters to your function as possible.
The code below may not be right I just threw it together quickly, but
hopefully you get the idea.






SELECT *
FROM FlexoDirectConfigFiles
WHERE 1=1

AND column = 


AND column = 





On 7/18/07, Chad Gray <[EMAIL PROTECTED]> wrote:
>
> I have a CRUD CFC that has this function and I load the CFC into the
> application scope:
>
> 
> 
>
> 
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE #arguments.criteria#
> 
>
> 
> 
>
> I want to be able to pass in the "WHERE" statement into it.  So it could
> be:
> FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01
> PM'
>
> So I run something like this to call the function:
>
>  '#getZJF_files.name#' AND FileModificationDate =
> '#getZJF_files.dateLastModified#'")>
>
> What I get back is an error:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '
> PLATES.zjf'.
>
> Then I look at the SQL that was run in debugging.
> SELECT *
> FROM FlexoDirectConfigFiles
> WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005
> 12:34:01 PM''
>
> Why did it take my single quotes and add another single quote?  Is it
> trying to escape the single quote?  How do I keep it from doing this?
>
>
> 

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: OT - Screen Capture Video

[Billy Cox]

I'm taking Wink for a test drive. Looks very interesting.

Thanks a bunch!


-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 9:25 AM
To: CF-Talk
Subject: Re: OT - Screen Capture Video


Wink is a freeware option

http://www.debugmode.com/wink/

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer _
http://blog.cutterscrossing.com

Andrew Peterson wrote:
> Hi,
> 
> I'm looking for a Windows solution that will capture my screen and 
> audio and present it in Flash for embedding in a web page. A friend 
> uses Snapz Pro at Ambrosia Software, a cheap and effective solution, 
> but only for the Mac. The videos are saved as Quicktime files and then 
> he uploads them to YouTube for the .swf. Very cool. Any ideas for a 
> similar Windows solution? What Adobe products will do this for me?  
> Thanks in advance.
> 
> Sincerely,
> Andy
> 
> 



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

RE: OT - Screen Capture Video

[Eric J. Hoffman]

Captivate 2 is fantastic.






Eric J. Hoffman
Managing Partner
1940 Greeley Street South
Suite 102
StillwaterMN55082
mail: [EMAIL PROTECTED]
www: http://www.ejhassociates.com
tel: 651.717.4105
fax: 651.717.4101
mob: 651.245.2717
Adobe Solutions Partner
Microsoft Certified Partner



This message contains confidential information and is intended only for [EMAIL 
PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, 
distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by 
e-mail if you have received this e-mail by mistake and delete this e-mail from 
your system. E-mail transmission cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does 
not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.


-Original Message-

From: Andrew Peterson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 8:30 AM
To: CF-Talk
Subject: OT - Screen Capture Video

Hi,

I'm looking for a Windows solution that will capture my screen and audio and 
present it in Flash for embedding in a web page. A friend uses Snapz Pro at 
Ambrosia Software, a cheap and effective solution, but only for the Mac. The 
videos are saved as Quicktime files and then he uploads them to YouTube for the 
.swf. Very cool. Any ideas for a similar Windows solution? What Adobe products 
will do this for me?  Thanks in advance.

Sincerely,
Andy



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

RE: Insert cfgrid record with default value in 1 column?

[Peterson, Chris]

After tinkering for a while, I got it to do what I needed with this
attached to the data grid:

onChange="rangeGrid.dataProvider.editField(rangeGrid.selectedIndex,
'customerCode', '#getCustomer.customerCode#');" 

Happy coding all,



Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer
-Original Message-
From: Peterson, Chris 
Sent: Wednesday, July 18, 2007 9:31 AM
To: CF-Talk
Subject: Insert cfgrid record with default value in 1 column?

I have a cfgrid in a flash form, and am using the integrated insert
button.  When the user inserts a new record, I want something to run
that will set the default value of a column to a coldfusion variable in
the current page (I need #getCust.customerCode# to pre-fill the hidden
column customerCode)

Has anyone done this?  I hope cf8 has a default value for a
cfgridcolumn!



Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

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

cfc question

[Chad Gray]

I have a CRUD CFC that has this function and I load the CFC into the 
application scope:





SELECT *
FROM FlexoDirectConfigFiles
WHERE #arguments.criteria#


  


I want to be able to pass in the "WHERE" statement into it.  So it could be:
FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01 PM'

So I run something like this to call the function:



What I get back is an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 
'PLATES.zjf'.

Then I look at the SQL that was run in debugging.
SELECT * 
FROM FlexoDirectConfigFiles 
WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005 
12:34:01 PM''

Why did it take my single quotes and add another single quote?  Is it trying to 
escape the single quote?  How do I keep it from doing this?


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

Encrypting database information

[Bosky, Dave]

Can anyone recommend a good encryption method for sensitive
information(login details, etc...) stored in database tables? 

Thanks,
Dave

**
HTC Disclaimer:  The information contained in this message may be privileged 
and confidential and protected from disclosure. If the reader of this message 
is not the intended recipient, or an employee or agent responsible for 
delivering this message to the intended recipient, you are hereby notified that 
any dissemination, distribution or copying of this communication is strictly 
prohibited.  If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.  
Thank you.
**


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

Re: Session Variable Types

[Raymond Camden]

I think Dave answered it well. I think the Users Online thing is
another example. If you have, on average, 200 users on your site, and
you are only showing it for "ego reasons", then why not let it be a
few off?

On 7/18/07, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Still, I don't get the whole concept of "If it's not that
> > important, don't lock it"... because.. if it's not that
> > important, and you know the numbers might be inaccurate, why
> > do it at all?
>
> The cost of locking may outweigh the value of an individual data point.
>
> For example, in a database, you may want to determine the average value of a
> column, in a table that has a million rows. The SQL to do this is quite
> easy, but by default it will prevent write access to those rows while the
> query is running. If a couple of values changed during the query, it
> wouldn't noticeably affect the outcome anyway.
>
> 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
>
>
> 

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283986
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: expected behavior of cflock without name or scope attribute?

[Joyce Young]

Thanks for the replies. That is sort of what I was afraid it was doing (I 
thought it would error gracefully and not actually lock the variables for the 
app). Sadly, the session vars are used elsewere in this app so I think the 
original developer made a little error but the good part is I get to rewrite 
this whole section. Now to just figure out why he would reset them in the exact 
same manner (erroneously) so many times in so many places


Thanks for the advice; it was much appreciated! 

Joyce 


>> Actually, it locks that one piece of code in that one page, 
>> without locking code on any other page. It's the equivalent 

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

Re: expected behavior of cflock without name or scope attribute?

[Joyce Young]

Thanks for the replies. That is sort of what I was afraid it was doing (I 
thought it would error gracefully and not actually lock the variables for the 
app). Sadly, the session vars are used elsewere in this app so I think the 
original developer made a little error but the good part is I get to rewrite 
this whole section. Now to just figure out why he would reset them in the exact 
same manner (erroneously) so many times in so many places


Thanks for the advice; it was much appreciated! 

Joyce 


>> Actually, it locks that one piece of code in that one page, 
>> without locking code on any other page. It's the equivalent 

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

Re: OT - Screen Capture Video

[Cutter (CFRelated)]

Wink is a freeware option

http://www.debugmode.com/wink/

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Andrew Peterson wrote:
> Hi,
> 
> I'm looking for a Windows solution that will capture my screen and audio and 
> present it in Flash for embedding in a web page. A friend uses Snapz Pro at 
> Ambrosia Software, a cheap and effective solution, but only for the Mac. The 
> videos are saved as Quicktime files and then he uploads them to YouTube for 
> the .swf. Very cool. Any ideas for a similar Windows solution? What Adobe 
> products will do this for me?  Thanks in advance.
> 
> Sincerely,
> Andy
> 
> 

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

Re: OT - Screen Capture Video

[Dan Vega]

JingProject was created by the same people who made Catasia (TechSmith)

On 7/18/07, Adam Churvis <[EMAIL PROTECTED]> wrote:
>
> Nothing beats Camtasia Studio 4 (from TechSmith).
>
> Respectfully,
>
> Adam Phillip Churvis
>
> Get advanced intensive Master-level training in
> C# & ASP.NET 2.0 for ColdFusion Developers at
> ProductivityEnhancement.com
>
> -Original Message-
> From: Andrew Peterson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 18, 2007 9:30 AM
> To: CF-Talk
> Subject: OT - Screen Capture Video
>
> Hi,
>
> I'm looking for a Windows solution that will capture my screen and audio
> and present it in Flash for embedding in a web page. A friend uses Snapz Pro
> at Ambrosia Software, a cheap and effective solution, but only for the Mac.
> The videos are saved as Quicktime files and then he uploads them to YouTube
> for the .swf. Very cool. Any ideas for a similar Windows solution? What
> Adobe products will do this for me?  Thanks in advance.
>
> Sincerely,
> Andy
>
>
>
> 

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

RE: OT - Screen Capture Video

[Adam Churvis]

Nothing beats Camtasia Studio 4 (from TechSmith).

Respectfully,

Adam Phillip Churvis

Get advanced intensive Master-level training in
C# & ASP.NET 2.0 for ColdFusion Developers at
ProductivityEnhancement.com

-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 9:30 AM
To: CF-Talk
Subject: OT - Screen Capture Video

Hi,

I'm looking for a Windows solution that will capture my screen and audio and 
present it in Flash for embedding in a web page. A friend uses Snapz Pro at 
Ambrosia Software, a cheap and effective solution, but only for the Mac. The 
videos are saved as Quicktime files and then he uploads them to YouTube for the 
.swf. Very cool. Any ideas for a similar Windows solution? What Adobe products 
will do this for me?  Thanks in advance.

Sincerely,
Andy



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

RE: OT - Screen Capture Video

[Dave Watts]

> I'm looking for a Windows solution that will capture my 
> screen and audio and present it in Flash for embedding in a 
> web page. A friend uses Snapz Pro at Ambrosia Software, a 
> cheap and effective solution, but only for the Mac. The 
> videos are saved as Quicktime files and then he uploads them 
> to YouTube for the .swf. Very cool. Any ideas for a similar 
> Windows solution? What Adobe products will do this for me?  
> Thanks in advance.

Adobe Captivate does all this and much more, and can publish directly to
SWF. It's very nice.

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


~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283980
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT - Screen Capture Video

[Dan Vega]

Andrew,
Funny you ask this because I just found a new tool that I posted a quick
review on today.

http://www.jingproject.com/
http://www.danvega.org/blog/index.cfm/2007/7/17/Jing-Capture-Record-amp-Share-Images-amp-Screencasts

Dan Vega
Letternine

On 7/18/07, Andrew Peterson <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm looking for a Windows solution that will capture my screen and audio
> and present it in Flash for embedding in a web page. A friend uses Snapz Pro
> at Ambrosia Software, a cheap and effective solution, but only for the Mac.
> The videos are saved as Quicktime files and then he uploads them to YouTube
> for the .swf. Very cool. Any ideas for a similar Windows solution? What
> Adobe products will do this for me?  Thanks in advance.
>
> Sincerely,
> Andy
>
> 

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

RE: OT - Screen Capture Video

[Dawson, Michael]

Adobe Captivate is pretty nice. 

-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 8:30 AM
To: CF-Talk
Subject: OT - Screen Capture Video

Hi,

I'm looking for a Windows solution that will capture my screen and audio
and present it in Flash for embedding in a web page. A friend uses Snapz
Pro at Ambrosia Software, a cheap and effective solution, but only for
the Mac. The videos are saved as Quicktime files and then he uploads
them to YouTube for the .swf. Very cool. Any ideas for a similar Windows
solution? What Adobe products will do this for me?  Thanks in advance.

Sincerely,
Andy

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

OT - Screen Capture Video

[Andrew Peterson]

Hi,

I'm looking for a Windows solution that will capture my screen and audio and 
present it in Flash for embedding in a web page. A friend uses Snapz Pro at 
Ambrosia Software, a cheap and effective solution, but only for the Mac. The 
videos are saved as Quicktime files and then he uploads them to YouTube for the 
.swf. Very cool. Any ideas for a similar Windows solution? What Adobe products 
will do this for me?  Thanks in advance.

Sincerely,
Andy

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283977
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Session Variable Types

[Dave Watts]

> Still, I don't get the whole concept of "If it's not that 
> important, don't lock it"... because.. if it's not that 
> important, and you know the numbers might be inaccurate, why 
> do it at all?

The cost of locking may outweigh the value of an individual data point.

For example, in a database, you may want to determine the average value of a
column, in a table that has a million rows. The SQL to do this is quite
easy, but by default it will prevent write access to those rows while the
query is running. If a couple of values changed during the query, it
wouldn't noticeably affect the outcome anyway.

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


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

Insert cfgrid record with default value in 1 column?

[Peterson, Chris]

I have a cfgrid in a flash form, and am using the integrated insert
button.  When the user inserts a new record, I want something to run
that will set the default value of a column to a coldfusion variable in
the current page (I need #getCust.customerCode# to pre-fill the hidden
column customerCode)

Has anyone done this?  I hope cf8 has a default value for a
cfgridcolumn!



Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

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

RE: OT - Exchange server, how to export shared contacts to cvs

[Dawson, Michael]

There really isn't anything considered to be a "shared" contact in
Exchange.  There are just contacts within Active Directory.  You can use
LDAP to retrieve these items.

Your LDAP filter should use "objectCategory=Contact".

Point your LDAP browser (or CFLDAP) at one of your domain controllers.
You don't need admin permissions, but you do need a domain account since
you have to authenticate against AD.

If you have access to Active Directory Users and Computers MMC Snap-In,
I believe you can filter for all contacts, then export them to a file.

M!ke 

-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 18, 2007 5:56 AM
To: CF-Talk
Subject: Re: OT - Exchange server, how to export shared contacts to cvs

On 7/18/07, Adrian Lynch <[EMAIL PROTECTED]> wrote:
>
> I've never done it before, but if you can get at the contacts, can you

> not take whatever format you receive them in and convert it to CSV? 
> You did mean CSV and not CVS didn't you?


Ah, yeah csv

I can't get the contacts,  I've looked in the exchange administrator,
all around in outlook, and I still don't understand how those are stored
or how to export them. A normal users contacts are not a problem, you
can export them from outlook, it's these company wide shared contacts
that I can't seem to be able to export.

It's a small company and while they use exchange, they do not have a
network person on-site. I would have access to administrator account
though if this helps provides enough user rights to get the data I need.

This also is not a coldfusion project, I just need these contacts to
merge with another set.

Casey

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

RE: Deleting multi-value attributes with CFLDAP

[Dawson, Michael]

SEPARATOR/DELIMITER.  I always get those two mixed up.  ;-D 

-Original Message-
From: Andrew Spear [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 17, 2007 4:16 PM
To: CF-Talk
Subject: Re: Deleting multi-value attributes with CFLDAP

Thanks M!ke!
CFLDAP was tripping up on the commas in the value of my "attributes"
parameter. You sent me down the right track, and I found that the
"separator" parameter was defaulting to "," which was matching the
commas in my DN string. 

>Did you try specifying the DELIMITER in your CFLDAP tag?  I think your 
>commas are causing the error.
>
>Try using DELIMITER="|" in your CFLDAP tag to have AD consider the 
>commas to be part of the value.
>
>M!ke



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

Re: Session Variable Types

[Rick Root]

On 7/17/07, John Paul Ashenfelter <[EMAIL PROTECTED]> wrote:
>
> Or if it's *really* worth reporting, get it from a reliable source.
> For example, maybe from the webserver log, which is a lot less
> ambigious than a session/application/etc-based counter. Let's not even
> get into dealing with clusters :)

There are a lot of cases where you want to track things that aren't
found in the web server logs, and you might want to track them in real
time.

Ray wrote some code to determine how many active sessions are on a
page that I use in CFMBB to determine how many users are "currently"
browsing the forums.  Of course, I consider this to be "important"
information... and obviously he did too, so there are locks around the
code.

Still, I don't get the whole concept of "If it's not that important,
don't lock it"... because.. if it's not that important, and you know
the numbers might be inaccurate, why do it at all?

Rick

~|
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:283972
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: managing multiple dev environments

[Kris Jones]

The data is quite volatile. The schema typically has some changes
during each release cycle. We currently point at shared DBs, which I'm
thinking is the direction we'll stick with. But we are talking about
all of the suggestions mentioned here. I can see the benefit in having
local DB as well--in fact this is how I've developed in the past, and
understand how easily this scenario can break the app for other
developers (who may not be in a position to update their local
code-base for whatever reason).

> On Tuesday 17 Jul 2007, [EMAIL PROTECTED] wrote:
> > As for running local DBs, not sure that is an option as our DB is
> > large. That would mean regular downloads/restores on every dev
> > station? This does beg the question of how we'll manage keeping our
> > dev data in tune. It's time consuming with 1 or 2 DBs, but start
> > talking 9 or 10, we're looking at a lot of time.
>
> Depends how often the data / schema changes - if this is infrequent you could
> point all the dev's at a shared DB.

~|
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:283971
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: managing multiple dev environments

[Kris Jones]

$50/per head is not the issue. Our application runs against MS SQL,
and given it's enterprise nature is likely to stay there. If there
were to be a move (very, very doubtful), it would be to Oracle. Not
casting stones at MySQL or PostrgreSQL--they're great. Just not
appropriate for our specific application/business domain.

> On Tuesday 17 Jul 2007, [EMAIL PROTECTED] wrote:
> > also pony up the $50/per head for MSSQL Developer edition
>
> Or just more to a freeier database like MySQL or PostgreSQL.

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283970
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT - Exchange server, how to export shared contacts to cvs

[Casey Dougall]

On 7/18/07, Adrian Lynch <[EMAIL PROTECTED]> wrote:
>
> I've never done it before, but if you can get at the contacts, can you not
> take whatever format you receive them in and convert it to CSV? You did
> mean
> CSV and not CVS didn't you?


Ah, yeah csv

I can't get the contacts,  I've looked in the exchange administrator,  all
around in outlook, and I still don't understand how those are stored or how
to export them. A normal users contacts are not a problem, you can export
them from outlook, it's these company wide shared contacts that I can't seem
to be able to export.

It's a small company and while they use exchange, they do not have a network
person on-site. I would have access to administrator account though if this
helps provides enough user rights to get the data I need.

This also is not a coldfusion project, I just need these contacts to merge
with another set.

Casey


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

RE: OT - Exchange server, how to export shared contacts to cvs

[Adrian Lynch]

I've never done it before, but if you can get at the contacts, can you not
take whatever format you receive them in and convert it to CSV? You did mean
CSV and not CVS didn't you?

Adrian

-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: 18 July 2007 11:41
To: CF-Talk
Subject: OT - Exchange server, how to export shared contacts to cvs


Exchange server, how to export shared contacts to cvs

I've been searching around and haven't found anything but, I need to export
the shared contacts from exchange server.  I'm at a loss as to how to get
these contacts and their details out in .cvs format. I've been looking
around the server itself, searching google, nothing. Any leads?
Casey


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

OT - Exchange server, how to export shared contacts to cvs

[Casey Dougall]

Exchange server, how to export shared contacts to cvs

I've been searching around and haven't found anything but, I need to export
the shared contacts from exchange server.  I'm at a loss as to how to get
these contacts and their details out in .cvs format. I've been looking
around the server itself, searching google, nothing. Any leads?
Casey


~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download 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:283967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfqueryparam and XML

[Dominic Watson]

>
> The CF XML object must be pretty close to plain old text.


Not really. Coldfusion is being clever; it sees that you want to express the
object as a string and so does the conversion.

Dom



On 18/07/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>
> Chad Gray wrote:
> >
> > I wonder if CF8 will have an XML type to support MS SQL 2005.
>
> No sooner then JDBC has an XML type.
>
> 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:283966
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SOT: managing multiple dev environments

[Tom Chiverton]

On Tuesday 17 Jul 2007, [EMAIL PROTECTED] wrote:
> As for running local DBs, not sure that is an option as our DB is
> large. That would mean regular downloads/restores on every dev
> station? This does beg the question of how we'll manage keeping our
> dev data in tune. It's time consuming with 1 or 2 DBs, but start
> talking 9 or 10, we're looking at a lot of time.

Depends how often the data / schema changes - if this is infrequent you could 
point all the dev's at a shared DB.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
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:283965
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: managing multiple dev environments

[Tom Chiverton]

On Tuesday 17 Jul 2007, [EMAIL PROTECTED] wrote:
> also pony up the $50/per head for MSSQL Developer edition 

Or just more to a freeier database like MySQL or PostgreSQL.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


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

Re: session vulnerabilities

[Michael Traher]

I care deeply for them all ;-)

On 7/18/07, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> >>Unfortunately this may exclude AOL users
>
> Who cares about AOL user? ;-))
>
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

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