Re: Contract rates

2007-04-12 Thread RichL
it should really be classed as 'permanent' then I think they need to go, room 101 for the agency! *pulls the lever. Hope that helps, Rob -Original Message- From: RichL [mailto:[EMAIL PROTECTED] Sent: 11 April 2007 16:44 To: CF-Talk Subject: Contract rates Hello guys I was hoping

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

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

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 quick answers and I

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

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

Dynamic Where Syntax

2006-12-21 Thread RichL
Guys I am trying to build up a where clause dynamically as follows: cfset whereClause = 'Where 1 = 0 or ' loop with i as a numeric index value... cfset whereClause = whereClause '(centreid = cfqueryparam cfsqltype=cf_sql_numeric value=#i# and cplname = cfqueryparam cfsqltype=cf_sql_varchar

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: cfset qtext=spanish cfoutput query=#qtext# 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

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: I think

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-2d5e1db91038displaylang=en and

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

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 each word? Take a look at initCapTitle() (I

Re: Country Name Case

2006-11-22 Thread RichL
- From: RichL [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 5:03 AM To: CF-Talk Subject: Country Name Case 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

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 cfset test = 2006-02-11 00:00:00.0 cfoutput#parseDateTime(test)# |

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

Re: How to strip a #

2006-11-13 Thread RichL
cfset foo = hello##goodbye !--- results in 'hello#goodbye' --- cfset bar = replace(foo, Chr(35), , all) cfoutput foo: #foo# br / bar: #bar# /cfoutput Works just fine On 11/13/06, John Cox [EMAIL PROTECTED] wrote: Sorry, Rick, haven't tried this yet, got distracted on a

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.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

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

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: 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: cfquery name=xxx datasource=fclounge result=yyy select * from tblbcplayer /cfquery cfdump var=#xxx# label=Query Results cfdump var=#yyy# label=Query Attributes xxx will dump the results yyy will show you the

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: You

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 cfsetting enablecfoutput=yes being used somewhere in the code (perhaps in an application.cfm/cfc page ? ) and that that is why you need to the cfoutput to get your html tags to render

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

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: 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(firstname)-1))) Seems to do it ? On 10

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 -- From: RichL [EMAIL

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 records in the table

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]

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 ... I

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 a little stumped The only things that I can think of: - are you using Cfsetting enablecfoutput=yes anywhere ? try wrapping the text in cfoutput 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

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. 80

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

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

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 cfsetting enablecfoutput=no just before this code to check this or alternatively... the cfoutputpno risorse/p/cfoutput should override this ok... to try

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

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 the

Re: zero length string

2006-10-13 Thread RichL
cfoutputa href=cfif len(trim(field)) GT 0file.cfmcfelse##/cfif#field#/a/cfoutput Or you can do - cfoutput a href=cfif len(trim(field))file.cfmcfelse##/cfif#field#/a /cfoutput he he he ;-) :-D ~| Introducing the Fusion

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

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 following

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, I'm

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

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

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 -

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

Re: Session Scope in Multi-Server Env

2006-09-27 Thread RichL
: Are you using J2EE version of ColdFusion? -Original Message- From: RichL [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 4:44 AM To: CF-Talk Subject: Session Scope in Multi-Server Env I am in the process of developing new applications from scratch I need

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

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: Error on Query of Queries

2006-09-22 Thread RichL
:17237 On 9/22/06, Selvakumar Selvaraj [EMAIL PROTECTED] wrote: Hi RichL, The link you have given is about the same problem i had and ofcourse it solves the issue. Thanks a lot for ur timely help. Selva

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

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: 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. !--- get all event details --- cfquery

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

Re: How to get these query results - Take 2

2006-09-20 Thread RichL
a new query with QueryNew instead of the output as you show. BTW, your test.cfm page wouldn't load for me. Server not found error. Thanks, Matt On 9/20/06, RichL [EMAIL PROTECTED] wrote: Matt You can try the following. It seems to work... my gut feeling tells me there may

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 called

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 Coldfusion Hosting

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

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: 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: 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) Arjun

Re: Quick Question

2006-08-31 Thread RichL
try: cfset myList = test1 test2 test3 cfset newList = listchangedelims(myList,-, ) cfoutput#mylist#, #newlist#/cfoutput On 8/31/06, Doug Brown [EMAIL PROTECTED] wrote: Say I have a list cfset myList = test1 test2 test3 What list function would I use to make it test1-test2-test3

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: cfset myList=ListChangeDelims(myList, , -) --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED]

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, br, all) just resolved the

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

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

Re: cfloop conditional help

2006-08-25 Thread RichL
this should work if i understand what you are trying to do: !--- set start to id divided by 10, rounded down to nearest integer. Multiply by ten and add one --- cfset start = (int(url.video_id/10) * 10) + 1 !--- set end to id divided by 10 and rounded up, multiply by 10 --- Cfset end =

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: cfset iStart = Int(url.video_id/10)*10 + 1 cfset