Re: Can the server-wide missing template handler be overridden?

2007-08-31 Thread James Holmes
http://www.cfquickdocs.com/cf8/#onMissingTemplate

On 8/31/07, Jim McAtee [EMAIL PROTECTED] wrote:
 I'm moving a couple dozen web sites from a CF5 server to a new CF8
 Standard server.

 In setting up the server-wide missing error handler, CF8 wants a
 relative path.  Relative to -what- it doesn't say, and since it checks
 for the existance of the file in the CF Adminsitrator and throws an error
 if it can't find it, the only way I can figure out how to make this work
 is by creating a CF mapping to the directory containing the cf file I want
 to execute.

 Unlike CF5, you don't specify the file's path directly, so it appeared to
 me that I might be able to override the missing error handler on
 individual web sites.  On one site I tried creating a physical directory
 with the same name as the CF mapped directory, but it's not recognized.  I
 must missing something here - why not just specify the actual path to the
 file as in CF5?


 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287511
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-ish: JSP equivalent for application.cfc?

2007-08-31 Thread Nick de Voil
Pete

  Does JSP have an analogue to the application.cfc file?

No, at least not a standard analogue (some JSP containers like JRun 
have/had a non-standard thing called global.jsa.) You can initialise 
simple global variables using web.xml.

  Any other tips for a CF guy teaching himself JSP?  I'm using Apache 
Tomcat.

Take a look at tag libraries (taglibs), Struts and Hibernate.

A JSP app written using taglibs looks remarkably like a CF application - 
not surprisingly, since taglibs were invented by people from Allaire, I 
believe.

Nick


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287512
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: Transfer ORM workshop starts in 50 minutes

2007-08-31 Thread Tom Chiverton
On Thursday 30 Aug 2007, [EMAIL PROTECTED] wrote:
  https://admin.adobe.acrobat.com/common/help/en/support/meeting
  _test.htm says Unable to connect for test 2, and meetings
  stick on the 'Connecting...' after the progress bar fills up.

 On that page, there is a send results button. If you click that, it opens
 a modal window with a details link. If you want, click on that, copy the
 text from the box and send it to me offlist, and I'll see if I can
 determine the problem. It'll look something like this:

Cool, done, cheers.

-- 
Tom Chiverton
Helping to dramatically morph visionary initiatives
on: http://thefalken.livejournal.com



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.


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

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


Re: Railo 2 Released

2007-08-31 Thread Dinner
On 8/30/07, Gert Franz wrote:
 :-)

 It's like in Die Hard:
 The Stockholm syndrome
 Like Stockholm Finnland?
 No Stockholm - Sweden

Hehe, that actually sounded funny when I typed it, but I'm glad you
got what I meant.  =]


 their code for performance, since it's our business. Railo helps, but
 unperformant code is easily written. Many developers rely too much on
 the server's hardware performance.

