Re: SQL Concat Issue

2007-10-15 Thread Aaron Rouse
is evaluated after the results have been calculated... sometimes... -- Jay -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 October 2007 00:01 To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here

RE: SQL Concat Issue

2007-10-15 Thread James Smith
October 2007 00:01 To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear

Re: SQL Concat Issue

2007-10-13 Thread Claude Schneegans
Right now I am getting an error that PubYear is not a valid column Then I'll try to make sure that PubYear is a valid column in table crAdInfo ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send

SQL Concat Issue

2007-10-12 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT

RE: SQL Concat Issue

2007-10-12 Thread Russ
,-mm-dd)# AND #dateformat(enddate,-mm-dd)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 7:01 PM To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here, but I have a legacy database