m receipts);
Generates 0 rows
The OUTER JOIN version is quite a bit more efficient (by an order of
magnitude) than the option with WHERE NOT EXISTS subquery.
Thanks all for the help. Saved my butt again!!
--
.Michelle
--
Michelle Murrain
mmurrain at dbdes dot com
413-222-6350 ph
617-8
* have an entry
in the receipts table.
Thanks in advance!!!
--
.Michelle
--
Michelle Murrain
mmurrain at dbdes dot com
413-222-6350 ph
617-889-0929 ph
952-674-7253 fax <--- new
Page: [EMAIL PROTECTED]
AIM:pearlbear0 ICQ:129250575
Skype: pearlbear
Jabber: [EMAIL PROTECT
ALTER TABLE coursesevaluations ADD CONSTRAINT rc_ce FOREIGN KEY
(courseid) REFERENCES rcourseinfo (rcourseinfo_pkey);
I got the error :
ERROR: ALTER TABLE: column "rcourseinfo_pkey" referenced in foreign
key constraint does not exist
!!
Thanks for any advice.
--
.Michelle
-
I thinking about this right? Is there a better way to get the
value of a newly inserted record?
Thanks!
PS: I'm subscribed to sql, odbc and general, and have not been
getting general mail for quite some time. I've send emails to the
address that's supposed to be read b
more than, I think 200 or so characters. It had to do
with the connection between postgres and Cold Fusion.
--
.Michelle
--
Michelle Murrain, Technology Consulting
[EMAIL PROTECTED] http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbe
with ColdFusion, and ColdFusion
runs into some very problematic issues with Postgres, sadly. Although
I use Postgres almost exclusively, I had to switch to MySQL for use
with ColdFusion.
--
.Michelle
--
Michelle Murrain, Technology Consulting
[EMAIL PROTECTED]
o you. Some applications (particularly Crystal Reports) do
not like unbounded text fields, and make it quite difficult to do any
manipulations of them. This might be an odbc issue, rather than an
application issue, but it can be a big deal sometimes.
--
.Michelle
--
Miche
he only problem tho, the source codes tend to be thousands of lines
> when it comes
> to DBs and time is ...
And, further, some of us are web programmers, and the source code doesn't
help one whit in getting DATA that one needs to do stuff on the front end,
like data entry validat
