Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: hc1619
- Order by date
-
Page Compression
If you go to www.trademe.co.nz.. and View Source, you'll see all their HTML stacked up up the top and all the whitespace removed. I want to know what sort of software is used to achieve this. Their pages come up ultra fast and I want to achieve this level of speed on my own site.- hc1619
- Thread
- Replies: 1
- Forum: Microsoft: Windows servers
-
Distinct wont work
jgoodman - that code worked.. it brought up just the one result for each topic.. BUT, as soon as i added another column to the query, ie: SELECT DISTINCT TID, DatePosted From TopicPostings Where TopicPostings.MemberID = @memberID it fell over and brought up all the results.. ignored the...- hc1619
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Distinct wont work
the Topics table has only 1 row.. so the subject is the topic title and one TID to identify it. The TopicPOstings table has multiple rows.. so if a user has made 5 posting to one topic, it will have 5 rows.. all with the same TID in the TID column, linking it to the appropriate TID row in the...- hc1619
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Distinct wont work
I have two tables (its a message board). One table is Topics, the other is TopicPostings. Topics contains the title of each discussion, date created etc and has ID called "TID". TopicPostings has all the postings.. it has a unique id "TPID", and also a "TID" column so i know which topic the...- hc1619
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
General Best Practice
I have a dating site.. with profiles. On each profile page I do a select from two tables using inner join. I have information on a 3rd table (about 10 varchar(250) fields) which contains more profile info. To view this though the user must click on another area of the profile and open up the new...- hc1619
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Auto close window
im such an idiot. my form posts to itself..runs the code and processes the form and then i redirect to another page. on that page i put: <body onLoad="window.close();"> and it worked. cant believe i didnt try that before.- hc1619
- Post #9
- Forum: Javascript
-
Auto close window
Hmmmm i dont think this is what i need. This is how i have it at the moment: A user on my site clicks a link and it pops up a window (this is the only popup to occur). So no worries to here. On this popped up page is a form. The user fills out the form.. pushes submit.. (STILL within the...- hc1619
- Post #7
- Forum: Javascript
-
Auto close window
could you give me code example please? (because everything I've tried doesnt seem to work)- hc1619
- Post #5
- Forum: Javascript
-
Auto close window
but i need to process the form first on another page, and THEN close the window.- hc1619
- Post #3
- Forum: Javascript
-
Auto close window
I have a window which pops up from my site using javascript. In this window the user types in their message in a form and pushes the submit button. WHat i want to happen is I'd like the confirmation page to close the window automatically... so the user types in their message.. .pushes submit...- hc1619
- Thread
- Replies: 8
- Forum: Javascript
-
AVG Function
thank you!! never dealt with decimal or precision/scale stuff.. had no idea. thanks :)- hc1619
- Post #12
- Forum: Microsoft SQL Server: Programming
-
-
AVG Function
whoops.. i saw the precision thing in EM on the tinyint field and thought it could handle it.. didnt realise it was greyed out tho. OK so i have changed it to decimal.. still storing just the single digit. What else could I be missing?- hc1619
- Post #7
- Forum: Microsoft SQL Server: Programming
-
AVG Function
ignore last post.. dumb syntax error that i missed. OK i got the code working.. but whats being stored in my Members table is still just a single digit where the final AVG should be.. its called "Rating" and is set to tinyint. Also.. when I test it and make a vote of 10 it throws an...- hc1619
- Post #5
- Forum: Microsoft SQL Server: Programming
-
AVG Function
... cos its bringing up error: "Incorrect syntax near 'from'- hc1619
- Post #4
- Forum: Microsoft SQL Server: Programming
-
AVG Function
like this? Update Members Set Votes = (SELECT COunt(RateID) From RateMe Where rMemberID = @rMemberID), ,rating = (SELECT Avg(1.0 * rating) from RateMe where rMemberID = @rMemberID) From RateMe Where MemberID = @rmemberID- hc1619
- Post #3
- Forum: Microsoft SQL Server: Programming
-
AVG Function
I have a photo rating system on my site.. one table, RateMe, which contains the votes, who made the vote, and who the vote was for. In my stored proc, whenever a vote is cast I then do a count of the votes and get a new average to store against the members profile. This is what I'm doing at...- hc1619
- Thread
- Replies: 12
- Forum: Microsoft SQL Server: Programming
-
-
Running CF site from a CD
I have a situation whereby I need to put my Coldfusion site (with database) on a CD. The whole site needs to run standalone from the CD. The site has queries to the DB and everything. I found a way to get solve the CF server problem.. but couldnt query the DB as the datasource needed to be... -
Security- Preventing duplicate people
I am building a referral system for my site. Members will be able to refer friends to my site (via a mechanism I'm building), and if 5 join up, then I'll give that member 1 free week of paid membership. I want to prevent people scamming the system... stopping people from just signing up...
