Skip navigation
Inkfast
Inkfast Calculating status...
Currently Being Moderated

Migrating an old website to MS SQL 2005 from MS Access

Jan 6, 2012 5:03 PM

There is one query I have that's giving me the "Maximum length is 128" error. My research mostly referred to single or double quotes or a stored proceedure in the db but that's not the case. I'm hoping that someone with see the obvious problem with the query while I look for a better SQL referenece for the 2005 server as I'm used to working with MySql.

 

<cfquery datasource="#dsn#" username="#dsnusername#" password="#dsnpassword#" name="GetProperties">

                SELECT     P.Property_ID, P.Display_Order, P.Property_Title_File, P.Manager_ID, P.Property_Name,

                                P.Address, P.City, P.State, P.ZIP_Code, P.Medium_Pic_File, P.Medium_Pic_Height,

                                P.Medium_Pic_Width, P.Leasing_Office_ID, NRV.NotRented

                FROM         Properties AS P

                                LEFT JOIN [

                                    SELECT   A.Property_ID, count(Currently_Rented) AS NotRented

                  FROM     Apartments A

                  WHERE    Currently_Rented = No

                  GROUP BY A.Property_ID

                  ]. AS NRV ON P.Property_ID = NRV.Property_ID

                ORDER BY P.Display_Order, NRV.NotRented Desc, P.Property_Name, P.ZIP_Code

            </cfquery>

 

The error starts with the left join select....

 

Thanks!

David

372 Views   1 Reply   Latest reply: Dan Bracuk, Jan 7, 2012 5:57 AM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Jan 7, 2012 5:57 AM   in reply to Inkfast
    Report

    use normal parentheses for your subquery and don't put a period after the closing one.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points