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...
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
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...
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
I want to show an event only if it's in the future, so I used...
<cfif #Dateformat(NOW(),"dd mm yyyy")# LTE "10 02 2006">
This is an event that occurs on 2nd Oct 2006
</cfif>
However I also only want to only show it, if it's less than (say) 60 days in the future - how would I evaluate the date...
I've got a series of variables from a database consisting of some words...
"one two three"
"four five"
"six seven eight nine"
...in each case I need to trim the variable to show just the first word...
"one"
"four"
"six"
...is this possible please?
--
John
I was hopeful that was a fix but unfortunatley the problem persists. I also tried unattaching the template and reapplying it.
The problem only occurs when its inside the style attribute - this must be a clue but I can't think how it helps.
Any other ideas?
--
John
...in my site.
I enter the following code in the template (i've tried with the cfoutput in 3 different places to try and investigate the problem)
**********************************************
<cfoutput>#range#</cfoutput>
<div class="col3" style="padding-top:0px; background-image...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.