>
> > Hi...I need another little tweak to my vacation posting program to get
> > it to work...
> >
> > First of all, my Date values in the Access table are still all
> > text...I tried changing
> > them from text to Date, but then the search didn't work with the form
> > drop down boxes
> > posting to the table vac20003....
> >
> > So now they are all text, so I got the posting form to return a
> > message when the dates
> > (DateA and DateB are the names of the drop down boxes) are within 21
> > days of each
> > other with the DateDiff command...so obviously even if the posting is
> > in text it still works...
> >
> > This is the snippet of code in vacpost4.cfm which I am attaching...
> >
> > <cfoutput>
> > <CFIF #Abs(DateDiff("d", DateB, DateA))# less than 22>
> > <p>These weeks are back to back.
> > <cfelse>
> > <p>No Information.
> >
> > </cfif>
> > </cfoutput>
> >
> >
> > But now here is the problem how do I get the same code to work in
> > vacsrchdate2.cfm with #DateA#
> > and #DateB# -- I tried using the same code, changed DateB to #DateB#
> > etc....didn't work, they need
> > the information on the search result report, not just the form...
> >
> > Could you help with this...I am attaching all the cold fusion files (4
> > as they are), the only ones you really
> > need to look at are vacpost4.cfm and vacsrchdate2.cfm
This is the code that works posted directly from a form...
<CFINSERT DATASOURCE="0707_acc_finacc_asc" TABLENAME="vac20003">
<cfoutput>
<CFIF #Abs(DateDiff("d", DateB, DateA))# less than 22>
<p>These weeks are back to back.
<cfelse>
<p>No Information.
</cfif>
</cfoutput>
I am trying to get the same code to work on the following page:
<CFQUERY NAME="EmpList" DATASOURCE="0707_acc_finacc_asc">
SELECT LastName, FirstName, SSNo, DateA, DateB, DateC, DateD, DateE, DateF,
DateG
FROM vac20003
WHERE (DateA >='#Form.Date1#' AND DateA <='#Form.Date2#') OR
(DateB >='#Form.Date1#' AND DateB <='#Form.Date2#') OR
(DateC >='#Form.Date1#' AND DateC <='#Form.Date2#') OR
(DateD >='#Form.Date1#' AND DateD <='#Form.Date2#') OR
(DateE >='#Form.Date1#' AND DateE <='#Form.Date2#') OR
(DateF >='#Form.Date1#' AND DateF <='#Form.Date2#') OR
(DateG >='#Form.Date1#' AND DateG <='#Form.Date2#') AND
(OpCtr='#OpCtr#')
ORDER BY LastName ASC
</cfquery>
<HTML>
<HEAD>
<BODY bgcolor="#FFFFFF">
<TITLE>Vacation Search Results by Center</TITLE>
</HEAD>
<CENTER><TABLE BORDER="1" CELLSPACING=4 CELLPADDING=7 WIDTH=670 height="30">
<TR><TD WIDTH="642" VALIGN="CENTER" HEIGHT=45>
<b><i>PAYROLL DEPARTMENT/UPS</i><BR>
<I>15 ARLINGTON STREET, WATERTOWN MA 02472</I></b></TD>
</TR>
</TABLE>
</CENTER>
<HR>
<H1 align="center">Vacation Search Results</H1>
<center>
<p><b>UNITED PARCEL SERVICE - NEW ENGLAND DISTRICTS</b></p>
<p><b>NON-UNION VACATION SCHEDULE</b></p>
<p><b>2000</b></p>
<p> </p>
</center>
<p align="left"><b>Vacations are selected by length of service with
company.</b></p>
<p align="left"><b>Non-union employees can opt to use 1 week in
days.</b></p>
<p align="left"><b>Note in the no of wks column as follows: (3+1) - employee
has
4 week avail. is taking 1 week in days.</b></p>
<p align="left"><b>Legend: X=vacation week</b></p>
<CFOUTPUT QUERY="EmpList">
<b>#LastName# #FirstName#<br> #SSNo#<br>
<b>#DateA# #DateB# #DateC# #DateD# #DateE# #DateF# #DateG#<br>
</CFOUTPUT>
<cfoutput>
#DateFormat(CreateODBCDate(DateA), "mm/dd/yyyy")#
#DateFormat(CreateODBCDate(DateB), "mm/dd/yyyy")#
</cfoutput>
<cfoutput>
<CFIF #Abs(DateDiff("d", DateB, DateA))# less than 22>
<p>These weeks are back to back.
<cfelse>
<p>No Information.
</cfoutput>
</cfif>
<P>
<b>Thank you for searching the Vacation Posting Database!</b></P>
<HR>
</CENTER>
</BODY>
</HTML>
> Hi everyone -- If you could help me apply this DateDiff code below to
> search results fields #DateA# and #DateB# in the code of vacsrchdate2.cfm
> I would be much obliged...
>
> Thanks...
>
> > Julia Green
> > Programmer/NER Accounting Division
> > 617-926-3413
>
>
>
>
> >
> Julia Green
> Julia Computer Consulting
> http://www.juliagreen.com/
> Email: [EMAIL PROTECTED]
> Phone: 617-926-3413
> FAX: 413-771-0306
> ----- Original Message -----
> From: Duane Boudreau <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 18, 2000 9:36 AM
> Subject: RE: Source Control
>
>
> > Bill,
> >
> > I've been using VSS about 4 years now, pretty much problem free. One of
my
> > only pet peeves is that it doesn't offer a web interface as of 6.0
> (without
> > a third party tool).
> >
> > I'm interested in how you got pinning to work. As I understand it
pinning
> > allows you to create a link to a label correct? Unfortunately I have
never
> > been able to successfully get pinning to work. Also do you, or you VSS
> > admin, run analyze often on your database?
> >
> > TIA,
> > Duane
> >
> >
> >
> > -----Original Message-----
> > From: Bill Grover [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 18, 2000 7:49 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: Source Control
> >
> >
> > I figured I would stick my nose in here. Having not used the Perforce
> > product I can not speak good or bad about it.
> >
> > We use Visual Source Safe and have been for about 3 years. Everything
the
> > other users are saying about perforce can be said about source safe.
> > Depending your configuration of source safe you can allow multiple
people
> to
> > checkout the same document. Then as each person checks the document in
> > source will compare what is being checked in with what is currently in
> > source safe. If you changed a line(s) of code and no one else has then
> > source safe simply merges your changes automatically. If however, you
> > changed some lines and someone else changed the same lines it will show
> you
> > the 2 versions and allow you to choose which set of lines to place into
> > source safe. Once "merged" you can even tweak the lines to get them
into
> > their final form.
> >
> > The only restriction on the multiple checkout function is for files that
> are
> > binary, for example Word documents, graphics, etc. In this case since
it
> > doesn't have text to display differences with it will only allow one
> person
> > to have them checked out at once.
> >
> > We have been very happy with source safe. We have had as many as 6-8
> > programmers working on 1 project simultaneously merging changes and
adding
> > files without any problems. We have even taken advantage of going back
> into
> > the history and pulling a previous version of a file when someone
"screwed
> > up" the current version. You can even "pin" versions. In this case you
> can
> > take a specific version of a file and this is the one retrieved whenever
> you
> > get latest version. However, I can have a later version checked out and
> > working on it. In this way if you have a routine that is stable and
> working
> > you pin that version. You can then enhance and add functionality to a
> later
> > version without worrying about corrupting someone else's application.
> This
> > usefulness comes in to play when you allow multiple projects to share
the
> > same program.
> >
> > Good luck with your decision!
> >
> > ______________________________________________________
> > Bill Grover
> > Supervisor IS Department Phone: 301.424.3300 x396
> > EU Services, Inc. FAX: 301.424.3300 x1396#
> > 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED]
> > Rockville, MD 20850-1299 WWW: www.euservices.com
> > ______________________________________________________
> >
> >
> > > -----Original Message-----
> > ------------------------------
> >
> > Date: Mon, 17 Apr 2000 17:30:19 +0100
> > From: "Reid Philpot" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Subject: RE: Source Control
> > Message-ID: <[EMAIL PROTECTED]>
> >
> > I am that "London Developer" and can't agree more with what Scott has
said
> > (and I'm not saying this just because he's my boss), Perforce is a
> wonderful
> > product which has made a potentially difficult situation very easy.
Other
> > great features include being able to skip back to previous changes in
the
> > documents history so you can eradicate any error your boss may have
made.
> > :-)
> >
> > <snip>
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
