I keep running into space issues when creating and/or modifying field varchar2 size in OEM for my Oracle 9i Schema. If I lower one field size then I can increase another field size etc...It seems like my Schema has a limit on total sizes of all my varchar2 fields.
Is the space or limit due to...
Please advise how I can call ASP using PHP?
<html>
<body>
here is several paragraphs of information that changes alot and is stored in ASP.........
Anyway to call the ASP so I dont have to manually change my information everytime it is changed?
I have many Cold Fusion MX 7 web apps that run great. Most are small and medium size web apps that work great with Oracle and MySQL.
I dont know how much we pay for the CF license for our Windows server, but I hear that people want to eliminate CF and use free PHP.
It seems CF saves money in...
How do I fetch a request value in a Java class?
Here is my attempt but it has request object error:
public class First
{
private HttpServletRequest request;
private String lastname;
public First()
{
lastname= request.getParameter("lastname");
}
public...
I have local development Oracle 9i database in my Windows XP. I see it uses TNS Listener port 1521. For some reason it must be using port 8080 also or in the background because it seems to not let my web container (Apache Tomcat which uses Port 8080) work when it (TNS Listener) is turned on...
I need to do an ssi include in my PHP web page located on a Unix web server, but cant seem to get it to work.
<!--#include virtual="http://anotherServer/thepage.asp" -->
Please advise how I can use SSI to fetch a file in another server that is located on a Windows Web server.
In my Oracle 9i I tried this and it gave me back an error saying fullname is invalid.
select firstname || ' ' || secondname as fullname where fullname like '%Jo%'
This works:
select firstname || ' ' || secondname where firstname || ' ' || secondname like '%Jo%'
Please advise how I can get it...
In my Access 2003 I have this setup:
TableOne
pocOne pocTwo
2 3
2 4
1 2
TableTwo
TableTwoId Name
1 Jones
2 Smith
3 Edwards
4 Camden
I currently have this query where I need to find all the records that match the...
I have a local Oracle 9i database and forgot the password for my Username. Please advise how I can reset the password? I do have the password for the sys and system logins to this local database.
A SID, database instance in Oracle 9i is really the name of the database? If I have one SID (or database instance) on my Unix server called ABC then I can say I have one database called ABC on my Unix server?
Is it possible to have two databases on my Unix Server.
So in my case I would have...
I see a site called Apache Tomcat: http://tomcat.apache.org/
Is it correct to say Apache Tomcat because I was wondering if Apache and Tomcat are the same or what the difference is?
I am trying to find out how big my Schema is in Oracle 9i.
This SQL seems to give the total amount of space that I have used in my Schema?
SELECT tablespace_name,
Sum(bytes)/1024/1024 AS total_size_mb
FROM dba_segments
WHERE owner = MYSCHEMANAME
How do I find the total size of my what I can...
I am trying to create a page where it will look the same if the screen is resolution 1024 x 768 or if the screen is resolution 800 x 600.
The below finds the resolution but the page looks different depending on the resolution. Please advise how I can make a web page look the same no matter...
For the past 5 years I been using DSN connections to connect to Oracle in my Cold Fusion. Is there any other way to connect in Cold Fusion MX 7 without using DSN?
<CFQUERY NAME="query_name" DATASOURCE="db_name">
SQL statements
</CFQUERY>
For example in Java, I can do this and not use any...
I have done alot of J2EE especially working with MVC architecture.
I want to start learning .Net and was wondering if there was a specific name for MVC under .Net and how .Net implements MVC? What is equal to a Servlet in .Net? What is equal to a JavaBean in .Net?
I have my PHP inserting into Oracle 9i.
But how do I prevent duplicate record entries?
I only have 3 fields in the insert in the action page:
<?php
$c=OCILogon("scott", "tiger", "orcl");
if ( ! $c ) {
echo "Unable to connect: " . var_dump( OCIError() );
die();
}
$s = OCIParse($c...
Our CF MX 7 Server (on Windows 2000) usually has issues every morning only due to to Access Databases datasource issues that brings down the services. I was wondering what could be occuring overnight to effect this or is it logs that just fill up?
Maybe even CFschedule but how do I find out...
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.