Search results for query: *

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

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

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?

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

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

When I run my current procedure, it seems to be getting caught in a never ending loop, not entirley sure what the problem is...? I'm not quite the expert so if possible, the more detail in the explaniation the better...thanks in advanced!! --The cursors cursor konami_mlb_pitchers_crsr is...

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

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

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

im working in pl/sql and I keep getting 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...

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

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

For the following code, the output displays two rows of data for some reason, it displays, team_name, punt_return, fair_catch, punt_ret_yd...any idea what is wrong with my code...thanks! select team_name, sum(Punt_ret) as Punt_ret, nvl(punt_fair_catch, 0) as punt_fair_catch...

I have the following SQL statement CURSOR player_cursor IS select * from customer_data.cd_soccer_players p where p.team_id = tID and p.league_id = p_leagueID and p.status = 'Y'; I would like to order the following statement by a column called player_position. Player...

Can someone please explain to me what is happening in the following code: <SELECT name="cf" class="data" onchange="this.form.cftxt.value=this.options[this.selectedIndex].text;"> <OPTION value="">Select Conference</OPTION> <%tempDivId = 0 Set rsConf = SPSSconn.Execute(tConfSQL) Do While...

I have an ASP application with some java script coding in it(searchResults.asp), and the stored procs are being pulled from an oracle database. I have a page called leadersIndex.asp which basically has a bunch of filters to choose from and redirects me to the page searchResults.asp. The page...

What I'm trying to do is to create a program that reads through a certain directory and outputs the location of each file(both in the directory and subdirectorys) into a text file. I am completely new to Perl and under a time restriction so any help would be greatly appreciated...thanks in advance

When I run my code I seem to get a 'SQL command not properly ended ' Here is my code: 'WHERE CLAUS (FILTERS) tWhereSQL = " WHERE main.active_record <> 'R' "&_ " AND main.game_type_id ="& iGameType &_ " AND main.split_number = -1" &_ " AND main.league_id IN (1,6)" &_ "...

Basically I'm kind of new to VB, can someone please help me make a program that: goes through every file in a directory and replaces any “$” characters in the filename with “_”. And if possible i'd like to hardcode the directory in the program (we can call the directory X for now) and to make...

I tried to add two new columns to my current coding (they're in bold): tTotalSQL = " replace(to_char(((sum(decode(minutes_seconds,null,minutes*60,minutes_seconds)) - (mod(sum(decode(minutes_seconds,null,minutes*60,minutes_seconds)),60)))/60),'999999990'),'...