Re: trying to get a query for a year

AND year(c.DtChildCreated) = 2011 On Thu, Aug 7, 2014 at 5:23 PM, Matthew Smith wrote: > > Off on my where clause: > > WHERE ft.Tag = 'bor' > AND c.DtChildCreated > 2011-01-01 > AND c.DtChildCreated < 2012-01-01 > > > > Getting 0 records. > > -- > Regards, > chedder is bedder > > > ~~~

trying to get a query for a year

Off on my where clause: WHERE ft.Tag = 'bor' AND c.DtChildCreated > 2011-01-01 AND c.DtChildCreated < 2012-01-01 Getting 0 records. -- Regards, chedder is bedder ~| Order the Adobe Coldfusion Anthology now! http://www.am

Re: still need help with query

You are still naming your functions and queries with same name. Other than that, what error are you getting? On Thu, Jun 12, 2014 at 7:50 PM, Matthew Smith wrote: > > returntype="query"> > > >name="qry_ordersGet" > datasour

Re: still need help with query

Seriously On Jun 13, 2014 12:03 PM, "Cameron Childress" wrote: > > On Fri, Jun 13, 2014 at 11:48 AM, Matthew Smith wrote: > > > The web site you are accessing has experienced an unexpected error. > > Please contact the website administrator. > > > > I am done helping till I see the code in a Gis

Re: still need help with query

There is an asterisk outside the tag. * On Jun 13, 2014 11:50 AM, "Matthew Smith" wrote: > > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > > The following information is meant for the website developer for > debugging purpose

Re: still need help with query

* Try removing the space before the /cfcs... . On Fri, Jun 13, 2014 at 11:48 AM, Matthew Smith wrote: > > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > > The following information is meant for the website developer for > de

Re: still need help with query

On Fri, Jun 13, 2014 at 11:48 AM, Matthew Smith wrote: > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > I am done helping till I see the code in a Gist and a screenshot. -Cameron ... ~~

Re: still need help with query

The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes.Error Occurred While Processing Request Context validation error for tag cffunction.The

Re: still need help with query

On Fri, Jun 13, 2014 at 11:42 AM, LRS Scout wrote: > Change = to in on lines 26 & 30 > Tim's right, the SQL I posted was just your original SQL. It was just an illustration of where to put the CFTRY and CFCATCH. Matt, just wrap the CFQUERY in a TRY/CATCH, run it, do the screenshot and then post

Re: still need help with query

Change = to in on lines 26 & 30 On Jun 13, 2014 11:40 AM, "Cameron Childress" wrote: > > On Fri, Jun 13, 2014 at 9:57 AM, Matthew Smith wrote: > > > What should they be? Thanks! > > > Something like this > > https://gist.github.com/cameroncf/d0786acf48ce377d2dd8 > > -Cameron > > -- > Cameron Chi

Re: still need help with query

On Fri, Jun 13, 2014 at 9:57 AM, Matthew Smith wrote: > What should they be? Thanks! Something like this https://gist.github.com/cameroncf/d0786acf48ce377d2dd8 -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook | twitter

Re: still need help with query

>> >>>>> >>>>> i dunno, I call them stupid procedures ;) >>>>> >>>>> >>>>>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout >> wrote: >>>>>> >>>>>> >>>&g

Re: still need help with query

@gmail.com> wrote: >> >> >> >>> >> >>> i dunno, I call them stupid procedures ;) >> >>> >> >>> >> >>>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout >> wrote: >> >>>> >> >>

Re: still need help with query

ph0d.b33bl3b...@gmail.com> wrote: > >> > >>> > >>> i dunno, I call them stupid procedures ;) > >>> > >>> > >>>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout > wrote: > >>>> > >>>> > >>>> That

Re: still need help with query

ave read stored, not stupid, sorry >>>>> On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: >>>>> >>>>> That's the big int vs int thing again. >>>>> >>>>> Also, your error messages are gonna s

Re: still need help with query

> > > > > The resultset is a number not the qry returned ie the default is 1 > > > > > > > > . > > > >> On Fri, Jun 13, 2014 at 8:48 AM, Matthew Smith > wrote: > >> > >> output="no" > >> returntype=&q

Re: still need help with query

-todatabase.cfc: line 832* *Called from* D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 > On Jun 13, 2014, at 9:52, Sam wrote: > > > The resultset is a number not the qry returned ie the default is 1 > > > > . > >> On Fri, Jun 13, 2014 at 8:48 AM, Matthew Smith

