Immedialty capturing auto-created field!!!!!!1

Hello, In my action page, I have an insert SQL statement inside my cftransaction tagthe primary key is an autoincremented field...so when the insert transaction is done, the key is created.. If that record that was just inserted meets certain criteria, I want to update another record in

Re: FREE HTML Editor

I like http://www.spiderwriter.com/ Julie From: Nick Betts [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: FREE HTML Editor Date: Fri, 13 Jul 2001 15:22:30 +0100 Hi, We have a client who wishes to edit content in an updater which is then published on

GetUserName into table

Hello, I want the use name of the person adding/updating a record to be written to that record. I tried using the GetUserName() method in MS SQL 2000 by adding (GetUserName()) to the formula section of the table but it doesnt like that. Does anyone know what I am missing? Thanks again,

session variables - newbie

I am trying to add a field to my records to let me know who added/updated the recordI am new to Cf so I am having some trouble figuring out how to go about doing this.this app is running only on our network and users must go thru a login page to access the app. My Login Action page

Foreign Key Constraint

I have 2 tables - tblAppointment_1 and tblAppointment_2. I want to set up a foreign key in appointment_1 to connect it to Appointment_2. My question is, if the Appointment_1 record is created a few weeks before Appointment_2, will this be a problem because the foreign key will be null for

RE: Simple Access Query Help

Meetings WHERE DatePart(,BegTime) = 2000 GROUP BY Site That should return the average time in minutes. Hope this helps Norman -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 10:11 AM To: CF-Talk Subject: Simple Access Query Help Hello

Access Help!!!

,EndTime)) AS AvgLength FROM Meetings WHERE DatePart(,BegTime) = 2000 GROUP BY Site That should return the average time in minutes. Hope this helps Norman -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 10:11 AM To: CF-Talk Subject: Simple

Simple Access Query Help

Hello, Can anyone help me with this simple query...? I have a Meeting Table which stores the begining time and ending time of each meeting conducted, per site. I need to write a query to calculate the average meeting time per site for the year 2000. Below is an example of my table:

manipulating DatePart Function???

Hello, Does anyone know how I can make the following code workI am trying to use the DatePart Function to parse out the hour and minute from a date/time field. however I am getting the hour in military time. To get around this I thought I would subtract 12 from any hour 13 and

RE: manipulating DatePart Function???

: timeFormat(BeginTime,h mm) The lower case h tells it to use 12 hr clock (use upper case for 24 hr) (Note you don't have to say QRYCasacActivity.BeginTime because you are inside a CFOUTPUT with query = QRYCasacActivity) -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent

SQL Newbie - Help!!!!!

Hello, I have a large sql query I need to write and am having some problems with it. I have broken it down into several sections...the fist section I cannot figue out involves 3 table which I have listed below along with the main fields I need to deal with in parenthasis: tblContacts

SQL Newbie - Help!!!!!

tblCasacCM left outer join tblCasac t2 on t1.pk_CasacAppt = t2.pk_CasacAppt left outer join tblContacts t3 on t1.pk_CMAppt = t3.CMAppt where pk_uniqueID = #Variable# order by t2.CasacDate desc John Hancock -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15

Re: SQL Newbie - Help!!!!! part 2

What do I change to make it grab the max CasacApptID PER iCMApptID TIA!!! Julie From: Julie Clegg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: SQL Newbie - Help! Date: Tue, 15 May 2001 17:52:30 -0500 Select cas.iCasacApptID, cas.cEncCatID From

Re: SQL Newbie - Help!!!!! part 2

What do I change to make it grab the max CasacApptID PER iCMApptID TIA!!! Julie From: Julie Clegg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: SQL Newbie - Help! Date: Tue, 15 May 2001 17:52:30 -0500 Select cas.iCasacApptID, cas.cEncCatID From

CF function to manipulate a date

Hello, I have a date field(myDate) in mm format. I want to compare it to a another year field and to another month field. How do I string out myDate inorder to seperate the mm and section of it so I can compare each section to a seperate month and year. Thanks, Julie

SQL - Count Function Error

Hello, I am trying to run this MS SQL query and I keep getting the following error: The count function requires 1 arguments... her is my query: cfquery name=QRYEventTotals datasource=#request.ProjectAceDB# Select cd1.vCodeDecodeDesc as EventTypeDesc,

Newbie CF architecture question

Hello, I have a genreal question concerning how CF embeds other code into its code. I understand how to use javascript in CF and how to call a stored prcedure from the SQL Server but how or even can you embed java code into my CF application. I guess I am trying to find out if there is

database design question

great Adobe Acrobat Documentation book: http://www.allaire.com/documents/cf45docs/acrobatdocs/45dwa.pdf Julia Green Julia Computer Consulting PO Box 279 Watertown MA 02471-0279 http://www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 FAX: 413-771-0306 - Original Message ---

Personal web server install

Hello all, I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this/ Thanks Julie ~~

Re: CF Books

ation book: http://www.allaire.com/documents/cf45docs/acrobatdocs/45dwa.pdf Julia Green Julia Computer Consulting PO Box 279 Watertown MA 02471-0279 http://www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 FAX: 413-771-0306 - Original Message ----- From: Julie Clegg [EMAIL

CFINCLUDE - relative mapping

Hello all, I am new to CF and am have some prolems with the CFINCLUDE tag...it cant find my template file. Here is what I did: First in CF Administrator I set up a logical mapping of LOGICAL PATH DIRECTORY PATH /Template_Mapping/ C:\INETPUB\WWWROOT\FastTrack\Lab\Templates\ then

cfinclude relative mapping problem

Hello all, I am very new to CF and have already come across a problem when I try to use my CFINCLUDE tag. Here is what I have done so far: (1) Went into CF Administrator and set up a logical path for my header and footer template. LOGICAL PATH DIRECTORY PATH /Template_Mapping/

mapping problem

Hello, I just installed CF 4.5 on my computer, along with PWS. Why is it when I try to browse a cfm page I get the followig error? "The ColdFusion file you are trying to browse cannot be resolved into a URL. Add a server development mapping to enable URL resolution for this file."

Re: CF Books

alk [EMAIL PROTECTED] Subject: Re: CF Books Date: Mon, 19 Mar 2001 14:25:36 -0500 http://www.defusion.com has them all there listed and the best one for you is the one you find and the book store, and skim through, and then compare reviews and opinions Hows that for an answer Its Honest Michael &q