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 SalesService 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 SalesService 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:00strongNot 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=##FF#Shipment_ID#/td 57 : td bgcolor=##FF 58 : cfif #ShipDT#=1970-01-01 00:00:00 59 : strongNot 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 -
RE: [ACFUG Discuss] CFIF/CFELSE
Greetings: I think your code: cfif #ShipDT#=1970-01-01 00:00:00strongNot Yet Shipped/strong cfelse #ShipDT# /cfif should be written as: cfif ShipDT EQ 1970-01-01 00:00:00strongNot 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 SalesService 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 SalesService 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:00strongNot 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=##FF#Shipment_ID#/td 57 : td bgcolor=##FF 58 : cfif #ShipDT#=1970-01-01 00:00:00 59 : strongNot 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
RE: FW: [ACFUG Discuss] dsn's in cf admin
Greetings: Are both SQL servers named (local)? If so, I would try to specify a different name for one or the other. I suspect that ColdFusion server is trying to connect to the wrong server and cannot find the database. 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] Dusty Hale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/04/2007 08:37 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: FW: [ACFUG Discuss] dsn's in cf admin Can't seem to find a solution that works so I'm going to develop with sql server express and dts the data back and forth with SQL Enterprise manager. I can set up dsn's with cf admin fine to sql express databases just not the sql 2000. Maybe there is a problem running multiple versions of sql on the same server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, May 03, 2007 7:30 PM To: discussion@acfug.org Subject: Re: FW: [ACFUG Discuss] dsn's in cf admin sorry i read sql server 2005 for some reason... and im not using windows anymore so I should lay off helping on any windows related questions. On 5/3/07, Dusty Hale [EMAIL PROTECTED] wrote: Of course it works fine when setting up through windows control panel. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Thursday, May 03, 2007 4:54 PM To: discussion@acfug.org Subject: [ACFUG Discuss] dsn's in cf admin I'm used to setting up dsn's for SQL Server with the server name (local) when in fact the server instance is local. However, I just installed SQL Server 2000 Eval on my laptop and am trying to set up a dsn to a database I just created. I've verified the server name is (local) and I tried that and also the IP 127.0.0.1 (CF 7 and SQL 2000) I get this error (in cf admin dsn section) when using the ip: Connection verification failed for data source: tester java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect I get this error when using (local): Connection verification failed for data source: tester java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: (local) The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: (local) If anyone could tell me what I'm doing wrong, I would greatly appreciate it. I also have SQL Server 2005 Express running on the same machine with a different instance name and setting dsn's to that one works fine. thx Dusty - 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 FusionLink - - 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 FusionLink - -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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