Here's a question I've been wrestling wtih.
Suppose that there is an HTML form to create a new user. When the form
is submitted, that user's information is added to the 'user' table.
The table uses an auto-increment integer for its primary key/user id,
so I'd like to grab that value for the newly
ty id
>
>Sandra Clark
>-Original Message-
>From: Chris Mueller [mailto:[EMAIL PROTECTED]
>Sent: Thursday, March 09, 2006 4:35 PM
>To: CF-Talk
>Subject: SQL-generated primary keys
>
>Here's a question I've been wrestling wtih.
>
>Suppose that there is an H
Hi everyone,
I'm wondering about doing an advanced SQL joined query that includes
counting records matching a certain criteria. An example probably
illustrates best.
I have a table of authors, and a table of books. They are joined on an
AuthorID. I am trying to display a page that contains a list
Rich,
That worked perfectly. Thanks for the help!
Chris
On 4/27/06, Rich Kroll <[EMAIL PROTECTED]> wrote:
> Chris,
> This should get you the results your after:
>
> SELECT a.AuthorID, a.AuthorName, COUNT(b.book_id) AS NumBooks
> FROMAuthor a
> INNER JOIN Book b
> ON
Rob,
I've personally installed and used MediaWiki (www.mediawiki.org),
which is also the software that runs Wikipedia. It uses PHP and MySQL
and has a great feature set, including support for media (images,
etc), user authentication, and various kinds of markup (including
HTML).
Good luck.
Chris
Actually, applications like Google Spreadsheets support this kind of
interface (to some extent, at least). I suppose it would be a little
difficult to get the Google engineers to let you at their databases,
though. ;-)
Chris
On 6/13/06, Chad Gray <[EMAIL PROTECTED]> wrote:
> Slight rant too let l
I'm trying to output a grouped query using a startrow and maxrows.
Something like this:
#myQuery.Foo#
#myQuery.Bar#
When startrow is 1, the output is as expected and I see 10 rows in the
table that correspond to the first ten rows (grouped) from my query.
When startrow is
I'm trying to use to do some HTML layout from within a CFC.
Here's the code inside the CFC:
---
Some generated output from the function.
This is some example code from template_main.cfm:
-
What I would e
Wow, do I feel stupid. I thought I went over this code with a fine-tooth comb,
but I guess not. Thanks for the help!
Chris
>>
>
>That should not have a closing slash.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authoriz
I hope this isn't getting too off-topic, but I'm looking for a host that
supports both Coldfusion and PHP... Any recommendations?
Thanks!
Chris
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233898
Archives: http://
10 matches
Mail list logo