Recent content by Gixonita

Hello All, The roles were working perfectly, my CSS was the one on the fritz, had to move the <ul>s outside of the logingview declaration. Thanks :)

Hello All, I have a menu in which items within it should display depending on the role assigned. In the code below all roles should see the "Forms" option, and then, depending on the role, they should see "Admission", "Service", "Treatment", or "Discharge", only the Administrator should see ALL...

Oops, sorry, didn't see the second home grouping, that will teach me to read more carefully before I post.

Hello SELECT MIN (Date) AS StartDate, MAX (Date) AS EndDate, Place FROM YOURTABLE GROUP BY Place Hope this helps :)

Thanks for your input, I will look into your suggestions :) Luis Torres

Hi All, We have installed Sql Server 2005 with a 5 CAL user licenses (we are a relatively small company). We are developing a website that will allow users to query one of our databases. The website uses in it's connection string only one User Name that was specifically created in SQL Server...

Here is an idea of how to do it, every query could be run as a sub query of the next one, but I kind of wanted you to see what is going on on the process. Hope this helps SELECT id AS Last_ID, MAX (record_date) AS Last_Date INTO #TEMPO FROM Your_Table GROUP...

SELECT Address, KepMap, CASE VACANT WHEN 1 THEN 'VACANT' ELSE 'OCCUPIED' END FROM PROPERTY WHERE CITY = 'Dallas'

Thanks for the suggestions :)

Hi experts :) I'm creating a little website to train our employees, it goes a little like this: - Employee logs in (Done) - A list of available presentations is shown (Done) - Employee selects presentation and goes through it (Done) - Employee takes a test and gets scored (Partly Done...

Thanks for the suggestions :)

Hi all, I've been requested to develop an intranet training web site in which the employees: Step 1.- Log into main page and get a list of training videos they have access to. (Done) Step 2.- Choose video, play to completion, print certificate. (Incomplete) Step 3.- Update...

No prob, glad I could help :)

How about this? UPDATE Master_Data_Vehicle SET Actual_Annual_KM = (MilageTemp.Mileage / (DATEDIFF (day, First_Registration, MilageTemp.RepairDate) / 365.0)) FROM MileageTemp INNER JOIN Master_Data_Vehicle ON Master_Data_Vehicle.Chassis_Number = MileageTemp.ChassisNo WHERE...

thanks for your response :)