Re: after a long hiatus back to talk about frameworks

2012-05-08 Thread John M Bliss

Anecdotally:

   - http://cfwheels.org
   - http://coldbox.org http://www.coldbox.org/
   - http://fusebox.org http://www.fusebox.org/
   - http://mach-ii.com http://www.mach-ii.com/
   - http://fw1.riaforge.org
   - http://ontap.riaforge.org
   - and others

I recommend picking whichever seems to line up best with your way of
thinking about things (or the way you'd *like* to think about things) and
go with it.

On Mon, May 7, 2012 at 11:58 PM, Don danfar...@hotmail.com wrote:


 Hi, its been a while since I did any CF work. I am wondering what
 framework seems to be popular right now.

 I did a bit of fusebox and liked it. But am wondering about the others out
 there. I noticed CF builder 2 didn't have any support for it as did
 CFEclipse. I find that odd. Has FB gone 'out of fashion' ?

 I would like something that worked liked objects.. I can't remember if FB
 did that very well.


 

~|
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:351051
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: after a long hiatus back to talk about frameworks

2012-05-08 Thread Russ Michaels

some resources which may help you getting back into CF

www.cf411.com
www.cfsearch.com
www.cfmldeveloper.com

from these you can most likely find everything else you need


On Tue, May 8, 2012 at 10:36 AM, John M Bliss bliss.j...@gmail.com wrote:


 Anecdotally:

   - http://cfwheels.org
   - http://coldbox.org http://www.coldbox.org/
   - http://fusebox.org http://www.fusebox.org/
   - http://mach-ii.com http://www.mach-ii.com/
   - http://fw1.riaforge.org
   - http://ontap.riaforge.org
   - and others

 I recommend picking whichever seems to line up best with your way of
 thinking about things (or the way you'd *like* to think about things) and
 go with it.

 On Mon, May 7, 2012 at 11:58 PM, Don danfar...@hotmail.com wrote:

 
  Hi, its been a while since I did any CF work. I am wondering what
  framework seems to be popular right now.
 
  I did a bit of fusebox and liked it. But am wondering about the others
 out
  there. I noticed CF builder 2 didn't have any support for it as did
  CFEclipse. I find that odd. Has FB gone 'out of fashion' ?
 
  I would like something that worked liked objects.. I can't remember if FB
  did that very well.
 
 
 

 

~|
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:351052
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: bizarre cffile upload bug.

2012-05-08 Thread Ras Tafari

the file is written as a 103kb file both ways, its ftp'd up, as the same size.

cffile through chrome (beta) = no dice
cffile through safari = workie workie

as i said, gonna test more this am.

On Mon, May 7, 2012 at 11:57 PM, Dave Watts dwa...@figleaf.com wrote:

 I must assume that the beta tag is maybe what is happening here.
 something about the filestream is getting corrupt when sending a file up.
 wird.

 Is the file itself written properly to the server in both cases?

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:351053
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: bizarre cffile upload bug.

2012-05-08 Thread Ras Tafari

:) dude. seriously.

the controller has no play in this, the controller merely
does the sql insertion of the record that yes a file has been uploaded,
here is its name, publish date, etc.

this piece is behind the site, in the /admin area.  there's no VIEWING of the
pdf back there just uploading and saving those facts in the DB.

mind you, this exact same code, with ZERO changes, works spot-on in safari.
my BETA version of chrome is the issue.

im going to do a test with the same code, pared down to the basics, and then ill
show ya what happens.  this ill make public facing, gimme a few.

tw

On Mon, May 7, 2012 at 11:56 PM, Dave Watts dwa...@figleaf.com wrote:

 but seriously, I'm merely hitting a method in my main controller that
 does stuff for this site.
 works in safari 100% of the time!!! just not chrome.

 I'm still going with something happening after the file upload for
 $100, Alex. But to see what exactly this might be, here's what I'd do:

 1. Build a working version outside of your controller (separate little
 app) that just does the file upload (and if you're then showing the
 file, that too).
 2. Test this to make sure it works in Chrome.
 3. Use a recording proxy/packet sniffer/Firebug/etc to see what's
 different in the response between the two.

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:351054
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: bizarre cffile upload bug.

2012-05-08 Thread Ras Tafari

so, I made a simple test case :) and it worked in chrome.
so, maybe the cflocation (back to the you've succeeded page) that is
after the cffile tag would make the file not correct, and corrupt??

weird.

weird.

tw

On Tue, May 8, 2012 at 8:31 AM, Ras Tafari rastaf...@gmail.com wrote:
 :) dude. seriously.

 the controller has no play in this, the controller merely
 does the sql insertion of the record that yes a file has been uploaded,
 here is its name, publish date, etc.

 this piece is behind the site, in the /admin area.  there's no VIEWING of the
 pdf back there just uploading and saving those facts in the DB.

 mind you, this exact same code, with ZERO changes, works spot-on in safari.
 my BETA version of chrome is the issue.

 im going to do a test with the same code, pared down to the basics, and then 
 ill
 show ya what happens.  this ill make public facing, gimme a few.

 tw

 On Mon, May 7, 2012 at 11:56 PM, Dave Watts dwa...@figleaf.com wrote:

 but seriously, I'm merely hitting a method in my main controller that
 does stuff for this site.
 works in safari 100% of the time!!! just not chrome.

 I'm still going with something happening after the file upload for
 $100, Alex. But to see what exactly this might be, here's what I'd do:

 1. Build a working version outside of your controller (separate little
 app) that just does the file upload (and if you're then showing the
 file, that too).
 2. Test this to make sure it works in Chrome.
 3. Use a recording proxy/packet sniffer/Firebug/etc to see what's
 different in the response between the two.

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:351055
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: bizarre cffile upload bug.

