I also like to have a separate interface for managing the records. So they can
add/edit the records. I do however like to give them the ability to add it
right on the current page.
I have tried many of the ways mentioned to do this but I always seem to get
frustrated by them for some reason or
Mickael Pervinski wrote:
I have two tables.
Animals
-
AnimalID
AnimalNAME
AnimalSEX
Projects
-
ProjectID
MaleID
FemaleID
SELECT
M.AnimalNAME AS male,
F.AnimalNAME AS female
FROM
Projects P
INNER JOIN Animals M ON P.MaleID = M.animalID
INNER JOIN
Thanks for the reply dominic, looks like I may now have the solution using a
union.
cheers,
Richard
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
Extends...implements...heheheh...my mistake
Eric
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 21, 2007 10:24 PM
To: CF-Talk
Subject: RE: CF8 Error
That is incorrect...MX7 (not sure about 6) had
an implements attribute where you can have
it
I have two tables, photos and comments. Their structures are as follows:
photos table
--
photoID
photoTitle
comments table
--
commentID
commentText
photoID_fk
I need to write a query that will allow me to display all the records in photos
while also displaying
First write your sql as
SELECT p.photoID, p.photoTitle, c.commentId, c.commentText
FROMphotos p
LEFT OUTER JOIN comments c
ON c.photoid_fk = p.photoid
ORDER BY p.photoID, c.commentID
Then output the query using cfoutput and group like this
ul
cfoutput
I'm using DataMgr(http://datamgr.riaforge.org/) for our Data Access
Layer(CRUD). This is a great Steve Bryant job. By now I'm looking for
examples about how to include a dynamic form builder in our applications.
This is why DataMgr works introspecting form fields with database fields.
Cheers
First write your sql as
SELECT p.photoID, p.photoTitle, c.commentId, c.commentText
FROMphotos p
LEFT OUTER JOIN comments c
ON c.photoid_fk = p.photoid
ORDER BY p.photoID, c.commentID
Then output the query using cfoutput and group like this
ul
cfoutput
First write your sql as
SELECT p.photoID, p.photoTitle, c.commentId, c.commentText
FROMphotos p
LEFT OUTER JOIN comments c
ON c.photoid_fk = p.photoid
ORDER BY p.photoID, c.commentID
Then output the query using cfoutput and group like this
ul
cfoutput
This should be simple, but doesn't seem to be working right.
I have a SQL Server view pulling data in from several tables. I'm
interested in three columns in the view:
1. dataID
2. before
3. after
Query below returns maybe 100 results, sometime there's values for
either before or after, but
If i recall, '' ' is not the same as is not NULL. So perhaps
you need to change your query to something like:
select * from myTABLE
WHERE
before is not NULL
and after is not NULL
and someID = #url.id#
On 7/23/07, Les Mizzell [EMAIL PROTECTED] wrote:
This should be simple, but
In a related question to this, can anyone please help me get started on the
best way to do a popup page that inserts the new record and then updates the
cfselect on the original page without having to reload the original page.
I know how to do the popup and the insert without any issues. I can
Can anyone point me to resources that explain how to export a Recordset to a
Quickbooks ? Similar to any bank website where you can download you transaction
to your software.
I've look into CFDOCUMENT, CFCONTENT, CFREPORT without success
Thanks for any help possible.
Well you just write the form as usual then use JS to popup the window.
Google for window.open
There are a couple ways to refresh the parent...
1) you could call a JS function that uses an http request (AJAX) to
repopulate the select
2) You could just pass the new record back to the parent via JS
Also your original logic says _all_ of the values must have a length
0. So if even one of those values is empty, it will always hit the
second step. There is nothing in the code that says skip the row if
all the values are emtpy. Make sense?
ooh ooh oooh! Yeah, it does now! I think I
Mike Kear wrote:
If i recall, '' ' is not the same as is not NULL. So perhaps
you need to change your query to something like:
select * from myTABLE
WHERE
before is not NULL
and after is not NULL
and someID = #url.id#
Which would see to lead me to this:
SELECT * FROM
What you've written there, Les, will only get you records where BOTH
before and after have a value. Is that what you want?
Perhaps you need to change the sql to read:
SELECT * FROM myTABLE
WHERE
(before is not NULL or before '')
OR
(after is not NULL or after '')
and
The query below (and the original one) doesn't say not where both are
blank, it says where both are not blank which is very different.
You are after:
SELECT * FROM myTABLE
WHERE
NOT ((before is NULL or before = '')
and (after is NULL or after = ''))
and database_id = #url.id#
On 7/23/07, Les
Joe,
First of all I am not sure if you need LEFT JOIN for both comments and
prices. My first example was based on the assumption that you could have
photos without comments and you might want to display those as well.
It will help if you can paste the entire query and your output code.
Thanks
Joe,
First of all I am not sure if you need LEFT JOIN for both comments and
prices. My first example was based on the assumption that you could have
photos without comments and you might want to display those as well.
It will help if you can paste the entire query and your output code.
Thanks
The second meeting of the Western Sydney and Blue Mountains ColdFusion
User Group (BMUG) will be held on 8 August in Penrith.We hope you
can all come.
It's to be a special meeting, because it's the second meeting for us.
Only once in our lives do we get to have a second meeting of a user
21 matches
Mail list logo
