OT: Book to learn MS SQL 2000

-Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 6:22 PM To: CF-Talk Subject: OT: Book to learn MS SQL 2000 What books do folks recommend to learn MS SQL 2000.Looking for basics at this point. Thanks, Andy The SAMS Learn SQL

CF Salary Range

How about the folks in California's Silicon Valley that are willing to work FOR FREE?!?!Of course, we are talking about California, where anything goes . . . Keith Hawkes DoD CF Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

advice

I've been in Puerto Rico a little over a year and I cannot BEGIN to tell you how awesome it's been. Truly widens the paradigms and offers a much more diverse and enriching life. ATTENTION!!! *** This email is privileged

Command Line From CF?

After searching the web and CF archives ad nauseum, here's my simple but unanswered question: Can I run a .cmd file using CF? I have a file that will run a sql DTS in a file called hrmd.cmd and I want a CF page to invoke it. Thanks, Keith Hawkes Database Administrator/Naval Hospital

Email Variable Syntax Problem

I have a query for getting customer's name to put into an autogenerated email: cfquery name=email_closure datasource=helpdesk SELECT cust_f_init + cust_m_init + cust_lname AS email_address, resolution FROM helpdeskmain WHERE ticketid = #recordset1.ticketid# /cfquery However, when I try to

OT? jrun.dll file

Don't know if this OT for the list, but we just discovered we're having a jrun.dll load failure and wonder if anyone has had the same problem? Thanks, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Count(*) Query

I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~|

Count(*) Query

YOU GUYS ROCK!!! Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc.

I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but

Any Interest In Managing A Small Web Site?

I'm looking for anyone interested in managing www.divepuertorico.com It's a scuba shop in Puerto Rico, It probably doesn't pay much, but you'd get all the free diving or snorkling you could handle should you visit. Please respond off-line, and I apologize for using this forum for this, but time

Web Management Job Is Filled

Thank you for all the reponses. The web management position has been filled, but it sure makes me feel like I'm not alone with all the great correspondence I received. Thanks to each and every one of you! ~| Archives:

Drivin' Me Nuts!

Here's the input form: * cfquery name=rs_shotwatch datasource=Shotwatch SELECT * FROMchildinfo WHERE childID = #url.childID# /cfquery html head titleShotwatch Version Beta 1.0/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body

ListGetAt + 1

There seems to be little literature I can find on the ListGetAt command, so my question is: what is the proper syntax to add '1' my #ListGetAt(form.MonthID,1)#? In other words, this returns a number, and I want it to return a number plus 1. TIA, Keith

You People Are AWESOME

And, after a little sucking up for successfully helping me with my last question, here's another point of confusion for me. Where are Cold Fusion sites retained in memory? I have a page that no longer exists that, if I type in the url, will appear and work just the way I don't want it to.

Newbie Question on Looping

I've recently taken a position to webify things and Cold Fusion is the tool de jour. I'm having trouble with an aspect and I'm sure someone here has been through this before. It's a common personnel db with a common objective - I need to do a morning roster with five different types of status.

Multiple Records Update Issue

Date: Tue, 22 Oct 2002 11:31:57 +0100 From: Adrian Lynch [EMAIL PROTECTED] Subject: RE: Newbie Question on Looping Message-ID: [EMAIL PROTECTED] Your code, we nd ya code My apologies, I thought that might have been presumptuous - there I go thinking again! Here it is: cfset