RE: NEWS: Great 3 part series on CF8's CFTHREAD tag by Ben Nadel

2007-06-04 Thread Robert Rawlins - Think Blue
:-o I'd forgotten that it now supports threading, sweet Jesus, we're all doomed! DOOMED! ;-) -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: 04 June 2007 16:59 To: CF-Talk Subject: NEWS: Great 3 part series on CF8's CFTHREAD

RE: sql insert error

2007-06-05 Thread Robert Rawlins - Think Blue
'Invalid data for CFSQLTYPE CF_SQL_NUMERIC' That would suggest that the value you're passing in is not numeric, or the column name is an Integer, in which case you might need to use CF_SQL_INTEGER, I've not used ORACLE so can't be sure about that, first thing I would do is dump the variable

Woops, I've F***ed up my rich text editor.

2008-01-01 Thread Robert Rawlins - Think Blue
Good morning guys! Happy new year to you all. So, 2008 is already causing me stress and woe :-D I'm hoping you guys can give me a hand. This morning I've been working on a small dynamic CMS for a friends site and took the new rich cftextarea out for the first time. It worked nicely! I then

RE: Woops, I've F***ed up my rich text editor.

2008-01-02 Thread Robert Rawlins - Think Blue
. Rick -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 01, 2008 8:13 AM To: CF-Talk Subject: Woops, I've F***ed up my rich text editor. Good morning guys! Happy new year to you all. So, 2008 is already causing me stress

RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
- From: Robert Rawlins [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 2:48 PM To: CF-Talk Subject: Sending File Data Over Webservice Hello Guys, I'm after a little advice on refactoring a web service which I have running on one of my applications. The webservice isnt a standard

RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
Thanks Dave, Unix? What's that? Heh, I'm only pulling your leg, I know what Unix is. I thought that cfcontent would be an intensive little monkey, it doesn't surprise me to hear you've found that in the past, it's nice to have that confirmation. I think my real goal with this is to keep it as

RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
I wonder if this can also be done using underlying JAVA classes and things like that? Might be worth looking around for some libraries. Rob -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 28 February 2008 16:36 To: CF-Talk Subject: RE: Sending File Data Over

RE: Could not instantiate stub objects

2009-04-23 Thread Robert Rawlins - Think Blue
Hi Kevin, You say that the webservice is listed in the CFADMIN? I'd try deleting it from the list and then the next time the code is called it should regenerate and hopefully solve your problem, have you tried that? Is this remote service your own? Or someone elses? Rob -Original

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
Hey Ian, My first thoughts on this would be to ensure that YOU keep total control over the actually SQL that is being run, if you're working with large sets of data (more than a few GB) than the performance problems which arise from poorly written SQL could likely cause you all kinds of beef ;-)

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
Skinner [mailto:h...@ilsweb.com] Sent: 23 April 2009 16:25 To: cf-talk Subject: Re: YIKES! I must let internet users write SQL queries for our database! Robert Rawlins - Think Blue wrote: Hey Ian, My first thoughts on this would be to ensure that YOU keep total control over the actually SQL

RE: CF Code to create AutoIncrement column MS SQL?

2009-04-23 Thread Robert Rawlins - Think Blue
Hi Dawn, This is something which should be handled by the database. In a database where you have auto incrementing the primary keys it shouldn't be the applications responsibility to keep an eye on that, you should be doing simple INSERT statements and allowing the DB to do the work. In a SQL

RE: CF Code to create AutoIncrement column MS SQL?

2009-04-23 Thread Robert Rawlins - Think Blue
Dawn, yes the express edition will do the job perfectly for you, I'd recommend getting that installed. I'd speak with the hosting company about connecting, they'll give you the details you need to get started. My concern on this at the moment is working with live databases is never a good idea,

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
-Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 23 April 2009 16:51 To: cf-talk Subject: Re: YIKES! I must let internet users write SQL queries for our database! Robert Rawlins - Think Blue wrote: Ian, Just out of interest, how much data are we talking about

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
Yeah you're quite right here, this is certainly something to consider as a security net down the line, however my only worry would be that it doesn't solve the root of the problem which seems to be this poor database which is struggling under its own weight. I think by the sounds of things the

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
Hi Ian, That all makes a great deal of sense. I really feel you're onto the right track with the database tuning method, that'll be a great start, whilst this is a fairly heavy database, in this day and age it also isn't really THAT heavy and these slow running queries, crashes and batch

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-23 Thread Robert Rawlins - Think Blue
Yeah it sounds like your typical legacy type systems that's a little out of date. You might not even need to normalize the data, there's a lot to be said for performance if the data is denormalized and flatter, it's a balance you'll have to find. If you look back through all the requests you've

RE: Could not instantiate stub objects

2009-04-23 Thread Robert Rawlins - Think Blue
Hi Kevin, In the admin panel when you click 'refresh' next to the webservice, what happens then? Also, try running the following code in a CFM and see what exception is thrown: cfset CreateObject(java, coldfusion.server.ServiceFactory ).XmlRpcService.RefreshWebService('URL OF THE WSDL GOES

RE: Could not instantiate stub objects

2009-04-23 Thread Robert Rawlins - Think Blue
Hi Kevin, Yeah these kinds of issues are a nightmare, web services seem to always throw really dumb vague errors which nobody knows anything about! I've wasted hours on problems like this. My final shot at this would be to delete that entry in the cfadmin and restart the coldfusion service on

RE: YIKES! I must let internet users write SQL queries for our database!

2009-04-24 Thread Robert Rawlins - Think Blue
That's alight Jim, I will be suing you for copyright infringement on my ideas though ;-) -Original Message- From: Jim Rising [mailto:cfflex...@jimrising.com] Sent: 24 April 2009 00:59 To: cf-talk Subject: Re: YIKES! I must let internet users write SQL queries for our database! sorry

RE: Could not instantiate stub objects

2009-04-24 Thread Robert Rawlins - Think Blue
Hi Kevin, Thanks for the update mate, sorry I disappeared last night, it was getting late and I was knackered. Well at least you have a working solution now, really very odd that it couldn't generate the stub objects. If the connection was fine from the server there shouldn't have been a

RE: Could not instantiate stub objects

2009-04-27 Thread Robert Rawlins - Think Blue
Hey Kevin, Seems like the servers you've got setup are as identical as you could hope for, just seems to senseless that it wasn't creating them. Tell me, have you tried to the regenerate them again since you got it working? My only thought at the moment is that whilst not a permissions issue

cffeed action when content changes.

2009-04-27 Thread Robert Rawlins - Think Blue
Afternoon guys, I'm after a little implementation advice from you. I am looking to build a scheduled task on the server which runs every 10 minutes pinging frequently changed RSS feeds, the addresses of which are stored in a DB, using, the trusty CFFEED tag. The top [n] records from the feed

<    1   2   3   4   5