Re: CFQuery to Database

2012-03-11 Thread Russ Michaels
if its just a few records then use query of query to get your subset of results and then insert the results into database B if this is a regular occurrence and happens often then then you may want to look at creating a DTS script on your SQL server and scheduling that to do the job. On Sat,

RE: CFQuery to Database

2012-03-11 Thread IT (Pradeep Viswanathan)
Thanks Russ, Scott@fussionapps has been kind enough to give me a nice code.. The little challenge was that the columns were not fixed and query results are completely dyanmic... Just posting it here for reference CFLOOP query=qry_data CFQUERY name=qry_insert datasource=#request.dsn#

Re: PSA - Daylight Savings Time

2012-03-11 Thread Raymond Camden
And in theory, CF10's scheduled task service should allow you to handle that with it's onMisfire support. On Sat, Mar 10, 2012 at 7:54 AM, Cameron Childress camer...@gmail.com wrote: You probably won't forget that DST changes this weekend.  But you may forget that this means the hour between

Re: Thank God for query params. ;)

2012-03-11 Thread Dave Watts
I often amazed why simple cf tags like cfqueryparam and even cfoutpout don't get pimped enough. Stuff CF developers don't worry as much as PHP, ASP, or RoR developers would. It's a minor pain to create prepared statements in PHP, but it's very easy to do so in ASP.NET. Dave Watts, CTO, Fig

Re: Thank God for query params. ;)

2012-03-11 Thread Phillip Duba
That was the one thing I thought was interesting when I just recently completed the .NET training. They taught query params in all their examples dealing with database interactions. I found that refreshing, Phil On Sun, Mar 11, 2012 at 1:47 PM, Dave Watts dwa...@figleaf.com wrote: It's a

Re: Thank God for query params. ;)

2012-03-11 Thread Mike Stemle
All major languages with abstracted DBMS layers have bind parameters, most of which provide similar security and control (some with greater control) to cfqueryparam. Perl's DBI and PHP's DBO come to mind. Anybody getting hit with SQL injection these days is very likely making a silly mistake

Fwd: kony2012

2012-03-11 Thread Brian Thornton
Have you guys seen this video... -- Forwarded message -- From: Fred Day fs...@msn.com Date: Mar 11, 2012 9:06 PM Subject: kony2012 To: Brian Thornton vegasthorn...@gmail.com http://www.youtube.com/watch?v=Y4MnpzG5Sqc

Re: Fwd: kony2012

2012-03-11 Thread Greg Morphis
Kinda off topic for this list, don't you think? On Mar 11, 2012 8:08 PM, Brian Thornton br...@cfdeveloper.com wrote: Have you guys seen this video... -- Forwarded message -- From: Fred Day fs...@msn.com Date: Mar 11, 2012 9:06 PM Subject: kony2012 To: Brian Thornton

Re: Fwd: kony2012

2012-03-11 Thread Brian Thornton
No... I think it should be on jerrys prediction list... On Mar 11, 2012 9:23 PM, Greg Morphis gmorp...@gmail.com wrote: Kinda off topic for this list, don't you think? On Mar 11, 2012 8:08 PM, Brian Thornton br...@cfdeveloper.com wrote: Have you guys seen this video... --

Re: Fwd: kony2012

2012-03-11 Thread Greg Morphis
OK, go back to spamming the cf-jobs list ;) On Mar 11, 2012 8:43 PM, Brian Thornton br...@cfdeveloper.com wrote: No... I think it should be on jerrys prediction list... On Mar 11, 2012 9:23 PM, Greg Morphis gmorp...@gmail.com wrote: Kinda off topic for this list, don't you think? On

Re: kony2012

2012-03-11 Thread Michael Stemle
I don't think this is a good place to discuss this, especially since the people local to that area are now opposing this whole movement. I don't believe the people involved in this movement have properly grasped the complexity of this issue - especially the racial aspects - and I don't think it

Re: kony2012

2012-03-11 Thread Gerald Guido
I don't think this is a good place to discuss this +1000 It is rather controversial, and in my opinion suspect at best. https://www.google.com/search?ix=sebsourceid=chromeie=UTF-8q=kony2012 Let the internets hash it out. G! On Sun, Mar 11, 2012 at 9:54 PM, Michael Stemle

RE: Fwd: kony2012

2012-03-11 Thread Eric Roberts
You posted to cf-talk...not cf-community Brian... -Original Message- From: Brian Thornton [mailto:br...@cfdeveloper.com] Sent: Sunday, March 11, 2012 8:44 PM To: cf-talk Subject: Re: Fwd: kony2012 No... I think it should be on jerrys prediction list... On Mar 11, 2012 9:23 PM, Greg