noamwegner

i wrote a paging script for HTML table that suppose to hold up to 5000 result rows and i am displaying for each page 100 rows what makes it ugly to see 50 page navigators so what i did was to display 5 each time the idea is like this …

Hi friends, can you guys help me to find the best way to track information changes in sql server 2000, like a free utility. The problem is that i need to track every single table because i want to figure something out. we have an ERP System and there is …

Hi, I need to use query to check if a person has made a purchase during the month of his / her birthday. If yes, I have to give the person 10% discount. So, I have my database as such (Some of the tables are omitted due to its relavancy): …

Hi Guys I want to crete the SQL Tigger.There is table called Fruits.In fruits table it contain ITEM_CODE,ITEM_NAME and PRICE.So there is application that used to insert the values into fruits table. So I want once ITEM_Name or ITEM_CODE is update then sql trigger execute and It insert the update …

what are the diffrences between CREATE INDEX [WITH IGNORE_DUPLICATE_KEY OFF] and CREATE UNIQUE INDEX it sounds the same! and if anyone knows when creating a plain INDEX just CREATE INDEX whether it creates a clustered or nonclustered index couldnt find an anshwer to that thanks in advance

Hello! I've got trivial problem and have no time to re-read manuals. I need to construct a function in SQL2005 which selects from DB and returns datatable. Something like this: [CODE] create function GetAllStudents() returns Table as begin ( select StudentID,StudentName,StudentFamilyName,Birthday,HisClass from Students ) return DataTable [/CODE] I need it …

i have the groups names in the database after getting them i get the manager from the active directory using directory searcher like this [CODE] public string getGroupManagersMail(string groupname) { DirectoryEntry drtEnt = new DirectoryEntry("LDPA=//DC=domain,DC=mil"); DirectorySearcher ds = new DirectedorySearcher(drtEnt, "sAMAccountName" + groupname); ds.PropertiesToLoad.Add("managedby"); SearchResult sr = ds.FindOne(); [/CODE] i …

I am trying to create a download link that will support all browsers here is the code [CODE]<a href="\\servername\blah\folder\myzip.zip > downlod zip </a>[/CODE] It works in IE but chrom doesn't react to it and firefox adds the current url to the begining of the path can anyone help thank you …

Hello, There is multidimensional array which has stored several information about each record. From those 1st is name and 2nd is pswd I am trying to write a function which would check name and pswd entered by user and check whether name exists in array or not. If it does …

Does anyone know if i can write a generic javascript function that check the file extension of the uploaded files and if the extension is incorrect erases the value because the user upload's more then one file i want to get the ID from the form something like: [CODE]fileselectedchange(obj) { …