Sorry abot the fingers. What I was about to say was - is 600 and 400 the
result you *want* or that you don't want?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.co
- Original Message -
From: "JS" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 19, 2003 1:42 PM
Subject: OT: SQL Help
> I know there are some smart SQL people on this list,
> so I hope someone would be willing to h
I know there are some smart SQL people on this list,
so I hope someone would be willing to help me with my
problem.
I have 2 tables
table 1
uid | person_id | amount
table 2
table_1_uid | person_id | percentage
I need a way to join these tables to get the
percentage of each amount due to a perso
OK... Here are my queries. I need to add 1 more lookup to this but I
am sure...
I need to add a lookup to that does this:
Select CourseID
>From Sections
Where Catalog_ID = #Getname.code#
I am just unsure as to how to integrate this Query into my existing
SQL We are currently looking u
You can also just check the value using CFOUTPUT and then add it to the list
if it is less than six.
Peter Bagnato
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 7:37 PM
To: CF-Talk
Subject: Re: SQL Help Requested
Thomas Sammons wrote:
>
> How would you do this in CF (any version 4.5 or higher): return all
> unique combinations of rows where the unique row field value combination
> has a certain summed value?
>
> For example:
> I have a SocksTable with 6 SockDrawers, and each SockDrawer has a number
> of S
Hiho,
I've posted this at the cf dev support forums but haven't gotten any
replies, so I thought I'd try here (where all the really smart people
are :-)
How would you do this in CF (any version 4.5 or higher): return all
unique combinations of rows where the unique row field value combination
h
The problem is that you're using cursors. Cursors in SQL Server are very, very slow.
Come up with an alternate way of doing your import.
- Original Message -
From: Duane Boudreau <[EMAIL PROTECTED]>
Date: Thursday, January 23, 2003 9:02 am
Subject: OT: SQL Help
> Hi Al
- SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail =
'[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND
(Approved = 1) AND (Registered = 1)
-Origi
tp://ruinworld.sourceforge.net
Scientia Est Potentia
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:56 AM
To: CF-Talk
Subject: RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (E
Registered = 1
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:56 PM
To: CF-T
ssage-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:48 PM
To: CF-Talk
Subject: RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew S
://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> Sorry for the OT but this should be a quick ans
L PROTECTED] I should be able to log in but the
problem is that it only accepts the primary email address.
Hope this clears it up.
Thanks,
Tony
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:22 PM
To: CF-Talk
Subject: RE: OT - S
> Sorry for the OT but this should be a quick answer.
> This is in ASP (sorry).
>
> If I have the following:
> sql = "SELECT * FROM SomeTable "
> sql = sql & "WHERE Email = '" & Request("un") & "'"
> sql = sql & " OR SEmail = '" & Request("un") & "'"
> sql = sql & " AND IsDeleted = 0 "
>
:14 PM
To: CF-Talk
Subject: RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: RE: OT - SQL Help
my ASP's not what it used to be! - so did Randells po
:14 PM
To: CF-Talk
Subject: RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: RE: OT - SQL Help
my ASP's not what it used to be! - so did Randells po
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: RE: OT - SQL Help
my ASP's not what it used to be! - so did Randells post sort it?
-Original Message-
my ASP's not what it used to be! - so did Randells post sort it?
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 17:59
To: CF-Talk
Subject: RE: OT - SQL Help
Dave's absolutely right. I am a lil' lazy. The less typin
Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^)
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 12:56 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> Sorry - I wasn't particularly clear. What I
This and CFDJList are the only good lists that are out there where everyone
is more than helpful and help/answers are extrememly quick.
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 12:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
That is
> Sorry - I wasn't particularly clear. What I meant to
> say was that the request object has a number of
> collections associated with it (form, querystring,
> etc...). When I have used the request object I have
> always referenced an element of one of these collections
> e,g, request.form("un
2002 17:25
To: CF-Talk
Subject: RE: OT - SQL Help
No scope. It is written in ASP.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:46 AM
To: CF-Talk
Subject: RE: OT - SQL Help
I'm a bit confused - I'm not sure what you mean b
:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:25 AM
To: CF-Talk
Subject: RE: OT - SQL Help
No scope. It is written in ASP.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:46 AM
To: CF-Talk
Subject: RE: OT - SQL Help
I'm
No scope. It is written in ASP.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:46 AM
To: CF-Talk
Subject: RE: OT - SQL Help
I'm a bit confused - I'm not sure what you mean by the error you are
getting. What scope are you
its using Structure notation.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 16:46
To: CF-Talk
Subject: RE: OT - SQL Help
I'm a bit confused - I'm not sure what you mean by the error you are
getting. What scope are you trying to r
ust reference them as "un". Not saying that
what you have will cause errors - just not seen it written like that b4.
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 16:31
To: CF-Talk
Subject: OT - SQL Help
Hi all,
Sorry for the OT but this s
You ( ) around your OR statements
Example:
sql = "SELECT * FROM SomeTable "
sql = sql & "WHERE (Email = '" & Request("un") & "'"
sql = sql & " OR SEmail = '" & Request("un") & "')"
sql = sql & " AND IsDeleted = 0 "
sql = sql & " AND Password = '" & Request("pw") & "'"
sql = sql & " AN
Hi all,
Sorry for the OT but this should be a quick answer. This is in ASP (sorry).
If I have the following:
sql = "SELECT * FROM SomeTable "
sql = sql & "WHERE Email = '" & Request("un") & "'"
sql = sql & " OR SEmail = '" & Request("un") & "'"
sql = sql & " AND IsDeleted = 0 "
sql = sq
Jason,
first, you should alias the tables and select real column names (get rid of
the asterick). Second, start with what you are after (probably the book in
this case)
Third, adjust the kinds of joins (inner outer full) - I've left those out
intentionally. Fourth, use query analyzer or some othe
Sorry I always forget to include the code- can't you guys read my mind :}
Here are the two queries I built because i couldn't figure out how to do a
four table join. (it was cobbled together from about 8 SQL books at
borders, and yes I did many google searches for table joins over 3 tables,
but c
SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.FieldX = Table2.FieldX
INNER JOIN Table3 ON Table1.FieldX = Table3.FieldX
INNER JOIN Table4 ON Table1.FieldX = Table4.FieldX
WHERE Table1.FieldY = SomeValueOfInterst
Try a Google Search for "SQL Tutor"
At 11:45 PM 11/5/02, you wrote:
>good evening
Jason,
It would help if you send a copy of your tables and fields for everyone to see. If
your using Studio, quick way to start is to use Query Builder and just modify
inner/outer joins as needed.
Michael
At 11:45 PM 11/5/2002 -0800, [EMAIL PROTECTED] wrote:
>good evening all (Or morning).
>I'v
good evening all (Or morning).
I've been digging around the net all night (and a number of books at
Borders- best library in town) but I can't find an easy example so here we
go:
I want to join 4 tables, what would a generic 4 table join look like?
thanks ahead of time. your help keeps me sane :)
SOLVED: Thanks again to all who had helped.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.
ere must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 1
ngs [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 8:59 AM
> To: CF-Talk
> Subject: RE: SQL HELP
>
>
> yes it may - unless you put ltrim(rtrim()) around the field values - change
> to an int and see what hapens
>
> -Original Message-
> From: Jos
g zero's in the other table
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 14:11
To: CF-Talk
Subject: RE: SQL HELP FIXED
I put this where statment in and it fixed the problem. The emp_id_nr in
tblemployee was null for empnr starting with six zeros
where emp_nr not like
'00%'))
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:53 AM
To: CF-Talk
Subject: Re: SQL HELP
Joshua Tipton wrote:
> For some unknown reason this query does not work correctly even though
Joshua Tipton wrote:
> The column is char 10 when I change it to int it truncates my numbers
> so I do not want that.
Use bigint/longint/int8 (or whatever your RDBMS calls 64 bit integers),
but if they are numbers you really should store them in an integer datatype.
Jochem
~~
FROM tblemployee)
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 14:04
To: CF-Talk
Subject: RE: SQL HELP
The column is char 10 when I change it to int it truncates my numbers so I
do not want that.
Josh
-Original Message-
The column is char 10 when I change it to int it truncates my numbers so I
do not want that.
Josh
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:59 AM
To: CF-Talk
Subject: RE: SQL HELP
yes it may - unless you put ltrim(rtrim()) around
yes it may - unless you put ltrim(rtrim()) around the field values - change
to an int and see what hapens
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 13:52
To: CF-Talk
Subject: RE: SQL HELP
Both char(10) I can change them to int is you think
Joshua Tipton wrote:
> For some unknown reason this query does not work correctly even though
> I know that there is data in temptbljobevl that does not match
> tblemployee data. Can someone please help me do this via a join.
I doubt that rewriting as a join is going to solve anything. That w
Both char(10) I can change them to int is you think it would make a
difference.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:44 AM
To: CF-Talk
Subject: RE: SQL HELP
shouldn't make a difference.
What field type is emp_id in
Still returns zero rows.
Josh
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:38 AM
To: CF-Talk
Subject: RE: SQL HELP
first of all I don't think you need the first ()
try this.
SELECT *
FROM temptblJOBEVL
-Talk
Subject: RE: SQL HELP
first of all I don't think you need the first ()
try this.
SELECT *
FROM temptblJOBEVL
WHERE SYS_EMP_ID_NR NOT IN
(SELECT emp_id_nr
FROM tblemployee)
.tony
Tony Weeg
Senior Web
ystem Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:40 AM
To: CF-Talk
Subject: SQL HELP
For some unknown reason this query does not work correctly even tho
For some unknown reason this query does not work correctly even though I
know that there is data in temptbljobevl that does not match tblemployee
data. Can someone please help me do this via a join.
Thanks,
Joshua Tipton
SELECT *
FROM temptblJOBEVL
WHERE (SYS_EMP_ID_NR NOT IN
> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=2
> 56
> &forumid=6&refresh=0
> Dan
> -Original Message-
> From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 12:13 PM
> To: CF-Talk
> Subject:
You could do it in SQL Server with a stored procedure and a cursor, although
all things considered, it's probably faster and easier to do it in cf...
I've thought about or wanted to do this myself on a number of occasions, but
never been able to find a way to do it that wasn't way more effort than
September 12, 2002 12:13 PM
To: CF-Talk
Subject: OT - MS SQL help
Is it possible to join two tables, and have a list of keys returned from one
of the tables as a column of a recordset?
tblOnePK| name
1 | threeFriends
tableTwoPK |
Is it possible to join two tables, and have a list of keys returned from one
of the tables as a column of a recordset?
tblOnePK| name
1 | threeFriends
tableTwoPK | tblOneFK
1 | 1
2 | 1
3 |
couldn't resist it..
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 16:37
To: CF-Talk
Subject: RE: SQL Help
had to go there huh neil :)
on a serious note, I would get the SQL in 10 minutes book by Mr Forta.
its cool. its easy to read. we
> Does anyone have a good site to bone up on SQL.
>
> I am looking to beef up my knowledge of stored procedures and
> learn all of the functions that MS SQL 2000 support.
Try SWYNK.com - they have some useful stuff there
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multime
o attend"
..tony
Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 11:42 AM
To: CF-Talk
Subject: RE: SQL Hel
I'll second that. Well the bit about it being cool, not the devcon bit :OP
Ade
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 16:37
To: CF-Talk
Subject: RE: SQL Help
had to go there huh neil :)
on a serious note, I would get the SQL in 10 mi
I bought a copy before I even realised it was by the man... Damn eh?
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 16:37
To: CF-Talk
Subject: RE: SQL Help
had to go there huh neil :)
on a serious note, I would get the SQL in 10 minutes book by Mr
410.548.2337
-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 11:29 AM
To: CF-Talk
Subject: RE: SQL Help
jeez dude, bone up in the privacy of your own home :-)
-Original Message-
From
jeez dude, bone up in the privacy of your own home :-)
-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 16:35
To: CF-Talk
Subject: SQL Help
Does anyone have a good site to bone up on SQL.
I am looking to beef up my
Does anyone have a good site to bone up on SQL.
I am looking to beef up my knowledge of stored procedures and learn all of
the functions that MS SQL 2000 support.
Thanks.
Matt Friedman
__
Your ad could be here. Monies from
#
-Original Message-
From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 9 augustus 2002 15:50
To: CF-Talk
Subject: Re: SQL Help
Actually let me show you
SELECT dbo.listings.address1, dbo.listings.city,
dbo.listings.address1,
dbo.listings.zip, dbo.listings.year_built
Woops, I didn't mean to post that query in there. Hehe. Sorry, disregard
it.
J
- Original Message -
From: "JLH All Turbo" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 9:49 AM
Subject: Re: SQL Help
#x27;s organizing the data by the style
it's just... I want each style to have a header when outputted.
I hope this makes more sense. :-)
J
- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, A
SELECT location, ball
FROM table
ORDER BY location, ball
#qTest.location#
#qTest.ball#
-Original Message-
From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 9 augustus 2002 15:36
To: CF-Talk
Subject: SQL Help
How can I structure a query
Make sure you are ordering by LocationName, then
#LocationName#
#Ball#
Is that what you mean??
- Original Message -
From: "JLH All Turbo" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 1:36
How can I structure a query and it's output to pull all the records out that
have a certain field = something and have them grouped by another field...
And then in the output put a header for each group?
In a DB with baseballs and footballs and different locations for the balls.
Pull all balls
disregard this. I know ...the commas.
On Tue, 30 Jul 2002, Alex wrote:
>
> SELECT *
>
> FROM HRWebAgent.tApply
>
> WHERE ReqNO > 0
> AND 0=0
>
>, AND(ReqNo='#ReqNo#')
>
>
>
>, AND(FIRSTNAME LIKE '#
SELECT *
FROM HRWebAgent.tApply
WHERE ReqNO > 0
AND 0=0
, AND(ReqNo='#ReqNo#')
, AND(FIRSTNAME LIKE '#FIRSTNAME#%')
On Tue, 30 Jul 2002, James Blaha wrote:
> Can any one help me out
# sign alert!
..you don't need those in 's to reference a variable.
works.
-Craig
>>-Original Message-
>>From: Venable, John [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, July 30, 2002 2:41 PM
>>To: CF-Talk
>>Subject: RE: SQL Help
>>
I don't think you need commas at all, the AND is the logical breakup of
statements.
John
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 2:29 PM
To: CF-Talk
Subject: SQL Help
Can any one help me out here? I'm having a problem ge
Just remove the commas. You shouldn't need them...
HTH,
Jim Vosika
http://tinyclick.com
Free URL Shortening!
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:29 PM
To: CF-Talk
Subject: SQL Help
Can any one help me out here? I'
: Can any one help me out here? I'm having a problem getting this query to
: work with putting in the proper commas when necessary in myWHERE clause
: for the SQL statement.
Don't put commas in the where clause. :-)
--Ben Doom
Programmer & General Lackey
Moonbow Software
nd on.
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 2:29 PM
To: CF-Talk
Subject: SQL Help
Can any one help me out here? I'm having a problem getting this query to
work with putting in the proper commas when necessary in myWHERE
Take out the commas and all will be good.
HTH
Clint Tredway
- Original Message --
from: James Blaha <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 30 Jul 2002 14:28:52 -0400
Can any one help me out here? I'm having a problem getting this query
Can any one help me out here? I'm having a problem getting this query to
work with putting in the proper commas when necessary in myWHERE clause
for the SQL statement.
James Blaha
SELECT *
FROM HRWebAgent.tApply
WHERE ReqNO > 0
AND(ReqNo=
> Since lovely M$ Sql does not have a select last_day function like oracle I
> was wondering if anyone had written a script that will take the month
> number and return either the number of days or the last day of that month?
Is there a particular reason it needs to be in the db? ...
declare @my
Since lovely M$ Sql does not have a select last_day function like oracle I
was wondering if anyone had written a script that will take the month number
and return either the number of days or the last day of that month?
Thanks,
Josh
m: Jeff Beer (E-mail) [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 1:11 PM
To: CF-Talk
Subject: SQL help
I have a products table with odd products..
Each product name exists in the table three times - they are actually
seperate products seperated by the product ID and some other attrib
I have a products table with odd products..
Each product name exists in the table three times - they are actually
seperate products seperated by the product ID and some other attributes.
I'm trying to query the DISTINCT product names to output so the site admin
can assign Featured status to cert
I got it:
Table2_ID = (600 + Table1_ID)
Thanks,
Dave
- Original Message -
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 10:26 PM
Subject: RE: A little SQL help
> >> WHERE Table1
>> WHERE Table1_ID = (600 + Table2_ID)
wouldn't it be this...
WHERE Table1_ID = (Table2_ID - 600)??
-Original Message-
From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 7:23 PM
To: CF-Talk
Subject: OT: A little SQL help
I want to filter the output of two tables with a "where" clause. Simple
enough. Except that the values in the two table keys look like this:
Table 1Table 2
IDID
106010
126012
256025
So, how can I write this SQL
though...
--- Kevin Schmidt <[EMAIL PROTECTED]> wrote:
> SELECT DISTINCT(CMME.iMonthlyEventID)
>
> :)
>
> Kevin
>
>
> -Original Message-
> From: Amanda Stern [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 9:18 AM
> To: CF-Talk
> Subj
SELECT DISTINCT(CMME.iMonthlyEventID)
:)
Kevin
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:18 AM
To: CF-Talk
Subject: SQL help - getting first rec of field
Hello,
I have been trying to figure out how to write this SQL
stmt..I
Hello,
I have been trying to figure out how to write this SQL
stmt..I have it written but it needs one more
modificationI need the query to only pull the
first unique EventID...
SELECT CMME.iMonthlyEventId as EventID,
CMME.iCMApptId as CMapptID,
cli.vClientFName + cli.vCli
t;[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 2:01 PM
Subject: Better way? Loop, Sql help
> ok i am trying to get this down & am running into problems
> Any Help would be greatly appreciated.
>
> First in rsStudioIN.StudioID i am trying to generate a list of id's t
lto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:11 AM
To: CF-Talk
Subject: Re: Better way? Loop, Sql help
>ok i am trying to get this down & am running into problems
>Any Help would be greatly appreciated.
>
>First in rsStudioIN.StudioID i am trying to generate a list of id&
>ok i am trying to get this down & am running into problems
>Any Help would be greatly appreciated.
>
>First in rsStudioIN.StudioID i am trying to generate a list of id's that
>where created this month
>it seems to being working, but when i call rsStudioIN.StudioID in my next
>Query, it only takes
ok i am trying to get this down & am running into problems
Any Help would be greatly appreciated.
First in rsStudioIN.StudioID i am trying to generate a list of id's that
where created this month
it seems to being working, but when i call rsStudioIN.StudioID in my next
Query, it only takes the fi
CF-Talk emails from the 'Hub?
Perhaps you subscribed to CF-Talk? I know CFHub posted another link to
CF-Talk (co houseoffusion.com) today but...
> UH OH! THERE IS A PROBLEM WITH WHAT I'M ASSUMING CAME FROM THE CFHUB SITE.
I
> JUST TRIED TO SIGN UP AND NOW I AM GETTING ALL THESE EMAILS!
>
Worked perfectly! Thank you! Now if I can only get them imported.
Athelene
-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 2:51 PM
To: CF-Talk
Subject: RE: SQL Help Needed!
This will work in sql server. Don't think access sup
UH OH! THERE IS A PROBLEM WITH WHAT I'M ASSUMING CAME FROM THE CFHUB SITE. I
JUST TRIED TO SIGN UP AND NOW I AM GETTING ALL THESE EMAILS!
-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:51 PM
To: CF-Talk
Subject: RE: SQL Help N
This will work in sql server. Don't think access supports compound outer
joins... I could be mistaken though...
Select * from
Docmaster left outer join versions on
docmaster.docnum = versions.docnumber and
docmaster.version = versions.version
Where verersions.docnumber is null
nt: Monday, March 18, 2002 6:48 PM
To: CF-Talk
Subject: SQL>>>HELP QUICK!
What does this mean?
Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
into column 'athId',
t my child may have
peace'..."
- Thomas Paine, The American Crisis
-Original Message-
From: CF_JONNY [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 3:48 PM
To: CF-Talk
Subject: SQL>>>HELP QUICK!
What does this mean?
Error Diagnostic Information
ODBC Error
What does this mean?
Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
into column 'athId', table 'blah.dbo.blah'; column does not allow nulls.
INSERT fails.
Do I need to set the Pri
] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 11:06 AM
> To: CF-Talk
> Subject: Re: SQL help please
>
>
> try
>
> select employeeid, startdate, enddate, count(*), paycatid
> from X
> gro
cc:
03/13/02 Subject: Re: SQL help please
04:51 PM
301 - 400 of 481 matches
Mail list logo