
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2008 11:06 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2009 07:29 PM
But I wanted to mention that your change in the SP for line...
"AS SELECT dbo.tblComputers.Computername, dbo.tblComputers.Username,"
Needs to be...
"AS SELECT dbo.tblComputers.Computername, ISNULL(dbo.tblComputers.Username, '') AS Username,"
The portion "AS Username" is required to change the name of the result's column from "thedescription".
without this the page throws an error.
Thanks again!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2009 06:50 PM
NB I am no expert in this, but it worked fine for me.
In the stored procedure 'Web30computers' replace
"AS SELECT dbo.tblComputers.Computername," with
"AS SELECT dbo.tblComputers.Computername, dbo.tblComputers.Username,"
In %ProgramFiles%\lansweeper32\website\it-alldomain.aspx replace
"<td valign="middle" class="tblcell">Description</td>" with
"<td valign="middle" class="tblcell">UserName</td>"
and replace
"<td class="lef"><%=myrow("thedescription") %> </td>" with
"<td class="lef"><a href="default.aspx?item=userdetail&username=<%=myrow("Username")%>&userdomain=<%=request("Domain")%>"><%=myrow("Username")%></a> </td>"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-18-2008 05:08 AM
I know I don't have the skills but someones code changes, and page code would be most useful
thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-26-2008 07:46 PM
In the list of the view in SQL I only have "dbo.GUI30Computers" but not "web30" !
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-26-2008 08:42 PM
wavin wrote:
Can you let me know how you can modify the view : "dbo.Web30computers" ?!?!
In the list of the view in SQL I only have "dbo.GUI30Computers" but not "web30" !
Thanks
I'm sorry, it's a stored procedure instead of a view

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2008 05:41 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2008 08:03 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-22-2008 10:45 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2008 05:54 PM