Re: still need help with query

Single int value > On Jun 13, 2014, at 9:40, Sam wrote: > > > I see orderkeylist as BIGINT > Since it has "list" in the name declared as a string, I'm guessing it > has commas. That won't work as a bigInt > > . > > ~| Orde

Re: still need help with query

mail.com> wrote: >>> >>>> >>>> i dunno, I call them stupid procedures ;) >>>> >>>> >>>>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout wrote: >>>>> >>>>> >>>>> That sh

Re: still need help with query

The resultset is a number not the qry returned ie the default is 1 . On Fri, Jun 13, 2014 at 8:48 AM, Matthew Smith wrote: > > returntype="query"> > > >name="qry_ordersShippingAddressGet" > datasource="#variables.datasour

Re: still need help with query

t; zaph0d.b33bl3b...@gmail.com> wrote: >> > >> >> >> >> i dunno, I call them stupid procedures ;) >> >> >> >> >> >>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout >> wrote: >> >>> >> >>> >> >>>

Re: still need help with query

> > >>> > >>> That should have read stored, not stupid, sorry > >>>> On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: > >>>> > >>>> That's the big int vs int thing again. > >>>> > >>>>

Re: still need help with query

gt; That should have read stored, not stupid, sorry > > > On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: > > > > > > > That's the big int vs int thing again. > > > > > > > > Also, your error messages are gonna suck in a stup

Re: still need help with query

t wrote: >>> >>> >>> That should have read stored, not stupid, sorry >>>> On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: >>>> >>>> That's the big int vs int thing again. >>>> >>>> Also, your error messag

Re: still need help with query

I see orderkeylist as BIGINT Since it has "list" in the name declared as a string, I'm guessing it has commas. That won't work as a bigInt . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Ant

Re: still need help with query

AM, LRS Scout wrote: > > > > > That should have read stored, not stupid, sorry > > On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: > > > > > That's the big int vs int thing again. > > > > > > Also, your error messages are gonna suck in a st

Re: still need help with query

Also, your error messages are gonna suck in a stupid procedure. > > > > If I were you I would write the sql out side of query tags and output it > > to the screen so you can see all the values. > > On Jun 13, 2014 8:49 AM, "Matthew Smith" wrote: > > &g

Re: still need help with query

That should have read stored, not stupid, sorry On Jun 13, 2014 9:07 AM, "LRS Scout" wrote: > That's the big int vs int thing again. > > Also, your error messages are gonna suck in a stupid procedure. > > If I were you I would write the sql out side of query tags

Re: still need help with query

#x27;s a good way to give more complete information about the errors you are seeing... Wrap any erroring queries in CFTRY like this, screenshot the resulting, then post it somewhere and provide a link (DropBox's public folder is good for this sort of thing). [your query goes here]

Re: still need help with query

That's the big int vs int thing again. Also, your error messages are gonna suck in a stupid procedure. If I were you I would write the sql out side of query tags and output it to the screen so you can see all the values. On Jun 13, 2014 8:49 AM, "Matthew Smith" wrote: &

Re: still need help with query

he new error and > code. > On Jun 13, 2014 8:31 AM, "Matthew Smith" wrote: > > > > > output="no" > > returntype="query"> > > > >default=""> > >> name="qry_ordersShippingAddressGet" &

Re: still need help with query

Isn't big int like the cftoken/cfid uuid data type? On Jun 13, 2014 8:31 AM, "Matthew Smith" wrote: > > returntype="query"> > > >name="qry_ordersShippingAddressGet" > datasource="#variables.datasource#"&

Re: still need help with query

Thing is every time you change something you need to post the new error and code. On Jun 13, 2014 8:31 AM, "Matthew Smith" wrote: > > returntype="query"> > > >name="qry_ordersShippingAddressGet" > datasource="#variable

Re: still need help with query

EXEC PROC QRY_PERSONGET , On Fri, Jun 13, 2014 at 8:02 AM, Matthew Smith wrote: > I fixed that, thanks. > > > On Fri, Jun 13, 2014 at 7:57 AM, Zaphod Beeblebrox < > zaph0d.b33bl3b...@gmail.com> wrote: > >> >> what does #request.sqlObjectPrefix# render out to? >> >> >> On

Re: still need help with query