2012-05-08 Thread Dave Watts

 so, I made a simple test case :) and it worked in chrome.

http://www.youtube.com/watch?feature=player_detailpagev=cCI18qAoKq4#t=59s

 so, maybe the cflocation (back to the you've succeeded page) that is
 after the cffile tag would make the file not correct, and corrupt??

 weird.

 weird.

How often have I said to you that when you have eliminated the
impossible, whatever remains, however improbable, must be the truth?

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
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:351056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: bizarre cffile upload bug.

2012-05-08 Thread Ras Tafari

well, my dear watt's-son :)

im perplexed, but ill tinker with it later.

take'er easy!

On Tue, May 8, 2012 at 10:15 AM, Dave Watts dwa...@figleaf.com wrote:

 so, I made a simple test case :) and it worked in chrome.

 http://www.youtube.com/watch?feature=player_detailpagev=cCI18qAoKq4#t=59s

 so, maybe the cflocation (back to the you've succeeded page) that is
 after the cffile tag would make the file not correct, and corrupt??

 weird.

 weird.

 How often have I said to you that when you have eliminated the
 impossible, whatever remains, however improbable, must be the truth?

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:351057
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Controlling Spiders

2012-05-08 Thread Claude Schnéegans

 this is the official way to do it.
http://www.robotstxt.org/

The problem with Robots.txt is that it is only obeyed by well behaved bots.
Well behaved bots won't cause traffic problem, even if they are a dozen sucking 
your site in the same time.
I've seen bad bots reading robots.txt and immediately request all exclusions.
Personaly, I use robots.txt to forbid a directory containing a trap for bad 
bots and shut the door to them.

~|
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:351058
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Controlling Spiders

2012-05-08 Thread Andrew Scott

What would be nice if the companies that create the likes of IIS and Apache
and others, got together and defined a protocol at the server level, then
they can request what they would like and if the server refuses them, then
stiff shit jack.

I like rewrite rules for this purpose, and it maybe best at the firewall
level, but any that disobey the robots.txt file is placed into the rewrite
rules and I forward them to a sever 404 error.

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



On Wed, May 9, 2012 at 12:20 AM,  wrote:


  this is the official way to do it.
 http://www.robotstxt.org/

 The problem with Robots.txt is that it is only obeyed by well behaved bots.
 Well behaved bots won't cause traffic problem, even if they are a dozen
 sucking your site in the same time.
 I've seen bad bots reading robots.txt and immediately request all
 exclusions.
 Personaly, I use robots.txt to forbid a directory containing a trap for
 bad bots and shut the door to them.

 

~|
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:351059
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Controlling Spiders

2012-05-08 Thread Claude Schnéegans

 What would be nice if the companies that create the likes of IIS and Apache
and others, got together and defined a protocol at the server level.

IMHO, the only rule that would be really useful would be to force Robots to
1. identify the web page were they discribe their purpose and what they are 
lookin for,
2. give a list of IP addresses or range they are crawling from so we can white 
or black list them.

But asking them to obey robots.txt file is like relying on laws to keep 
burglars away from your house.

~|
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:351060
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: after a long hiatus back to talk about frameworks

2012-05-08 Thread Don

some resources which may help you getting back into CF

www.cf411.com
www.cfsearch.com
www.cfmldeveloper.com

from these you can most likely find everything else you need






thanks guys. Wow, some old names I still remember. =) 