Hey, that's me!  Glad to hear you're battling it on your end, now I can
write 4x more bloated code! (I'm not real strong in math, either :)

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


RE: UI recommendations needed

2007-08-31 Thread Dan G. Switzer, II
Andy,

Interesting... I wonder. I used IFRAME to display a PDF file within a
CFLAYOUT (pushing data one way). However I am not sure of the level of
interactivity possible with IFRAME (data going both ways). It might work if
you just want to pass the form information one way to the IFRAME.

What I've done in the past is set the target attribute of the form / tag
to point to the iframe /. Then whatever script your posting to in the
iframe / you can just use a JS callback function to notify the main page
when the upload is complete. That's a technique that I've used since 1998.

-Dan


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Fwd: Web Service File Permission Issue

2007-08-31 Thread Rick Root
I'm forwarding this to cf-talk, where it belongs =)

the program creating the images is actually imageCFC... so take that
into account when reading the message below.  This issue stumped me,
so I suggested that he hit up the mailing list for ideas.

-- Forwarded message --
From: Developer MediaDoc [EMAIL PROTECTED]
Date: Aug 30, 2007 11:58 AM
Subject: Web Service File Permission Issue
To: CF-Community [EMAIL PROTECTED]


Hi All,

Have a 'captcha' image creation web service creating a .jpg file,
storing it on my domain in a 'services' folder. File is created no
problems.

When the 'requesting' web site tries to display the file however, I
get a standard windows Authentication Required dialog box (username /
password) to gain access to my domain.

I look in my services / image_store folder and the file my service
created has permissions set to the requesting domain (i.e.
IUSR_requestor_domain) instead of IUSR_my_services_domain -- which is
causing the issue.

However in windows, I have set the folder holding all these generated
files to apply IUSR_my_services_domain to the folder, subfolder and
all files... and yet when a new file is created it NEVER takes those
permission settings! Maddening. Im missing something simple I hope!

Regards,

Matts

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

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


binding a cfselect to a grid

2007-08-31 Thread Will Swain
Hi,
 
Mucking about with the ajax stuff in CF8.
 
I have a grid with a binding to a cfc. The grid is populated with a list of
book names. All works great.
 
I have another form, with cfinputs that are bound to the grid selected row.
These display values like ISBN number, price, publisher, author etc, and I
want them to be editable. 
 
I want to pull all the authors from the database, populate a cfselect with
them and then bind the selected value to the grid above. Is that possible?
 
Thanks
 
Will 


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287517
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-ish: JSP equivalent for application.cfc?

2007-08-31 Thread Rick Root
Are people still using JSP?

Isn't it even more of a dying language than Coldfusion? ;)

Rick

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: CF vs. PHP

2007-08-31 Thread John Paul Ashenfelter
On 8/29/07, Dave l [EMAIL PROTECTED] wrote:
 actually, im not trolling, it was a serious ?

 And of course its as good as who codes it but thats just the code and i'd 
 imagine the issue is more about the server itself, I don't honestly know but 
 would like to and thats why i asked as I have heard many people say that 
 security is a big disadvantage of php. I remember some big exploits on the 
 server but not exactly what they were.

The bulk of the highly publicized security issues with PHP have been
with open source apps that have SQL injection, XSS, and similar
vulnerabilities (eg -- coder-related problems).

 Like i said, im not trolling but would like to know for my own personal 
 benefit and to have the correct info.

Secunia is a good place to look for reported vulnerabilities for any
major product:

ColdFusion 7.x has 0/13 unpatched (http://secunia.com/product/4984/)
Zend Platform 2.x (PHP) has 0/2 unpatched (http://secunia.com/product/11679/)
Rails 1.x has 0/2 unpatched (http://secunia.com/product/11350/)
ASP.NET 1.x has 4/7 unpatched (http://secunia.com/product/2173/)

That's reported vunlerabilities in the product itself. Doesn't
honestly mean that much, but it's a better metric than guessing :)



 Security is an issue with all exposed languages??  Its only as good as the
 codemonkey writing it?  Yahoo uses PHP? Directnic Uses PHP?
 
 James I will put up some examples been really busy past couple days.
 
 Dave im sorry if I am wrong but that really appears to be a Troll Response
 
 Eric Haskins
 
 
 
 
  Out of curiosity, do you worry about security with php? I haven't been in
  touch with it much lately but I have read the articles where the guy in
  charge of trying to make php more secure quit and said it was a battle that
  couldn't be won.
 
 

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287519
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-ish: JSP equivalent for application.cfc?

2007-08-31 Thread Pete Ruckelshaus
The vast majority of developers that I know (mostly friends from previous
jobs) in this area are JSP developers.

Pete


On 8/31/07, Rick Root [EMAIL PROTECTED] wrote:

 Are people still using JSP?

 Isn't it even more of a dying language than Coldfusion? ;)

 Rick

 

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

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


CF Flash Properties Retrieval

2007-08-31 Thread Robert Harrison
Before I knock myself out working a JavaScript, the thought occurred to me
that CF is supposed to integrate well with flash. So here's the question:

 

Is there an easy way using CF to retrieve the width and height of a flash
(.swf) file?

 

Thanks

 

 

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 

F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



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

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


SQL - dupicate table

2007-08-31 Thread daniel kessler
I have a table and I'd like to duplicate all of it's data to another table.  
I've set the second table to have the same structure.  How do I go about 
transferring that data through SQL?  It'll be a one-time transfer.
I'd like to do the whole table at once, but if I have to do field by field, 
then that's okay too.

Here's my attempt at doing the first field, which failed:
update timesheets_tmp
 set date_added = 
  (
   select date_added
   from timesheets
  )

It executes fine but timesheets_tmp isn't updated.

thank you. 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: SQL - dupicate table

2007-08-31 Thread John Paul Ashenfelter
How about

INSERT INTO new_table SELECT * FROM old_table

On 8/31/07, daniel kessler [EMAIL PROTECTED] wrote:
 I have a table and I'd like to duplicate all of it's data to another table.  
 I've set the second table to have the same structure.  How do I go about 
 transferring that data through SQL?  It'll be a one-time transfer.
 I'd like to do the whole table at once, but if I have to do field by field, 
 then that's okay too.

 Here's my attempt at doing the first field, which failed:
 update timesheets_tmp
  set date_added =
   (
select date_added
from timesheets
   )

 It executes fine but timesheets_tmp isn't updated.

 thank you.

 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


In depth Solaris Unix CF install questions

2007-08-31 Thread Ian Skinner
A question for all the experienced ColdFusion on Unix administrators out 
there from a recent Windows to Unix convert newbie.

We are getting ready to build a new server on Solaris Unix, hopefully 
with CF 8, otherwise with CF 7.  Our desire is to separate the roles of 
the CF server administration from the larger Unix administration.  In 
the past the Unix administrator has done the CF installation as root and 
from then on all the ColdFusion configuration files are owned by root 
and only the Unix administrator could change them.  Is this the only way 
CF can be set up?  Or can this somehow be configured so that a separate 
CF administrator, without complete root access, can control the CF 
configuration after the install.  If so, what needs to be done to make 
sure the CF installation correctly runs under this option.

Pointers to documentation|discussion|information that explains the ins 
and outs, whys and wherefores of a Unix installation in more depth then 
the basic Installation Guide always gratefully accepted.

Thank you.
Ian Skinner

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

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


Re: SQL - dupicate table

2007-08-31 Thread daniel kessler
How about

INSERT INTO new_table SELECT * FROM old_table

Yep, that was it - thank you.

I had done:
insert into timesheets_tmp
 (timesheet_id,id,date_added,entry_date,type,hours,minutes,notes,signoff)
  (
   select 
timesheet_id,id,date_added,entry_date,type,hours,minutes,notes,signoff
   from timesheets
  )


I guess I wasn't thinking INSERT and I should've been.

thanks again -and a good weekend to y'all.

daniel 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: SQL - dupicate table

2007-08-31 Thread daniel kessler
I meant to mention that it's Oracle. 

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

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


Re: AJAX Security

2007-08-31 Thread Andy Chen
Thanks... nice read.

So the easiest way to add another layer of Ajax security is the Prefix 
serialized JSON option in CF Admin but from I understand, it won't break 
anything either right? Sort of like the supress white space function.

 Have you seen my blog posts on CF8 and Ajax Security?
 
 http://www.coldfusionjedi.com/index.
 cfm/2007/7/31/ColdFusion-8-Ajax-Security-Features
 
 On 8/30/07, Andy Chen [EMAIL PROTECTED] wrote:
  Not sure how many attended but I attended today's eSeminar - Beyond 
 HTML: using Ajax, PDF, and more to create engaging applications with 
 ColdFusion 8.
 
  Some people were worried about AJAX security and how easy it is to 
 hack RIA (Rich Internet Applications). My take is AJAX is almost 
 like a web service. It allows you to access common information easily. 
 Anything which writes to a database, I have more checks in place 
 (checking UUIDs and various form fields) to prevent someone from just 
 messing around with it.
 
  For my current project, it's an intranet one so I am not too worried 
 about security but is there something even more dangerous that I might 
 be missing when using AJAX that I might not of thought about?
 
  


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: AJAX Security

2007-08-31 Thread Raymond Camden
Right - CF - when it generates JS code, will know it needs to strip prefixes.

On 8/31/07, Andy Chen [EMAIL PROTECTED] wrote:
 Thanks... nice read.

 So the easiest way to add another layer of Ajax security is the Prefix 
 serialized JSON option in CF Admin but from I understand, it won't break 
 anything either right? Sort of like the supress white space function.

  Have you seen my blog posts on CF8 and Ajax Security?
 
-- 
===
Raymond Camden, Camden Media

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287529
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-ish: JSP equivalent for application.cfc?

2007-08-31 Thread Dave Watts
 Are people still using JSP?
 
 Isn't it even more of a dying language than Coldfusion? ;)

Oh no! But as Nick mentioned, many JSP programmers use some sort of
abstraction on top of JSP - templating libraries like Velocity, JSF, etc,
etc.

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!


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: SQL - dupicate table

2007-08-31 Thread Judah McAuley
INSERT INTO tbl2 (col1, col2, etc)
SELECT col1, col2, etc
FROM tbl1

Should copy everything from tbl1 to tbl2. This presumes that tbl2 is empty.

Cheers,
Judah

daniel kessler wrote:
 I have a table and I'd like to duplicate all of it's data to another table.  
 I've set the second table to have the same structure.  How do I go about 
 transferring that data through SQL?  It'll be a one-time transfer.
 I'd like to do the whole table at once, but if I have to do field by field, 
 then that's okay too.
 
 Here's my attempt at doing the first field, which failed:
 update timesheets_tmp
  set date_added = 
   (
select date_added
from timesheets
   )
 
 It executes fine but timesheets_tmp isn't updated.
 
 thank you. 
 
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Odd query caching

2007-08-31 Thread Cutter (CFRelated)
Running into some odd behavior, that maybe someone can give me insight 
on. On CF8, connecting to MS SQL, I'm seeing some very odd situations, 
whereby my query results are being cached, even though I haven't coded 
them to be. I run a template, that dumps query results, and get 23 
values back. I go into SQL Enterprise Manager, adjust a record, run the 
query in Query Analyzer, and get 22 records back. I refresh my template 
and get the 23 records previous. The data has changed. If I adjust the 
query, like by adding an additional column, and refresh the template 
then I will get the correct 22 records back. Remove the additional 
column and I'll get the correct 22 records.

I was banging my head against a wall, for several hours, over an Ajax 
call to a paging query, before opening Firebug and discovering the same 
type of issue. Am I missing something? I've never had this type of issue 
before on an uncached query, so I am at a loss. Any suggestions?

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

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: AJAX Security

2007-08-31 Thread Rey Bango
Hi Andy,

Apart from Ray's feedback, also keep in mind that the security issues 
with Ajax typically stem from using eval() on JSON packets and external 
JS scripts. While not all-inclusive, of late this has been the biggest 
attack vector for hackers looking to exploit JS weaknesses.

This article will give you some additional info:

http://www.ibm.com/developerworks/library/x-ajaxsecurity.html

Rey...



Andy Chen wrote:
 Thanks... nice read.
 
 So the easiest way to add another layer of Ajax security is the Prefix 
 serialized JSON option in CF Admin but from I understand, it won't break 
 anything either right? Sort of like the supress white space function.
 
 Have you seen my blog posts on CF8 and Ajax Security?

 http://www.coldfusionjedi.com/index.
 cfm/2007/7/31/ColdFusion-8-Ajax-Security-Features

 On 8/30/07, Andy Chen [EMAIL PROTECTED] wrote:
 Not sure how many attended but I attended today's eSeminar - Beyond 
 HTML: using Ajax, PDF, and more to create engaging applications with 
 ColdFusion 8.
 Some people were worried about AJAX security and how easy it is to 
 hack RIA (Rich Internet Applications). My take is AJAX is almost 
 like a web service. It allows you to access common information easily. 
 Anything which writes to a database, I have more checks in place 
 (checking UUIDs and various form fields) to prevent someone from just 
 messing around with it.
 For my current project, it's an intranet one so I am not too worried 
 about security but is there something even more dangerous that I might 
 be missing when using AJAX that I might not of thought about?

 
 
 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


ColdFusion 8 and Exchange 2007

2007-08-31 Thread Patrick Heppler
Hi List,
i've some trouble with CF8 and Exchange 2007.

With this code, i can dump my emails:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangemail action=get folder=Posteingang name=weeksMail 
connection=testconn1
/cfexchangemail

cfexchangeconnection action=close connection=testconn1

cfdump var=#weeksMail#

But if i try to query my calendar:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangecalendar
 action = get
name = theUID
 connection = testconn1
cfexchangeconnection action=close connection=testconn1
cfdump var=theUID

I get an error: 
Ensure that the Exchange web application is configured in IIS and Web Service 
Extension for the Exchange server is allowed. 
Message
Cannot access Exchange server as a web application at mail.mydomain.com.

Same error when i try to query my contacts.
The server requires https! I can access the Outlook Web Access with the same 
user/pass.

webdav is enabled on IIS.
The exchange 2007 runs on windows 2003 standard server. but the iis runs on a 
virtual server on the same machine as the exchange server. 

anyone using cf8 and exchange 2007? 

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

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


ANSWER: CF Flash Properties Retrieval

2007-08-31 Thread Robert Harrison
 Is there an easy way using CF to retrieve the width and height of a flash
(.swf) file?

I found the answer on a blog by Doug Hughes. This a great cfc he's written
that retrieves and returns properties from an .swf file. Eactly what I
needed. If you're on the list Doug, nice... very nice. The post was at:

http://www.doughughes.net/index.cfm?event=viewEntryentryId=166



Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: Web Service File Permission Issue

2007-08-31 Thread Rick Root
wow, nobody on this list has comments or suggestions on this topic?
Hard to believe this got more play on cf-community.

On 8/31/07, Rick Root [EMAIL PROTECTED] wrote:
 I'm forwarding this to cf-talk, where it belongs =)

 the program creating the images is actually imageCFC... so take that
 into account when reading the message below.  This issue stumped me,
 so I suggested that he hit up the mailing list for ideas.

 -- Forwarded message --
 From: Developer MediaDoc [EMAIL PROTECTED]
 Date: Aug 30, 2007 11:58 AM
 Subject: Web Service File Permission Issue
 To: CF-Community [EMAIL PROTECTED]


 Hi All,

 Have a 'captcha' image creation web service creating a .jpg file,
 storing it on my domain in a 'services' folder. File is created no
 problems.

 When the 'requesting' web site tries to display the file however, I
 get a standard windows Authentication Required dialog box (username /
 password) to gain access to my domain.

 I look in my services / image_store folder and the file my service
 created has permissions set to the requesting domain (i.e.
 IUSR_requestor_domain) instead of IUSR_my_services_domain -- which is
 causing the issue.

 However in windows, I have set the folder holding all these generated
 files to apply IUSR_my_services_domain to the folder, subfolder and
 all files... and yet when a new file is created it NEVER takes those
 permission settings! Maddening. Im missing something simple I hope!

 Regards,

 Matts



-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


RE: Web Service File Permission Issue

2007-08-31 Thread Dave Watts
 However in windows, I have set the folder holding all these 
 generated files to apply IUSR_my_services_domain to the 
 folder, subfolder and all files... and yet when a new file is 
 created it NEVER takes those permission settings! Maddening. 
 Im missing something simple I hope!

What permissions are applied to the file if you create one directly from
within Windows Explorer (not an image file specifically, just any kind of
file at all).

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!


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: ColdFusion 8 and Exchange 2007

2007-08-31 Thread Patrick Heppler
Yeah, our Exchange Admin told me, that Microsoft did some changes in the OWA.
The main thing is to add events to the calendar via our intranet calendar build 
in cf.
Maybe Exchange supports adding an event via Email, so i could send Email 
invitations.


Am 31.08.2007 18:56 Uhr schrieb Dawson, Michael unter [EMAIL PROTECTED]:

From what I remember, there are some known issues with Exchange 2007
support.

We are still on Exchange 2003.

M!ke

-Original Message-
From: Patrick Heppler [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 12:29 PM
To: CF-Talk
Subject: ColdFusion 8 and Exchange 2007

Hi List,
i've some trouble with CF8 and Exchange 2007.

With this code, i can dump my emails:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangemail action=get folder=Posteingang name=weeksMail
connection=testconn1 /cfexchangemail

cfexchangeconnection action=close connection=testconn1

cfdump var=#weeksMail#

But if i try to query my calendar:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangecalendar
 action = get
name = theUID
 connection = testconn1
cfexchangeconnection action=close connection=testconn1 cfdump
var=theUID

I get an error:
Ensure that the Exchange web application is configured in IIS and Web
Service Extension for the Exchange server is allowed.
Message
Cannot access Exchange server as a web application at mail.mydomain.com.

Same error when i try to query my contacts.
The server requires https! I can access the Outlook Web Access with the
same user/pass.

webdav is enabled on IIS.
The exchange 2007 runs on windows 2003 standard server. but the iis runs
on a virtual server on the same machine as the exchange server.

anyone using cf8 and exchange 2007?



~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Epoch Time in CF off???

2007-08-31 Thread Mallory Woods
Rick,

I think thats it. I will mention it and see if we can get upgraded to the
latest version.

Thanks for your help

On 8/30/07, Rick Root [EMAIL PROTECTED] wrote:

 On 8/30/07, Mallory Woods [EMAIL PROTECTED] wrote:
 
  I'm using CF ver: 7,0,0,91690
  I don't know what version of JVM is intstalled I don't have admin access
 to
  the box.

 cfdump var=#server#

 That'll help you figure out what JVM you're using.

 Probably the old one since whomever is your hosting provider hasn't
 updated to 7.0.2 yet.  The default version of Java installed with 7.0
 and 7.0.1 does NOT account for recent daylight savings time changes.

  When I run your example code I get the same results for both lines of
 code.
 
  I have noticed that the are still off from the Javascript code thats
 running
  the same formula.

 By how much?

 I suspect that part of the difference might have to do with time zones.

 Rick

 --
 Rick Root
 Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
 www.opensourcecf.com

 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


RE: ColdFusion 8 and Exchange 2007

2007-08-31 Thread Dawson, Michael
From what I remember, there are some known issues with Exchange 2007
support.

We are still on Exchange 2003.

M!ke

-Original Message-
From: Patrick Heppler [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 31, 2007 12:29 PM
To: CF-Talk
Subject: ColdFusion 8 and Exchange 2007

Hi List,
i've some trouble with CF8 and Exchange 2007.

With this code, i can dump my emails:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangemail action=get folder=Posteingang name=weeksMail
connection=testconn1 /cfexchangemail

cfexchangeconnection action=close connection=testconn1

cfdump var=#weeksMail#

But if i try to query my calendar:
cfexchangeconnection
action=open
username =myusername
password=mypass
server=mail.mydomain.com
connection=testconn1
protocol=https

cfexchangecalendar
 action = get
name = theUID
 connection = testconn1
cfexchangeconnection action=close connection=testconn1 cfdump
var=theUID

I get an error: 
Ensure that the Exchange web application is configured in IIS and Web
Service Extension for the Exchange server is allowed. 
Message
Cannot access Exchange server as a web application at mail.mydomain.com.

Same error when i try to query my contacts.
The server requires https! I can access the Outlook Web Access with the
same user/pass.

webdav is enabled on IIS.
The exchange 2007 runs on windows 2003 standard server. but the iis runs
on a virtual server on the same machine as the exchange server. 

anyone using cf8 and exchange 2007? 

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

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


Re: AJAX Security

2007-08-31 Thread Andy Chen
Hi Rey,

The information from your link is excellent. Since my current project is 
internal and we aren't using any external JSON sources, some of the security 
warnings may not be applicable. However I do see how dangerous it could be 
for an external site and double so for those which are doing E-commerce or 
anything with $$.

Thanks...

Hi Andy,

Apart from Ray's feedback, also keep in mind that the security issues 
with Ajax typically stem from using eval() on JSON packets and external 
JS scripts. While not all-inclusive, of late this has been the biggest 
attack vector for hackers looking to exploit JS weaknesses.

This article will give you some additional info:

http://www.ibm.com/developerworks/library/x-ajaxsecurity.html

Rey...



Andy Chen wrote:
 

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

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


Re: UI recommendations needed

2007-08-31 Thread Andy Chen
Thanks Dan,

I haven't really used IFRAME much except to display external sites, so I 
haven't played with the JS interaction between them. I should give it a try and 
see if I can get it to solve the upload problem. Will tell you how it goes. 

Andy

Andy,

Interesting... I wonder. I used IFRAME to display a PDF file within a
CFLAYOUT (pushing data one way). However I am not sure of the level of
interactivity possible with IFRAME (data going both ways). It might work if
you just want to pass the form information one way to the IFRAME.

What I've done in the past is set the target attribute of the form / tag
to point to the iframe /. Then whatever script your posting to in the
iframe / you can just use a JS callback function to notify the main page
when the upload is complete. That's a technique that I've used since 1998.

-Dan 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


cfwindow refreshes main page

2007-08-31 Thread Larry Schaberg
I am a bit confused as to why this is occurring, but I am sure it is something 
I have done wrong. I am attempting to have a cfgid, that displays a list of 
issues that users have submitted on our intranet to the IT department. When you 
load the page, the first row of the cfgrid is selected and the cfwindow 
refreshes. It gives me an error, but once you click ok, it then loads the page 
and you can do anything including updating the information, but when you click 
on another row of the cfgrid, it starts to refresh the cfwindow, but then the 
entire parent page refreshes, but nothing loads. The parent page just hangs and 
you just see a white page.

he following code is on one page in this order. 
- cfgrid -

cfform name=step1 
cfgrid colheaders=yes format=html pagesize=15 
bind=cfc:helpdesk.IssueDisplay({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})
 name=unresissues striperows=yes 
cfgridcolumn display=no width=40 name=helpdesk_id 
header=Request 
cfgridcolumn display=no name=it_member_id header=AssignID 
width=0 
cfgridcolumn display=yes width=80 name=helpdesk_fname 
header=First Name 
cfgridcolumn display=yes width=80 name=helpdesk_lname 
header=Last Name 
cfgridcolumn display=yes width=90 name=class_type 
header=Classification
cfgridcolumn display=yes mask=MM/DD/ 
name=helpdesk_date_created header=Date Submitted width=100 
cfgridcolumn display=yes name=assign_it_name header=Assigned To 
/cfgrid 
cfinput type=button name=GO value=View Request 
onClick=ColdFusion.Window.show('helpdeskdata') / 
/cfform

-- cfwindow tag -
cfwindow name=helpdeskdata title=Helpdesk Data initShow=true width=500 
height=885 x=700 y=0 refreshonshow=true 
source=windowresult.cfm?id={unresissues.helpdesk_id}act=1itmemid={unresissues.it_member_id}classtype={unresissues.class_type}
 cfajaximport tags=cfform, cftextarea, cfwindow scriptsrc=/CFIDE/scripts
/cfwindow

Any assistance would be appreciated 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: cfwindow refreshes main page

2007-08-31 Thread Steve Sequenzia
Larry,

What is the error you are getting when it loads?

Here is a similar demo I did using a grid and a pod. It might be helpful:

http://demo.thinksys.com/cf8/cfgrid/contacts.cfm


 I am a bit confused as to why this is occurring, but I am sure it is 
 something I have done wrong. I am attempting to have a cfgid, that 
 displays a list of issues that users have submitted on our intranet to 
 the IT department. When you load the page, the first row of the cfgrid 
 is selected and the cfwindow refreshes. It gives me an error, but once 
 you click ok, it then loads the page and you can do anything including 
 updating the information, but when you click on another row of the 
 cfgrid, it starts to refresh the cfwindow, but then the entire parent 
 page refreshes, but nothing loads. The parent page just hangs and you 
 just see a white page.
 
 he following code is on one page in this order. 
 - cfgrid -
 
 cfform name=step1 
 cfgrid colheaders=yes format=html pagesize=15 
 bind=cfc:helpdesk.IssueDisplay({cfgridpage},{cfgridpagesize},
 {cfgridsortcolumn},{cfgridsortdirection}) name=unresissues 
 striperows=yes 
   cfgridcolumn display=no width=40 name=helpdesk_id 
 header=Request 
   cfgridcolumn display=no name=it_member_id header=AssignID 
 width=0 
   cfgridcolumn display=yes width=80 name=helpdesk_fname 
 header=First Name 
   cfgridcolumn display=yes width=80 name=helpdesk_lname 
 header=Last Name 
   cfgridcolumn display=yes width=90 name=class_type 
 header=Classification
   cfgridcolumn display=yes mask=MM/DD/ 
 name=helpdesk_date_created header=Date Submitted width=100 
   cfgridcolumn display=yes name=assign_it_name header=Assigned 
 To 
 /cfgrid 
   cfinput type=button name=GO value=View Request 
 onClick=ColdFusion.Window.show('helpdeskdata') / 
 /cfform
 
 -- cfwindow tag -
 cfwindow name=helpdeskdata title=Helpdesk Data initShow=true 
 width=500 height=885 x=700 y=0 refreshonshow=true 
 source=windowresult.cfm?id={unresissues.
 helpdesk_id}act=1itmemid={unresissues.
 it_member_id}classtype={unresissues.class_type} cfajaximport 
 tags=cfform, cftextarea, cfwindow scriptsrc=/CFIDE/scripts
 /cfwindow
 
 Any assistance would be appreciated 


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


CF8 AJAX

2007-08-31 Thread Asim Manzur
I have cfselect  statement:

cfselect name=proj_id height=70
bind=cfc:MyCfcPath.MyCFCFunction(#session.userid#)
value=project_id  display=project_name bindonload=true /

I have a cfinput type=text

which will take the value from cfselect and call another function in
cfc and display the value.

I tried putting the onchange on cfselect, but how to bind that value
to the text cfinput field.

Appreciate any help in this.

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: Query speed diference

2007-08-31 Thread Qasim Rasheed
If your DB is Oracle, you can easily use MERGE SQL command for this
purpose.

HTH

Qasim

On 8/30/07, Nick de Voil [EMAIL PROTECTED] wrote:

 Jay

  Which of these two methods would be faster?
 
  - Method 1 -
 
  cfquery
  SELECT * FROM table WHERE someID = #someVar#
  /cfquery
 
  cfif query.recordCount IS 1
cfqueryUPDATE table.../cfquery
  cfelse
cfqueryINSERT INTO table.../cfquery
  /cfif
 
  - Method 2 -
 
  cfquery
  DELETE FROM table WHERE someID = #someVar#
  /cfquery
  cfqueryINSERT INTO table.../cfquery

 You can achieve an improvement by either:

 - changing your logic so that you know whether to do an update or
 insert without needing to check the record ID against the database; or

 - whichever of the 2 methods you use, combining the 2 SQL statements
 into one stored procedure or at least one CFQUERY.

 Nick


 

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

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


MySQL Fulltext search problem

2007-08-31 Thread Les Mizzell
I've set up a FULLTEXT index in the MySQL database. This part should be 
correct as the database shows the below with no errors:

Index Name: textSEARCH
Field Names: Title, Author, Publishers
Index: Full Text

Here's my query:

cfquery name=getBOOK
  dataSource=#getDATASOURCE
SELECT title,
Author,
Publishers,
ListPrice,
ISBN
FROM booksDATA
WHERE MATCH (Title, Author, Publishers)
   AGAINST cfqueryparam
cfsqltype=cf_sql_varchar
value=#form.search#
/cfquery


So, let's try to find a Beatrix Potter book about rabbits.

Here's the error.

Syntax error or access violation: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near ''potter rabbit''


Not sure what I've got wrong. I've never used a fulltext index before, 
but query looks correct tome. Hm - suggestions?

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

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


livedocs.adobe.com down?

2007-08-31 Thread Janet MacKay
Anyone know where I can find a copy of http://livedocs.adobe.com/coldfusion/8/ 
online? I don't have CF8 it installed on this computer and the whole livedocs 
site seems to be down.

TIA 

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

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


RE: livedocs.adobe.com down?

2007-08-31 Thread Dave Watts
 Anyone know where I can find a copy of 
 http://livedocs.adobe.com/coldfusion/8/ online? I don't have 
 CF8 it installed on this computer and the whole livedocs site 
 seems to be down.

You can download the documentation in PDF format here:
http://www.adobe.com/support/documentation/en/coldfusion/

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!


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: livedocs.adobe.com down?

2007-08-31 Thread Janet MacKay
You can download the documentation in PDF format here:
http://www.adobe.com/support/documentation/en/coldfusion/

Perfect. Thanks so much! 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: CF8 AJAX

2007-08-31 Thread Raymond Camden
You've lost me. Are you syaing you want the cfinput to bind to the
select? Did you try bind={proj_id} in the text input?

On 8/31/07, Asim Manzur [EMAIL PROTECTED] wrote:
 I have cfselect  statement:

 cfselect name=proj_id height=70
 bind=cfc:MyCfcPath.MyCFCFunction(#session.userid#)
 value=project_id  display=project_name bindonload=true /

 I have a cfinput type=text

 which will take the value from cfselect and call another function in
 cfc and display the value.

 I tried putting the onchange on cfselect, but how to bind that value
 to the text cfinput field.

 Appreciate any help in this.

 

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

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


Re: binding a cfselect to a grid

2007-08-31 Thread Raymond Camden
You can certainly bind to a grid - what I haven't tried is doing it in
a select. Try it and let us know.

If it doesn't work with a simple bind=, then consider using
cfajaxproxy with bind. You can tell the tag to run a JS function when
th egrid changes. The JS function then could simply update the drop
down.

On 8/31/07, Will Swain [EMAIL PROTECTED] wrote:
 Hi,

 Mucking about with the ajax stuff in CF8.

 I have a grid with a binding to a cfc. The grid is populated with a list of
 book names. All works great.

 I have another form, with cfinputs that are bound to the grid selected row.
 These display values like ISBN number, price, publisher, author etc, and I
 want them to be editable.

 I want to pull all the authors from the database, populate a cfselect with
 them and then bind the selected value to the grid above. Is that possible?

 Thanks

 Will


 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


braindead duh!! moment with db

2007-08-31 Thread mayo
My queries aren't working. Can't figure it out.

 

SELECT

items.itemID,

items.designerID,

designers.designerID,

designers.designerName,

FROM

items,

designers

WHERE

items.designerID=designers.designerID

 

 

cfoutput query=

-- #designerID#  --

/cfoutput

 

It should return the designer name. Instead I get -- d --

 

When I substituted designers with another table itemTypes I got an -- I
--

 

I've looked at this for over an hour and can't make head or tails with it.
Check to make certain I was accessing the correct database (changed data)
it's linked to the correct db. !?!

 

I'm going nuts here.

 



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

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


Re: binding a cfselect to a grid

2007-08-31 Thread Raymond Camden
Ok, so I tried. YOu can't. I'm working on a demo now for my blog.

On 8/31/07, Raymond Camden [EMAIL PROTECTED] wrote:
 You can certainly bind to a grid - what I haven't tried is doing it in
 a select. Try it and let us know.

 If it doesn't work with a simple bind=, then consider using
 cfajaxproxy with bind. You can tell the tag to run a JS function when
 th egrid changes. The JS function then could simply update the drop
 down.

 On 8/31/07, Will Swain [EMAIL PROTECTED] wrote:
  Hi,


-- 
===
Raymond Camden, Camden Media

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: binding a cfselect to a grid

2007-08-31 Thread Raymond Camden
Ok, got a demo done. It isn't too difficult.

http://www.coldfusionjedi.com/index.cfm/2007/8/31/Updating-a-drop-down-based-on-an-HTML-Grid-Selection

On 8/31/07, Raymond Camden [EMAIL PROTECTED] wrote:
 Ok, so I tried. YOu can't. I'm working on a demo now for my blog.

 On 8/31/07, Raymond Camden [EMAIL PROTECTED] wrote:
  You can certainly bind to a grid - what I haven't tried is doing it in
  a select. Try it and let us know.
 
  If it doesn't work with a simple bind=, then consider using
  cfajaxproxy with bind. You can tell the tag to run a JS function when
  th egrid changes. The JS function then could simply update the drop
  down.
 
  On 8/31/07, Will Swain [EMAIL PROTECTED] wrote:
   Hi,


 --
 ===
 Raymond Camden, Camden Media

 Email: [EMAIL PROTECTED]
 Blog  : www.coldfusionjedi.com
 AOL IM : cfjedimaster

 Keep up to date with the community: http://www.coldfusionbloggers.org



-- 
===
Raymond Camden, Camden Media

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: braindead duh!! moment with db

2007-08-31 Thread Bryan Stevenson
You are selecting 2 columns from different tables named designer_id.you 
should alias one of them.  I'm suprised the query even executes like thatit 
shouldn't!

You haven't put the query name in the CFOUTPUT tag eitherthat might help ;-)

None of what you posted should even runso I can only assume it's psuedo 
code??

Cheers

PS...outputting the designerID as you code states would NOT show the designer 
nameuse the designerNAme field for that ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments. 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


RE: braindead duh!! moment with db

2007-08-31 Thread mayo
Yes, it was abbreviated.

And, yes I'm tired. I should have stated designerID not designerName?

here's a snippet (MUCH IS CUT OUT)

cfquery name=getItems datasource=storeSR
SELECT
items.itemID,
items.categoryID,
items.itemTypeID,
items.designerID,
items.designerItemCode,
items.itemName,
items.itemDescShort,
items.itemPrice,
designers.designerID,
designers.designerName,
designers.designerNameWWW,
designers.isActive,
designers.hasDescriptionPage
FROM
items,
designers
WHERE
items.designerID=designers.designerID

/cfquery


cfoutput query=getItems
 -- #itemID#  -- #designerID# br/
/cfoutput

I ought to get a list of numbers
-- 77 -- 20
-- 78 -- 20
Etc..

Instead I get

-- 77 -- d 
-- 77 -- d 
-- 78 -- d 
-- 78 -- d 
-- 78 -- d

If I ran the query width itemTypes (changed the tables and fields) and put
in itemTypeID instead of designerID I get a list with  an i instead of a d.

Go figure!?

I swear these queries worked before!  :-)



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 31, 2007 5:54 PM
To: CF-Talk
Subject: Re: braindead duh!! moment with db

You are selecting 2 columns from different tables named
designer_id.you 
should alias one of them.  I'm suprised the query even executes like
thatit 
shouldn't!

You haven't put the query name in the CFOUTPUT tag eitherthat might help
;-)

None of what you posted should even runso I can only assume it's psuedo 
code??

Cheers

PS...outputting the designerID as you code states would NOT show the
designer 
nameuse the designerNAme field for that ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments. 





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

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


Re: braindead duh!! moment with db

2007-08-31 Thread Bryan Stevenson
OKthat's better ;-)

You are still selecting designerID from items and designers tablesjust 
select it from one table and not both (or as I said before...alias one or both 
of them).

I can only guess (if the query is actually running) that it is getting confused 
between those 2 columns with the same name and you're getting some unexpected 
weirdness.

What if you use CFDUMP to dump the querydo you see the correct data then?

HTH

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments. 



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


RE: braindead duh!! moment with db

2007-08-31 Thread Bruce, Rodney S Mr CTR USA AMC
Don't know why you are getting the ds or Is.

But a few things I would do are:

Alias one of the designerIDs or remove it from the SELECT.

Scope the vars  #getItems.itemid##getItems.designerid#,  something
might be in designerid from another scope.

Do a CFDUMP of the query and see what is in the recordset.
See if you have ds in the recordset before you are outputting the data.

If you have ds in the recordset from the CFDUMP then I would go back
and run the query in the database and look at what is in the tables.



-Original Message-
From: mayo [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 31, 2007 3:10 PM
To: CF-Talk
Subject: RE: braindead duh!! moment with db

Yes, it was abbreviated.

And, yes I'm tired. I should have stated designerID not designerName?

here's a snippet (MUCH IS CUT OUT)

cfquery name=getItems datasource=storeSR
SELECT
items.itemID,
items.categoryID,
items.itemTypeID,
items.designerID,
items.designerItemCode,
items.itemName,
items.itemDescShort,
items.itemPrice,
designers.designerID,
designers.designerName,
designers.designerNameWWW,
designers.isActive,
designers.hasDescriptionPage
FROM
items,
designers
WHERE
items.designerID=designers.designerID

/cfquery


cfoutput query=getItems
 -- #itemID#  -- #designerID# br/
/cfoutput

I ought to get a list of numbers
-- 77 -- 20
-- 78 -- 20
Etc..

Instead I get

-- 77 -- d
-- 77 -- d
-- 78 -- d
-- 78 -- d
-- 78 -- d

If I ran the query width itemTypes (changed the tables and fields) and
put in itemTypeID instead of designerID I get a list with  an i instead
of a d.

Go figure!?

I swear these queries worked before!  :-)

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

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


LearnCF Launched

2007-08-31 Thread Dale Fraser
Sorry if this has appeared already, but I didn't see the post come through.

 

http://learncf.com

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 




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

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


RE: LearnCF Launched

2007-08-31 Thread Matthew Smith
Good looking site.  Hope to see the content grow a bit.

-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 31, 2007 5:52 PM
To: CF-Talk
Subject: LearnCF Launched

Sorry if this has appeared already, but I didn't see the post come
through.

 

http://learncf.com

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 






~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: best way to store search terms entered on a website?

2007-08-31 Thread TechInfo
I also log how many hits they got from their search.  That tells us if
our search mechanisms are working or not.

Jerry Johnson wrote:
 Yes, but the rows are not (duplicate).

 The time, the search string. Potentially the IP address. in
 combination, always unique.

 On 8/24/07, stylo stylo [EMAIL PROTECTED] wrote:
   
 You seriously just keep adding row upon (duplicate) row every day for years 
 and years? That's a hell of a lot of rows because people search a lot. I'm 
 surprised, but I'm no expert. If no one thinks that's a bad idea...

 Thanks again.


 

 

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

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


Re: LearnCF Launched

2007-08-31 Thread Christopher Jordan
Nice Dale. I commented on the launch post, but I'll ask here too... how do
community members contribute?

Chris

On 8/31/07, Dale Fraser [EMAIL PROTECTED] wrote:

 Sorry if this has appeared already, but I didn't see the post come
 through.



 http://learncf.com



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com






 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: LearnCF Launched

2007-08-31 Thread Peter Donahue
Good evening everyone,

Let me also congratulate you on the launch of this site. You'll also be
happy to know that it passed the accessibility muster as I was able to visit
a number of pages using my screen reader without any trouble.

Finally let me also mention that the tutorials currently on the site
were written by people I know from this list. I once downloaded some CF
tutorials from another site several years ago and found I needed to, Clean
them up so they would work as they were most likely not written by those
with lots of experience programming with ColdFusion. They were a mess to
figure out before we finally got them working. Keep up the good work.

Peter Donahue

- Original Message - 
From: Christopher Jordan [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, August 31, 2007 6:08 PM
Subject: Re: LearnCF Launched


Nice Dale. I commented on the launch post, but I'll ask here too... how do
community members contribute?

Chris

On 8/31/07, Dale Fraser [EMAIL PROTECTED] wrote:

 Sorry if this has appeared already, but I didn't see the post come
 through.



 http://learncf.com



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com










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

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


Re: In depth Solaris Unix CF install questions

2007-08-31 Thread James Holmes
Sudo is your friend here. You can give sudo rights to vi the
appropriate files to certain users, thus allowing them to change only
the relevant configs.

On 8/31/07, Ian Skinner [EMAIL PROTECTED] wrote:
 A question for all the experienced ColdFusion on Unix administrators out
 there from a recent Windows to Unix convert newbie.

 We are getting ready to build a new server on Solaris Unix, hopefully
 with CF 8, otherwise with CF 7.  Our desire is to separate the roles of
 the CF server administration from the larger Unix administration.  In
 the past the Unix administrator has done the CF installation as root and
 from then on all the ColdFusion configuration files are owned by root
 and only the Unix administrator could change them.  Is this the only way
 CF can be set up?  Or can this somehow be configured so that a separate
 CF administrator, without complete root access, can control the CF
 configuration after the install.  If so, what needs to be done to make
 sure the CF installation correctly runs under this option.


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

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

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


Anyone know what is up with Viviotech?

2007-08-31 Thread Brian Rinaldi
Every site I know of that is hosted at Viviotech, including my own and
actually including Viviotech's site, is down. Anyone have any idea
what is going on? I would normally check the site but, as I said...

-- 
Brian Rinaldi
blog - http://www.remotesynthesis.com/blog
ColdFusion Open Source List- http://www.remotesynthesis.com/cfopensourcelist
Boston CFUG - http://www.bostoncfug.org
Adobe Community Expert -
http://www.adobe.com/communities/experts/members/brian_rinaldi.html

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread James Holmes
Yeah, I'm getting the same thing. Thanks for confirming it's not just me.

On 9/1/07, Brian Rinaldi [EMAIL PROTECTED] wrote:
 Every site I know of that is hosted at Viviotech, including my own and
 actually including Viviotech's site, is down. Anyone have any idea
 what is going on? I would normally check the site but, as I said...

 --
 Brian Rinaldi
 blog - http://www.remotesynthesis.com/blog
 ColdFusion Open Source List- http://www.remotesynthesis.com/cfopensourcelist
 Boston CFUG - http://www.bostoncfug.org
 Adobe Community Expert -
 http://www.adobe.com/communities/experts/members/brian_rinaldi.html

 

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

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


Re: LearnCF Launched

2007-08-31 Thread Rey Bango
Congrats Dale!

Dale Fraser wrote:
 Sorry if this has appeared already, but I didn't see the post come through.
 
  
 
 http://learncf.com
 
  
 
 Regards
 
 Dale Fraser
 
  
 
 http://dalefraser.blogspot.com
 
  
 
 
 
 
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Mary Jo Sminkey
Yeah, I'm getting the same thing. Thanks for confirming it's not just me.

Same here. Anyone called them to see if they are working on it? I know they 
don't have anyone on staff evenings and weekends, but there's no way to page 
them with the servers completely down. 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread James Holmes
Ah, it's back up for me now.

On 9/1/07, Mary Jo Sminkey [EMAIL PROTECTED] wrote:
 Yeah, I'm getting the same thing. Thanks for confirming it's not just me.

 Same here. Anyone called them to see if they are working on it? I know they 
 don't have anyone on staff evenings and weekends, but there's no way to page 
 them with the servers completely down.



 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Brian Rinaldi
I have to admit, I don't even know the number unless the site is up. I
now get some response from Viviotech.net, but its been giving a BD
error for about the past 10 minutes...which I guess is progress from
no response at all. Still no response from my site or my email :(

- Brian

On 8/31/07, Mary Jo Sminkey [EMAIL PROTECTED] wrote:
 Yeah, I'm getting the same thing. Thanks for confirming it's not just me.

 Same here. Anyone called them to see if they are working on it? I know they 
 don't have anyone on staff evenings and weekends, but there's no way to page 
 them with the servers completely down.

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

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Brian Rinaldi
Looks like it was some sort of power outage perhaps -
http://www.viviotech.net/forum/viewtopic.php?t=353 (yeah, there site
is up now)

Guess it has been down for some hours though based on the time of that
message (even taking the time differential into account).

Sadly, my server is still not responding :(
nor my email...

- Brian

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

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Rick Root
Mine seems to be up.  I was told they were going to turn off the old
IP addresses today, so I had to make DNS changes to 50 domains today
:)

Rick

On 8/31/07, Brian Rinaldi [EMAIL PROTECTED] wrote:
 Looks like it was some sort of power outage perhaps -
 http://www.viviotech.net/forum/viewtopic.php?t=353 (yeah, there site
 is up now)

 Guess it has been down for some hours though based on the time of that
 message (even taking the time differential into account).

 Sadly, my server is still not responding :(
 nor my email...

 - Brian

 

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

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Brian Rinaldi
I thought I understood it was a power outage from them. Mine is
finally back up too.

- Brian

On 8/31/07, Rick Root [EMAIL PROTECTED] wrote:
 Mine seems to be up.  I was told they were going to turn off the old
 IP addresses today, so I had to make DNS changes to 50 domains today
 :)

 Rick

Adobe Community Expert -
http://www.adobe.com/communities/experts/members/brian_rinaldi.html

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Mary Jo Sminkey
 I have to admit, I don't even know the number unless the site is up. 
 I
 now get some response from Viviotech.net, but its been giving a BD
 error for about the past 10 minutes...which I guess is progress from
 no response at all. Still no response from my site or my email :(

Yeah, my site is back up too. I did grab the phone number from doing a Whois, 
but I assumed as well from the BD error that they were working on it. 

MJS 

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

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Joseph Lamoree
On 31 Aug 2007, at 19:20, Rick Root wrote:

 Mine seems to be up.  I was told they were going to turn off the old
 IP addresses today, so I had to make DNS changes to 50 domains today

To be fair, the IP migration to their own ARIN block was announced on  
8 May 2007; customer address allocations were made on 24 July 2007. I  
was able to migrate all my servers and update DNS without an issue.  
The power outage, however, was very unfortunate.

--
Joseph Lamoree


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Rick Root
On 8/31/07, Brian Rinaldi [EMAIL PROTECTED] wrote:
 I thought I understood it was a power outage from them. Mine is
 finally back up too.

It may have been, but they did tell me that I needed to change my DNS
tonight (I don't use their DNS, my domains are registered through enom
and I just use their hosted DNS service)

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

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

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


Re: Anyone know what is up with Viviotech?

2007-08-31 Thread Rick Root
On 8/31/07, Joseph Lamoree [EMAIL PROTECTED] wrote:

 To be fair, the IP migration to their own ARIN block was announced on
 8 May 2007; customer address allocations were made on 24 July 2007. I
 was able to migrate all my servers and update DNS without an issue.

Not saying I had an issue... just that I didn't do my DNS changes
until this morning.

 The power outage, however, was very unfortunate.

truth


-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


Re: MySQL Fulltext search problem

2007-08-31 Thread Les Mizzell
 Here's my query:
 
 cfquery name=getBOOK
   dataSource=#getDATASOURCE
 SELECT title,
 Author,
 Publishers,
 ListPrice,
 ISBN
 FROM booksDATA
 WHERE MATCH (Title, Author, Publishers)
AGAINST cfqueryparam
 cfsqltype=cf_sql_varchar
 value=#form.search#
 /cfquery


Doh! Needed parenthesis...


  SELECT title,
  Author,
  Publishers,
  ListPrice,
  ISBN
  FROM booksDATA
  WHERE MATCH (Title, Author, Publishers)
 AGAINST (cfqueryparam
  cfsqltype=cf_sql_varchar
  value=#form.search#)


Like I said - never done an fulltext index before...

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


RE: LearnCF Launched

2007-08-31 Thread Dale Fraser
Peter,

Thanks for the comments, the code viewer is actually reading the files from
the disk, the same files that get executed and every tutorial must have a
working demo. It uses CFZIP to download the same code, so you are always
guaranteed to have working code.

Regards
Dale Fraser

http://dalefraser.blogspot.com

-Original Message-
From: Peter Donahue [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 1 September 2007 11:24 AM
To: CF-Talk
Subject: Re: LearnCF Launched

Good evening everyone,

Let me also congratulate you on the launch of this site. You'll also be
happy to know that it passed the accessibility muster as I was able to visit
a number of pages using my screen reader without any trouble.

Finally let me also mention that the tutorials currently on the site
were written by people I know from this list. I once downloaded some CF
tutorials from another site several years ago and found I needed to, Clean
them up so they would work as they were most likely not written by those
with lots of experience programming with ColdFusion. They were a mess to
figure out before we finally got them working. Keep up the good work.

Peter Donahue

- Original Message - 
From: Christopher Jordan [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, August 31, 2007 6:08 PM
Subject: Re: LearnCF Launched


Nice Dale. I commented on the launch post, but I'll ask here too... how do
community members contribute?

Chris

On 8/31/07, Dale Fraser [EMAIL PROTECTED] wrote:

 Sorry if this has appeared already, but I didn't see the post come
 through.



 http://learncf.com



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com












~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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


Re: In depth Solaris Unix CF install questions

2007-08-31 Thread Dinner
What about Zones?  chroot type stuff?

On 8/31/07, James Holmes [EMAIL PROTECTED] wrote:
 Sudo is your friend here. You can give sudo rights to vi the
 appropriate files to certain users, thus allowing them to change only
 the relevant configs.

 On 8/31/07, Ian Skinner [EMAIL PROTECTED] wrote:
  A question for all the experienced ColdFusion on Unix administrators out
  there from a recent Windows to Unix convert newbie.
 
  We are getting ready to build a new server on Solaris Unix, hopefully
  with CF 8, otherwise with CF 7.  Our desire is to separate the roles of
  the CF server administration from the larger Unix administration.  In
  the past the Unix administrator has done the CF installation as root and
  from then on all the ColdFusion configuration files are owned by root
  and only the Unix administrator could change them.  Is this the only way
  CF can be set up?  Or can this somehow be configured so that a separate
  CF administrator, without complete root access, can control the CF
  configuration after the install.  If so, what needs to be done to make
  sure the CF installation correctly runs under this option.


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

 

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

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


RE: LearnCF Launched

2007-08-31 Thread Dale Fraser
Thanks Chris,

I have added a contribute page to the site.

http://learncf.com/contribute.cfm

Regards
Dale Fraser

http://dalefraser.blogspot.com


-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 1 September 2007 9:09 AM
To: CF-Talk
Subject: Re: LearnCF Launched

Nice Dale. I commented on the launch post, but I'll ask here too... how do
community members contribute?

Chris

On 8/31/07, Dale Fraser [EMAIL PROTECTED] wrote:

 Sorry if this has appeared already, but I didn't see the post come
 through.



 http://learncf.com



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com






 



~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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