you can.
the easiest tho not the most accepted way to do this is to use a union
statement.
for example:
select 1 as displayOrder, books.bookName, books.ISBN, authors.fullname as
caption
from books left join booksToAuthors on books.bookID=booksToAuthors.bookID
left join authors on booksToAuthors
i think he's assuming that attributes.fuseaction has already been defined.
which is a good point for the question.. you can use any variable schema
you want as long as it contains the proper data and exists.
On Fri, 20 Jul 2001, Thomas Chiverton wrote:
> >
> >
> > Will this work even if
pop quiz hot shot. if noone has been getting messages since last week, how
are you getting these messages now?
:) all in fun :)
-chris
On Mon, 2 Jul 2001, Kelly Matthews wrote:
> No one has gotten any since mid last week!
>
> -Original Message-
> From: Bruce, Rodney [mailto:[EMAIL P
ok here's a perl script.. i have a 20$ bet with a friend that it can be
done in CF and of course theres only one hard part to it...
#!/usr/bin/perl
print "Content-type: image/gif\n";
open IMAGEFILE, "<../html/image1.gif";
my $length = (stat(IMAGEFILE))[7];
print "Content-length: $length\n\n";
the problme is in the where clause. the condition on the right side of the
OR statemnet will always test true.. or .. i should say is potentially
testing true. which is giving you your cartisian product.
i suggest you use either a left join or an inner join (depending on wether
you want nulls) in
use
or use
the contains version should work fine, but the reFind has less potential
for error
-chris
On Fri, 1 Jun 2001, Marcus wrote:
> I'm trying to provide functionality to a select group of people on a
> specific subnet. What I'd like to do is something along the lines of..
>
>
>
make sure you are using cffile.serverfile as the variable you are
inserting into the database.
if you use the form variable sent from the webpage, you'll get a temp file
name.. which is prollly not what you want :)
-chris
On Thu, 31 May 2001, Shally wrote:
> Hello Every one,
> I am using Cffil
#queryname.columnlist#
-chris
On Tue, 29 May 2001, David Sterling wrote:
> I have seen this before, I have even used it before, but right now I just
> cant recal the code to the fieldnames from a can
> anybody help?
>
> David Sterling
>
>
~~
if someone can run a query from a url, all they have to do is get to the
sysobjects table (a known table in ss7) thhen, if done properly, your code
will display ever table name in the database. they could then insert
orders (yes even as strings though that is a bit harder), or query teh
credit car
hey hey everyone.. here's a dilemma for you.
i've been task with createing an application model for a very large
application that is being gutted and rebuilt. now i've decided that we
need both application and session variables. however the govt doesnt allow
cookies on thier machines.. even for i
hey everyone.. i cant seem to find allaire's cfx_cybercash tag (the free
one) in the tag gallery? anyone have it or know where i can get it?
thnx
-chris
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionau
11 matches
Mail list logo
