Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by florida1987

  1. florida1987

    Large data type

    Thanks for your time. I actually created it using OEM. I will do as you advised tomorrow morning.
  2. florida1987

    Enforce Maxlength on Textarea

    For a textarea how do I limit the number of characters in the box to 500? For input text I can set to maxlength and limit the entry in the input: <INPUT TYPE=TEXT NAME="myInfo" MAXLENGTH=500> For textarea I assume I need to create a validation or something to fetch the length of the field and...
  3. florida1987

    Large data type

    I created the CLOB datatype (called BigField) in my table but when I try and add text info to the CLOB field it seems to not add anymore than 4000 characters. INSERT INTO TableOne (BigField) VALUES ('dsfadfasdfasdfadsfetaere etc....more than 4000 characters here..');
  4. florida1987

    Large data type

    Thanks, I added the CLOB to my table but it only takes 4000 max characters. How do I add more?
  5. florida1987

    Large data type

    I have a text field that has a data type of varchar2(4000). I would like to change it to hold 10,000 but I dont think it can go that big. Please advise how I can do it?
  6. florida1987

    Windows Installer

    Trying to load JRE 1.6 on Windows Server and it keeps saying my Windows installer is not working properly. I tried downloaded new one from microsoft and still the installer wont work. Any advise? Thanks
  7. florida1987

    Email not working

    I have this email method that worked about 2 months ago. . Today when I used it, it didnt send any emails and I got no error messages on the web page. Where or how can I find out what the issue is or why its not working? public static void send(String smtpServer, String to, String from, String...
  8. florida1987

    Export and Import Data

    Thanks! I will do that on Monday. I googled "Oracle DBA revoke" and found something like this: To revoke DBA privileges from a user: alter user markd revoke DBA. Revoking DBA priviliges SQL> revoke dba from gsdev; I assume that is all I need to do for revoking DBA privilege on my local...
  9. florida1987

    Export and Import Data

    Thanks, In my previous post example I just posted your exact code but I did use my Schema/password and tnsalias. I can understand the import not working but why did the export say it worked (local database to server database) and I didnt see my local database tables in the server? Maybe I...
  10. florida1987

    Export and Import Data

    Thanks, I tried this in my Windows Command Line: imp buffer=15000000 grants=y feedback=1000 fromuser=TEST touser=TEST file=DHUNT.TEST.dump log=TEST_Imp.log userid=TEST/TEST@tnsalias and it gave me a message imp - 00013 only DBA can import.. I am not a DBA on the Server. I assume I cant import...
  11. florida1987

    Export and Import Data

    I have a local development Oracle 9i database on my Windows XP workstation and I have the production Oracle 9i on a unix server. I use Oracle Enterprise Manager (OEM) in my local database for creating my tables, sql plus etc. Now I was wondering if there is anyway to export and import my data...
  12. florida1987

    Stored Procedure and Prepared Statment

    For my Oracle SQL as a back end to my web applications I use Prepared Statements alot in my Java Database Connectivy (JDBC) working with Oracle 9i. I also heard the term Stored Procedure. What is the difference between Stored Procedure and Prepared Statement?
  13. florida1987

    Oracle datasource connection in CF Admin

    Just a follow up to my question....it looks like I need to have an Oracle database installed for it to find anything. It now works.
  14. florida1987

    Limitations of older MySQL

    I have a free version of MySQL 4.1 running on our web server. I use it as a database for my Cold Fusion web applications. Please advise what are the advantages if I get newer MySQL version (5.0 and above)?
  15. florida1987

    Change font color

    Thanks
See more

Part and Inventory Search

Back
Top