> Wow, I can't believe I didn't think of using a temporary table to store the
> dynamic data while it's being edited, that's a great
> idea. I can't use session variables because it's a grid and would be
> considered a complex data type. (I was under the
> impression that session variables can o
Wow, I can't believe I didn't think of using a temporary table to store the
dynamic data while it's being edited, that's a great idea. I can't use session
variables because it's a grid and would be considered a complex data type. (I
was under the impression that session variables can only hold
> Thanks Justin, I wasn't aware that a dynamic query was lost
> once the page was finished loading. Does the same rule apply
> to structures?
Yes, that would apply to all variables unless you store them in
persistent memory (e.g. database, session scope, write to a file,
etc.). In your case I wo
normal variables only exists for the duration of the CF request.
you need to use session scope if you want persistence that is specific
to each user.
On Mon, Nov 7, 2011 at 6:01 PM, Ray Meade wrote:
>
> Thanks Justin, I wasn't aware that a dynamic query was lost once the page was
> finished loa
Thanks Justin, I wasn't aware that a dynamic query was lost once the page was
finished loading. Does the same rule apply to structures? Perhaps I can use a
structure to hold the data and update it as changes are made. Basically, I
don't want the physical database being updated until the submit
> ...I'm not sure how to update the dynamic query.
Hi Ray, I don't know much about the mechanics of your application, but
remember that once the HTML has been generated and the page loaded on
the client, the ColdFusion process is finished and that dynamic query
doesn't exist in memory anymore unt
I'm writing an app. for an auto repair shop that has a Flash cfgrid containing
quantity, description, price and total cost (the quantity times the price).
Right now, the initial total cost is being calculated in a view in the
database. I've created a dynamic query (using queryNew) to hold all o
ments ...
From: "Stefan Richter"
Sent: Monday, January 31, 2011 3:21 PM
To: "cf-talk"
Subject: Re: Query of query help
I was trying something like this:
select * from roomList
WHERE name = 'x'
OR roomList.name = '#ro
Ah great, an interesting approach. Many thanks.
Stefan
On 31 Jan 2011, at 20:10, Jason Fisher wrote:
>
> Stefan,
>
>
> This might work ... can't remember if the IN () function works in QoQ or
> not.
>
>
>
>
>
>
>
>
>
> SELECT *
> FROM roomList
> WHERE name NOT I
I was trying something like this:
select * from roomList
WHERE name = 'x'
OR roomList.name = '#roomid#'
I think I am getting somewhere with it. Anything inherently wrong with this?
Stefan
On 31 Jan 2011, at 17:54, Raymond Camden wrote:
>
> Um, did you try the where clause? You said
PM
To: "cf-talk"
Subject: Re: Query of query help
Thanks.
Guess what I was trying to avoid was a loop with 35,000 queries... I was
trying to come up wit a clever way to do this in one SQL statement. One
issue I noticed is that QoQ does not to seem to (easily?) support joins.
Then again I&#x
Thanks Dave,
listing the folders performs a lot better than I expected, so that's not my
issue here.
Cheers
Stefan
On 31 Jan 2011, at 17:57, Dave Watts wrote:
>
>> I've got a folder which contains 35,000 folders.
>
> Setting aside your QoQ question, you may have problems simply
> traver
Thanks.
Guess what I was trying to avoid was a loop with 35,000 queries... I was trying
to come up wit a clever way to do this in one SQL statement. One issue I
noticed is that QoQ does not to seem to (easily?) support joins.
Then again I'm no SQL ninja by any means.
S
On 31 Jan 2011, at 17
> I've got a folder which contains 35,000 folders.
Setting aside your QoQ question, you may have problems simply
traversing a folder with this many items in it.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Bus
Yes, QoQ will work here.
SELECT roomid
FROM rooms
SELECT name
FROM roomsDB
WHERE roomid = '#name#'
Um, did you try the where clause? You said it didn't work - how did it
not work? Can you show us the full code and the error?
On Mon, Jan 31, 2011 at 11:48 AM, Stefan Richter
wrote:
>
> Hi all,
> hoping for some advice with querying a query - at least I think that's what's
> a good fit here bu
Hi all,
hoping for some advice with querying a query - at least I think that's what's a
good fit here but feel free to advise otherwise.
I've got a folder which contains 35,000 folders. I've also got a table with
lots of records, where the roomid column matches the name of one of the
folders.
I've got some code that uses the JExcelAPI for converting queries to
Excel spreadsheets.
It's got some support for formulas, so theoretically you could "wow"
the people you need to send it to by not only having the sums there,
but having them update if they change the numbers in the various
colum
I have no idea what that was. My sent mail has the same blank
message, but I didn't reply. WITH ROLLUP is the clause you want
though, if your DB supports it.
cheers,
barneyb
--
Barney Boisvert
bboisv...@gmail.com
http://www.barneyb.com/
On Jul 17, 2009, at 4:09 PM, Seamus Campbell
wrot
Hi Barney
Your answer was cut - would you mind resending please
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/grou
On Thu, Jul 16, 2009 at 4:57 AM, Seamus
Campbell wrote:
>
> I have a database (access at the moment) for members of an organisation. The
> members are scattered throughout (mostly in one state) Australia (with a
> couple in the US) They all are one of three language groups.
>
> I need to export
I have a database (access at the moment) for members of an organisation. The
members are scattered throughout (mostly in one state) Australia (with a couple
in the US) They all are one of three language groups.
I need to export an excel spreadsheet with a count of members from each
language gr
- Original Message -
From: "Jason Fisher" <[EMAIL PROTECTED]>
> Cool, yeah I never remember until I do it when an aggregate query is going
> to want HAVING vs WHERE. Glad it's working for you!
This bites me too when I'm not paying attention. Just remember that the
WHERE applies to the
Cool, yeah I never remember until I do it when an aggregate query is going to
want HAVING vs WHERE. Glad it's working for you!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free
NM, got it... changed the where clause to having and moved it below the group
by... seems to be working so far!
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
h
didn't work, got an error. changed the isnull to ifnull, got a "invalid use of
a group function" error... I don't even know how to fix that...=(
> Try this, I think it's what you're looking for:
>
> SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points, p.
> short_description, p.quant
> In MS SQL Server it's ISNULL(), but can't speak for other platforms.
> Can't recall what it is in Oracle, might just be NULL().
IIRC in Oracle it is NVL. There is also COALESCE, which is usually a safe bet
with most databases.
~~~
In MS SQL Server it's ISNULL(), but can't speak for other platforms. Can't
recall what it is in Oracle, might just be NULL().
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free T
i believe the correct function to use is IFNULL(), not ISNULL()...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Jason Fisher wrote:
> Try this, I think it's what you're looking for:
>
> SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points,
> p.short_description, p.quantity, p.
Try this, I think it's what you're looking for:
SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points,
p.short_description, p.quantity, p.image
FROM tblproducts as p LEFT JOIN
tblorder_list as o ON p.sku = o.sku #can_afford#
WHERE SUM(ISNULL(o.qty, 0)) < p.quantity
GROUP BY p.sku
I have a MySQL query to pull all products from the database, no problem. I am
trying to get it to only display prodcuts that are in stock, the value should
be "sold < p.quantity" in the following query. however, when sold appears as
null (very often) it removes the full record, which I don't wa
Hard to say what is going on. The following works fine for me:
SELECT node.userCity,count(node.userCity)
FROM core.users AS node, core.users AS parent
WHERE parent.userName = node.userFirstName
AND node.userCity = 'Pasadena'
GROUP BY node.userCity
I seem to get the correct number based on the no
no luck...
I do need the group by clause, my actual query is much larger than the one
posted. the problem, for example is this:
for five people, paid="no", for five others, paid="yes" under one parent
sponsor.
I am now getting a result of "10", but I need the result to be "5", only
counting
> SELECT COUNT(node.name)
> FROM tbl1 as node, tbl1 as parent
> WHERE parent.sponsor=node.name AND node.paid='yes'
> GROUP BY node.name
GROUP BY should only be used if you're selecting non-aggregates along with
your aggregate.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf S
Well, is the paid field a character field or a number field in the DB?
and just FYI, you can always go #querryName.Recordcount# to get a
count via CF. :)
On Tue, Jun 17, 2008 at 3:23 PM, Jessica Kennedy
<[EMAIL PROTECTED]> wrote:
> I'm pretty sure I will smack my head when I hear the answer, but
I'm pretty sure I will smack my head when I hear the answer, but I'll ask
anyway...
I am using a select count() query to get the number of people directly
sponsored by a person... this works fine, the problem is that I only want to
have the query count people that meet a certain qualification.
ncomplete thoughts.
>
> I _think_ you can abbreviate with a-z and 1-9 instead of typing out the
> characters.
>
>
>
>
> > -Original Message-
> > From: Chad Gray [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, May 21, 2008 2:27 PM
> > To: CF-Talk
>
I am full of incomplete thoughts.
I _think_ you can abbreviate with a-z and 1-9 instead of typing out the
characters.
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 21, 2008 2:27 PM
> To: CF-Talk
> Subject: RE: MSSQL Query he
ds with CAP or 8CAP9, but won't return records with CAPTAIN or
CAPITAL.
At least I think it will. Try it out. I am not in front of a MS SQL server.
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 21, 2008 2:17 PM
> To: CF-Talk
&g
In MySQL... '%CAP %' works.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:43 PM
To: CF-Talk
Subject: SOT: MSSQL Query help - Finding an exact word in a field
We are trying to tease out the following:
SELECT ProjNum,
Sent: Wednesday, May 21, 2008 1:43 PM
> To: CF-Talk
> Subject: SOT: MSSQL Query help - Finding an exact word in a field
>
> We are trying to tease out the following:
>
> SELECT ProjNum, ClientName, tblProj.Title, StartDate
> FROM tblProj
> WHERE (tblProj.Tit
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 1:43 PM
To: CF-Talk
Subject: SOT: MSSQL Query help - Finding an exact word in a field
We are trying to tease out the following:
SELECT ProjNum, ClientName, tblProj.Title, StartDate
FROM tblPr
We are trying to tease out the following:
SELECT ProjNum, ClientName, tblProj.Title, StartDate
FROM tblProj
WHERE (tblProj.Title LIKE '%Cost Plan%')
OR(tblProj.Title LIKE '%Cost Allocation Plan%')
OR (tblProj.Title LIKE '%CAP%')
The problem is that "OR (t
daniel kessler wrote:
> I had continued to try and figure it out after I sent the email. I did
> figure out a way to make it work.
>
> FROM expenditures e, people p
> WHERE e.approved_by = people.id (+)
>
> In Oracle, the + does the outer join.
Yes, that is the original outer join syntax for Or
I had continued to try and figure it out after I sent the email. I did figure
out a way to make it work.
FROM expenditures e, people p
WHERE e.approved_by = people.id (+)
In Oracle, the + does the outer join. And it worked well, but it wasn't
explicit. I don't know sql well enough to read th
daniel kessler wrote:
> 1 - I'm not so good at sql and the join only works if there's an id in the
> approved_by field. This is going to be empty unless the ticket has been
> approved, but I still want it to work whether it's approved or not. Is that
> an outter join?
>
Yes it will be an L
I am using Oracle and I have a table for expenditures that stores a person's ID
when the expenditures is approved. The person's ID is from a People table.
When I query, I want to make a new variable that references the other table to
put in their full name. I have two problems doing this.
1
>I dont believe this is working with Access DB
> SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound
I think Access's version of CASE is IIF(..). Try using IIF instead and also try
the query Barney suggested. One of them should work.
I dont believe this is working with Access DB
SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound
C S <[EMAIL PROTECTED]> wrote:
>select *, exists (
>select *
>from orders
>where date between #date1# and #date2#
>) as hasOrdered
>from customers
>order by name, id
>
>Use CFQUERYPARAM
>select *, exists (
>select *
>from orders
>where date between #date1# and #date2#
>) as hasOrdered
>from customers
>order by name, id
>
>Use CFQUERYPARAM, of course.
Another variation is a left join. Ditto on using cfqueryparam.
SELECT
c.ID,
c.Name,
c.Email,
SUM(CASE WHEN o.Date IS NULL T
select *, exists (
select *
from orders
where date between #date1# and #date2#
) as hasOrdered
from customers
order by name, id
Use CFQUERYPARAM, of course.
cheers,
barneyb
On Mon, Apr 28, 2008 at 8:57 PM, Brian Sheridan
<[EMAIL PROTECTED]> wrote:
> I will try to make this as simple as possible.
I will try to make this as simple as possible. Any help would be greatly
appreciated. I have 2 tables like below.
tblCustomers
===
ID | Name | Email |
1, John, [EMAIL PROTECTED]
2, Bob, [EMAIL PROTECTED]
3, Steve, [EMAIL PROTECTED]
=
> > user_doc table has one entry for each time a user has signed off on
> > having
> > read a document. A row is inserted with the user id and the doc id.
> >
> > What I'm trying to return is the users who have not signed off on
> > viewing
> > one or
more documents and the documents on which they've failed to sign
> off.
>
>
>
>
>
>
> Subject: query help
> From: Sonny Savage
> Date: Mon, 10 Mar 2008 08:39:57 -0400
> Thread:
>
> http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55471#30084
off on viewing
one or more documents and the documents on which they've failed to sign off.
Subject: query help
From: Sonny Savage
Date: Mon, 10 Mar 2008 08:39:57 -0400
Thread:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55471#300843
Question: Do you also want a resu
This query will return all users and docs that have a relationship
established but don't have a sign-off record:
SELECT u.user_name
, d.doc_name
FROM user_docs ud
INNER JOIN users u
ON ud.user_id = u.user_id
INNER JOIN docs d
ON ud.doc_id = d.doc_id
WHERE ud.signoff_id I
Question: Do you also want a result in the case where there is no USER_DOCS
record for a given USER and DOC record (FULL OUTER JOIN)?
On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley <[EMAIL PROTECTED]> wrote:
> I've got three tables like this (simplified):
>
> USERS
> user_id
> user_name
>
> DOCS
Josh,
The SQL I posted worked for me in my tests. If you deviated from that, can you
post the SQL that you used?
Assuming the join table doesn't have any duplicate rows (and no rows exist in
the join table without a match in both of the other tables) then the resultset
of the query should have
OK, so let's just say that the "where not exists" option is comparable in
efficiency. I ran the query and was greeted by every row in the tables. 70K
results instead of the 60 or so I should be getting.
~|
Adobe® ColdFusion® 8
Josh,
I use WHERE EXISTS and WHERE NOT EXISTS with some frequency and I have never
run into any performance problems with it.
In SQL Server, each join statement needs an "on" clause, even if it is 1 = 1.
I ran some quick tests with about 50 rows in one table, 200 in another, and
about a dozen
>
> In large tables, though, I don't think it's going to be a very good
> solution.
>
Why not? It should perform fine if there are indexes on the tables. Make a
couple of test tables and populate them with a whole load of numbers and
test it before rejecting it ;)
> Anybody know why this doesn't
I'm really looking for a solution with only one query using joins. It should
be possible to do this with a couple of joins.
This query, suggested by Steve, would work well if the tables remained
small:
SELECT user_id,user_name,doc_id,doc_name FROM USERS,DOCS WHERE NOT EXISTS
( SELECT sign
>
> As a side note, I generally recommend that you have a compound primary key
> in a join table. So, USERS_DOCS would have a compound primary key of user_id
> and doc_id and wouldn't need another column. This helps to enforce
> referential integrity.
Or create a unique index / constraint of the
The nice thing about SQL is you can often write the query almost how you word
the problem:
SELECT user_id,user_name,doc_id,doc_name
FROMUSERS,DOCS
WHERE NOT EXISTS (
SELECT signoff_id
FROMUSER_DOCS
WHERE user_id = USERS.user_id
I've never worked in MySQL, but take a look at the below. It should get you
in the right direction. BTW, it's a 2 step process. 1st, your combining
the User and Docs tables to get a list. Then you take that list and bounce
it agaist the USER_DOCS table and show anything where SIGNOFF is NULL.
By the way, this is a MySQL DB.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/
I've got three tables like this (simplified):
USERS
user_id
user_name
DOCS
doc_id
doc_name
USER_DOCS
signoff_id
user_id
doc_id
I need all user names and doc names where the combination doesn't exist in the
signoff table USER_DOCS. For example, user 12 hasn't signed of on doc 9 and
user 6 hasn
>SELECT t.groupid,
> t.groupname
>FROM @tblgroups t
>INNER JOIN @tblgrouptypes gt ON gt.groupid = t.groupid
>WHERE gt.grouptype in ('College','Jewish') -- This would be dynamic
>GROUP BY t.groupid,
> t.groupname
>HAVING count(*) = 2 -- This would be dynamic
>ORDER BY t.gr
Will Tomlinson wrote:
> Hey,
>
> I've got groups that can have one or more types associated with them. I have
> a linking table that I'm querying and filtering. But I'm not getting the
> results I need.
>
> Example: A group can be both 'College' and 'Jewish', as listed in the many
> linking t
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 12:12 PM
To: CF-Talk
Subject: Re: Need query help
Joining is what databases are good at.
===
Flying is what birds are good at; but why send the whole
Brad Wood wrote:
> If you query is highly dynamic, this way may not be best. Let's say the
> user can specify groups that are of type college, jewish, preschool,
> catholic, and skinny. Now, you have to join to the type table 5 times
> and that ain't looking too good.
Joining is what databases a
t: Tuesday, March 04, 2008 10:50 AM
To: CF-Talk
Subject: Re: Need query help
This should work and is much clearer that your original statement.
SELECT t.groupid,
t.groupimage,
t.groupname,
t.groupcity,
t.state,
t.voicingid,
t.groupcontactperson
This should work and is much clearer that your original statement.
SELECT t.groupid,
t.groupimage,
t.groupname,
t.groupcity,
t.state,
t.voicingid,
t.groupcontactperson,
t.country,
t.region,
x.groupid,
x.grou
What would that look like? Unioned result sets are not mutually
dependant, but Will needs all his criteria to be met.
~Brad
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 10:00 AM
To: CF-Talk
Subject: RE: Need query help
Could do a UNION
Could do a UNION to gather the results
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 10:56 AM
To: CF-Talk
Subject: RE: Need query help
If you query is highly dynamic, this way may not be best. Let's say the
user can specify groups tha
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 6:27 PM
To: CF-Talk
Subject: Re: Need query help
>No, that'll get one or the other - he wants ones that are both.
>
>Aliasing will work, something like this:
James, I think I got this to work. My first tests ar
>No, that'll get one or the other - he wants ones that are both.
>
>Aliasing will work, something like this:
James, I think I got this to work. My first tests are good. I didn't mention
this is a highly dynamic query. I have quite a few other filters in play, but
your example would work nicely w
If you HAVE to have both jewish and college types and only one record
returned, try this:
SELECT tblgroups.*,
tblgrouptypes_x.groupid,
tblgrouptypes_x.grouptype
FROM tblgroups
INNER JOIN tblgrouptypes_x ON tblgrouptypes_x.groupid = tblgroups.groupid
INNER JOIN tblgrouptypes ON tblgrouptypes.
If there's a group that's jewish and college, I just need a single
record returned.
=
Then removed type from the select list, group by everything else with an
"or" equivalent in your where clause and add the "having count(*) > 1"
to the end.
That will only return groups which re
>I'm a little unsure of what your query is expected to return. If a
>group can have multiple types, then I assume that there is a one-to-many
>relationship between groups and types, where a single group record has
>one or more type records.
Correct.
>
>You are returning type in your query, s
ement to an OR statement:
>
> AND (tblgrouptypes_x.grouptype = 'College' OR tblgrouptypes_x.grouptype =
> 'Jewish')
>
>
>
>
> -Original Message-
> From: Will Tomlinson [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 03, 2008 5:39 PM
> T
e-
From: ColdFusion [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 5:37 PM
To: CF-Talk
Subject: RE: Need query help
Try changing your AND statement to an OR statement:
AND (tblgrouptypes_x.grouptype = 'College' OR tblgrouptypes_x.grouptype
=
'Jewish')
-Origin
Try changing your AND statement to an OR statement:
AND (tblgrouptypes_x.grouptype = 'College' OR tblgrouptypes_x.grouptype =
'Jewish')
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 5:39 PM
To: CF-Talk
Subject:
>
>If you take out one or the other, does it return the results?
>
>
Yes. I get valid results if I remove one of the AND's. I can just pull jewish
groups for instance.
Originally, I used IN ('jewish',college').
But that returns ALL jewish groups, and ALL college groups. My client wants it
to
To make your query more readable, can you alias your tables?
> SELECT g.groupid, g.groupimage, g.groupname, g.groupcity, g.state,
g.voicingid, g.groupcontactperson, g.country, g.region,
gtx.groupid, gtx.grouptype, gt.grouptype
> FROM tblgroups g, tblgrouptypes gt, tblgrouptypes_x
Hey,
I've got groups that can have one or more types associated with them. I have a
linking table that I'm querying and filtering. But I'm not getting the results
I need.
Example: A group can be both 'College' and 'Jewish', as listed in the many
linking table - tblgrouptypes_x.grouptype
In m
It was pretty close. Running it in "one direction", knowing that table B
has extra records, works fine.
- Original Message -
From: "Dawson, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, February 11, 2008 7:59 PM
Subject: RE: Query He
bruary 11, 2008 8:45 PM
To: CF-Talk
Subject: RE: Query Help - find unique rows in two similar tables
SELECT
a.*
,b.*
FROM
TableA a
FULL OUTER JOIN TableB b
ON a.id = b.id
WHERE
a.id IS NULL
OR
b.id IS NU
To: CF-Talk
Subject: Query Help - find unique rows in two similar tables
I have two tables with identical structures. The data in the two tables
is _nearly_ identical, with one table having a few additional rows. I
need to find those additional rows.
I want to query the two tables and find the
I have two tables with identical structures. The data in the two tables
is _nearly_ identical, with one table having a few additional rows. I
need to find those additional rows.
I want to query the two tables and find the rows in one or the other that
are not present in both. It would be OK
change one thing it errors on another lol
now it errors on the ","
>I'll take a look at those
>
>thanks guys
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/pro
I'll take a look at those
thanks guys
> Looks like CEIL() or CEILING() is the function you're looking for:
> http://db.apache.org/derby/docs/10.2/ref/refderby.pdf
>
> HTH,
> Jon
> On Dec 8, 2007, at 11:18 PM, Dave l wrote:
>
> > if i change the select statement to:
> > SELECT ce
Looks like CEIL() or CEILING() is the function you're looking for:
http://db.apache.org/derby/docs/10.2/ref/refderby.pdf
HTH,
Jon
On Dec 8, 2007, at 11:18 PM, Dave l wrote:
> if i change the select statement to:
> SELECTcenter_id, address1, city, state, postalcode, state,
>
drian
>
> -Original Message-
> From: Dave l
> Sent: 09 December 2007 04:18
> To: CF-Talk
> Subject: Re: query help
>
>
> if i change the select statement to:
> SELECT center_id, address1, city, state, postalcode, state,
>ROUND((ACO
If ROUND isn't there, look for another rounding function like CEILING, FLOOR
etc.
Adrian
-Original Message-
From: Dave l
Sent: 09 December 2007 04:18
To: CF-Talk
Subject: Re: query help
if i change the select statement to:
SELECT center_id, address1, city, state, posta
if i change the select statement to:
SELECT center_id, address1, city, state, postalcode, state,
ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) +
it changes the error to:
'ROUND' is not recognized as a function or procedure.
so i might be sol on this tut
~~
i am trying to write a quite tutorial for learncf on a dealer locator.
I guess you have to use one of the included db's so I am using one of the derby
ones cause well.. thats all there is and this query is choking on it, it works
on mysql but I know diddlysquat about derby
the query
SELECT *,RO
Hey,
I have 3 tables - one to many rel.
tblreports
reportid PK
lotsmorefieldsforfiltering
tblquestioncomments
questioncommentid PK
reportid FK
questionid FK
tblquestions
questionidPK
Originally I just needed a question count based off a specific question ID. As
my loop
I got it fixed.
Thanks,
Will
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Arch
I have three tables, worship_songs, worship_sets, worship_song_lists.
worship_songs:
worship_songID
worship_song_title
worship_song_lyrics
worship_sets:
worship_setID
worship_set_title
worship_set_date
worship_song_lists:
worship_song_listID
worship_songID_fk
worship_setID_fk
I have a spry data
1 - 100 of 506 matches
Mail list logo
