Greetings: I think your code:
<cfif #ShipDT#="1970-01-01 00:00:00"><strong>Not Yet Shipped</strong> <cfelse #ShipDT#> </cfif> should be written as: <cfif ShipDT EQ "1970-01-01 00:00:00"><strong>Not Yet Shipped</strong> <cfelse>#ShipDT# </cfif> Don't confuse the assignment operator (=) the comparison operator (EQ). Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] Robert Reil <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/06/2007 05:47 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] CFIF/CFELSE Thank you Dean. I'll get it in time. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -----Original Message----- From: Dean H. Saxe [mailto:[EMAIL PROTECTED] Sent: Saturday, May 05, 2007 4:56 PM To: Carbs Sales&Service Subject: RE: [ACFUG Discuss] CFIF/CFELSE You should also know when and where hashes are needed around variable names. They are not required in the <cfif> block as you have them below or in many other functions. This will make your code infinitely easier on the eyes when you go to review it later. -dhs On May 5, 2007, Robert Reil wrote: > Got it! Just got to learn the symantics of the language... > thanks for listening to me think. lol... > > Robert P. Reil > Managing Director, > Motorcyclecarbs.com, Inc. > 4292 Country Garden Walk NW > Kennesaw, Ga. 30152 > Office 770-974-8851 > Fax 770-974-8852 > <http://www.motorcyclecarbs.com/> www.motorcyclecarbs.com > > > > _____ > > From: Robert Reil [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 05, 2007 1:34 PM > To: Carbs Sales&Service > Subject: [ACFUG Discuss] CFIF/CFELSE > > > I have a field that allows Nulls. > It auto populates nulls as > "1970-01-01 00:00:00" > > I used the following code to try to make it work and also tried > various examples of "IsNull" and could not seem to get it to work. > What am I missing/ > > <cfif #ShipDT#="1970-01-01 00:00:00"><strong>Not Yet Shipped</strong> > <cfelse #ShipDT#> > </cfif> > > CF Error states: > > The error occurred in > C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\shipping\editShipDate.cfm: > line 58 > > > 56 : <td bgcolor="##FFFFFF">#Shipment_ID#</td> > > 57 : <td bgcolor="##FFFFFF"> > > 58 : <cfif #ShipDT#="1970-01-01 00:00:00"> > > 59 : <strong>Not Yet Shipped</strong> > > 60 : <cfelse #ShipDT#></cfif></td> > > > coldfusion.compiler.ParseException: Invalid CFML construct found on > line 58 at column 31. > > I want it to say: > If > "shipdate" is null, or has that date in it then > text "Not Yet Shipped" > Else > Output the "shipdate" > > What am i overlooking? > > > > Robert P. Reil > Managing Director, > Motorcyclecarbs.com, Inc. > 4292 Country Garden Walk NW > Kennesaw, Ga. 30152 > Office 770-974-8851 > Fax 770-974-8852 > <http://www.motorcyclecarbs.com/> www.motorcyclecarbs.com Dean H. Saxe [EMAIL PROTECTED] "What difference does it make to the dead, the orphans, and the homeless, whether the mad destruction is wrought under the name of totalitarianism or the holy name of liberty and democracy? " -Gandhi ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------ ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
<<image/gif>>
