I have reverted to using MAXROWS = 1 because I only want ONE record. At all times there should never be more than 1 record within the table.
This was added to make sure it only returned 1 record. As a personal choice, I am against SELECT * Yes, TOP 1 does do something, by returning only 1 record which Is the desired results. -----Original Message----- From: Simon Smith [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 12:13 PM To: CF-Talk Subject: Re: CFMX 7 Reserve Words? >This is the exact same code on my machines, running CFMX 7 and the ODBC >is Microsoft Access. > > ><CFQUERY NAME="qSystemSettings" DATASOURCE="#REQUEST.DSN#" >USERNAME="#REQUEST.DSN_USERNAME#" PASSWORD="#REQUEST.DSN_PASSWORD#"> > SELECT > TOP 1 > ApplicationTitle, > ApplicationSlogan, > LoginSlogan, > MailServer, > SupportEmail, > DocumentPath, > BannerColor, > PrimaryColor, > SecondaryColor, > DateMask, > TimeMask, > EvenRowColor, > OddRowColor, > UserUploads, > AdminUploads, > TempDirectory > FROM > SETTINGS ></CFQUERY> > > > >-----Original Message----- >From: Tony [mailto:[EMAIL PROTECTED] >Sent: Monday, October 03, 2005 11:38 AM >To: CF-Talk >Subject: Re: CFMX 7 Reserve Words? > >show your code, might be something else... > 1) does removing the top 1, but keeping all the other sql stop the error ? eise try select * to see if the error is caused by a column name 2) can you use maxrows="1" instead ? 3) does the top 1 do anything useful ? (there is no order by clause) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
