QoQ and MOD function

[safo kaska]

newbie question

 i am using the following QoQ

<cfquery name="qaccbytyp" dbtype="query">select * 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=17837.14401.4

[James Holmes-3]

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 <safokaskas@...>:

>
> newbie question
>
>  i am using the following QoQ
>
> <cfquery name="qaccbytyp" dbtype="query">select * 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=17837.14401.4

[safo kaska]

so what can I do??????

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328168
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[safo kaska]

so what can i do?????



> newbie question
>
 

> i am using the following QoQ
>
> <cfquery name="qaccbytyp" dbtype="query">select * 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:328166
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[safo kaska]

so what can I do?????

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328169
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[safo kaska]

so what can I do ?????

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328167
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[safo kaska]

so what can i do???

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328170
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Paul Kukiel]

> elect * 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

There is no and or or between aab='#sanad.saab#' andsaan='#sanad.saan#'

I'd try fix that first.  But mod might not work in QoQ never tried.

Paul


On Nov 10, 2009, at 2:27 AM, safo kaskas wrote:

>
> so what can i do?????
>
>
>
>> newbie question
>>
>
>> i am using the following QoQ
>>
>> <cfquery name="qaccbytyp" dbtype="query">select * 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:328171
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Phillip Vector]

<cfset modvalue= MOD(C,#ABS(firstD)#)>

<cfquery name="qaccbytyp" dbtype="query">select * from data where
saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and
(sadrf='#manyref.sadrf#' or C=#lastD# or #modvalue# =0 )</cfquery>

On Tue, Nov 10, 2009 at 12:08 AM, safo kaskas <safokaskas@...> wrote:
>
> so what can i do???
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328172
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Stefan Richter-3]

I'm using cflogin and cflogout on my site.
A user is logged into http://www.mysite.com and then clicks log out. I  
run cflogout and redirect her to http://mysite.com  (note I missed the  
www off).

There seems to be some kind of double session going on when I  
previously logged into http://www.mysite.com as well as http://mysite.com 
  because after the logout I still see to be logged in as the user who  
previously logged into the other respective site (of course there is  
only one site).

I hope this makes sense. Is this expected behaviour?

Stefan



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Dave Phillips-10]

Yes, I believe so.  www is a 'subdomain', albeit a standard one, just like
any other 'subdomain' (whatever.mysite.com for example) and each one
represents a potentially different domain and therefore a different session.

I've experienced this to, but in a positive way.  When I did a site for a
client, the requirement was to create 'affiliate' sites like this:

Affiliate1.mysite.com
Affiliate2.mysite.com

And so on.....this worked to my advantage of course, if someone was on
affiliate1's site and logged in and doing something, they should not be
logged into affiliate2's site and vice versa.

Dave Phillips

-----Original Message-----
From: Stefan Richter [mailto:stefan@...]
Sent: Tuesday, November 10, 2009 8:03 AM
To: cf-talk
Subject: CFLogout confusion


I'm using cflogin and cflogout on my site.
A user is logged into http://www.mysite.com and then clicks log out. I  
run cflogout and redirect her to http://mysite.com  (note I missed the  
www off).

There seems to be some kind of double session going on when I  
previously logged into http://www.mysite.com as well as http://mysite.com 
  because after the logout I still see to be logged in as the user who  
previously logged into the other respective site (of course there is  
only one site).

I hope this makes sense. Is this expected behaviour?

Stefan





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328175
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Paul Alkema]

What Stefan said is true.

Also, as a general rule I would pick either http://www.mysite.com or
http://mysite.com for your site and 301 redirect the one that your not using
to the domain that you are using as search engines will see typically see
the two sites as being two different websites and therefore they'll index
both of them. This is really bad for SEO purposes as search engines see this
as being duplicate content. : )

Paul Alkema
Application Developer
http://www.alkemadesigns.com/

On Tue, Nov 10, 2009 at 9:03 AM, Stefan Richter <stefan@...>wrote:

>
> I'm using cflogin and cflogout on my site.
> A user is logged into http://www.mysite.com and then clicks log out. I
> run cflogout and redirect her to http://mysite.com  (note I missed the
> www off).
>
> There seems to be some kind of double session going on when I
> previously logged into http://www.mysite.com as well as http://mysite.com
>  because after the logout I still see to be logged in as the user who
> previously logged into the other respective site (of course there is
> only one site).
>
> I hope this makes sense. Is this expected behaviour?
>
> Stefan
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328179
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Rob Voyle-2]

Hi folks

I have about 6 sites that run CF and need to move them to a new host.

any recommendations? I see that godaddy offers CF for $1.99 a month. Has
anyone used them. Or does anyone have any recommendations.

I am tired of being on small providers that seem to get bought and sold by who
knows what.

