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 …

if you have a testing enviorment you can open a new trace in sql server profiler on the test db and lunch the process you wish to check there you can see everything that is executed on the db if you dont have a testing enviorment then i suggest you …

-- creating a temp table to hold the lucky ones CREATE TABLE #whoGotDisountShopCartId(id BIGINT) INSERT INTO #whoGotDisountShopCartId SELECT DISTINT ShopCart.ShopCartID FROM Shopper INNER JOIN ShopCart ON ShopCart.ShopperID = Shopper.ShopperID INNER JOIN orderData ON orderData.ShopCartId = ShopCart.id WHERE OrderPlaced = 1 AND MONTH(Shopper.Birthdate) = MONTH(orderData.DateOrdered ) AND YEAR(Shopper.Birthdate) = YEAR(orderData.DateOrdered ) …

insert into table values (blah,blah) SELECT SCOPE_IDENTITY will give you the new given identity if the new id is four you will get four and if its not an automaticly given identity then you know it already in the insert itself

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

why dont you use a stored proc CREATE PROC blahProcName () { AS select StudentID,StudentName,StudentFamilyName,Birthday,HisClass from Students } and on the server side using system.data.sqlclinet; sqlconnection conn = new sqlconnection(connectionstring); conn.open; sqlcommand cmd = new sqlcommand("blahProcName",conn); cmd.commandType = commandType.storedproc; dateTable dt = new dataTable("mytable"); sqlAdapter sa = new sqlAdapter (cmd); …

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 …

in the loop you have made the function works once because one return always happens fopr the first time either the if retrurns true or the else retuns false you can do something like: while (x < arrUser.length) { if ((formtest.usrrname.value == arrUser[x][0]) && (formtest.pswd.value == arrUser[x][1])) return true; X++; …

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) { …