I know I have done this in the past, but I cannot figure it out for some
reason.
I want to grab out of a database the record with the highest value for
the field RATING (it is an INT). I also want to grab all the data for
the record like Image1, Description etc
SELECT MAX(RATING), Image1,
Hi All,
In a query, pulled from MS Access, I want to retrieve the five most
recent postings (they are datestamped when inputted). I know how to do
this in SQL, using top, but I can't figure out in Access.
SELECT eID, city, state, country, datestamp
WHERE datestamp = [five most recent]
T
Maybe someone can help me
I've written a photo gallery app and I'm having a problem with one of my
queries. My gallery has several Main Categories (category table).
Within each category is a subcategory (subcat table) that contains
photosets (gallery table). After uploading a photoset you choose
I'm assuming that all of your ID fields are autoincremented integers. Thus, the
newest upload will be the one with the largest GalleryID.
Try this:
SELECT Category.CatName, Gallery.directory, subcat.Directory,
photos.photo, photos.galimg, subcat.img
FROMCategory, photos, subcat, G
Can someone tell me what's wrong with this line:
SELECT * FROM Events WHERE eDate <
I can't figure out how to get a date query to work right...
Thanks,
Scott
-Original Message-
From: Costas Piliotis
Sent: Mon 01/13/2003 01:01 PM
To: CF-Talk
Hi all,
I have a table with columns named q1,q2,q3, through q19. Each question can have a
value of 1, 2, or 3. How can I generate a query/cfcode that will tell me how many
people answered 1, 2, and 3 for question 1 through question 19 without having a ton of
queries? I know it needs to loop som
I'm having a bit of trouble with my query. What I have is a table with
Tickets. I want to select all the tickets, which works great. Each Ticket
has accompanying Threads, so each Ticket can have multiple threads (like a
conversation). What I also need to grab along with the Tickets, is the
NEWEST T
I need to write some SQL that says
Delete from session where Last is 1 minute ago
Delete
>From Session
Where Last < __
???
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www
Hello,
I have a table one column of which is a foreign key. For each unique value
in this column I'd like to output 2 rows containing this value. Obviously,
that would be pretty easy in CF, but I need it to be completely in SQL.
Thanks for any tips!
___
This is my query...
select * from estates where featured = 1 and
[ I want to select the oldest date_modified field here ]
~~
Daniel Farmer
Coldfusion Developer / Sales / Producer
613.284.1684
~~
[Todays Threads]
[This Message]
[Subs
How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for the
record I just inserted...
__
This list and all House of Fusion resources hosted by CFHosti
I'm missing something here.
I have an Oracle database. A column named LIVE have a type of varchar2(3),
with possible values of YES or NO.
I have a simple query where I am attempting to get all records where LIVE is
YES. Sounds easy right??
Why does this give me an error?
SELECT headline,
I'm missing something here.
I have an Oracle database. A column named LIVE have a type of varchar2(3),
with possible values of YES or NO.
I have a simple query where I am attempting to get all records where LIVE is
YES. Sounds easy right??
Why does this give me an error?
SELECT headline,
I am using the following query to pull info from a DB and give me the record
count for each doc_group_id. I've gotten to this point but this is as far as
I can go. Can some SQL guru here lend a hand?
SELECT
doc_group_id, short_descr, (SELECT COUNT(doc_id) AS DocCount FROM documents
WHERE
Hello, I am getting the below message:
[INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-00937: not a single-group
group function
SQL = "SELECT SUM(PRICE) AS
tot_price,ORDERID,CUSTOMERID,REPORTID,ORDERDATE,PRICE,TRANSAPPROVED,ORDER_TYPE
FROM REIS.ORDERS WHERE TRANSAPPROVED = 'Y' AND ORDERDATE BE
Ok.. why does it say this:
Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not
match with a table name or alias name used in the query.
Query:
SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus,
Tickets.Priority,
Us
Merry Meet,
I have a query that pulls data from almost identical tables and I need to
know which rows come from which tables.
IE:
SELECT id, name
FROM table1, table2
WHERE table1.name LIKE '%#search#%'
OR table2.name LIKE '%#search#%'
then in the output I need to know which table (1 or 2) each
Does anyone see any problems with the following query:
Select shiprate from shipratesdollars
WHERE '#session.total#' >= shipfrom
and '#session.total#' <= shipto
I can not figure out why I am getting incorrect results. Sometimes it will
pull more than one record and sometimes it will pull the
(second post, i didnt see it make it back)
This query works fine but I need to select about 10-15 more columns from the
Master (m) table. The only way I can seem to get that to work is if I also
group on all the columns but this totally kills the query speed and Im not
sure I am even getting corr
I have to make a report based upon this scenario...seems simple, yet I
can't get the numbers rightany pointers? (I have ordered a newer
Advanced SQL book in the meantime!!)
Need to get orders within date range containing a part number and get
total dollars received in payments for this.
So I
@;careyweb.com]
Sent: Sunday, November 03, 2002 8:54 AM
To: CF-Talk
Subject: Query help
I know I have done this in the past, but I cannot figure it out for some
reason.
I want to grab out of a database the record with the highest value for
the field RATING (it is an INT). I also want to grab all the data
Try this...
SELECT Image1, Description
FROM cars
WHERE rating = (SELECT MAX(rating) FROM cars)
HTH,
Jeff Garza
-Original Message-
From: Chad [mailto:cgray@;careyweb.com]
Sent: Sunday, November 03, 2002 8:54 AM
To: CF-Talk
Subject: Query help
I know I have done this in the past, but
Thanks guys...
These queries did the trick!
> -Original Message-
> From: Jeff [mailto:jeff@;hawkandheron.com]
> Sent: Sunday, November 03, 2002 11:01 AM
> To: CF-Talk
> Subject: RE: Query help
>
> Try this...
>
> SELECT Image1, Description
> FROM car
e off) you're saying "get all
the cars and sort them by rating, then just return the first one ("top
1").
Hope this helps,
Jim Davis
> -Original Message-
> From: Chad [mailto:cgray@;careyweb.com]
> Sent: Sunday, November 03, 2002 10:54 AM
> To: CF-Talk
&
Try ordering by date descending and limiting to five rows.
SELECT eID, city, state, country, datestamp
ORDER BY datestamp DESC
> -Original Message-
> From: Mark Leder [mailto:mel@;markleder.com]
> Sent: Tuesday, November 05, 2002 1:42 PM
> To: CF-Talk
> Subj
Not sure you can but you might.
However instead of the WHERE clause ADD a ORDER BY Clause
and have it = DateStamp
Then on the OUTPUT QUERY TAG set Maxrows = 5
Sure there maybe another way but that is one.
>>> [EMAIL PROTECTED] 11/05/02 01:41PM >>>
Hi All,
In a query, pulled from MS Access, I
Works great! Thanks.
Thanks,
Mark
-Original Message-
From: Everett, Al [mailto:AEverett@;askallied.com]
Sent: Tuesday, November 05, 2002 1:58 PM
To: CF-Talk
Subject: RE: Query Help
Try ordering by date descending and limiting to five rows.
SELECT eID, city, state, country
Heres the query:
SELECT ALL STUDENT.STUDENT_NUM,
STUDENT.LASTNAME, STUDENT.FIRSTNAME, STUDENT.BIRTHDATE, STUDENT.SEX,
STUDENT.SSNUM,
STSERVICE.DATE_BEGIN, STSERVICE.DATE_END, STSERVICE.LOCATION,
STSERVICE.HANDICAP,
STSERVICE.CSIZE_RATIO, STSERVICE.ST_CLASS, STSERVICE.FUND,
STSERVICE.SERVICE, CUST
I need to parse a query to a calendar database that returns just the current month's
events, and I'm hung up on the Where part of the query (I'm obiously also getting very
confused between CF and SQL functions).
SELECT Title, Details, EventDate, StartHour, StartMin
FROMEvents
WHERE Da
working for jd?
tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 2:56 PM
To: CF-Talk
Subject: Query Help
That works only if I want to display the last photo added. I need to
display the last photo added to each category.
Thanks for the help though
Emmet
-Original Message-
From: Harley Friedman [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 6:22 PM
To: CF-Talk
Subject: Query Help
I got it...I've gotta figure out a way to get ASP out of my head...lol
Scott
-Original Message-
From: Scott Wilhelm
Sent: Mon 01/13/2003 01:02 PM
To: CF-Talk
Cc:
Subject: Query help!
Can someone te
try
SELECT *
FROM events
WHERE eDate < ;
(assuming your eDate field is a date/time datatype...i don't think you'd
need a dateFormat() function)
hth,
charlie
Scott Wilhelm writes:
> Can someone tell me what's wrong with this line:
>
>
> SELECT * FROM Events WHERE eDate < value=#f
Instead of dateformat try createodbcdate(now())
Cutter
Scott Wilhelm wrote:
>Can someone tell me what's wrong with this line:
>
>
> SELECT * FROM Events WHERE eDate < value=#formatdate(now(),"mm-dd-yy")#>
>
>
>I can't figure out how to get a date query to work right...
>
>Thanks,
>
>Scott
>
Assuming that your running from a SQLServer or access DB (although it should
work with mysql) try
SELECT * FROM Events WHERE eDate <
HTH
-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 18:02
To: CF-Talk
Subject: Query h
Please look at the help docs for cfqueryparam. It takes at least two
params, one for value and another for type. You should specify the
type. Also note that you don't have to format the date when passing to
cfqueryparam.
Best regards,
Sam
BTW, a lot of people don't use cfqueryparam until t
SELECT * FROM Events WHERE eDate <
-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 10:21 AM
To: CF-Talk
Subject: Re: Query help!
Please look at the help docs for cfqueryparam. It takes at least two
params, one for value
Can someone tell me what's wrong with this query? I've verified that
everything between this query & the database matches up, I've printed
out the SQL statement, and that was verified through my database that
it's good...
INSERT INTO Links(Text, URL, SBName, SBEmail, SBSchool, Category)
VALUES(
select q1, q2, from table
At 03:49 PM 1/29/2003 -0500, you wrote:
>Hi all,
>
>I have a table with columns named q1,q2,q3, through q19. Each question can
>have a value of 1, 2, or 3. How can I generate a query/cfcode that will
>tell me how many people answered 1, 2, and 3 for question
> I have a table with columns named q1,q2,q3, through q19. Each
> question can have a value of 1, 2, or 3. How can I generate a
> query/cfcode that will tell me how many people answered 1, 2, and 3
> for question 1 through question 19 without having a ton of queries?
> I know it needs to loop someh
Why are you doing a max on the sentby table as well?
You also may try doing an inner join as well.
Also, If subject and priority could be different, you may want to get rid of
them otherwise you are not going to get what you want.
The easiest for this may be another approach if you must have those
T.priority desc, T.ticketID
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 08:35 PM
To: CF-Talk
Subject: RE: QUERY Help
Why are you doing a max on the sentby table as well?
You also may try doing an inner join as well.
Also, If subject
suooprt Query of
Queries? Any other ideas?
Cedric
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 6:39 PM
Subject: RE: QUERY Help
> This got cut out...sorry!
>
> SELECT Th.sentBy,T.ti
Villat [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 09:20 PM
To: CF-Talk
Subject: Re: QUERY Help
Thanks for the help, but I'm getting an error.
[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-log]You have an error in your SQL
syntax near 'SELECT Max(threadID) AS threa
Thanks! This worked great with a couple small modifications.
Cedric
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 9:42 PM
Subject: RE: QUERY Help
> You may have to put Select Max(ThreadID) AS
WHERE last < #DateAdd("n", "-1", now())#
Adam.
> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 12:12 PM
> To: CF-Talk
> Subject: Query Help?
>
>
> I need to write some SQL that says
&
Hi,
I want to delete a specific amount of records matching a criteria.
I may have many records matching the crteria but I want to delete a specified amount.
Is it possible to do this directly with SQL?
Thank you,
Frank Mamone
__
> To: CF-Talk
> Subject: Query help
>
>
> Hello,
>
> I have a table one column of which is a foreign key. For each
> unique value
> in this column I'd like to output 2 rows containing this
> value. Obviously,
> that would be pretty easy in CF, but I need
.
> -Original Message-
> From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 1:24 PM
> To: CF-Talk
> Subject: RE: Query help
>
>
> Output two rows or two columns?
>
> I don't know about rows, but columns would be fairly easy:
>
> S
What I am looking to do would be like this in CF:
SELECT DISTINCT number FROM table
SELECT TOP 2 *
FROM table
WHERE number = #getNums.number#
Is there anyway to combine this into one query?
T-SQL maybe?
- Original Message -
From: "C
select top 2 * from table
where number in
(select distinct number from table)
- Matt Small
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:32 PM
To: CF-Talk
Subject: Re: Query help
What I am looking to do would be like this
Adam.
> -Original Message-
> From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 2:53 PM
> To: CF-Talk
> Subject: RE: Query help
>
>
> select top 2 * from table
> where number in
> (select distinct number from table)
>
> - Matt S
t: RE: Query help
select top 2 * from table
where number in
(select distinct number from table)
- Matt Small
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:32 PM
To: CF-Talk
Subject: Re: Query help
What I am looking to do would be like
Hmmm... good catch. It certainly is Friday.
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:46 PM
To: CF-Talk
Subject: RE: Query help
Hehe, I was going to post the same thing, but I caught myself. That will
only return two records
t; -Original Message-
> From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 2:53 PM
> To: CF-Talk
> Subject: RE: Query help
>
>
> select top 2 * from table
> where number in
> (
le t2 where t2.number = t4.number))
order by number
-Marian :)
> -Original Message-
> From: stas [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 4:26 PM
> To: CF-Talk
> Subject: Re: Query help
>
>
> Andrew - the query you posted using UNION SOLUTION
Nice one Marian.
Adam.
> -Original Message-
> From: Marian Dumitrascu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 3:49 PM
> To: CF-Talk
> Subject: RE: Query help
>
>
> try this , (but you'll need an unique id):
>
> select * from tabl
Wow, it works!. Are you a witch? :D
Would you please unwind this query for me?
- Original Message -
From: "Marian Dumitrascu" <[EMAIL PROTECTED]>
try this , (but you'll need an unique id):
select * from table t1
where
t1.id in (select top 1 id from table t2 where t2.number = t1.numb
: Query help
select top 2 * from table
where number in
(select distinct number from table)
- Matt Small
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:32 PM
To: CF-Talk
Subject: Re: Query help
What I am looking to do would be
CFMX 6.1 Cached Query Problem:
I have an XML file that I'm reading into a query object (to facilitate faster search) using the QueryNew(), QueryAddRow() and QuerySetCell() functions. Now, I need to hit this query often and I decided that caching it would be a good idea. Hence I did a query of query
Thanks..that worked out easier.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
select * from estates where featured = 1 and date_modified=(select max(date_modified) from estates)
Nick Han
>>> [EMAIL PROTECTED] 02/17/04 10:14AM >>>
This is my query...
select * from estates where featured = 1 and
[ I want to select the oldest date_modified field here ]
select * from estates where featured = 1 and date <= (select
max(date_modified) from estates where featured = 1)
maybe?
-Original Message-
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 1:15 PM
To: CF-Talk
Subject: query help...
This is my qu
this didn't work got error... using mySQL btw
TCX][MyODBC]You have an error in your SQL syntax near
- Original MTCX][MyODBC]You have an error in your SQL syntax near essage -
From: Nick Han
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:21 PM
Subject: Re: query
This didn't work either...
TCX][MyODBC]You have an error in your SQL syntax near
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:24 PM
Subject: RE: query help...
select * from estates where featured = 1 and date <= (sele
Daniel Farmer wrote:
> This is my query...
>
> select * from estates where featured = 1 and
>
> [ I want to select the oldest date_modified field here ]
>
>
>
> ~~
> Daniel Farmer
> Coldfusion Developer / Sales / Producer
> 613.284.1684
> ~~
ECTED]
Sent: Tuesday, February 17, 2004 1:51 PM
To: CF-Talk
Subject: Re: query help...
Daniel Farmer wrote:
> This is my query...
>
> select * from estates where featured = 1 and
>
> [ I want to select the oldest date_modified field here ]
>
>
>
> ~~
select top 1 *
from estates
where featured = 1
Order by date_modified desc
> From: Daniel Farmer [mailto:[EMAIL PROTECTED]
>
> This is my query...
>
> select * from estates where featured = 1 and
>
> [ I want to select the oldest date_modified field here ]
[Todays Threads]
[This Message]
use the first
record? Or if you're worried about passing all of that data back and
forth you can use TOP (or whatever corresponds to your DB server)
John Burns
-Original Message-
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 1:51 PM
To: CF-Talk
S
OK that sounds like a good solution but how do I select the first record of a query ?
- Original Message -
From: Burns, John
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:53 PM
Subject: RE: query help...
Why not select them ordered by date_modified and then just use the
I think this has been the closest yet... but still no work. =(
- Original Message -
From: Philip Arnold
To: CF-Talk
Sent: Tuesday, February 17, 2004 2:04 PM
Subject: RE: query help...
select top 1 *
from estates
where featured = 1
Order by date_modified desc
uot; startrow="1" maxrows="1"> and that would just output the
first record.
John Burns
-Original Message-
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 2:17 PM
To: CF-Talk
Subject: Re: query help...
I think this has been the close
> Well, if you do top 1 you would not want dates desc or the
> first one would be the newest (right?).
Oops, I mis-read, the desc was in there as I thought he wanted the
newest
> Other than that, you
> could just return the whole query (if there's no sort of top
> syntax for your DB it'll w
> Jeremy, I didn't use the rownum example because in the given
> scenario, using rownum may not give you the latest mod date
> record from the all records in the table.
Won't it give you the first record if you specify an ORDER BY?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsu
AIL PROTECTED] 02/17/04 10:53AM >>>
> > Why not select them ordered by date_modified and then just use the
> > first
> > record? Or if you're worried about passing all of that
> data back and
> > forth you can use TOP (or whatever corresponds to your DB
Intuitively, you would think so, but it doesn't work that way. The sql engine would do the rownum first and then apply the order-by clause after.
So if you do this, select * from users where rownum >=10 and last_name='SMITH' order by last_name, first_name, you might not get exactly what you exp
3:12 PM
To: CF-Talk
Subject: RE: query help...
> Well, if you do top 1 you would not want dates desc or the first one
> would be the newest (right?).
Oops, I mis-read, the desc was in there as I thought he wanted the
newest
> Other than that, you
> could just return the whole query
And people say that Oracle is better than SQL Server?
I do TOP quite a lot, so it'd be annoying to have to bury my query in a
sub-query that is "unnecessary"
> Intuitively, you would think so, but it doesn't work that
> way. The sql engine would do the rownum first and then apply
> the order-b
= @id
SELECT @id
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 14:06
To: CF-Talk
Subject: Query help
How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for the
record I
almost!
instead of SELECT @@identity = @id you need SELECT @id = @@identity
-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 15:14
To: CF-Talk
Subject: RE: Query help
Kris,
In your Stored Proc you can use one of SQL's own vari
Just keeping you on your toes Boss!
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 15:18
To: CF-Talk
Subject: RE: Query help
almost!
instead of SELECT @@identity = @id you need SELECT @id = @@identity
-Original Message-
From
ssage-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:06 AM
To: CF-Talk
Subject: Query help
How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for the
record I just ins
s.com
-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 10:14 AM
To: CF-Talk
Subject: RE: Query help
Kris,
In your Stored Proc you can use one of SQL's own variables @@identity to get
the row id for the record you have just inserted. Simply assign
PROTECTED]>
Sent: Tuesday, May 21, 2002 8:05 AM
Subject: Query help
> How can Insert a record into a table (that I know how to do) but after
> the insert, I want to be able to know what the primary key for the
> record I just inserted...
>
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 9:06 AM
To: CF-Talk
Subject: Query help
How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for t
What database? What are you using as a primary key (an ID number)?
On Tue, 21 May 2002, Kris Pilles wrote:
> How can Insert a record into a table (that I know how to do) but after
> the insert, I want to be able to know what the primary key for the
> record I just inserted...
>
_
Access. Yeah autonumber field... I've never done this before seems like
it would be a simple task
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 10:29 AM
To: CF-Talk
Subject: Re: Query help
What database? What are you using as a primary key (
Almost all the answers are MS SQL-centric.
Not sure what type of development house you work in, but MS-SQL centric
answers are not a valid solution for some of us.
Both Oracle and MS SQL have several methods to retrieve the last primary
key in a particular table.
I won't bore you with my opinion
autonumber field it sounds like he's using MS Access, in which case I don't
believe there even exists a datetimestamp column type.
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 11:23 AM
To: CF-Talk
Subject: RE: Query help
Almost all
I agree with you, 99% of the time it will be Access or SQL Server.
I just gave another possible answer because I wanted to shed another view.
Access also has a date/time field which one can create a CF variable and
then insert that in and then check against the cf variable.
Works well.
At 11:41
oever started this thread is paying attention to my ramblings at this
point anyway.
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 11:50 AM
To: CF-Talk
Subject: RE: Query help
I agree with you, 99% of the time it will be Access or SQL Server.
I just
If you're using SQL Server, it's not always good practice to use @@IDENTITY.
Instead, use SCOPE_IDENTITY(). SCOPE_IDENTITY() is the same as @@IDENTITY,
except it limits the scope. For example, if you insert a row into TableA,
but that table has an insert trigger that does some processing and ins
> Also, SCOPE_IDENTITY() may have been recently added. It may
> be a SQL Server 2000 feature so if you're using anything
> prior, you may be out of luck. Anybody else know if this
> is new to SQL Server 2000?
Yes, it's new to SQL Server 2000.
Dave Watts, CTO, Fig Leaf Software
http://www.figl
-Talk
Subject: RE: Query help
If you're using SQL Server, it's not always good practice to use @@IDENTITY.
Instead, use SCOPE_IDENTITY(). SCOPE_IDENTITY() is the same as @@IDENTITY,
except it limits the scope. For example, if you insert a row into TableA,
but that table has an insert tr
Hello,
I am having a little trouble constructing this query
because I need a count of a " distinct composite
column combo - Date and CMid"..for example..here is
the table and the columns in it:
DateCMid value rate
- -- -- --
02/021 3 6
02/021
Since I'm still very new to CF, I'm back at the trough for some more help.
First I'm like to say thinks to all that have help in the past and any help
I can get on this one, since I've been beating my head for three days on at.
I have a database that has the Date Of Birth (DOB) stored in mm/dd/
Hi all,
I have this simple search query that's perplexing me somewhat.
select news.title, news.subtitle, news.dated, news.id, news.article
fromnews
where news.complete = 1
and news.article like '#form.keywords#%'
or
> Why does this give me an error?
try
WHERE live is 'YES'
or
WHERE live = 'YES'
or
WHERE live like 'YES'
Regards,
Gennadi
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Uns
Jeff,
The "where" clause in your query is not correct. It should be
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE live = 'Yes'
ORDER by date_entered DESC
Nathan Chen
Jeff Fongemie wrote:
> I'm missing something here.
>
> I have an Oracle database
Hi All,
Thanks to all those that answered my cry for SQL help. David's query did the
trick. Thanks David
Duane
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 12:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Query Help
Hi Duane.
Hav
1 - 100 of 308 matches
Mail list logo