~|
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:351061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: after a long hiatus back to talk about frameworks

2012-05-08 Thread Nathan Strutz

I'm not afraid to poke the stormcloud :)

Fusebox went unsupported for a number of years and there was some drama
about who owned the source code (it predates modern open source licenses).
There was a failed fork and then the community stepped in and created a
barrage of better frameworks. Recently, Fusebox has been open-sourced (on
github) and there is a small team of people working on the next version. It
may be too little and too late, but still probably a worthy effort. Even
still, I would not recommend going that way.

Many people believe Framework/1 (fw1.riaforge.org) is the true successor to
Fusebox. It implements a couple features the same way, and it was created
by the FB 5 and 5.5 primary developer Sean Corfield.

Depending on the size of what you plan to build, you may be able to shrink
your selection. The more enterprise options are probably Mach-II,
Model-Glue and ColdBox. They do a lot and have a lot going for them.
ColdBox is the younger of the three, and probably best documented, Louis
also does great training classes. Model-Glue hasn't seen a lot of action
lately. Model-Glue and Mach-II are heavily XML based and (to me) can get
overwhelming. The more casual options are probably cfwheels and FW/1, but
like John Bliss said, go with whichever works with your way of thinking.

(I hope I offended everyone with this ;)

nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]


On Mon, May 7, 2012 at 9:58 PM, Don danfar...@hotmail.com wrote:


 Hi, its been a while since I did any CF work. I am wondering what
 framework seems to be popular right now.

 I did a bit of fusebox and liked it. But am wondering about the others out
 there. I noticed CF builder 2 didn't have any support for it as did
 CFEclipse. I find that odd. Has FB gone 'out of fashion' ?

 I would like something that worked liked objects.. I can't remember if FB
 did that very well.


 

~|
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:351062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: after a long hiatus back to talk about frameworks

2012-05-08 Thread Gerald Guido

 Many people believe Framework/1 (fw1.riaforge.org) is the true successor
to
Fusebox.

+1

I ran into this the other day:
CFMeetup 2011_0303 Simple MVC with FW/1, with Daria Norris
http://vimeo.com/21864956

That should get you started with FW/1 in (fairly) short order.

HTH
G!


On Tue, May 8, 2012 at 12:18 PM, Nathan Strutz str...@gmail.com wrote:

 Many people believe Framework/1 (fw1.riaforge.org) is the true successor
 to
 Fusebox. It implements a couple features the same way, and it was created
 by the FB 5 and 5.5 primary developer Sean Corfield.




-- 
Gerald Guido
http://www.myinternetisbroken.com


~|
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:351063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Controlling Spiders

2012-05-08 Thread Cameron Childress

On Mon, May 7, 2012 at 6:42 PM, Richard Steele r...@photoeye.com wrote:

 Today we had Google + 3 or 4 other spiders hammering our multi-instance
 server at the same time. Is there a way to control these bots to prevent
 them from submitting request after request? How do most high traffic
 servers handle this? Thanks!


I addition to the advice you've gotten (and please take this as
constructive advice) it's possible that if you are having trouble dealing
with search engine traffic - you do not, in fact, have a high traffic
server. This may be a good gut-check time to ask yourself Can we
handle increased load if our website becomes suddenly more
successful?. Seeing your website hiccup on search crawler traffic may be a
good early indicator that you need to do some stress testing and find
places to improve.

-Cameron

-- 
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook http://www.facebook.com/cameroncf |
twitterhttp://twitter.com/cameronc |
google+ https://profiles.google.com/u/0/117829379451708140985


~|
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:351064
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Controlling Spiders

2012-05-08 Thread Brian Thornton

Here's my cent and a half.

