CFQuery to Database

[IT (Pradeep Viswanathan)]

I have couple of records which are filtered from data source x which is oracle 
based and require to insert it into datasource y which is MS SQL server.

The number of rows, columns is not fixed, however I have the records in a Query 
object, what would be the best way to insert get this data into the other 
database?

Thanks in advance.


DISCLAIMER:
"This e-mail message including any of its attachments is intended solely for 
the addressee(s) and may contain privileged information. If you are not the 
addressee or you have received this email message in error, please notify the 
sender who will remove your details from its database. You are not authorized 
to read, copy, disseminate, distribute or use this e-mail message or any 
attachment to it in any manner and must delete the email and destroy any hard 
copies of it. 
This e-mail message does not contain financial instructions or commitments of 
any kind. Any views expressed in this message are those of the individual 
sender and do not necessarily reflect the views of Emirates NBD PJSC, or any 
other related subsidiaries, entities or persons."


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

Thank God for query params. ;)

[.jonah]

An IP from the Ukraine was attacking my contact form with name values like:

"John 1) declare @q varchar(8000) select @q = 
0x57414954464F522044454C4159202730303A30303A313527 exec(@q) --"

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

Bizarre Behavior

[Richard Steele]

We offer a template-based, self-administered solution for hosting websites and 
have a CF8 Enterprise server with two load-balanced. Yesterday, for the first 
time in 6 years of offering hosting services, we had a bizarre user login 
problem event. A user logged into to administer their hosted site using their 
normal credentials and another user's administration came up!! I then tried 
logging into their administrative backend and the same thing happened to me. I 
then logged out and tried yet another user's credentials and that worked fine, 
but when I logged out of their administrative backend I was taken to that other 
user's site's administration (the one that was the wrong one in the first 
example) instead of to the hosting site's home page. 

I thought we might have been hacked, but no login files' date times had 
changed. The application.cfm had not changed either. 

I restarted both instances of CF server and all is back to normal. 

I'm completely baffeled and concerned. What in the world could cause this that 
a CF service restart would fix?
Thanks in advance. 

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

Re: Bizarre Behavior

[Andrew Scott]

By restarting, it sounds like you are keeping some things in memory to do
your comparison with. Would that be a place to start.

Without knowing more on how your doing your authentication, it would be
hard to give an accurate answer either.


-- 
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543


On Sun, Mar 11, 2012 at 9:59 AM, Richard Steele  wrote:

>
> We offer a template-based, self-administered solution for hosting websites
> and have a CF8 Enterprise server with two load-balanced. Yesterday, for the
> first time in 6 years of offering hosting services, we had a bizarre user
> login problem event. A user logged into to administer their hosted site
> using their normal credentials and another user's administration came up!!
> I then tried logging into their administrative backend and the same thing
> happened to me. I then logged out and tried yet another user's credentials
> and that worked fine, but when I logged out of their administrative backend
> I was taken to that other user's site's administration (the one that was
> the wrong one in the first example) instead of to the hosting site's home
> page.
>
> I thought we might have been hacked, but no login files' date times had
> changed. The application.cfm had not changed either.
>
> I restarted both instances of CF server and all is back to normal.
>
> I'm completely baffeled and concerned. What in the world could cause this
> that a CF service restart would fix?
> Thanks in advance.
>
> 

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

Re: Thank God for query params. ;)

[Justin Scott]

> An IP from the Ukraine was attacking my contact form with name values like:
>
> "John 1) declare @q varchar(8000) select @q =
> 0x57414954464F522044454C4159202730303A30303A313527 exec(@q) --"

Indeed, this looks like an initial reconnaissance injection to see if
other commands would work (that hex value decodes to WAITFOR DELAY
'00:00:15').  This would cause a page load to be delayed a short
period so they know the command executed on the database server before
moving on to more interesting attacks.


-Justin

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

Re: Migrate back and forth between cf7 and cf8 on IIS

[Al Musella, DPM]

An easier way may be to set up a virtual PC with the version of cf 
you use least often.. leave the other one on your computer..
Then just launch the virtual pc when you need that version. Set up a 
hosts file on your computer so cf8.mydomain.com goes to the virtual pc.  


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

PSA - Daylight Savings Time

[Cameron Childress]

You probably won't forget that DST changes this weekend.  But you may
forget that this means the hour between 2:00a and 3:00a doesn't exist on
Sat night / Sun morning.  So on Monday when you are wondering... *THAT* is
why your 2:15am scheduled task didn't run over the weekend...

-Cameron

-- 
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook  |
twitter |
google+ 


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

Re: Thank God for query params. ;)

[Michael E. Carluen]

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.


On Mar 10, 2012, at 9:43 PM, Justin Scott  wrote:

> 
>> An IP from the Ukraine was attacking my contact form with name values like:
>> 
>> "John 1) declare @q varchar(8000) select @q =
>> 0x57414954464F522044454C4159202730303A30303A313527 exec(@q) --"
> 
> Indeed, this looks like an initial reconnaissance injection to see if
> other commands would work (that hex value decodes to WAITFOR DELAY
> '00:00:15').  This would cause a page load to be delayed a short
> period so they know the command executed on the database server before
> moving on to more interesting attacks.
> 
> 
> -Justin
> 
> 

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