Search

Home › ASP.NET Forums › Search

You searched for the word(s): userid:712433

More Search Options

RSS Available

Matching Posts

best aproach for data classification

Hi all, I'm having trouble getting my head around the best architecture for the database to support efficient access to categorized data. the site/application is for classifieds ads, I know this is pretty common, but I think my requirements are a little more advanced (or seem that way to me anyway), or maybe I'm just taking the wrong approach. basically from the searching point of view: 1. User searches a hierarchy (any depth) of categories. Once they have selected a top level category, ALL

Posted to Architecture (Forum) by dotdodont on 12/1/2008
Filed under: categories, classification, database design
Re: Query quiz

wow, thanks ramireddyindia , thats a pretty complex piece of SQL, no wonder I was stumped... however, I just realised that I put my query in the wrong group, I'm actually using MySql and I dont think it has all those funtions. thanks for the quick response though, I will try to find the mysql equiv of your solution.

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dotdodont on 11/14/2008
Query quiz

Hi all, I cant figure out how to do get the result I need out of this: table1 -------- id name table2 -------- id fk_table1_id int ok, so there is a one-to-many relationship from table1 to table2. if I have this query: select table1.name, table2.int from table1 inner table2 on table2.id = table1.id order by table2.int then I get a linked row for every table2 row found, and ordered by int. But what I actually want is the first table2 row found only. So the result should only have 1 row per table1

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dotdodont on 11/14/2008
Re: creating a new Option(...) object

thanks NC01 and A1ien51 , that did it ... appreciate the fast responses

Posted to Client Side Web Development (Forum) by dotdodont on 11/13/2008
creating a new Option(...) object

hi All, am bit stuck with finding the correct syntax for creating a new Option object that has a certain background color. the normal definition I use to create an option is optionItem = new Option( textValue, idValue, defaultSelected, isSelected); .. and I pass in the variables. but I also need to pass in a variable containing the style - each option has a different background color depending on the value that its populated with. But I do not know how to pass in the style to this object, I was hoping

Posted to Client Side Web Development (Forum) by dotdodont on 11/13/2008
Re: Javascript Error: Object Requred - but WHY?

of course, thanks I should've known.

Posted to Client Side Web Development (Forum) by dotdodont on 5/27/2008
Re: Javascript Error: Object Requred - but WHY?

thanks for ALL the responses, I just thought the script would automatically execute anyway. but window.onload does the trick. thanks again

Posted to Client Side Web Development (Forum) by dotdodont on 5/15/2008
Javascript Error: Object Requred - but WHY?

Hi All, This is really killing me, one of those, no doubt, simple-to-fix-but-I-just-cannot-see-it problems. see code below, on page load the script should change the bg color of the element tried it with td and div, but both return error 'Object Required' - but why?? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Edit Sales People - OFFICE</title> <link rel="stylesheet"

Posted to Client Side Web Development (Forum) by dotdodont on 5/15/2008
Filed under: Javavascript
Re: need help with cascading join on saem table

just thought i'd add that I'm using a mysql db

Posted to MySQL (Forum) by dotdodont on 4/9/2008
Re: need help with cascading join on saem table

Hi xpscodes, sorry didn't see your reply before posting my sql statement, yours looks good too.

Posted to MySQL (Forum) by dotdodont on 4/9/2008

Page 1 of 10 (97 items) 1 2 3 4 5 Next > ... Last »