I help a large ecommerce group 10x google traffic by presenting the
data to google by direct html and no ajax as google was not indexing
the ajaxan data.

That 10x traffice meant big business for the company and they decided
to push CF into a cluster group via ralio.

Just because it's high traffic doesn't mean it's high expense.

Treat google as the best sales guy your company can have and give it
what it wants..

Know that page load time to the crawler comes into play for the google
reports to reindex times etc. Check out the google webmaster tools and
put it through the tests there.

On Tue, May 8, 2012 at 1:21 PM, Cameron Childress camer...@gmail.com wrote:

 On Mon, May 7, 2012 at 6:42 PM, Richard Steele r...@photoeye.com wrote:

 Today we had Google + 3 or 4 other spiders hammering our multi-instance
 server at the same time. Is there a way to control these bots to prevent
 them from submitting request after request? How do most high traffic
 servers handle this? Thanks!


 I addition to the advice you've gotten (and please take this as
 constructive advice) it's possible that if you are having trouble dealing
 with search engine traffic - you do not, in fact, have a high traffic
 server. This may be a good gut-check time to ask yourself Can we
 handle increased load if our website becomes suddenly more
 successful?. Seeing your website hiccup on search crawler traffic may be a
 good early indicator that you need to do some stress testing and find
 places to improve.

 -Cameron

 --
 Cameron Childress
 --
 p:   678.637.5072
 im: cameroncf
 facebook http://www.facebook.com/cameroncf |
 twitterhttp://twitter.com/cameronc |
 google+ https://profiles.google.com/u/0/117829379451708140985


 

~|
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:351065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Page-break pdf not working inside table

2012-05-08 Thread George Campbell

I am having trouble with using page-breaks within a PDF table that has nested 
loop with boarders. The bottom boarder seems to be on the last pasge by it 
self. the page looks fine untill I use cfdocumentitem type=pagebreak. I have 
alo tried some HTML page breaks with no sucsess... 



Backround 
Using dreamweaver CS4
Cold Fusion 9 server

~|
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:351066
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Odd SQL Problem

2012-05-08 Thread Brian Thornton

I don't know if it's because its 11PM or what but I got a get of SQL
working on MSQL client but wont work via cfquery significant amount of
googleing was a nogo...

Any ideas?

select *
into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Brian.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')

SQL MS comes back with 1500 record(s) added but cfcomes back with
Microsoft.Jet.OLEDB.4.0 for linked server (null)

turns out this is a generic message and could very to permissions to
single quotes

Any ideas or does anyone have cfquery example to the insert into?

~|
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:351067
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd SQL Problem

2012-05-08 Thread Dave Watts

 I don't know if it's because its 11PM or what but I got a get of SQL
 working on MSQL client but wont work via cfquery significant amount of
 googleing was a nogo...

 Any ideas?

 select *
 into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=C:\Brian.xls;HDR=YES',
    'SELECT * FROM [Sheet1$]')

 SQL MS comes back with 1500 record(s) added but cfcomes back with
 Microsoft.Jet.OLEDB.4.0 for linked server (null)

 turns out this is a generic message and could very to permissions to
 single quotes

I suspect that OPENROWSET isn't going to work with CF through JDBC.
I'm not sure why - perhaps it expects the connection string to work
from the machine running CF. You could try writing it as a stored
procedure, then calling the sproc from CF.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or ons

~|
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:351068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd SQL Problem

2012-05-08 Thread Brian Thornton

Got it..
Thanks Dave.

On Wed, May 9, 2012 at 12:13 AM, Dave Watts dwa...@figleaf.com wrote:

 I don't know if it's because its 11PM or what but I got a get of SQL
 working on MSQL client but wont work via cfquery significant amount of
 googleing was a nogo...

 Any ideas?

 select *
 into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=C:\Brian.xls;HDR=YES',
    'SELECT * FROM [Sheet1$]')

 SQL MS comes back with 1500 record(s) added but cfcomes back with
 Microsoft.Jet.OLEDB.4.0 for linked server (null)

 turns out this is a generic message and could very to permissions to
 single quotes

 I suspect that OPENROWSET isn't going to work with CF through JDBC.
 I'm not sure why - perhaps it expects the connection string to work
 from the machine running CF. You could try writing it as a stored
 procedure, then calling the sproc from CF.

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or ons

 

~|
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:351069
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm