Re: Contract rates

2007-04-12 Thread RichL
cut off the top for such a long time is a little cheeky. > > If you were hopping from job to job than its fair enough that they take a > profit, but on such a long standing position which let's face it should > really be classed as 'permanent' then I think they need to go, r

Contract rates

2007-04-11 Thread RichL
Hello guys I was hoping to get a feeling from you guys of what the average hourly rate is for a Coldfusion developer working on development and maintenance of fairly complex applications. My situation is that I have been working for the same client for nearly two years with several contract exten

Re: OT: Saving remotely in Eclipse

2007-01-30 Thread RichL
I have noticed that it is saving .htm files but not .cfm files. Any idea anybody? On 1/30/07, RichL <[EMAIL PROTECTED]> wrote: > Apologies for the slightly off-topic content of the post but I am > trying to get up and running with Eclipse quite speedily and could do > with some qu

OT: Saving remotely in Eclipse

2007-01-30 Thread RichL
Apologies for the slightly off-topic content of the post but I am trying to get up and running with Eclipse quite speedily and could do with some quick answers and I know there are lots of Eclipse users here.. I have installed Eclipse and CFEclipse. I have come from using Dreamweaver MX and use t

Re: problem with a file extension

2007-01-16 Thread RichL
Did you try removing the seemingly extra single quote mark before ..jpg? This will be added to your file name and it may be that you don't need this? If there is no error, is there a blank image placeholder where the image should be? If there is, right click on it and select properties and it shou

Re: problem with a file extension

2007-01-16 Thread RichL
Alex I am not sure that you need that extra' in the middle of here [fotoNum]#'.jpg Have you tried dumping the contents of foto to make sure you have the data that you need and are you also sure that fotoNum has a numerical value that you require? It may be helpful for these emails if you post th

Dynamic Where Syntax

2006-12-21 Thread RichL
Guys I am trying to build up a where clause dynamically as follows: loop with i as a numeric index value... and cplname = )'> end loop I am running a query as follows: select * from x #whereclause# The SQL is falling over with 'Line 1: Incorrect syntax near '<'.' but on the same error

Re: Firebug 1.0 Beta is Out

2006-12-04 Thread RichL
Rey this absolutely rocks... thank you for the link Regards Rich On 12/4/06, Rey Bango <[EMAIL PROTECTED]> wrote: > Man I wish I could John. For IE 7, checkout this from Microsoft: > > http://www.microsoft.com/downloads/details.aspx?familyid=e59c3964-672d-4511-bb3e-2d5e1db91038&displaylang=en > >

Re: problem on cfoutput query syntax too complex for cfmx

2006-12-04 Thread RichL
And if we are being syntactically correct, you'll need the quotes around spanish... Actually. Apologies here... i am half asleep still and have only just finished the coffee... Adrian is completely correct another Americano please On 12/4/06, RichL <[EMAIL PROTECTED]> wrote

Re: problem on cfoutput query syntax too complex for cfmx

2006-12-04 Thread RichL
I think you'll find that that may need to be: You will need the hashes around 'qtext' for coldfusion to resolve it in to the desired name of your query (i.e. English or Spanish) Regards Rich On 12/4/06, Adrian <[EMAIL PROTECTED]> wrote: > scrap the hashes. > > > > > > > On 04/12/06, alex p

Re: Identifying date/time objects

2006-11-22 Thread RichL
Will, It looks like isDate() will do what you need - to see if the string can be converted to a date You might want to look at parseDateTime() which will create a date object from the date string.. may or may not be of any use #parseDateTime(test)# | #isDate(test)# | #dateformat(parseDateTime

Re: Country Name Case

2006-11-22 Thread RichL
> >> web developer > >> certified advanced coldfusion programmer > >> ICGLink, Inc. > >> [EMAIL PROTECTED] > >> 615.370.1530 x737 > >> --//-> > >> > >> -Original Message- > >> From: RichL [mailto:[EMAIL PROTECTED] &g

Re: Country Name Case

2006-11-22 Thread RichL
Thank you very much Rob I found CapFirstTitle() which looks like it may be useful On 11/22/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote: > On 11/22/06, RichL <[EMAIL PROTECTED]> wrote: > > > > Also, is there a UDF around for capitalising the first letter of ea

Country Name Case

2006-11-22 Thread RichL
Hi Guys I have a country reference table where all of the country names are held in upper case. I want to be able to output in lower case but keep the caps where appropriate (e.g. UNITED KINGDOM to United Kingdom). However I think that this going to be close to impossible as there are values suc

Re: How to strip a #

2006-11-13 Thread RichL
foo: #foo# bar: #bar# Works just fine On 11/13/06, John Cox <[EMAIL PROTECTED]> wrote: > Sorry, Rick, haven't tried this yet, got distracted on a different problem. > Will let you know! > > On 11/13/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > > > > > > > >

Re: cfDevcon06

2006-11-13 Thread RichL
Congratulations on this Russ... I know you had a few hassles along the way so I hope that you feel it was worth your time and effort I'm pretty gutted I missed this Is there anyway we could get all the presentations together for people to view who didn't/couldn't make it? On 11/13/06, Tom Chiver

Re: help on update query

2006-11-10 Thread RichL
Are you sure that URL_PASSWORD_ID had a value otherwise it may be executing: "WHERE PASSWORD_ID = " Output the variable before running the query to make sure that it isn't this On 11/10/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > Hi everybody need help on this update query which gives me a

Re: Application Var Scope

2006-11-09 Thread RichL
John I am not too sure on the domain front but the application variables will persist on a per server basis as far as I am aware, so depending on the data you are putting in to the application scope there is the potential for it to be different on different servers (if for example you are setting

Re: application.cfm question

2006-11-09 Thread RichL
John CF will just process the application.cfm of the original file not from any directory where the included file comes from (if different from the calling file) e.g. /dir1/ /dir1/dir2 - both dir1 and dir2 have their own application.cfm If you have a file in dir1 and this includes a file in d

Re: application.cfm question

2006-11-09 Thread RichL
Coldfusion will look for an application.cfm at the current folder level and carry on up the directory tree until it finds one. The first that it finds will override any further up the tree On 11/9/06, John Cox <[EMAIL PROTECTED]> wrote: > One more newb question while I am at it. Does CF load app

Re: see my query - watch it fail

2006-11-08 Thread RichL
Daniel not sure exactly what you want to see but you could try this: select * from tblbcplayer xxx will dump the results yyy will show you the following attributes: cached?, columnlist, exectiontime, recordcount, SQL executed (not sure when this 'result' attribute became ac

Re: Head Banging Access LIKE error in QoQ

2006-11-07 Thread RichL
That's strange... the syntax works ok for me if phototag is a valid column and there are records in request.photolist then it is a bit of a weird one...not much help I know but just letting you know the syntax works here On 11/7/06, Katz, Dov B (IT) <[EMAIL PROTECTED]> wrote: > Just a guess: > >

Re: OT - MS Access UPPERCASE to Lowercase

2006-10-30 Thread RichL
or you could add another table column on to set this new formatted data - depends on you needs i.e. firstNameDisplay for example and insert formatted data in to that column On 10/30/06, RichL <[EMAIL PROTECTED]> wrote: > run it as it is here if you want to update the current recor

Re: OT - MS Access UPPERCASE to Lowercase

2006-10-30 Thread RichL
run it as it is here if you want to update the current records in the table with the new value On 10/30/06, Dwayne Cole <[EMAIL PROTECTED]> wrote: > Do I run this as SQL statement or do i run an append query? > > > -- Original Message --

Re: OT - MS Access UPPERCASE to Lowercase

2006-10-30 Thread RichL
(of course that won't cater for Mary-Joe etc which would become Mary-joe or Mary Joe which would become Mary joe) On 10/30/06, RichL <[EMAIL PROTECTED]> wrote: > Dwayne > > Update tblname set firstname = UCase(Left(firstname,1)) &LCASE( > right(firstname,( Len(firstna

Re: OT - MS Access UPPERCASE to Lowercase

2006-10-30 Thread RichL
Dwayne Update tblname set firstname = UCase(Left(firstname,1)) &LCASE( right(firstname,( Len(firstname)-1))) Seems to do it ? On 10/30/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > If you have a text editor capable of changing case, then it would probably > be just as easy to select the whole

Re: Need regular expression in REReplace for email

2006-10-30 Thread RichL
Hi Karl My regular expressions are very rusty to say the least.. but I had a go using string manipulation which you could put in to a UDF seems to work ok with a variety of emails and may at least get you started. I am sure that there is a better/easier way probably using regular expressions..

Re: help on the cfif code

2006-10-30 Thread RichL
Hi Alex Glad to hear that you got it sorted Your solution seems to suggest that you have got a being used somewhere in the code (perhaps in an application.cfm/cfc page ? ) and that that is why you need to the to get your html tags to render http://www.cfquickdocs.com/?getDoc=cfsetting I reali

Re: help on the cfif code

2006-10-27 Thread RichL
Hmm I disagree on both accounts I Doug - Peter was saying that the syntax was invalid and not fit for the situation not just that you don't need an operator - which isn't true - it seems from what Alex is saying that he is dropping in to the else condition as he seems to be suggesting there i

Re: help on the cfif code

2006-10-27 Thread RichL
Hmm I did raise that point earlier Mingo but Alex says he isn't ... unless like you say it is being set elsewhere Alex you may want to add just before this code to check this or alternatively... the no risorse should override this ok... to try and cover everything try this and see what happ

Re: help on the cfif code

2006-10-27 Thread RichL
Peter are you quite sure about that? You are saying a query object will not exist from a query that returns no records? Try running a query with no records and dumping the query object? Does it complain of not existing or display an empty recordset? I think you'll find it is the latter Your logi

Re: help on the cfif code

2006-10-27 Thread RichL
Alex Have you tested if the code is definitely dropping to the 'else' condition when there are no records being retrieved - try out putting the recordcount to make sure you know what you are getting back from the query or dumping the contents before the conditional block - on the else condition,

Re: Look, up in the sky! (you gotta go do this)

2006-10-27 Thread RichL
Is this part of Adobe's marketing strategy or Ben's overwhelming enthusiasm for the new release ? :) On 10/27/06, Will Tomlinson <[EMAIL PROTECTED]> wrote: > Hilarious!! > > ~| Introducing the Fusion Authority Quarterly Update.

Re: help on the cfif code

2006-10-27 Thread RichL
Hmm I am a little stumped The only things that I can think of: - are you using anywhere ? try wrapping the text in tags - although I don't think that it is this otherwise your links wouldn't output whent there are records - some kind of CSS overide ? seems unlikely though... have you viewed so

Re: Look, up in the sky! (you gotta go do this)

2006-10-27 Thread RichL
he he he !!! On 10/27/06, Jeff Small <[EMAIL PROTECTED]> wrote: > Go to flickr and type the following three words into the search: > > "Scorpio Man Max" > > People have said that Scorpio Man and Ben Forta have never been seen > in the same place at the same timeh > > ~~~

Re: help on the cfif code

2006-10-27 Thread RichL
Hmm I am not sure I fully understand...at the moment your code will output 'no risorce' in place of any links when there are no records returned. Is this what you want? This is what is happening for me On 10/27/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > >Alex > > > >That code seems to work ok

Re: help on the cfif code

2006-10-27 Thread RichL
Alex That code seems to work ok ... I am not sure I understand exactly what your problem is ... I am getting a link if there are records from the query and a message if there isn't any records Can you explain more about what your poblem is? Rich On 10/27/06, alex poyaoan <[EMAIL PROTECTED]> wro

Re: WiFi available at MAX?

2006-10-24 Thread RichL
> It's really, really rude, not to mention distracting, to be typing away while > someone is trying to give a preso. You don't need wi-fi to type and take notes ? On 10/24/06, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Thursday 19 October 2006 22:24, John Dowdell wrote: > > but they might have

Re: zero length string

2006-10-13 Thread RichL
> >#field# Or you can do - #field# he he he ;-) :-D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a y

Re: training

2006-10-12 Thread RichL
I can't see the need/desire for training ever going completely - no matter how much resource there is from books and the web Yes I can vouch that highlander will do this ... i had some from Alex Skinner there along with several colleagues whilst supporting a high profile local govnt site. Alex ev

Re: CF SQL question

2006-10-05 Thread RichL
I'm guessing as it's a SQL error and has a where clause then it is in the SQL ! Also for the length test in CF, I would go for len(tim(variableName) (whether you put 'GT 0' after this test is the subject of another recent thread ;-) ) On 10/5/06, Kris Jones <[EMAIL PROTECTED]> wrote: > Tim, > >

Re: CF SQL question

2006-10-05 Thread RichL
Tim you can try 'IS NOT NULL' which tests for completely empty field values in a table if this is what you are trying to test? On 10/5/06, Tim Laureska <[EMAIL PROTECTED]> wrote: > I hope this is an easy one. using SQL Server 2000.. Have a query trying to > test for empty fields. tried the follow

Re: FlashPaper vs PDF

2006-10-04 Thread RichL
many thanks for that... looks like pdf is the way to go here On 10/4/06, Casey Dougall <[EMAIL PROTECTED]> wrote: > >>Is there any generally accepted preference about at the moment? > > Outside of the amount of people who have one of these two installed > programs, my main gripe with flashpaper is

Re: FlashPaper vs PDF

2006-10-04 Thread RichL
It is a good point and one that should be considered I think but if I as a developer don't really know the merits of either this makes me feel that it could potentially open the way for a bit of confusion for the user? some of them may not know what flashpaper is and without some explanatory text a

FlashPaper vs PDF

2006-10-04 Thread RichL
I've got to provide a downloadable and printable form to fill in. I am wondering which route to go down between flashpaper and pdf. Is there any generally accepted preference about at the moment? Are there any known stats for percent users with Adobe Reader vs MacrAdobe Flash installed ? >From

CF and IIS Install on new disk

2006-10-03 Thread RichL
Hi Guys I am just installing a second hard drive as slave in my PC to store all media files and then I am going to reformat my existing master disk and reinstall XP SP2. I currently have Inetpub on the existing C: master drive with CF installed in here and any website folder in here also - includ

Re: CFIF Statement

2006-10-02 Thread RichL
Neil I notice a slight subtle difference in the comparison you are making... Of course a function like IsStruct() is always going to return you a boolean value by nature of what it is asking? (However it also isn't failsafe as the variable you are evaluating isn't necessarily defined which will r

Re: Session Scope in Multi-Server Env

2006-09-27 Thread RichL
rs. > > $0.02 > > On 9/26/06, Steve Brownlee <[EMAIL PROTECTED]> wrote: > > > > Are you using J2EE version of ColdFusion? > > > > -Original Message- > > From: RichL [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 26, 2006 4:44 AM &g

Session Scope in Multi-Server Env

2006-09-26 Thread RichL
I am in the process of developing new applications from scratch I need to move data around several pages of an app with all data relating to the current user accessible from each page in the application The obvious choice for me would be to use session scope but after speaking to permanent member

Re: Error on Query of Queries

2006-09-22 Thread RichL
ww.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:17237 > > > > > >On 9/22/06, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote: > >> > > Hi RichL, > The link you have given is about the same problem i had &

Re: Error on Query of Queries

2006-09-22 Thread RichL
Selva are you manually creating the first query by using querynew() etc? there is something on this page that may or may not apply for you: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:17237 On 9/22/06, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote: > Email : [EMAIL PROTECTED]

Re: How to get these query results - Take 2

2006-09-21 Thread RichL
Jim... nice work.. I am not overly familiar with using the Select in the order by column but it works great in MS-SQL as you say (MS Access doesn't seem to like it ! ) On 9/20/06, Jim Wright <[EMAIL PROTECTED]> wrote: > Matt Williams wrote: > > Rich, you are right in that I want the event with the

Re: How to get these query results - Take 2

2006-09-20 Thread RichL
clever" solution too as this is > > actually an OO-style app where I hope to have a CFC return the query > > results for me. I suppose I could just build a new query with QueryNew > > instead of the output as you show. > > > > BTW, your test.cfm page wouldn&

Re: How to get these query results - Take 2

2006-09-20 Thread RichL
I presume the design is based on one table for the event names and a separate for instances of those events on a given date which seems sensible. Matt if you need the output based on the event names alphabetically and then the dates desc in them then Jim/Kris code is great... my assumption was th

Re: How to get these query results - Take 2

2006-09-20 Thread RichL
Matt You can try the following. It seems to work... my gut feeling tells me there may be an easier way with less queries but I can't think of anything right now. You may want to consider caching queries for speed depending on how much the data is changing. select * from tblEvent

Re: How to get these query results

2006-09-20 Thread RichL
Doug I too thought that the 'join' syntax was more proper but you do make a very valid point... the WACK does actually go in to some depth about joins using the where clause as perfectly acceptable before moving on to show the 'join syntax' as being an alternative. to quote from the book: "Both

Re: SQL in a variable

2006-09-18 Thread RichL
that looks like a handy attribute, although like you say James the SQL value doesn't look so easy straight forward to use once you use the CFQUERYPARAM on the ingoing query attribute. !? :o/ On 9/18/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > James, > > In CFMX 7, there's an attribute cal

Re: Free Coldfusion Hosting that lets me connect to MS Access Database

2006-09-08 Thread RichL
It may do but I have a feeling that this is only being offered to UK based people at the moment but I may be wrong ! On 9/8/06, David Low <[EMAIL PROTECTED]> wrote: > > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > > Sent: 08 September 2006 15:52 > > To: CF-Talk > > Subject: Re: Free Coldfusio

Re: Updating multiple records with different values

2006-09-07 Thread RichL
apologies it's been a really long day !! try also: set fld_qty_shipped = #evaluate(FORM.fld_qty_shipped & Qty)# although I am not 100% sure if this is the source of the error... today is a bit manic and I don't have too much spare time to look at other bits this afternoon On 9/7/06, Web Master

Re: Updating multiple records with different values

2006-09-07 Thread RichL
not 100% sure what you are trying to do with this last where clause: where fld_item_ID = 'evaluate(#FORM.fld_item_ID# & #Qty#)' are you trying to concatenate the form.fld_item_id with the qty variable? I think that SQL is trying to update where records match that whole piece of text in single qu

Re: Weird CGI error

2006-09-05 Thread RichL
You could try CGI instead of GGI ??? On 9/5/06, Richard Cooper <[EMAIL PROTECTED]> wrote: > Hi, > > I'm getting and odd CGI variable error. > > I've wrapped CGI.query_string in a if stament. However, when there is a query > string and the if statment is confirmed I receive this error: > > Element

Re: Quick Question

2006-08-31 Thread RichL
I thought the second parameter was the new list delimiter? (third the old) ? On 8/31/06, Ben Forta <[EMAIL PROTECTED]> wrote: > ListChangeDelims() > > In your example: > > > > --- Ben > > > -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 31, 2006 8

Re: Quick Question

2006-08-31 Thread RichL
try: #mylist#, #newlist# On 8/31/06, Doug Brown <[EMAIL PROTECTED]> wrote: > Say I have a list > > > > What list function would I use to make it > > test1-test2-test3 > > > Sorry for the newb question!! > > ~| Introducing

Re: Ajax - Whats everybody using?

2006-08-31 Thread RichL
I'm newbie to Ajax and just having a look at the mxAjax examples now - there is some really cool stuff on there I am going to have a bit of a further look in to it - exciting stuff On 8/31/06, James Holmes <[EMAIL PROTECTED]> wrote: > Yes, it's to replace cfajax. > > The benefits are many: > > 1)

Re: formatting cfoutput from memo field

2006-08-30 Thread RichL
Check for the existence of desired words and apply different CSS class to them if they meet your criteria? On 8/30/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > HI formatting output for memo fields is always a problem for me.. used > ParagraphFormat() or replace(field, , all) just resolved the ca

Re: cfdirectory - Security: The requested template has been denied access to

2006-08-29 Thread RichL
Brett I do something similar to this and encountered a similar problem I have a non CF based host where I upload any media files. I wanted to be able to dynamically supply (e.g. URL variable) a folder name within the media folder and have CF find all the file names within that folder, then loop a

Re: CF and SQL or just SQL?

2006-08-29 Thread RichL
D I'm not sure if I 100% understand what you need to do but I think that based on an id of a variable you need to: - find the 10 integer range that it is in and calculate the start and end values for that range - based on the range you need to work out a current page number in a set of pages and th

Re: cfloop conditional help

2006-08-25 Thread RichL
from how i understood this the loop was only being used to ascertain the final range start and end values? if you are using int/ceiling to find these out - then the looping isn't necessary ? On 8/25/06, Gert Franz <[EMAIL PROTECTED]> wrote: > > > > > > > > Greetings / GrĂ¼sse > Gert Fran

Re: cfloop conditional help

2006-08-25 Thread RichL
this should work if i understand what you are trying to do: On 8/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I want to loop over a URL.VIDEO_ID value and find the numeric range it > falls in. > The value range needs to be between 1-10 or 11-21 etc. until the condition > is met.