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!

Register Log in
  • Congratulations derfloh 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
  1. hc1619

    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.
  2. hc1619

    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...
  3. hc1619

    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...
  4. hc1619

    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...
  5. hc1619

    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...
  6. hc1619

    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.
  7. hc1619

    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...
  8. hc1619

    Auto close window

    could you give me code example please? (because everything I've tried doesnt seem to work)
  9. hc1619

    Auto close window

    but i need to process the form first on another page, and THEN close the window.
  10. hc1619

    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...
  11. hc1619

    AVG Function

    thank you!! never dealt with decimal or precision/scale stuff.. had no idea. thanks :)
  12. hc1619

    AVG Function

    precision 3, scale 0
  13. hc1619

    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?
  14. hc1619

    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...
  15. hc1619

    AVG Function

    ... cos its bringing up error: "Incorrect syntax near 'from'
  16. hc1619

    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
  17. hc1619

    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...
  18. hc1619

    Running CF site from a CD

    absolutely perfect!! thank you!
  19. hc1619

    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...
  20. hc1619

    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...

Part and Inventory Search

Back
Top