here is how I update my dal customers info DB from an update form
<cfquery datasource="ADSL_DSN">
UPDATE ADSLCustomers SET OrderNumber='#Form.OrderNumber#',
OrderPhoneNumber='#Form.OrderPhoneNumber#',
CompanyName='#Form.CompanyName#',
ContactFirstName='#Form.ContactFirstName#',
ContactLastName='#Form.ContactLastName#',
BillingAddress='#Form.BillingAddress#', City='#Form.City#',
State='#Form.State#',
PostalCode='#Form.PostalCode#', ContactPhone='#Form.ContactPhone#',
Extension='#Form.Extension#', FaxNumber='#Form.FaxNumber#',
EmailAddress='#Form.EmailAddress#', CircuitID='#Form.CircuitID#',
Speed='#Form.Speed#', PaymentMethod='#Form.PaymentMethod#',
AccountType='#Form.AccountType#', IPs='#Form.IPs#',
Provider='#Form.Provider#', Pending='#Form.Pending#',
OrderedDate='#Form.OrderedDate#', ADSLOrder='#Form.ADSLOrder#',
DueDate='#Form.DueDate#',
G_octed1='#Form.G_octed1#', G_octed2='#Form.G_octed2#',
G_octed3='#Form.G_octed3#', G_octed4='#Form.G_octed4#',
Sub_octed1='#Form.Sub_octed1#', Sub_octed2='#Form.Sub_octed2#',
Sub_octed3='#Form.Sub_octed3#', Sub_octed4='#Form.Sub_octed4#',
StartDate='#Form.StartDate#' WHERE DLCI='#URL.DLCI#'
</cfquery>
----- Original Message -----
From: "Tammy Schilling" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 3:55 PM
Subject: newbie question
>
> --------------704CA9BF13C96FBC1A24AFE5
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi all,
>
> I'm relatively new to CF. I'm trying to design an interface for a local
> non-profit that holds monthly meetings to track attendance at those
> meetings. I have an Access db with a table called Attendance. This
> tables columns are the ID for each member and one for each month,
> Jan-Dec. They keep a "rolling calendar", so year is not a factor in the
> attendance tracking. They just want each month's attendance to write
> over the attendance in that month from the year before.
>
> The ID column is a number column and each of the month columns are
> yes/no. I have an interface which pulls the names of members who've
> attended in the last 12 months (in order to minimize the number
> displayed and make it more useable) along with a check box to be checked
> if the person was at that month's meeting, but I can't seem to get the
> form to work. I know it's probably something simple, but I've been
> banging my head against it for too many hours now and can't think
> anymore. Some help would be appreciated, please.
>
> Here is the code:
>
> This is the query that gets the existing data
>
> <CFQUERY DATASOURCE="LLL" NAME="Active_Moms">
> SELECT Attendance.July, Attendance.ID, MailingList.FirstName,
> MailingList.LastName, Attendance.January, Attendance.February,
> Attendance.March, Attendance.April, Attendance.May, Attendance.June,
> Attendance.August, Attendance.September, Attendance.October,
> Attendance.November, Attendance.December
> FROM Attendance INNER JOIN MailingList ON Attendance.ID = MailingList.ID
>
> WHERE (((Attendance.July)=Yes) OR ((Attendance.January)=Yes)
> OR ((Attendance.February)=Yes) OR ((Attendance.March)=Yes) OR
> ((Attendance.April)=Yes) OR ((Attendance.May)=Yes) OR
> ((Attendance.June)=Yes) OR ((Attendance.August)=Yes) OR
> ((Attendance.September)=Yes) OR ((Attendance.October)=Yes) OR
> ((Attendance.November)=Yes) OR ((Attendance.December)=Yes))
> ORDER BY LastName, FirstName
> </cfquery>
>
> This is the form
> <FORM ACTION="process_janatten.cfm" METHOD="POST">
> <INPUT TYPE="checkbox" NAME="January" VALUE="#January#">
> <INPUT TYPE="text" NAME="FirstName" SIZE="30" MAXLENGTH="30"
> VALUE="#LastName#, #FirstName#">
>
> This is the form action query
> <CFQUERY DATASOURCE="LLL">
> UPDATE Attendance
> SET January = '#January#'
> WHERE ID = #ID#
> </cfquery>
>
>
> Thanks in advance!
>
> Tammy
> --
> personal copy designs
> better living through computer graphics
> http://www.personal-copy.com
> 410 219 5300
>
>
> --------------704CA9BF13C96FBC1A24AFE5
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hi all,
> <p>I'm relatively new to CF. I'm trying to design an interface for
> a local non-profit that holds monthly meetings to track attendance at
those
> meetings. I have an Access db with a table called Attendance.
> This tables columns are the ID for each member and one for each month,
> Jan-Dec. They keep a "rolling calendar", so year is not a factor
> in the attendance tracking. They just want each month's attendance
> to write over the attendance in that month from the year before.
> <p>The ID column is a number column and each of the month columns are
yes/no.
> I have an interface which pulls the names of members who've attended in
> the last 12 months (in order to minimize the number displayed and make
> it more useable) along with a check box to be checked if the person was
> at that month's meeting, but I can't seem to get the form to work.
> I know it's probably something simple, but I've been banging my head
against
> it for too many hours now and can't think anymore. Some help would
> be appreciated, please.
> <p>Here is the code:
> <p><u>This is the query that gets the existing data</u>
> <p><CFQUERY DATASOURCE="LLL" NAME="Active_Moms">
> <br>SELECT Attendance.July, Attendance.ID, MailingList.FirstName,
> <br>MailingList.LastName, Attendance.January, Attendance.February,
> <br>Attendance.March, Attendance.April, Attendance.May, Attendance.June,
> <br>Attendance.August, Attendance.September, Attendance.October,
> <br>Attendance.November, Attendance.December
> <br>FROM Attendance INNER JOIN MailingList ON Attendance.ID =
MailingList.ID
> <br>WHERE (((Attendance.July)=Yes) OR ((Attendance.January)=Yes)
> <br>OR ((Attendance.February)=Yes) OR ((Attendance.March)=Yes)
> OR
> <br>((Attendance.April)=Yes) OR ((Attendance.May)=Yes) OR
> <br>((Attendance.June)=Yes) OR ((Attendance.August)=Yes) OR
> <br>((Attendance.September)=Yes) OR ((Attendance.October)=Yes) OR
> <br>((Attendance.November)=Yes) OR ((Attendance.December)=Yes))
> <br>ORDER BY LastName, FirstName
> <br></cfquery>
> <p><u>This is the form</u>
> <br><FORM ACTION="process_janatten.cfm" METHOD="POST">
> <br><INPUT TYPE="checkbox" NAME="January" VALUE="#January#">
> <br><INPUT TYPE="text" NAME="FirstName" SIZE="30" MAXLENGTH="30"
VALUE="#LastName#,
> #FirstName#">
> <p><u>This is the form action query</u>
> <br><CFQUERY DATASOURCE="LLL">
> <br>UPDATE Attendance
> <br>SET January = '#January#'
> <br>WHERE ID = #ID#
> <br></cfquery>
> <br>
> <p>Thanks in advance!
> <p>Tammy
> <br>--
> <br>personal copy designs
> <br>better living through computer graphics
> <br><A
HREF="http://www.personal-copy.com">http://www.personal-copy.com</A>
> <br>410 219 5300
> <br> </html>
>
> --------------704CA9BF13C96FBC1A24AFE5--
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
