Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. janinja

    XmlParse - 'premature end of input' error message

    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!
  2. janinja

    XmlParse - 'premature end of input' error message

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

    Return rows ignoring duplicates over a particular field

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

    Return rows ignoring duplicates over a particular field

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

    Return rows ignoring duplicates over a particular field

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

    Return rows ignoring duplicates over a particular field

    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 :)
  7. janinja

    Return rows ignoring duplicates over a particular field

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

    Return rows ignoring duplicates over a particular field

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

    Return rows ignoring duplicates over a particular field

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

    hittest action performed once only?

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

    hittest action performed once only?

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

    opening windows

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

    opening windows

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

    Add today's date to a month from now!

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

    ESCAPE chars for XML special char results fetched via CFHTTP

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

    change a page according to date

    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!
  17. janinja

    change a page according to date

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

    broken javascript in included file

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

Part and Inventory Search

Back
Top