I swear I need to have this tattooed on my head or something. Thank you so much. That did the trick.
Bruce Ray Thompson wrote: > How about an alias: > > SELECT abc.Prefix > FROM [xx.xxx.xx.xxx].Snowline.dbo.Street abc > > Ray Thompson > Tau Beta Pi (www.tbp.org) > The Engineering Honor Society > 865-546-4578 > -----Original Message----- > From: Bruce Sorge [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 04, 2007 1:33 PM > To: SQL > Subject: Binding Error > > OK, so I got my linked server issue fixed, but now when I run this query: > SELECT [xx.xxx.xx.xxx].Snowline.dbo.Street.Prefix > FROM [xx.xxx.xx.xxx].Snowline.dbo.Street > I get the error The multi-part identifier > [xx.xxx.xx.xxx].Snowline.dbo.Street.Prefix could not be bound. > > If I do this: > SELECT * > FROM [xx.xxx.xx.xxx].Snowline.dbo.Street > the query works fine. Problem is that I cannot do a select * since I am > building a string from four different fields. > > Thanks, > > Bruce > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2971 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
