QoQ and MOD function
newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error.Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
The MOD function isn't available in Query of Queries. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/11/8 safo kaska safokas...@hotmail.com: newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error.Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Element thumbnail is undefined in a Java object of type class coldfusion.xml.XmlNodeList.
I don't understand how this is failing... keeps on saying thumbnail doesn't exist... BUT the next node down is content which DOES exist. I'm trying to set lists of things based on the reply back from livestream.com API and everything is ok but these thumbnail Element thumbnail is undefined in a Java object of type class coldfusion.xml.XmlNodeList. item XmlText title XmlTextDj Necro - Fri Apr 10 2009 link XmlText pla_1521349091473958947 description XmlText pubDate XmlTextSun, 04 Jan 2009 03:32:38 GMT guid XmlText pla_1521349091473958947 dc:date XmlText2009-01-04T03:32:38Z media:thumbnail XmlText XmlAttributes struct height 100 url http://mogulus-user-files.s3.amazonaws.com/chv2torqdjtv/2009/04/09/9b5dd820-b625-4129-9e74-bae70d863eb6_990.jpg width 100media:content XmlText XmlAttributes struct duration 1963096 type video/x-flv url http://www.livestream.com/torqdjtv/ondemand/pla_1521349091473958947 cfloop index=i from=1 to=#request.ListClips.totalClips# step=1 This Doesn't Work: cfset request.ListClips.thumbnailurls = ListAppend(request.ListClips.thumbnailurls, ListClips.Reply[rss][channel][item][i][thumbnail][XmlAttributes][url], ',') But this DOES Work: cfset request.ListClips.durations = ListAppend(request.ListClips.durations, ListClips.Reply[rss][channel][item][i][content][XmlAttributes][duration], ',') /cfloop Any ideas of what I'm missing here? This is their API over view with the sample XML return. http://www.livestream.com/userguide/index.php/Channel_API#List_Clips Casey ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element thumbnail is undefined in a Java object of type class coldfusion.xml.XmlNodeList.
I don't understand how this is failing... keeps on saying thumbnail doesn't exist... BUT the next node down is content which DOES exist. From the docs: If the thumbnail is not available for the clip then the element media:thumbnail will not be present. Maybe there aren't any thumbnails. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
The start of a pure CF - CFX_POP3 replacement :-)
So I've finally started a CFX_POP3 replacement project and I'm open sourcing the thing too :-) http://popcfc.riaforge.org/ At the moment it has functions that can extend the POP functionality in CFPOP to match that of CFX_POP3 and I've added some extra functions too. There are features that are missing from POPCFC that are in CFX_POP3 such as the SPAM filtering Bayesian analysis functions but the main POP processing functions that are missing from CFPOP are in there such as... - hasMail() returns a Boolean if the mailbox has mail. - getMessageCount() returns the number of mails in the mailbox. - getUIDList() returns an array of UID values for the messages in the mailbox. - getMessagesAfterUID() returns all messages (up to maxrows) that have been received since the message specified by the UID passed in. Performance wise, these functions are as fast or faster than CFX_POP3. You can use the CFC as follows: !--- normal usage --- cfset popAccount = createObject(component, pop).init(myserver, myusername, mypassword) cfif popAccount.hasMail() cfset messages = popAccount.getMessages() cfdump var=#messages# /cfif - OR - !--- SSL usage --- cfset popAccount = createObject(component, pop).init(myserver, myusername, mypassword) cfset popAccount.setProperty(UseSSL, true) cfif popAccount.hasMail() cfset messages = popAccount.getMessages() cfdump var=#messages# /cfif Hope you like it! If anyone finds any problems with it, be sure to let me know :-) Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
!DOCTYPE double byte issue
Hi all, I have a strange problem where with: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.1//EN http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd; pages in IE 8 don't properly display asian characters (it displays ok in FF) but with : !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN pages are displayed correctly in both browser. I have cfcontent type=text/html; charset=utf-8 in Application.cfc and even tried meta http-equiv=Content-Type content=text/html;charset=utf-8 on the page but no luck with IE. Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
