Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Select does not return values

Author  Topic 

Art Raz
Starting Member

2 Posts

Posted - 2006-09-15 : 15:43:51
I am new to SQL and I am trouble-shooting a problem with a home-grown app someone else wrote using PERL. It has a web interface with names of boards. I found the program where i need to add the board names into and did that. The new board names show up in the drop-down list in the Web page for the app. Alerts are sent to the new board names and show up on the new boards. Users are granted access to the new boards and they can clear items off the new boards. Yet when i try to use a report function for the new boards i added, nothing is returned. I even ran a simple SQl select statement specifying the new board names and nothing is returned. The older board names, some of which i added myself, return values. I don't know what is going on. Any help is appreciated.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-09-15 : 18:52:04
welcome to SQLTeam,

Why not post your sample code here

Afrika
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-09-16 : 08:27:28
Also post some sample data and the result you want

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Art Raz
Starting Member

2 Posts

Posted - 2006-09-19 : 11:46:13
To all,
Thanks for the feedback. It turns out the board that i was trying to pull data on was a 'roll-up' board (summarizes data from other boards) which will not have any data to pull. Everything is working correctly. I was getting ready to update this issue when i got an email saying people had replied.
Go to Top of Page
   

- Advertisement -