>- see footer for list info -< There are a couple of things In CF when you run a stored proc you will be using a DSN in the datasource attribute, check the DSN is pointing to the right DB instance.
Then inside the stored proc itself check that the tables its using are not three part named or something equally silly. A three part name looks like this database_name.user_name.table_name If the database_name part is pointing to your old DB then you'll get the wrong data. I usually shorten these to just the table name if I can and the user name and table name if I must. You can in fact have four part names now (with SQL 2005)with the server_name first using linked servers which makes it even easier to access the wrong table if you aren't being careful, especially as it defaults to using these for you, thank you very much intellisense. Also if you are using SQL2005 check that the user you are logging in as in your DSN doesn't have some odd schema assigned menaing he's seeing different tables to the login you are using to check in query analyzer, though the fact you're using query analyzer suggests its SQL2000 unless like me you just can't get used to the new SQL Manager Tools. regards Steve Paul Swingewood <[EMAIL PROTECTED]> wrote : > >- see footer for list info - > > I know this may appear a stupid question but I have a really weird thing going > on. > > I have a stored proc which handles logins for me. > > How do I know where the code is fetching the stored proc from? > > The reason I ask is that the code is definately NOT pointing at the data that > it > should. > > I have a feeling that its pointing at an old server. - > > The code .... > > > > > > > The SP definatley runs ok checked with query analyzer (it always did work) in > fact it does work but if I change any of my data the changes aren't reflected > which makes me think I am looking at the wrong data set (maybe an old server). > Is there a setting in the administrator to make things point at the right > server? > > I haven't explained this very well but I hope you get the idea. > > Happy new year - Paul_______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk - > >- Lists hosted by www.Gradwell.com - > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help - Steve Powell [EMAIL PROTECTED] 07971 583792 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
