Search results for query: *

I managed to solve the problem - was nothing to do with the xml file after all - but I had a syntax error in my loop - oops!

Hello, I'm using cfhttp get to retrieve and xml file, which works fine. However, when I try to parse the cfhttp.filecontent with the xmlparse function, I get the error message - 'Premature end of input'. I know that this must be a problem with the xml file itself as I've used this method of...

James - I got your query to work by writing the MIN(TimeStamp)in the select as: MIN(TimeStamp) AS TimeStamp And then I added the distinct keyword to the query and it didn't fall over so I presume it's working OK now. I have also seen no more duplicates! Here's the finished and working query...

The data type of the timestamp column is datetime. I need to collect the data from that column so we know exactly when people entered the comp. When I tried your query, it wouldn't output the timestamp data further down the page: "The column TIMESTAMP is not present in the query named...

Thank you for that, but I can't get it to work unfortunately. It doesn't seem to include the timestamp column because I'm getting this message returned: The column TIMESTAMP is not present in the query named QUERY. It is likely that you have misspelled the name of the column.

If I removed the timestamp column it would work fine. But I need the timestamp info too unfortunately. I think I just have to accept that DISTINCT can't run over one column in a list and find another way of doing it (sigh) ninja :)

I need to return them all unfortunately. The other info is needed to be sent on to the companies that sponsor the comps.

I'm returning entries for a competition - some users have entered more than once so I'm trying just to return one row per email address. I tried using distinct, but it applied the 'distinct' over all the columns in the row, instead of just the email column. That could have worked - but because...

Hello everyone, I've written the following query which worked fine until I added the Group By clause. SELECT DISTINCT Email,FormName,Timestamp,FirstName,LastName,Street,Town,City,County,Postcode,DayPhone,Newsletter,MoreInfo,Other FROM #TName# WHERE FormName = '#CName#' GROUP BY Email ORDER BY...

Thanks Frozenpeas, that worked. But I found that it only did it once, and then once the sleighit var had been defined it wouldn't work again. In the end I worked around the problem by telling the colliding movie clip to skip the rest of the frames of the collision and carry on.

Hello, I've made a game and set an action so that the score increments when two movie clips collide: onClipEvent (enterFrame) { if (this.hitTest(_root.sleigh.present)) { var /:lost = number(/:lost)+1; } } But I'm finding that instead of incrementing once only, it continues to...

oops I didn't see mwolfs reply before I posted mine! sorry.

This is a local forum for local people! Hi Johnnygogogogo I can't get that to work either, but if you use a simple javascript popup function and call the function from the link, then it will work. eg put this in your first page: <script> function openpopup(){ var...

You can also use the code above to subtract an amount of time from a date, by appending your number with a minus sign: <cfset NewDate = DateAdd(&quot;m&quot;, -2, Now())> Will return the current date minus two months. Coldfusion seems to automatically compensate for the differing amount of...

I've succesfully managed to parse with cfwddx a page of XML retrieved via cfhttp. However, when I try to retrieve a structure containing an &, I get the following error message: 'Expression result cannot be converted to a string'. I have trawled through this site and cfdev trying to find out...

I don't want to keep one page and change the content according to the date, I want to actually make a different page load according to the date : ( can't work out how to do it!

Does anyone know how I can automatically change a page according to the date? In my case, I need to do it for a daily horoscope page over the christmas period when I can't come into work. I was thinking along the lines of using something like CF schedule but I'm not too sure so if anyone has...

Trying to implement a javascript image clock which sits in an included file to be used throughout my website. Have mapped all the images with virtual paths, and it works fine when I test the included file on it's own. However, when I browse the file as an include in another page, it doesn't...