Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 28, 2006 9:51 PM
To: CF-Talk
Subject: Re: Query Problem
You have a query with 100 rows and you are trying to set a cell in row
1920. 1920 is greater than 100.
On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote:
Hello.
I
it crated
2020 rows which sucked.
Thanks
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 28, 2006 9:51 PM
To: CF-Talk
Subject: Re: Query Problem
You have a query with 100 rows and you are trying to set a cell in row
1920. 1920 is greater
: Query Problem
You have a query with 100 rows and you are trying to set a cell in row
1920. 1920 is greater than 100.
On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote:
Hello.
I have these three queries that I am creating below. The first two
work
great, but the third one gives me
You have a query with 100 rows and you are trying to set a cell in row
1920. 1920 is greater than 100.
On 12/29/06, Bruce Sorge [EMAIL PROTECTED] wrote:
Hello.
I have these three queries that I am creating below. The first two work
great, but the third one gives me the following error:
The
Looks like you might need to add an additional field to your albums table.
Then populate it with the artists id's that are associated with speccific
albums. Also might want to add the same to your track table.
albumid int(10) unsigned NOT NULL auto_increment,
artistid int (10),
albumtitle
06, 2006 7:37 AM
To: CF-Talk
Subject: Re: Query Problem
Looks like you might need to add an additional field to your albums table.
Then populate it with the artists id's that are associated with speccific
albums. Also might want to add the same to your track table.
albumid int(10) unsigned
Actually I think that would be a grouping issue (once you fixed the 'seletc'
type)... and I hate 'GROUP BY' clauses... they get me every time!
At the risk of being bashed for using 'IN'... try this
select albumtitle, name, year
from album, artist
where albumid =
Actually, you should use a inner join on that, so not to return records you
do not need.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered
I tend to find that exists is very helpful for these situation (and reads
like the english version of what I want).
SELECT artistid,name
FROMartist
WHERE EXISTS (
SELECT artistid
FROMtrack
INNER JOIN artisttrack
-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:10 AM
To: CF-Talk
Subject: Re: Query Problem
Actually, you should use a inner join on that, so not to return records you
do not need.
~|
Introducing
- Original Message -
From: Bobby Hartsfield [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, November 06, 2006 7:14 AM
Subject: RE: Query Problem
Im not sure which one you mean. The first one I posted DID use inner joins
and the problem was of course returning the same
.
Joshua
-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 8:03 AM
To: CF-Talk
Subject: Re: Query Problem
I tend to find that exists is very helpful for these situation (and reads
like the english version of what I want).
SELECT artistid,name
Ahh gotcha. Still hasnt come through. Im sure you can see why I thought you
meant mine thoguh ;-)
cheers
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:20 AM
To: CF-Talk
Subject: Re: Query Problem
Weird. I had sent a query and it posted
Use select distinct on the original query to eliminate duplicate records.
I have a database of music CDs, something like:
album
-
albumid int(10) unsigned NOT NULL auto_increment,
albumtitle varchar(255),
year smallint(5) unsigned
track
-
trackid int(10) unsigned NOT
PROTECTED]
Sent: Monday, November 06, 2006 7:37 AM
To: CF-Talk
Subject: Re: Query Problem
Looks like you might need to add an additional field to your albums table.
Then populate it with the artists id's that are associated with speccific
albums. Also might want to add the same to your track
PROTECTED]
Sent: Monday, November 06, 2006 7:37 AM
To: CF-Talk
Subject: Re: Query Problem
Looks like you might need to add an additional field to your albums table.
Then populate it with the artists id's that are associated with speccific
albums. Also might want to add the same to your track
On Friday 04 August 2006 17:19, Kris Jones wrote:
(which just doesn't work at all)
It was meant to be in a loop.
O(N), of course, but that's not so bad with only a few cats.
Going with a linking table is probably the right way to go. Better
performance too.
Very, very, much the +1'ness :-)
You can turn this
SELECT catid FROM deep_images
WHERE catid LIKE '#uid#'
OR catid LIKE '#UID#,%'
OR catid LIKE '%,#UID#'
OR catid LIKE '%,#UID#,%'
INTO this and it should do what your looking to do.
SELECT catid FROM deep_images
WHERE 0=0
AND (catid = '#uid#'
OR
On Thursday 03 August 2006 18:43, Kris Jones wrote:
SELECT catid FROM deep_images WHERE #uid# IN (catid)
IN is evil.
It will randomly stop working when you hit the db's limit for items in a
string list.
Which is not fun :-)
If you must have comma lists rather than a more sensible layout, why
-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 9:30 AM
To: CF-Talk
Subject: Re: Query problem with lists of values
On Thursday 03 August 2006 18:43, Kris Jones wrote:
SELECT catid FROM deep_images WHERE #uid# IN (catid)
IN is evil.
It will randomly stop
but one item has entries of 15,16,30,49,50,52,75 and it is being put in
a catecory that has the id of 2 there are lots of these that are
behaving this way. any one think of a way to help with this?
SELECT catid FROM deep_images WHERE #uid# IN (catid)
IN is evil.
It will randomly stop
but one item has entries of 15,16,30,49,50,52,75 and it is being put in
a category that has the id of 2 there are lots of these that are
behaving this way. any one think of a way to help with this?
This is happening of course because two of your like clauses catid LIKE
'#uid#' AND catid LIKE
How about:
SELECT catid FROM deep_images WHERE #uid# IN (catid)
Cheers,
Kris
but one item has entries of 15,16,30,49,50,52,75 and it is being put in
a category that has the id of 2 there are lots of these that are
behaving this way. any one think of a way to help with this?
that is kind of what I thought, but is there any way around this?
This is happening of course because two of your like clauses catid LIKE
'#uid#' AND catid LIKE '#uid#,' means that the 2 will match the 2 in '52,'.
This is the difficulty with this kind of set up.
--
Patrick Forsythe
Tech
Kris Jones wrote:
How about:
SELECT catid FROM deep_images WHERE #uid# IN (catid)
Cheers,
Kris
I had tried that originally and sql server didn't like that much at all
--
Patrick Forsythe
Tech Support
Smallville Communications
http://www.toto.net
Guter Rat ist teuer. --Unbekannt
Why don't you use a join table via which to associate your items and
categories?
Josh
-Original Message-
From: Patrick Forsythe [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 03, 2006 1:47 PM
To: CF-Talk
Subject: Re: Query problem with lists of values
that is kind of what I thought
03, 2006 12:49 PM
To: CF-Talk
Subject: Re: Query problem with lists of values
Kris Jones wrote:
How about:
SELECT catid FROM deep_images WHERE #uid# IN (catid)
Cheers,
Kris
I had tried that originally and sql server didn't like that much at all
--
Patrick Forsythe
Tech Support
Smallville
On 8/3/06, Mark A Kruger [EMAIL PROTECTED] wrote:
Patrick,
You can create a UDF that allows for list functions. Here's blog post on the
topic.
http://mkruger.cfwebtools.com/index.cfm?mode=entryentry=87616A7F-D611-F201-
A72DB4B567CFA1F7
The UDF that Mark is blogging about looks like it
the category information is in a seperate row these are only the uid s
that are stored with the product.
Jim Wright wrote:
The UDF that Mark is blogging about looks like it will get you what
you want, but do keep in mind that if you use a UDF like this in the
WHERE clause, it will be executed
On 8/3/06, Patrick Forsythe [EMAIL PROTECTED] wrote:
the category information is in a seperate row these are only the uid s
that are stored with the product.
Understood...but what you need is an intermediate table which links
the two...something like...
category table:
uid
description
: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 10:40 PM
To: CF-Talk
Subject: RE: Query Problem - sorting
From: Dennis Powers [mailto:[EMAIL PROTECTED]
SELECT FilesCategory.Cat_Name,
Avg(Comments.Numeric1) AS Userrating,
Count(Comments.Numeric1
From: Dennis Powers [mailto:[EMAIL PROTECTED]
SELECT FilesCategory.Cat_Name,
Avg(Comments.Numeric1) AS Userrating,
Count(Comments.Numeric1) AS Responses
FROM (FilesData LEFT JOIN Comments ON FilesData.ID =
Comments.LinkID) LEFT JOIN FilesCategory ON
[empty string] is CF's way of saying NULL, since ColdFusion has not native
NULL value.
Thus your where clause should be WHERE Publication_Type IS NOT NULL
didn't work, but this did. Interestingly, != NULL didn't work. It had to
be IS NOT NULL
I never would have gotten this. I was thinking
[empty string] is CF's way of saying NULL, since ColdFusion has not native NULL
value.
Thus your where clause should be WHERE Publication_Type IS NOT NULL
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
-
not equals in sql is , that may help
On 9/28/05, Daniel Kessler [EMAIL PROTECTED] wrote:
I can't seem to see what is wrong with this query. I added the WHERE
line and it comes up with no records returned. Without the WHERE, it
comes up with two records, but one of them has publication_type
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
CFQUERY NAME=the_type DATASOURCE=dpch
select publication_type
from publications
where publication_type !=''
group by publication_type
/CFQuery
If the field is NOT NULL try,
where LEN(TRIM(publication_type)) == 0
*note...
In case the default value returned by the db is an empty string, you may
need the belt and the suspenders:
where NOT (publication_type IS NULL OR publication_type = '')
--
___
REUSE CODE! Use custom tags;
See
CAN YOU FIIP/FLOP VARIABLES AND DATA IN CF?
This works in the SQL Query Analyzer. Is there a way to switch it to CF? When I
run it I get the following error.
[SQLServer JDBC Driver][SQLServer]Invalid column name 'DateFrom'.
Because DateFrom is a passed variable.
Select * RENTALS r
Where NOT
Impressive use of your noggin. Hopefully I can explain my problem a little
better. I have changed my data import to create a date record for every night.
Instead of the arrival date and number of nights. I can easily change back it
this doesn't provide the results the best way. Below is some
This looks like a good use of a Tally table. A Tally table is a table that
contains just an ID field with records from 1 to 10,000 (you can use any upper
bound you need). You can then join this table to generate queries based on
ranges.
To test, I created the following table:
ID int
Change it so it has an arrival date and a departure date? :D
On 7/28/05, Doug Bedient [EMAIL PROTECTED] wrote:
I have 2 tables, one lists properties and the other contains arrival dates
and number of nights for those properties. The common variable is 'unitCode'.
The search parameters
I would still have dates between the arrival date and newly created departure
date that would need to be handled somehow. Originally, I had looping set up to
create a record for every date but it seemed like a lot of extra processing
that shouldn't be required.
I don't think you can do it in a single SQL statement. At least not
an efficient one.
How about pull the list of reservations that overlap the desired
dates, and then creating an array of dates (from arrival to
departure), and then loop over the recordset and remove dates from
the array that are
Can you not use the SQL operator BETWEEN?
where thedate BETWEEN arrivaldate AND departuredate
?
-Original Message-
From: Doug Bedient [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 2:47 PM
To: CF-Talk
Subject: Re: Query Problem - Brain Cloud
I would still have dates between
Add a vacant field and check to see if vacant is 0 or 1 0 being not
vacant and 1 being vacant?
But the where clause would look something like
Select * from task t
WHERE TO_DATE('#arguments.new_to#','mm/dd/') = t.startDate
AND TO_DATE('#arguments.new_from#','mm/dd/') = t.finishDate
, July 28, 2005 11:47 AM
To: CF-Talk
Subject: Re: Query Problem - Brain Cloud
I would still have dates between the arrival date and newly created
departure date that would need to be handled somehow. Originally, I had
looping set up to create a record for every date
Something like this wouldn't handle them
where arrivaldate = #arrivaldate# and departuredate = #departuredate#
?
Maybe I don't understand what you are trying to do?
On 7/28/05, Doug Bedient [EMAIL PROTECTED] wrote:
I would still have dates between the arrival date and newly created departure
?
where thedate BETWEEN arrivaldate AND departuredate
?
-Original Message-
From: Doug Bedient [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 2:47 PM
To: CF-Talk
Subject: Re: Query Problem - Brain Cloud
I would still have dates between the arrival date and newly created
here's a timeline in days (if you don't have fixed-width font, CP
into something that does):
123456789
xxx reservation 1
xxx reservation 2
x reservation 3
q desired range
there are two possible days available: 4 and 6. That's the problem
he's trying to solve.
Then you need a reference table of dates, so you can query what IS NOT
there. You can hit this table like this:
select date
from datetable
where date BETWEEN x AND y
and date NOT IN (select distinct date from reservation where date
between x AND y)
right?
-jc
Barney Boisvert wrote:
Doug Bedient wrote:
I have 2 tables, one lists properties and the other contains arrival dates
and number of nights for those properties. The common variable is 'unitCode'.
The search parameters provide an arrival date and departure date.
My question. How would you use the arrival
SELECT max(stockid) as stockid, data1, data2
FROM table
HAVING data1 = 5
Unfortunately this is returning the following data
StockID | Data1 | Data2
---
3 | 5 | 2
Ie: the correct stockid and data1 but data2 from a diferent row!
What RDBM are you using? Wouldn't this do it?
-- MySQL
SELECT *
FROM table
WHERE data1 = '5'
ORDER BY DESC
LIMIT 1
-- SQLServer
SELECT Top 1 *
FROM table
WHERE data1 = '5'
ORDER BY DESC
- Original Message -
From: James Smith [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
What RDBM are you using? Wouldn't this do it?
-- MySQL
SELECT *
FROM table
WHERE data1 = '5'
ORDER BY DESC
LIMIT 1
Unfortunately not. If you view the larger query you will get a better idea,
and to explain the process...
The query returns about 7500 records. AddedToFile is a flag
James Smith wrote:
SELECT max(stockid) as stockid, data1, data2
FROM table
HAVING data1 = 5
Unfortunately this is returning the following data
StockID | Data1 | Data2
---
3 | 5 | 2
Ie: the correct stockid and data1 but data2 from a diferent
this sounds like it should do it for you, but perhaps I'm missing something
SELECT memberID, max(paidThru) AS paidThru
FROM someTableName
ORDER BY memberID
cheers,
barneyb
On Thu, 17 Mar 2005 22:03:03 -0500, Mark Leder [EMAIL PROTECTED] wrote:
I have a table with two columns, memberID
:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:00 PM
To: CF-Talk
Subject: Re: Query problem
this sounds like it should do it for you, but perhaps I'm missing something
SELECT memberID, max(paidThru) AS paidThru FROM someTableName ORDER BY
memberID
cheers,
barneyb
On Thu, 17 Mar 2005 22:03:03
Whoops. Try this one. Meant 'group by' but typed 'order by'. Sorry
about that.
SELECT memberID, MAX(paidThru) AS paidThru
FROM someTableName
GROUP BY memberID
cheers,
barneyb
On Thu, 17 Mar 2005 22:22:41 -0500, Mark Leder [EMAIL PROTECTED] wrote:
Tried it, here's the error:
That worked.
Thanks Barney.
Mark
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:26 PM
To: CF-Talk
Subject: Re: Query problem
Whoops. Try this one. Meant 'group by' but typed 'order by'. Sorry about
that.
SELECT memberID, MAX
Ahh, the sound of yesterday, the delicious bouquet of simpler times,
when I was younger, thinner, flexible, and spent my time in the
pursuits of youth...
Like sitting at my desk screaming WHY WON'T THIS EFFING THING WORK?!?!?!?
Only to realize that I was making the most elemental of mistakes. A
use CFQUERYPARAM value=#newMonth# cfsqltype=cf_sql_integer / for both
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 4:16 PM
To: CF-Talk
Subject: Query Problem
I am running into a problem which I have not ran into before. Below is
my
Put hashes(pound signs) around your variables:
Day(Status.EffectiveDate) = #variables.newDay# and
without them the SQL reads as is e.g. a table named variables with a column
named newDay.
Ade
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]
Sent: 06 March 2005 22:14
On Thursday 07 Oct 2004 11:22 am, James Smith wrote:
To create the appropriate formatting but there are no such list functions
in MySQL.Can anyone out there think of a way to do this?
Loop over the query, and construct an array to use with queryAddColumn, such
that each element in the array is
how about
SELECT sum(quantity) as TotalQuantity,
RIGHT( '0' + SUBSTRING_INDEX(location , '.' , 1),2) as rack,
RIGHT('0' + SUBSTRING_INDEX(SUBSTRING_INDEX(location , '.' ,
2), '.' , -1),2) as shelf
RIGHT( '0' + SUBSTRING_INDEX(location , '.' , -1),2) as box
FROM stockquantities
WHERE Quantity 0
With the exception of the missing , after the shelf that works perfectly,
thanks.
--
Jay
-Original Message-
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: 07 October 2004 12:29
To: CF-Talk
Subject: Re: Query problem
how about
SELECT sum(quantity) as TotalQuantity
Traher [mailto:[EMAIL PROTECTED]
Sent: 07 October 2004 12:29
To: CF-Talk
Subject: Re: Query problem
how about
SELECT sum(quantity) as TotalQuantity,
RIGHT( '0' + SUBSTRING_INDEX(location , '.' , 1),2) as rack,
RIGHT('0' + SUBSTRING_INDEX(SUBSTRING_INDEX(location
, '.' , 2
-Original Message-
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: 07 October 2004 15:04
To: CF-Talk
Subject: Re: Query problem
It would have spoilt all your fun if I hadn't made at least
one mistake :-)
On Thu, 7 Oct 2004 12:42:36 +0100, James Smith
[EMAIL PROTECTED] wrote
-
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: 07 October 2004 15:04
To: CF-Talk
Subject: Re: Query problem
It would have spoilt all your fun if I hadn't made at least
one mistake :-)
On Thu, 7 Oct 2004 12:42:36 +0100, James Smith
[EMAIL PROTECTED] wrote
You can't use the alias in the WHERE clause -- you need to write the
_expression_ again. Also, you'll probably need to CAST your productCode as an
integer depending on your DBMS. Or perhaps simply do a string comparison and
change the cfsqltype to cf_sql_varchar.
_
From: Mark Leder
TRANSFORM
sum (dp.cantidad) as totalt
select sum (dp.cantidad) as total, dp.idproducto as codigo
from pedidos p, detallesdepedido dp
where p.idpedido=dp.idpedido
and p.mesenvio = 7
group by dp.idproducto
PIVOT
p.diaenvio
In CFMX i can make a query like this, if i can how i do
the ouput
You could convert the single quotes in the string to ASCII or
PreserveSingleQuotes() might work (been awhile so I'm not 100% sure on the
preserve)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
Use cfqueryparam then you won't have to worry about it anymore.
Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL
Instead of #IIf(Trim(form.confsent) EQ '', No,
Yes)#,
use #YesNoFormat(Trim(form.confsent) EQ '')#
-Original Message-
From: Jillian Carroll [mailto:jillian;koskie.com]
Sent: Sunday, October 27, 2002 2:04 PM
To: CF-Talk
Subject: RE: Query Problem
When I use cfqueryparam as you
Jillian Carroll wrote:
cfif #form.confsent# EQ ' '
cfquery name=adduser datasource=#DSN#
UPDATE attendee
SET confsent = NULL
WHERE users_id = #FORM.users_id#
/cfquery
cfelse
cfquery name=adduser datasource=#DSN#
UPDATE attendee
SET confsent =
When I use cfqueryparam as you specified below, I get this error:
An error occurred while evaluating the expression:
#IIf(Trim(form.confsent) EQ '', No, Yes)#
Error near line 63, column 95.
~|
Archives:
Subject: RE: Query Problem
When I use cfqueryparam as you specified below, I get this error:
An error occurred while evaluating the expression:
#IIf(Trim(form.confsent) EQ '', No, Yes)#
Error near line 63, column 95
Jillian Carroll wrote:
cfif #form.confsent# EQ ' '
cfquery name=adduser datasource=#DSN#
UPDATE attendee
SET confsent = NULL
WHERE users_id = #FORM.users_id#
/cfquery
cfelse
cfquery name=adduser datasource=#DSN#
UPDATE attendee
SET confsent =
The query below doesn't work... the first clause in the
CFIF works fine, but it gives me the error: Error while
executing the query (non-fatal); ERROR: Relation form
does not exist for the CFELSE portion.
Incedentally, this _sounds_ to me like a bug. The syntax of the query
certainly looks
Dealey [mailto:info;turnkey.to]
Sent: Sunday, October 27, 2002 1:26 PM
To: CF-Talk
Subject: Re: Query Problem
The query below doesn't work... the first clause in the
CFIF works fine, but it gives me the error: Error while
executing the query (non-fatal); ERROR: Relation form
does not exist
Jillian Carroll wrote:
When I use cfqueryparam as you specified below, I get this error:
An error occurred while evaluating the expression:
#IIf(Trim(form.confsent) EQ '', No, Yes)#
My mistake:
#IIf(Trim(form.confsent) EQ '', DE(No), DE(Yes))#
I think you might have to switch
Jillian Carroll wrote:
I'm going out of my mind with this one. I use the EXACT same code to
do the initial entry of the user information and it works.
It keeps telling me that Relation form does not exist... That
leads me to believe one of two things... either it is looking in my
, 2002 2:29 PM
Subject: RE: Query Problem
I'm going out of my mind with this one. I use the EXACT same code to do
the
initial entry of the user information and it works.
It keeps telling me that Relation form does not exist... That leads me
to believe one of two things... either it is looking
Jillian Carroll wrote:
When I use cfqueryparam as you specified below, I get
this error:
An error occurred while evaluating the expression:
#IIf(Trim(form.confsent) EQ '', No, Yes)#
My mistake:
#IIf(Trim(form.confsent) EQ '', DE(No), DE(Yes))#
I think you might have to
How about you replace it with this?
cfquery name=adduser datasource=#DSN#
UPDATE attendee
SET confsent = cfqueryparam cfsqltype=cf_sql_varchar
value=#form.confsent# null=#YesNoFormat(form.confsent EQ ' ')#
WHERE users_id = cfqueryparam cfsqltype=cf_sql_integer
Thank you guys for your help... I'm FINALLY in business with this form!
-Original Message-
From: S. Isaac Dealey [mailto:info;turnkey.to]
Sent: Sunday, October 27, 2002 1:53 PM
To: CF-Talk
Subject: Re: Query Problem
Jillian Carroll wrote:
When I use cfqueryparam as you specified
You want to display the latest docs before a selection in the drop down?
If so, why not just display the latest 5.
Assumign your'e using SQL server, try this.
cfquery name=q_news datasource=#REQUEST.dsn1#
SELECT TOP 5 t_art_category.*, t_committees.*, t_articles.id_art,
t_articles.art_title,
The only issue here is that the amount of articles could vary from month
to month.
Thanks,
Mark
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 7:56 AM
To: CF-Talk
Subject: RE: Query Problem
You want to display the latest docs before
August 2002 13:22
To: CF-Talk
Subject: RE: Query Problem
The only issue here is that the amount of articles could vary from month
to month.
Thanks,
Mark
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 7:56 AM
To: CF-Talk
Subject: RE: Query
Try using single quotes around 'Parametric'.
-Original Message-
From: ronmyers [SMTP:[EMAIL PROTECTED]]
Sent: 30 April 2002 14:41
To: CF-Talk
Subject: Query Problem
Can someone tell my why I am getting this error. If I take the WHERE line
out it returns all the data just
, April 30, 2002 9:52 AM
To: CF-Talk
Subject: RE: Query Problem
Try using single quotes around 'Parametric'.
-Original Message-
From: ronmyers [SMTP:[EMAIL PROTECTED]]
Sent: 30 April 2002 14:41
To: CF-Talk
Subject: Query Problem
Can someone tell my why I am getting this error
Thanks it worked Getting up to early to see straight
-Original Message-
From: Paul Bowley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 7:52 AM
To: CF-Talk
Subject: RE: Query Problem
Try using single quotes around 'Parametric'.
-Original Message-
From: ronmyers
All working nowthe delete date field was having a problem when no data
was being added.
Cheers
Will
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 21 February 2002 11:30
To: CF-Talk
Subject: query problem
Hi all,
Ok, having an annoying little problem, and
Will,
Your date needs to be an ODBC Date.
Use CreateODBCDate() on your Date form field and CreateODBCTime() on your
Time form Field.
Regards
Stephen
- Original Message -
From: Will Swain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 11:29 AM
[mailto:[EMAIL PROTECTED]]
Sent: 21 February 2002 12:42
To: CF-Talk
Subject: Re: query problem
Will,
Your date needs to be an ODBC Date.
Use CreateODBCDate() on your Date form field and CreateODBCTime() on your
Time form Field.
Regards
Stephen
- Original Message -
From: Will Swain [EMAIL
Date is probably a date/time function. So your definition of 'today' needs
to be a little more exact. My point being, you probably have the date
(4/9/2001) stored as: 04/09/2001 00:00:00.000 and when you do the now()
function Access is seeing that as 04/09/2001 15:30:29.001 which is actually
Comparing dates are fun - here's a couple suggestions:
-check your formatting of the date object you're comparing and format your
where-clause date to be exactly the same format as appears in the DB (i.e.
smalldate time, ODBC d/t obj. etc.); relying on the auto conversion within
ODBC has yielded
, April 09, 2001 3:24 PM
To: CF-Talk
Subject: RE: QUERY PROBLEM
Comparing dates are fun - here's a couple suggestions:
-check your formatting of the date object you're comparing and format your
where-clause date to be exactly the same format as appears in the DB (i.e.
smalldate time, ODBC d/t obj
Order BY GDATE
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com
-Original Message-
From: [EMAIL PROTECTED]
Hi,
The default format of date function is date with time. Ms-Access has also
the same format. If you want to compare two date values, change the target
value to default format and make the comparision. Like cfset today=Now()
which is the default for both CF MS-Access. Now try with this default
Will,
Are you using access? ID is a reserved word, I think. So, number one would
be to change the name of your field in the table. Also, is ID in members the
same as id in fields? If so, you can do something like this:
SELECTm.email, m.id
FROMmembers m, main_details d
WHERE
1 - 100 of 112 matches
Mail list logo