Recent content by gtbikerider

That worked perfectly Lyndon - Thank you. -- John

I have a way for people to search for database records. I want to find plurals and singular so I want to strip the 's' off their keyword. So far I have <!--- trim off the s if its plural ---> <cfif #right(Attributes.Keywords,1)# IS "s"> cfset the Attributes.Keywords to be trimmed 1 char from...

Actually the £ is replaced with little squares but tek-tips replaced those with ?? -- John

In mySQL4.1 I have stored £100. However when I do a query and a CFoutput I see ??100. Any ideas why? -- John

I'm trying to store foreign characters in mySQL 4.1 and ColdFusion. Until recently I used Access. The user entered "ö" into a form and "ö" got stored in the database. Now I'm trying to move to mySQL 4.1. The user enters say "Malmö" in a form field and "Malm" gets stored in mySQL (in other...

I'm using the following code to insert into an Access db... <cfquery datasource="dsn" name="subscribe"> INSERT INTO email_addresses (listID, emailaddress) VALUES ('1', '#Form.emailaddress#') </cfquery> But I get the error... "Error casting an object of type to an incompatible type. This...

I'm a real MySQL newbie but I think I have MySQL5 installed and a db created on localhost:3306 (SQL Manager 2005 Lite tells me this is OK) In the CF administrator I type the datasource name. When I select a driver from the drop down there is no MySQL 5 so I select MySQL3.x (is this a problem?)...

Hi Wullie That worked a treat - Thanks. Thanks for your great hosting too! -- John

Hi I'm using <img src="#ImageSRC#" alt="#ImageName#" /> to show an image and alt tag. The problem is that the ImageName sometimes contains a " (to mean inches) and this causes the tag to close early when rendered eg <img src="ruler.gif" alt="12" ruler" /> Is there a way to force the...

Hi I have a word document where all the text is inside hundreds of frames (its been exported from pdf). How can I globally remove all the frames and leave it as 'inline' text? (I need to keep images and formatting) -- John

I can see that cfdirectory gives me a list of documents. But I need to display them in a 'windows explorer'-like way? (with a click on the folder giving access to the files it contains? Do you know of a code example? -- John

My customer uploads files into folders they create. I need to display those folders and files. I'd expect this to reletively common and easy requirement but I'm stuck. Should I look at cfdirectory to get the information? CFtree to display (I'm not keen that its java)? Some Flex solution? Or is...

How would I then display a list of files in the root, and click on the folder name to display files in that folder? -- John

The code is... <cfset weeknumber = #week(NOW())#> <cfoutput>#weeknumber#</cfoutput> ...nothing else. I found that on my live server I also get week 40 - its just something about my local machine that gives week 41. I guess I can live with it now I know my live machine is OK, but I'd be...

I'm using <cfset weeknumber = #week(NOW())#> to get the week number. It tells me that it is week 41. However this site http://www.onlineconversion.com/day_week_number.htm tells me that it is actually week 40. Why the discrepancy? (My system date is set to 6/10/2006 (uk format)) -- John