Oracle ROWTOCOL function

I am trying use this rowtocol function posted in oracle tech doc's I am trying pass a query to this function but it is not working can some one please look into this:I am trying to get output from the following:select distinct user_id "Account ID", username "Correlation Key (PPM User ID)",(select en ...

Oracle anyone used this rowtocol function

Has anyone used this roltocol function @ http://www.oracle.com/technology/oramag/code/tips2004/050304.html ?i got the eror msg : "ORA-00933: SQL command not properly ended"note : i have removed the incorrect commenting before compiling the function successfully on Oracle 9i , i.e i removed the incor ...

Oracle rowtocol in interactive report

I am trying to use a rowtocol function within the SQL query source for an interactive report. The rowtocol function gets a set of values from a query of another table and the Where clause in the rowtocol needs to reference the primary key column of the row of the primary table I am reporting on. I c ...

Oracle ROWS TO COLUMNS (9i and 10g)

Please help with the RowToCol function?? See: http://www.oracle.com/technology/oramag/code/tips2004/050304.html I have been unable to get it to work on 9i - ORA-00904: "ROWTOCOL": invalid identifier. Any ideas??? Thanks! Example STUDENT   TEST1   TEST2    ...

Oracle Unable to get rows to column

All, I have gone through forums & other sites and searched for solution i also got few solutions.As of now they are not working for me. Senario :I have a 3 tables template_master,template_detail and eq_detail (equipment details).1) Template_Master (Item_code varchar2(10), code_id varchar2(20), c ...

Oracle .NET DBCommand to create one function is not working - needs Recompile

First I test if the Function exist in the current schemarunning this SQL code in .netselect rowtocol('select ''TRUE'' from dual') as OKA from dualThen if not exist I create the function CREATE OR REPLACE FUNCTION rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2 AUTHID C ...

Oracle Function

This program is used to concatenate the distinct name.But i need to change this program using BULK COLLECT.If possible plz any one help me./* Program*/CREATE OR REPLACE FUNCTION scott.rowtocol (p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',')RETURN VARCHAR2 AUTHID CURRENT_USERASTYPE c_refcur IS R ...

jQuery basic sort function

guys today I finally got around to using jQuery today and man do ilove it. wished that I had known about it before I started my lastproject. would have saved me a couple of months work.Ok well back to todayI needed to take a structure (table made of div's) and sort byalphabetic order once I got ...

jQuery Unable to bind click function in a dynamically created object?

i got a bit of a stumper for ya, trying to bind a function to the click event of each link in a dynamically generated list.i have a bunch of long content pages that we're breaking up into subpages, with a sidenav to navigate through them. the markup for each page is as follows:<div class= ...

Jquery.css function poor performance

<div>Hi,</div><div> </div><div>I'm performing css manipulation in my application, but the performance degrades considerably fast as more markup is added. I tracked the problem to the jQuery.css function, specifically for those cases where I'm setting the width and ...

jQuery How to bind a function only once

I have a group of checkboxes, and as long as any one of the boxes is checkedI need a function bound to a select list, but anytime none of the boxes arechecked I need the function unbound. What I have below binds and unbinds,but if I select lets say 4 checkboxes the function is bound and called 4time ...

jQuery How to bind a function only once

> I have a group of checkboxes, and as long as any one of> the boxes is checked I need a function bound to a select> list, but anytime none of the boxes are checked I need the> function unbound. What I have below binds and unbinds,> but if I select lets say 4 checkboxes the function i ...

jQuery forms plugin how to implement a preCallBack function to validate inputs

I would like to use the precallback function to check the inputs of the form heres my preCall function    function preContact()    {        // check name is not empty        if($("input#yrName").value ...

Function from jquery_auto

i find this fine Plugin:http://sputnik.pl/code/javascript/jquery_autocan i use the Auto-submitting SELECTs Function solo?not in the Plugin, i write this, works no:$(document).ready(function() {$('SELECT.Submit').bind('change', this.on_change);function change() {if (this.value) this.f ...

jQuery controling when function get executed

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 11 (filtered m ...

jQuery Why does $("body").resize(function(){ alert("hello"); }); does not trigger ?

does someone know why this does not work ? Or do i bind to wrong object? I want the function to be called when the browser changes window size.best regards,Truppe Steven ...

jQuery input.setAttribute is not a function

Hi,I'm using Jquery for a little Ajax I'm putting in a form. I'm no JS expertbut I can usually hack it so it works.The Jquery works for the stuff I'm using it for, but it seems to clash withthe drupal.js or something.Anyway, I get the following in firebug: input.setAttribute is not a ...

jQuery how to stop each iteration under each's function?

<div>for exzample:</div><div> </div><div>$("input[@type='text']").each(function(){if (this.value==""){alert("error");this.focus();break;}});</div><div> </div><div>but 'break;' won't stop the iteration of ea ...

jQuery how to stop each iteration under each's function?

> but 'break;' won't stop the iteration of each, what should i do?Return false inside the function and it will stop. That was added recentlybut the docs weren't updated to reflect it. ...

jQuery Function to enumerate the querystring?

Is there a jQuery function to enumerate the key/value pairs in aquerystring? I wasn't able to find one with the Visual jQuery websiteand instead of reinventing the wheel I thought I'd query the list.Thanks,Chris. ...

jQuery dimensions.js breaks height function?

Please advise: I need to use dimensions.js for the offset function. However,since this file overwrites JQuery's height function, I can no longer setheights (-- i.e. $("p").height("20px"); --). Will the offset function workon all browsers if I strip out dimensions' height ...

jQuery [Beginner. Help] Javascript not function in the loaded content by AJAX

thanks, all :)now, I apply eval($("div#append_area script").html());after:$("div#append_area").append(data);it works.I have thought to use:$("div#append_area").load('/ajax_input',$("#input_form").fastSerialize(), function(data)// do stuff on laod});But ...

jQuery [Beginner. Help] Javascript not function in the loaded content by AJAX

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=us-ascii"><META content="MSHTML 6.00.2900.2964" name=GENERATOR></HEAD><BODY><DIV dir=ltr align=left><FONT face= ...

Need help on first JQuery nested list function

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generato ...

Need help on first JQuery nested list function

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 11 (filtered m ...

jQuery SOT: Function review please?

The coupon codes are freely offered on the website, quite prominentlyactually. If the person still doesn't use them then that's their loss.The price is calculated in the cart code so I'm not worried about that. Thisis more a check because some people are using the wrong code either onpur ...

jQuery SOT: Function review please?

Do you want to prevent someone with an order over $1500 from using thesave10 coupon code? Why not let them use it? They're leaving more money onthe table for you, so let them have the smaller discount.If I View Source I can get the coupon codes? :) I would do a hash on thecoupon code (a simple c ...

jQuery SOT: Function review please?

A client has a range of coupon codes that people can enter in the shoppingcart to receive a certain percentage off their order. It's based on theirsubtotal in a range from 0 - $6000. He says that sometimes people willlenter the max coupon code for a lower range order thinking that they'll ge ...

jQuery executing a function thickbox closes

all,I am trying to execute a function when thickbox gets closed.using the code below I can get the alert box to run:$("#TB_closeWindowButton").click(                        ...

jQuery $(function(){...}); best practice?

all,as my number of $(function(){...}); adds up, I wonder what the best practicehere is?For example, is there a performance difference in the following, or is oneway simply better than the other?:$(function(){// some stuff});$(function(){// some stuff});$(function(){// some stuff});orfunction init() ...

jQuery Interface Selectable.. function on deselect

I've just started using jQuery and the really nice Interface plugin andfound that I was needing to call a function when something wasde-selected using the Selectable plugin.As a quick hack, I've added a few lines to the iselect.js code, butwould love to see this integrated properly into the core plu ...

jQuery Function: $(...).ancestorsTo(match)

> Would this be a candidate for addition to the core possibly?The ancestorsTo looks like it's an up-the-tree analog of the nextUntilmethod for siblings that was discussed here a while back. I think thegeneral consensus on that was that there would be an extended navigationplugin rather than a ...

jQuery Function: $(...).ancestorsTo(match)

I wrote a method that will provide a list of ancestors for any number of generations until an ancestor matches the expression. Example:<span style="font-weight: bold;">BODY</span>  <span style="font-weight: bold;">DIV</span>    <span style="font-weight: ...

setTimeout in jquery function

I am (attempting) to convert a standard javascript function to a jqueryfunction. It targets an image within a given div and changes it height andwidth. Here is the old function, where z is the image. img_act_height,max_width etc are global variables:function zoom_in() {    if(z.w ...

DOM traversing then applying a non JQuery function

Alright. I have a non Jquery function called <span style="font-weight: bold;"><span style="font-family: courier new,monospace;">myFunction(</span><span style="font-style: italic; font-family: courier new,monospace;">domObject</span><span style="font-family: courier n ...

jQuery Problem redefining $ with merge function

I discovered jQuery via Cody Lindley's Thickbox script and will warn everyonethat I have only a very basic understanding of javascript (despite severalyears' worth of ASP, PHP, etc).That said, I'm running into a problem using jQuery 1.0.4 with other scriptsthat use the Prototype library. ...

jQuery Binding a function to a variable (Newbie question)

I've just started using jquery, and as you can tell from my blog, very close to just having started javascript, but I'm determined to do things properly.I've written a post function that, for the sake of argument, pops an alert when you submit a form.$(document).ready(function(){  ...

jQuery Binding a function to a variable (Newbie question)

I've fixed my own problem with a hack of a kind. which is a bit disappointing as I'm not sure what was causing it. I changed the values called to be 'form#fPollX', in order to pass that straight to the $() jQuery function and stripped the id value off the end. In order to pass that v ...

jQuery Passing values to a custom function

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=us-ascii"><META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD><BODY><DIV dir=ltr align=left><SPAN class=2961654 ...

jQuery Passing values to a custom function

following up my previous post where I was trying to bind a function to a submit event, I'm now trying to pass values from the function that returns a function to the bound submit event.<br clear="all">I've a number of forms on a page, that perform a variety of functions, some similar. ...

jQuery possible bug: css(property) function

I don't know it this is considered a bug or not but, hasn't anyone noticed that if you try to access a css property through the <span style="font-family: courier new,monospace; font-weight: bold;">.css(property)</span>function to an object that doesn't exist the whole applica ...

jQuery 1 Function, Multiple Events?

I have a feeling there is an obvious answer to this, but it escapes me...if have some thing like this that is called by document.ready():function init_top_level() {    $(".top_folder").click(function(i) {        // Do a ton of stu ...

jQuery Pass var to parent function syntax?

I'm calling a resize function from a file loaded into an object tag:onload=function(){var sH = (document.body.scrollHeight)this.parent.resize("#external",sH);}The resize function in the parent page:function resize(objId,h){console.log(objId+","+h); // #external,1157$(objId).h ...

jQuery Multiple divs using one ajax function

all,i've managed to write the code to update one div after an ajax success callby usingsuccess: function(response){$("#diva").html(response);}I now have several div's i would like to selectively update depending on theresponse back from the ajax call. How can i do that? do i have t ...

jQuery Effect function runs twice

I'm new to jQuery so bare with me if I'm a bit slow. As the subject implies I'm havning trouble with the function hide because it runs twice when I would think I've only set it to run once. Here's the code in question:    $(document).ready(function(){   / ...

jQuery help with recursive function

I am trying to create a multi-step form using a recursive function to findthe form, bind a submit event, and replace the form with either an errormessage or a new form for the following step. This is what I have so far:        $(function(){    ...

jQuery External or anonymous function - which is best?

My question is more about Javascript memory and best practices than aspecific problem, but I will use the following example to illustrate:I have a div, which I would like to have a minimum height of 600 px. If Iput 600px as the height in the .css file, the div will not expand forcontent that is larg ...

jQuery ajaxComplete & ajaxError callback function parameters weirdness

I'm struggling with these global ajax callback handlers. The documentations states as follows:    $("#msg").ajaxComplete(function(request, settings){            $(this).prepend('Successfully loaded url: ...

jQuery a bind function inspired by prototype's Function.prototype.bind implementation

was looking for an easy way to bind functions to objects when using jquery,and couldn't find any information about it. is there a reason for notimplementing this? i found it very useful when using prototype.i've made my own implementation for jquery...it declares a bind function inthe global ...

jQuery IE function() bug when using clone()

Maybe I'm missing something but I seem to have found a problem with assigninga function to a new object created with clone(). But oddly enough it onlyseems to happen in certain cases related to the assignment of the thiselement. There is an example at: http://aos.elicochran.com/Example works fin ...