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: vb89
  • Order by date
  1. vb89

    Copying listbox items...

    Well that doesn't seem to quite work, here's the code to move items... function MovePlayers(lstPlayerSelect,lstPlayerQueue,action) //function fnMoveItems(lstbxFrom,lstbxTo) { var varFromBox = document.all(lstPlayerSelect); var varToBox = document.all(lstPlayerQueue); var varMove =...
  2. vb89

    Copying listbox items...

    Essentially, I have an ASP.net page where I load a record set server side and upload it into a listbox. I'm trying to do all the movement functionalities of the listbox items client side. Specifically, I'm trying to figure out how to copy selected listbox items from one listbox to another --...
  3. vb89

    Loop through csv file...

    I'm trying to create a validation program which entails throwing everything in a csv file that i have into array and then looping through it and doing a comparison. Here is some of my preexisting code which currently finds the name of a file that I want to do a comparison off by basically...
  4. vb89

    Print first value of output?

    I have the following query SELECT count(*), COUNTRY_DESC FROM customer_data.cd_soccer_field_season WHERE SEASON_ID = 200849 group by country_desc order by count(*)desc how do i go about printing out only the first row of the output?
  5. vb89

    SQL Query Issue...

    I have the following code and im not sure what is missing or coded wrong here... Using: Oracle 10g open x_cursor; loop fetch x_cursor bulk collect into x_tab; for ii in 1 .. x_tab.count loop personID := x_tab(ii).personID; if profile_tab.exists (ipersonID)...
  6. vb89

    Combine Rows?

    Is there any other way of doing what i stated above?
  7. vb89

    Combine Rows?

    I'm trying to combine two rows under one column. using: oracle 10g Here is my code select cr.report_id as report_id, cr.report_name as report_name, ei.info as info from SPSS.WEB_CLIENT_REPORTS_NFL CR, spss.web_report_extra_info_nfl EI where cr.report_id = ei.report_id current...
  8. vb89

    Never ending loop...not sure why?

    I'm not entirley sure if that's exactly what i want, is there another fix to this problem so that the proc outputs the correct number of rows without hardcoding a maximum value?
  9. vb89

    Never ending loop...not sure why?

    .../ decode(sum(ytd.wins) + sum(ytd.losses), 0, 1, null, 1, sum(ytd.wins) + sum(ytd.losses)), '0d000') as winning_pct, trim(to_char( (9 * sum(ytd.earned_runs)) / (sum(ytd.outs_pitched) / 3) , '990d00')) as era, sum(ytd.strikeouts), sum(ytd.saves), sum(ytd.hits)...
  10. vb89

    UNION statement?

    that seemed to have fixed it...thanks
  11. vb89

    UNION statement?

    I kept everything the same except for the suggestion that you recommended and when i ran the query it threw an error..."not a single-group group function" Any ideas?
  12. vb89

    UNION statement?

    I'm trying to add a union statement(my statement is towards the bottom of the page )to the following cursor, but when i compile it says "query block has incorrect number of result columns." I understand why this is, but how do i go about solving the problem. select ytd.player_id...
  13. vb89

    Not sure what is occuring in this code

    Can somone please explain to me what is happening in this code... If InStr(iTeamID,"lg") Then iLeagueID = Replace(iTeamID,"lg","") iTeamID = "" tTeamName = "" Else iLeagueID="9" 'All players (I-A and I-AA) End If
  14. vb89

    Synatx and Logic correct?

    thanks
  15. vb89

    Synatx and Logic correct?

    I'm basically try to write a piece of code that displays which overtime it is based on the quarter of the game. Not sure if logic is correct and positive syntax isn't correct. if cInt(quarters) > 4 then ot = (""&cInt(quarters) - 5&" OT))" else ot = " " end if If for example quarters...
  16. vb89

    Keep getting error Component must me declared?

    ...the error componet 'first' must be declared, and i have no idea why... here is my code for my cursor and proc cursor cGetTeamStats is select * from varsity.soccer_period_results where game_code = p_GameCode; type team_stats_1d is table of cGetTeamStats%rowtype index by...
  17. vb89

    If Else From Statement... Overwrite

    yeah I tried that...unfortunatly it didn't do the job, any other suggestions? I also tried : If iLeagueID = "0" and iTeamID = "0" then tSQL = tSQL & " AND main.cfb_division_id = 1" tPlayerFilter = tPlayerFilter & " - Division: I-A" leagueAndTeamProcessed = True End If...
  18. vb89

    If Else From Statement... Overwrite

    (This is a classic asp page pulling data from an oracle database) I basically just want the first if statement to overwrite the second statement in the case that the criteria of the first if statement is met. So basically if the league_id value is 0 and the team id value is 0 I would like the...
  19. vb89

    If Else From Statement... Overwrite

    (This is a classic asp page pulling data from an oracle database)(I know this is the wrong forum but it's still the same basic fudamentals and the closes to what i need...thanks) I basically just want the first if statement to overwrite the second statement in the case that the criteria of the...
  20. vb89

    Group By SUM, statement

    yea nm, I got a bit confused, there...works fine, thanks

Part and Inventory Search

Back
Top