Why are you using query on query? You could just use this code for your second query:
<cfquery name="qDataCorrections" datasource="#VARIABLES.dsn#">
SELECT prot_num, cntr_num, subj_id, init, visit_num
FROM subject s, data_correction d
WHERE s.subj_seq =...
I have a problem trying to use SAX to get data from an XML file into an oracle database...
I have downloaded the sample code from oracle, but to no avail; i can't get it to work..
Please can someone help me with getting the necessary procedures loaded into Oracle and a bit of sample code for...
I want to pass a (non-oracle) coldfusion query 'recordset' to an oracle stored procedure using a CF_SQL_REFCURSOR.
this is my code:
<cfquery datasource="NATIVE" NAME=NATIVEQUERY>
SELECT *
FROM NATIVETABLE
</cfquery>
<CFSET NEWVAL=99>
<cfstoredproc...
thanks for your input guys, but i found a way round it by using a form with hidden input fields named 'body', 'subject' etc and using the link to submit the form.
this needs a bit of javascript:
function win()
{
open('one.asp',null,'width=400')
}
</script>
<a href="#" onclick="win()">link</a>
for details see:
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp
hope this helps
for...
on my site i have link that users can click to send pages to others. the problem is that some of these pages have multiple querysting variables that i am finding difficult to pass.
this is an example of a link that does not work properly:
<a...
can anyone suggest how i can carry out a case insensitive search on a CLOB field in Oracle.
NB
i need to be able to search the entire field in one go each time.
TIA
Rhys
Here is a bit of code that will help.
this page consists of a counter that counts down from 5 to 0 then closes the window. There is some code that resets the counter if you move the mouse (you will probably want to remove this, but i though i'd leave it in to show you what can be done).
HTH...
i answered a post very much like this with the following code:
<html>
<head>
<title>Untitled</title>
</head>
<body onLoad="fnStartInterval()" onmousemove="setkk()">
<form name=jj>
<input type=text name=kk value=5 size=4 >
</form>
<script...
Soryy mate...
i must have changed the code inbetweem checking and posting it. there where some ';'s in the wrong place i think...
give this a go:
<html>
<head>
<title>Untitled</title>
</head>
<body onLoad="fnStartInterval()" onmousemove="setkk()">
<form name=jj>
<input...
try something like this:
notice that i have used the setAttribute() method to set the value for the control...
Hope this is ok.
Rhys.
<html>
<head>
<title>Untitled</title>
</head>
<body onLoad="fnStartInterval()" onmousemove="setkk()">
<form name=jj>
<input type=text...
Hi,
I have created a *.REG file to add a custom button to the default toolbar in Internet Explorer. The button works fine, the problem is that i would like to add a separator between my 'custom' button and the default buttons on the toolbar aswell. That is to say that when i run the REG file i...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.