I fixed that, thanks. On Fri, Jun 13, 2014 at 7:57 AM, Zaphod Beeblebrox < zaph0d.b33bl3b...@gmail.com> wrote: > > what does #request.sqlObjectPrefix# render out to? > > > On Fri, Jun 13, 2014 at 3:47 AM, Matthew Smith > wrote: > > > > > i have converted to a stored proc: > > > > USE [redhotki

Re: still need help with query

what does #request.sqlObjectPrefix# render out to? On Fri, Jun 13, 2014 at 3:47 AM, Matthew Smith wrote: > > i have converted to a stored proc: > > USE [redhotkitties2005db] > GO > /** Object: StoredProcedure [dbo].[proc_latest24items]Script Date: > 06/13/2014 04:12:02 **/ > SET A

Re: still need help with query

i have converted to a stored proc: USE [redhotkitties2005db] GO /** Object: StoredProcedure [dbo].[proc_latest24items]Script Date: 06/13/2014 04:12:02 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[proc_procpersonGET] @personKey varchar(8000), @emailAdd

Re: still need help with query

What he's saying is this... in your code snippet: ANDo.tablePK = and the other one that uses the cfqueryparam where list="Yes" you need to treat it as an IN clause instead of an EQUALS. Here's an unparameterized example. select * from table where ID in (3,5,2,6,1) U

Re: still need help with query

Changes inline in quote On Jun 12, 2014 7:51 PM, "Matthew Smith" wrote: > > > returntype="query"> > > >name="qry_ordersGet" > datasource="#variables.datasource#"> > SELECTo.t

Re: still need help with query

Frustrating. Need to get site up ASAP >> >>> On Jun 12, 2014, at 20:36, LRS Scout wrote: >>> >>> >>> Same error? >>>> On Jun 12, 2014 7:51 PM, "Matthew Smith" wrote: >>>> >>>> >>>> &g

Re: still need help with query

7:51 PM, "Matthew Smith" wrote: > >> > >> > >> >> returntype="query"> > >> > >> default=""> > >> >>name="qry_ordersGet" > >>datasource="#variables

Re: still need help with query

Yes same error. Frustrating. Need to get site up ASAP > On Jun 12, 2014, at 20:36, LRS Scout wrote: > > > Same error? >> On Jun 12, 2014 7:51 PM, "Matthew Smith" wrote: >> >> >> > returntype="query"> >> >> >

Re: still need help with query

Those are lists Yo need to use in not = On Jun 12, 2014 7:51 PM, "Matthew Smith" wrote: > > returntype="query"> > > >name="qry_ordersGet" > datasource="#variables.datasource#">

Re: still need help with query

Same error? On Jun 12, 2014 7:51 PM, "Matthew Smith" wrote: > > returntype="query"> > > >name="qry_ordersGet" > datasource="#variables.datasource#"> > SELECTo.tabl

re: still need help with query

Add this function to your CFC and then call it from your template and output the result. What do you get? What happens when you run the output from this directly against your database server. My initial guess is that you have an issue with your cfqueryparams when you are passing in list var

still need help with query

SELECTo.tablePK ,o.tblPeopleFK ,o.createdOn ,o.shippingMethod ,o.itemSubTotal ,o.totalBeforeTax ,o.tax ,o.shippingCost ,o.total ,p.f

Re: error with query, can't figure it out...?

> FROM #request.sqlObjectPrefix#tblPeople > > If I were a betting man, I might bet the error is being caused by this line. What try dumping out '#request.sqlObjectPrefix#tblPeople' before the query to make sure the value

RE: error with query, can't figure it out...?

What's the whole query? Sometimes that error happens because something is wrong before the "WHERE" -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Saturday, June 7, 2014 10:32 AM To: cf-community Subject: Re: error with query, can't figu

Re: error with query, can't figure it out...?

I doubt your using the old eight digit cftoken meaning it's not a bigint. . . On Sat, Jun 7, 2014 at 3:54 AM, Matthew Smith wrote: > >> Still erroring out. I bring shame to my people. >> > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver]

Re: error with query, can't figure it out...?

Post the whole cfc method. On Jun 7, 2014 3:42 AM, "Matthew Smith" wrote: > > > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the > keyword 'WHERE'. > > The error occurred in D:/Ine

Re: error with query, can't figure it out...?

Free cat print if someone can figure this out. I got nothing. Please help!?!?!? > On Jun 7, 2014, at 3:54, Matthew Smith wrote: > >> Still erroring out. I bring shame to my people. > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]I

Re: error with query, can't figure it out...?

> Still erroring out. I bring shame to my people. > Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. The error occurred in D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc: line 748 Called from D:/Inetp

Re: error with query, can't figure it out...?

> Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. The error occurred in D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc: line 748 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs

Re: error with query, can't figure it out...?

, 2014 at 3:07 AM, Maureen wrote: > Or even better, with cfqueryparms > > returntype="query"> > > > > > SELECT* > FROM #request.sqlObjectPrefix#tblPeople > WHERE tablePK = cfsqltype="

Re: error with query, can't figure it out...?

Or even better, with cfqueryparms SELECT* FROM #request.sqlObjectPrefix#tblPeople WHERE tablePK = ANDemailAddress = ~| Order the Adobe Coldfu

Re: error with query, can't figure it out...?

You need a where clause in your query and you need to change the name of either the function or the query, as having them both the same is confusing. SELECT* FROM #request.sqlObjectPrefix#tblPeople WHERE tablePK

Re: error with query, can't figure it out...?

cffunction access="public" name="qry_peopleGet" output="false" returntype="query"> SELECT * FROM#request.sqlObjectPrefix#tblPeople where

Re: error with query, can't figure it out...?

cffunction access="public" name="qry_peopleGet" output="false" returntype="query"> SELECT * FROM#request.sqlObjectPrefix#tblPeople where

Re: error with query, can't figure it out...?

Please help... The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Error Executing Database Query

Re: error with query, can't figure it out...?

Maybe it's just the weird format of your pasted message but, i don't see the "where" clause anywhere...? On Fri, Jun 6, 2014 at 9:59 AM, Matthew Smith wrote: > > returntype="query"> > > >default="qry_peopleG

error with query, can't figure it out...?

ienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes.Error Occurred While Processing Request Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syn

Re: cfchart bar chart for group by query result set

Read through these two links they may help: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53866 http://www.raymondcamden.com/index.cfm/2010/3/12/Coloring-CFCHART-Dynamically hth, larry On Sat, Feb 18, 2012 at 1:07 PM, sarah mfr wrote: > > I have a result set that has the fol

cfchart bar chart for group by query result set

I have a result set that has the following columns studentid,sectionid,tracedate,duration,pagehits I want to draw a horizontal bar chart per student per section displaying tracedate as xaxis and duration and pagehits as the yaxis one below the other Thanks ~

Re: Been out of the game - Needs query help

only 34 > people so I will probably just do it by hand. > > On Thu, Jul 29, 2010 at 10:27 AM, Judah McAuley wrote: > >> >> This is still kind of weird looking to me. The query as G put it would >> seem like it is trying to convert the current rank that a User has >&g

Re: Been out of the game - Needs query help

:27 AM, Judah McAuley wrote: > > This is still kind of weird looking to me. The query as G put it would > seem like it is trying to convert the current rank that a User has > from a text value to an id of the equivalent row in the Rank table. > That would, amongst other things, mean th

Re: Been out of the game - Needs query help

McAuley wrote: > > The subquery SELECT Rank.Rank_Name FROM Rank is probably returning > more than one record because you aren't doing any filtering on it. You > can't use a subquery that returns multiple values in most areas of a > query. This query also looks like it is

Re: Been out of the game - Needs query help

This is still kind of weird looking to me. The query as G put it would seem like it is trying to convert the current rank that a User has from a text value to an id of the equivalent row in the Rank table. That would, amongst other things, mean that you're going to be now storing all nu

Re: Been out of the game - Needs query help

The subquery SELECT Rank.Rank_Name FROM Rank is probably returning more than one record because you aren't doing any filtering on it. You can't use a subquery that returns multiple values in most areas of a query. This query also looks like it is circular. You seem to be trying to set

Re: Been out of the game - Needs query help

On Thu, Jul 29, 2010 at 11:09 AM, Bruce Sorge wrote: > > UPDATE Users > SET Users.User_Rank = (Select Rank_ID FROM Rank > Where Users.User_Rank = > (Select Rank.Rank_Name > FROM Rank)); > Will an Update...From work? Something like: UPDATE Users SET Users.User_Rank = Rank.Rank_ID FROM Users JOI

Re: Been out of the game - Needs query help

Can you join Users and Rank? On Thu, Jul 29, 2010 at 12:09 PM, Bruce Sorge wrote: > > OK, so I have been out of the game for a bit and my platoon sergeant wants > me to build an MS Access form for our platoon info. So I am trying to do a > simple update query and I get the messa

Been out of the game - Needs query help

OK, so I have been out of the game for a bit and my platoon sergeant wants me to build an MS Access form for our platoon info. So I am trying to do a simple update query and I get the message Operation must use an updateable query. Here is the query: UPDATE Users SET Users.User_Rank = (Select

Re: Weird error returned from a query.

Oracle? +1 for JDBC driver issue. -- Liberalism regards life as an adventure in which we must take risks in new situation, in which there is no guarantee that the new will always be the good or the true, in which progress is a precarious achievement rather than inevitability. Morris Raphael Coh

Re: Weird error returned from a query.

> > From: Larry C. Lyons [mailto:larrycly...@gmail.com] > > Sent: Wednesday, November 11, 2009 3:59 PM > > To: cf-community > > Subject: Re: Weird error returned from a query. > > > > > > that may be the problem, there are a lot of rows where the column

Re: Weird error returned from a query.

. plus I know dick about advanced PL/SQL > > -Original Message- > From: Larry C. Lyons [mailto:larrycly...@gmail.com] > Sent: Wednesday, November 11, 2009 3:59 PM > To: cf-community > Subject: Re: Weird error returned from a query. > > > that may be the problem, ther

RE: Weird error returned from a query.

om] Sent: Wednesday, November 11, 2009 3:59 PM To: cf-community Subject: Re: Weird error returned from a query. that may be the problem, there are a lot of rows where the column's value is empty. That gives me a lot to go on. many thanks, larry On Wed, Nov 11, 2009 at 2:36 PM, Michael Gr

Re: Weird error returned from a query.

that may be the problem, there are a lot of rows where the column's value is empty. That gives me a lot to go on. many thanks, larry On Wed, Nov 11, 2009 at 2:36 PM, Michael Grant wrote: > > Are there definately at least 3 chars in every row of the query? > > Could you t

Re: Weird error returned from a query.

rev, -3, 3) as myColumn from cls_regioninfo It might also be significant to know if you are using maxrows or any other attributes of CFQUERY. -Cameron On Wed, Nov 11, 2009 at 12:48 PM, Larry C. Lyons wrote: > > H all, > > I'm getting a weird error instead of some query results.

Re: Weird error returned from a query.

mailto:larrycly...@gmail.com] > Sent: Wednesday, November 11, 2009 1:42 PM > To: cf-community > Subject: Re: Weird error returned from a query. > > > region_abbrev       varchar2(10) > > On Wed, Nov 11, 2009 at 1:21 PM, LRS Scout wrote: >> >> What's the data type?

Re: Weird error returned from a query.

Are there definately at least 3 chars in every row of the query? Could you try adding a where clause? Where length(region_abbrev) >= 3 Not sure if that's the right syntax for Oracle, but you get the idea. On Wed, Nov 11, 2009 at 12:48 PM, Larry C. Lyons wrote: > > H all, >

RE: Weird error returned from a query.

Does it execute when you pull the distinct out? -Original Message- From: Larry C. Lyons [mailto:larrycly...@gmail.com] Sent: Wednesday, November 11, 2009 1:42 PM To: cf-community Subject: Re: Weird error returned from a query. region_abbrev varchar2(10) On Wed, Nov 11, 2009 at

Re: Weird error returned from a query.

if you remove disctinct and use group by instead? > > select substr(region_abbrev, -3, 3) > from cls_regioninfo > group by substr(region_abbrev, -3, 3) > > On Wed, Nov 11, 2009 at 12:48 PM, Larry C. Lyons wrote: > >> >> H all, >> >> I'm gett

Re: Weird error returned from a query.

ct: Weird error returned from a query. > > > H all, > > I'm getting a weird error instead of some query results. > some background - its an oracle database and I'm trying to do a select > based on the last 3 letters of a column > > here's my sql: > s

RE: Weird error returned from a query.

What's the data type? -Original Message- From: Larry C. Lyons [mailto:larrycly...@gmail.com] Sent: Wednesday, November 11, 2009 12:49 PM To: cf-community Subject: Weird error returned from a query. H all, I'm getting a weird error instead of some query results. some backgr

Re: Weird error returned from a query.

not sure, but what happens if you remove disctinct and use group by instead? select substr(region_abbrev, -3, 3) from cls_regioninfo group by substr(region_abbrev, -3, 3) On Wed, Nov 11, 2009 at 12:48 PM, Larry C. Lyons wrote: > > H all, > > I'm getting a weird error inst

Weird error returned from a query.

H all, I'm getting a weird error instead of some query results. some background - its an oracle database and I'm trying to do a select based on the last 3 letters of a column here's my sql: select distinct SUBSTR(region_abbrev, -3, 3) from cls_regioninfo this works fine when

Re: VB query question

On Dec 3, 2007 10:01 AM, Jacob <[EMAIL PROTECTED]> wrote: > My VB skills are, well do not exist, but I can figure some things out. Been a while, but she Looks like a string of text to me. So, sure! ~| Create robust enterprise

VB query question

My VB skills are, well do not exist, but I can figure some things out. I have a query in which I need to update another column in a table. I need to update the column CALC_WEIGHT. Looking at my original query and the new query, would I be correct? I am going to test it out, but I want to make

Re: sql query question

> okee dokee... i figured my way around it... > > and did my thing, but its all good :) > > > > tw > > > > On 11/19/07, G Money <[EMAIL PROTECTED]> wrote: > > > Then you'll need to change your querybecause the way you've got it > >

Re: sql query question

Cool, glad I could be of absolutely no help :) On Nov 19, 2007 10:18 AM, Tony <[EMAIL PROTECTED]> wrote: > okee dokee... i figured my way around it... > and did my thing, but its all good :) > > tw > > On 11/19/07, G Money <[EMAIL PROTECTED]> wrote: > > T

Re: sql query question

r, max(a.dateAssigned) as mostRecent > > > > from > > > >accts a > > > > inner join > > > >clients c on c.clientNumber = a.clientNumber > > > > group by > > > >a.clientNumber > > > > order by > > &

Re: sql query question

okee dokee... i figured my way around it... and did my thing, but its all good :) tw On 11/19/07, G Money <[EMAIL PROTECTED]> wrote: > Then you'll need to change your querybecause the way you've got it set > up, even if 2 things came in on the same day, for the same c

Re: sql query question

; > > > > good peeps of the roundtable... > > > > > > select > > >distinct a.clientNumber, max(a.dateAssigned) as mostRecent > > > from > > >accts a > > > inner join > > > clients c on c.clientNumber = a.clientNumber > &

Re: sql query question

Then you'll need to change your querybecause the way you've got it set up, even if 2 things came in on the same day, for the same client, your DISTINCT will ensure that you only get ONE row back for that client and that day. On Nov 19, 2007 8:28 AM, <[EMAIL PROTECTED]> wrot

Re: sql query question

gt; wrote: > > > good peeps of the roundtable... > > > > select > >distinct a.clientNumber, max(a.dateAssigned) as mostRecent > > from > >accts a > > inner join > >clients c on c.clientNumber = a.clientNumber > > group by > > a.c

Re: sql query question

ccts a > inner join >clients c on c.clientNumber = a.clientNumber > group by >a.clientNumber > order by >mostRecent desc > > to prevent having to go get another query > i want to count the number of mostRecent matches there are per client. > > how do i

sql query question

good peeps of the roundtable... select distinct a.clientNumber, max(a.dateAssigned) as mostRecent from accts a inner join clients c on c.clientNumber = a.clientNumber group by a.clientNumber order by mostRecent desc to prevent having to go get another query i want to count

RE: Organizing query results with css

ewart [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 3:57 PM To: CF-Community Subject: Organizing query results with css Hey all How would you do this with .css #itemA##itemb# Scott Stewart ColdFusion Developer HYPERLINK "http://maps.yahoo.com/py/maps.py

Organizing query results with css

Hey all How would you do this with .css #itemA##itemb# Scott Stewart ColdFusion Developer HYPERLINK "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=7241+Jillspring+Ct&csz=Sprin gfield%2C+VA.+22152&country=us" \n7241 Jillspring Ct Springfield, VA. 22152 HYPERLINK

Re: Sort an LDAP Query?

> During the LDAP call you can use the sort parameter: sort="CN". Cool thanks > After a LDAP record set has been returned you can use a QofQ to sort it. Aye! A resounding duh... Brain on vapor lock yesterday. > Take your pick. Thank you thank you! -- will "If my life weren't funny, it woul

RE: Sort an LDAP Query?

During the LDAP call you can use the sort parameter: sort="CN". After a LDAP record set has been returned you can use a QofQ to sort it. Take your pick. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | |

  1   2   3   >