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 Chriss Miller 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: BigRed1212
  • Content: Threads
  • Order by date
  1. BigRed1212

    Include rows for which no data exists

    Hey and Hello, Given a table of survey responses from two dummy responders (I have more than two): table:dummy_responses code ques_elem response 001669 1 3 001669 2 3 001669 3 3 001669 4 3 001669 5 3 001669 6 3 001669 7 3 001669 8...
  2. BigRed1212

    Triggering a JS function on an AJAX write back

    Hello, I have these includes: <script src="raphael.js" type="text/javascript" charset="utf-8"></script> <script src="g.raphael.js" type="text/javascript" charset="utf-8"></script> <script src="g.pie.js" type="text/javascript" charset="utf-8"></script> followed by this...
  3. BigRed1212

    Translate onLoad to jQuery

    Hi, I'm looking to translate: window.onload=function(){ document.getElementById("states").selectedIndex = document.getElementById("states").getAttribute("default"); } to jQuery. I've tried a number of combinations like: $(document).ready(function(){ $("#states").selectedindex=...
  4. BigRed1212

    List of week start and end dates for a given year

    Surely this is a path well trod, just unfamiliar to me. Given a year (eg 2010, 2011, 2012 - user input), I would like to return a recordset with week, start of the week, end of the week. Looking like: weeknumber startdate enddate 1 1/1/2010 1/2/2010 2 1/3/2010 1/9/2010 3 1/10/2010...
  5. BigRed1212

    Should I have empty records or just get rid of them?

    I have payments to entities over years. Not each entity gets a payment in each year. For spreadsheet purposes I like to see an entry and a value even if no payment is made. This reassures me that the entity wasn't overlooked. Simplified example: entity year payment 1 1 10 2 1...
  6. BigRed1212

    AJAX call and timing of table sorting script

    Hey. I'm sure this is a timing thing, but I'm looking for a way to make it work. I use this javascript to make tables sortable. http://www.kryogenix.org/code/browser/sorttable/ Easy. Highly recommended. I have a page that presents the users a form with some selects, then executes an...
  7. BigRed1212

    where else did people apply?

    I don't know how to even set this up. I have data that look like this: fname ident place applied accepted bill 345 a 0 0 bill 345 b 0 0 bill 345 c 0 0 jane 234 d 1 1 jimmy 456 u 1 1 jimmy 456 f 1 1 jimmy 456 a 1 1 joe 123 g 1 1 joe 123 h 1 0 joe 123 b 0 0 jorge 678 e 1 0 tom 567 u 1 0 tom 567...
  8. BigRed1212

    Query for a poll- show all the options

    At the risk of getting in trouble, I am reposting this here. I accidentally posted it in the ASP formum even though it is an SQL question and I want to make sure it gets found. Apologies in advance if I am breaking the rules too badly. ________________________________ I've written a "quick...
  9. BigRed1212

    Sanitized parameter inputs

    I just realized I may not have doing what I thought I was doing and I may need to do it. Love that sentence. Currently I take in user input from a form: fname=Request.Form("fname") lname=Request.Form("lname") city=Request.Form("city") etc.. I connect to the database: data_source -...
  10. BigRed1212

    Turning one color into another

    I never have known how to do this. Is it simple? Say I have a black and white drawing and I want to make it on a grey background. What I want is a tool that lets me turn everything that is white to gray. Is there such a beastie?
  11. BigRed1212

    Proper table design for proper queries, how to normalize

    Big post, sorry in advance. I run a site for a local soccer league. I currently have all the pages which have the game schedule, team standings, and leading scorers, as well as the registered players database driven using ASP and an Access database. My problem is that the schedule table I use...
  12. BigRed1212

    How to avoid a trailing comma is a list of written items

    Hi, I have an application that writes out records in a recordset that meet a criterion; specifically for each soccer game in recordset1 (rs) it writes out the ident of the goal scorers from recordset2 (rs2) for that game. The control structure I have is: ...[Do while not rs.Eof followed by...
  13. BigRed1212

    I think I need a self join or a subquery to do this, but don't know

    I posted this someplace else but this forum looks like it might be a better place. I have a simple table, 3 columns. Goals scored in soccer games. lineid corresponds to an individual game. teamid is the team name. ident is a text field that is either a number or a name (for some players I get...

Part and Inventory Search

Back
Top