>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:219907 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
