I think this would work for you assuming you have table2_id field on table1
insert into table1 (table1_id,table2_id,forename,surname)
select sequence.nextval, table2.table2_id,table2.forename,table2.surname
from table2
where table2.table2_id not in (select table2_id...
have you tried this in sqlplus
select to_char(to_date('2008-01-17 5:23:20 PM', 'yyyy-mm-dd hh:mi:ss am'),'yyyy-mm-dd hh24:mi:ss') from dual;
this returned 2008-01-17 17:23:20 for me.
As BJCooperIT pointed out having hh24 and am/pm is unusual and in sqlplus trying this gives an error.
select...
with regards to the caching problem we have the following at the top of all the pages
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no cache">
but the proxy still caches
Hello we had a problem with our clients caching pages on their proxy server so people we seeing other peoples information. We got round this by using forms and submitting them that in turn forced the proxy server to get a new version of the page each time. This works fine with IE but not with...
Hello,
I have installed BCB 5 on Windows 2000 and I'm having problems creating a new project.
If I save the project using the defaults of unit1 and project1 the program will run but if I use any other name I get
[Linker Error] Unresolved external 'WinMain' referenced from C:\PROGRAM...
Thanks LAwebTek,
I thought that might be the ony way but I was hoping there was some page property that would tell me this as our application is pretty much finished.
Anthony.
Hello again Samphdauto,
This is a procedure I ended up with that posts a form to an URL.
Public Sub validate_logon()
Dim URL As String
Dim Flags As Long
Dim TargetFrame As String
Dim PostData() As Byte
Dim Headers As String
URL = "http://thisisthevalidationurl"...
Hello samphdauto,
I'm not quiet sure what you mean but if you are passing a value to an url e.g. 'the car of the future' where the name of the parameter is title. the url might look something like this.
http://www.abcnews.go.com?storytitle=the%20car%20of%20the%20future
Helo John,
I have found that I have to call the method with no brackets around the parameters e.g. .navigage url,flags not .navigate(url,flags)
Anthony
Hello,
This is probably very easy.
I am using the navigate2 method in my prog. eg. mynav.navigate2 (url)
the method navigate2 is define like so
object.Navigate2 URL [Flags,] [TargetFrameName,] [PostData,] [Headers]
I would like to be able to pass some values the the flags parameter. How do...
Thnks Jeff,
The filter works perfectly. The reason I had the extra single quotes is that I'm using Oracle Portal to build html pages and I left these in by mistake.
Anthony.
Hello I am trying to validate a date if the format dd/mm/yy
this works fine in IE5-6
var filter=/^[0-9]{2}[/]{1}[0-9]{2}[/]{1}[0-9]{2}$/;
if (! filter.test(inpDate))
{ alert("Please enter Date in DD/MM/YY Format !");');
return false;');
};
but I get
JavaScript Error...
Hi,
I have three dropdown select option fields on a html form called myform.
They are hours_values (00 - 23), minutes_values (00 - 59) and day_segment_select (1.00,0.75,0.50,0.25).
when then user changes the day_segment_select the other two dropdowns change depending on values on other...
Hello,
What I have is a pop-up calendar which needs to return the date to a field on the main page.
I have got this working now. My problem was that I was using Oracle Webdb to generate my pop-up calendar page but my calling page was a normal html page. Once I used webdb to generate the...
Hello I am using window.opener to return a value to a page that calls a pop-up window.
when I try to pass back the value I get a permission denied error.
Within my pop-up window the user can click a button that updates the pop-up window by calling an url to rebuild the page.
If I do a very...
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.