SQL-generated primary keys

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

Re: SQL-generated primary keys

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

Question about counting in SQL

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

Re: Question about counting in SQL

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

Re: OT: Wikis

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

Re: SOT: Getting data into a web site

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

cfoutput with groups and a startrow

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

cfmodule and CFCs?

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

Re: cfmodule and CFCs?

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

Re: CF Host recommendations

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://