Thanks

Rob



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328180
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Dave Watts]

> Yes, I believe so.  www is a 'subdomain', albeit a standard one, just like
> any other 'subdomain' (whatever.mysite.com for example) and each one
> represents a potentially different domain and therefore a different session.

While you're correct on the important parts, www (in this case at
least) is not a subdomain, it's a host name. A subdomain is a domain
within a larger domain.

For example, in the domain figleaf.com, I have hosts www and training,
and you can get to those via HTTP. I also have a subdomain,
gsa.figleaf.com, which contains its own hosts.

To describe this even more accurately, figleaf.com is a subdomain of
.com, and gsa.figleaf.com is a subdomain of figleaf.com.

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:328181
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Jason Fisher-3]

Have been very happy with CrystalTech.  About $24 / quarter on shared
hosting, and they've been solid.  Lots of file space and plenty of DB space
for my needs.
 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328182
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Kevin Pepperman]

By default CF sets the cookie in only the domain it is on."mydomain.com" But
cfcookie does not let you set the domain name for the cookie.

So you couldn't use the cookies session across sub domains. eg "
one.mydomain.com"

I have had situations where I had to overwrite the session cookies that CF
sets on each request with cfheader, that way I could specify the .subdomain.

This also allows you to use the HTTPOnly flag.

 <cfheader name="Set-Cookie" value="CFID=#SESSION.CFID#;path=/;domain=.
mydomain.com;expires=MON, 21-Dec-2009 00:00:00 GMT;HTTPOnly;" />
<cfheader name="Set-Cookie" value="CFTOKEN=#SESSION.CFTOKEN#;path=/;domain=.
mydomain.com;expires=MON, 21-Dec-2009 00:00:00 GMT;HTTPOnly;" /)>

(note the dot in ".mydomain.com")

/K


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328184
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[James Holmes-3]

I can only recommend Viviotech.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/11/10 Rob Voyle <robvoyle@...>:

>
> Hi folks
>
> I have about 6 sites that run CF and need to move them to a new host.
>
> any recommendations? I see that godaddy offers CF for $1.99 a month. Has
> anyone used them. Or does anyone have any recommendations.
>
> I am tired of being on small providers that seem to get bought and sold by who
> knows what.
>
> Thanks
>
> Rob
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328185
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Stefan Richter-3]

I think I know what subdomains are and how they work, but www. - while  
technically a subdomain - is attached to the same vhost/site as the  
straight http version. That's why I am a bit confused.

Cheers

Stefan



On 10 Nov 2009, at 15:08, Kevin Pepperman wrote:

>
> By default CF sets the cookie in only the domain it is on."mydomain.com
> " But
> cfcookie does not let you set the domain name for the cookie.
>
> So you couldn't use the cookies session across sub domains. eg "
> one.mydomain.com"
>
> I have had situations where I had to overwrite the session cookies  
> that CF
> sets on each request with cfheader, that way I could specify  
> the .subdomain.
>
> This also allows you to use the HTTPOnly flag.
>
> <cfheader name="Set-Cookie" value="CFID=#SESSION.CFID#;path=/;domain=.
> mydomain.com;expires=MON, 21-Dec-2009 00:00:00 GMT;HTTPOnly;" />
> <cfheader name="Set-Cookie"  
> value="CFTOKEN=#SESSION.CFTOKEN#;path=/;domain=.
> mydomain.com;expires=MON, 21-Dec-2009 00:00:00 GMT;HTTPOnly;" /)>
>
> (note the dot in ".mydomain.com")
>
> /K

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328186
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

James,

Have you thought of cloud hosting using BD or Ralio?

-mark


Mark A. Kruger, CFG, MCSE
[phone] ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-----Original Message-----
From: James Holmes [mailto:james.holmes@...]
Sent: Tuesday, November 10, 2009 9:16 AM
To: cf-talk
Subject: Re: Hosting options


I can only recommend Viviotech.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/11/10 Rob Voyle <robvoyle@...>:

>
> Hi folks
>
> I have about 6 sites that run CF and need to move them to a new host.
>
> any recommendations? I see that godaddy offers CF for $1.99 a month.
> Has anyone used them. Or does anyone have any recommendations.
>
> I am tired of being on small providers that seem to get bought and
> sold by who knows what.
>
> Thanks
>
> Rob
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328187
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[James Holmes-3]

I haven't yet, no.

I have however just rebuilt my server on a newer platform, using Railo
and Tomcat rather than BD. Railo is truly awesome. Tomcat really
sucks. I can see why the Railo folk provide it with Resin instead.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

2009/11/10 Mark Kruger <mkruger@...>:
>
> James,
>
> Have you thought of cloud hosting using BD or Ralio?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328188
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4