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!

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

Search results for query: *

  • Users: daph
  • Content: Threads
  • Order by date
  1. daph

    Query Slow when adding ORDER BY clause

    Hi guys, I have a simple query using the following table: COL1 NUMBER(5) COL2 NUMBER(3) COL3 NUMBER(4) COL4 VARCHAR2(20) COL5 VARCHAR2(200) COL6 VARCHAR2(200) COL7 NUMBER(8,2) COL8 NUMBER(8,2) COL9 NUMBER(8,2)...
  2. daph

    Database Objects

    Hi, Is there a way to know how many database objects are open in a program? Thanks daph
  3. daph

    JSP Error - oracle.jsp.provider.JspCompileException

    Hi Guys, Here is my situation: I'm adding multiple JSP pages to a web site. All pages are very similar...only small differences in content. At first, everything works fine...but as I keep adding pages, I start getting errors. I refresh a few times and it seems fine. So, I keep adding my pages...
  4. daph

    Get date modified of remote file

    Hi Guys, Here is what I would like to do...currently, I have a job that gets a document from a remote ftp server by using unix commands. What I would need to get is the date the document has been updated last. Is there a way to get that date modified that we usually see with a FTP client by...
  5. daph

    Problem sending to a specific email

    Hi, I was sending an email via sendmail to 10 recipients...all of them received the email except for one. Here are the errors for that failure: ----- Transcript of session follows ----- 554 rewrite: map @ not found ... while talking to something.pch.gc.ca.: >>> MAIL...
  6. daph

    Maximum characters in string

    Hi, Anyone here know the maximum number of charaters possible in a string? Ex: char string[MAX]; Thanks, Daph
  7. daph

    Modifying the type of a referenced primary key

    Hi everyone, I have a table which has a primary key USERNAME VARCHAR2(50) I also have a lot of tables that refer to that primary key, fields are also type VARCHAR2(50) Is there a way to ensure that if the primary key's type is change from VARCHAR2(50) to VARCHAR2(150), that all the refrenced...
  8. daph

    Creating a mailing List

    Hi, I have to create a mailing list and I have no idea where to start since I've never done this before. I've been trying to figure out the most efficient and relyable way of doing this. I have no idea how many people will be in that mailing list - could be 10 or 1000. This list will also be...
  9. daph

    Creating a mailing List

    Hi, I have to create a mailing list and I have no idea where to start since I've never done this before. I've been trying to figure out the most efficient and relyable way of doing this. I have no idea how many people will be in that mailing list - could be 10 or 1000. This list will also be...
  10. daph

    ActiveXObject("Excel.Application") Formatting

    Hi guys, Anybody ever worked with the object ActiveXObject("Excel.Application") to export data in excel? I was wondering if anybody could tell me how to merge cells. Any help would be greatly appreciated. Thank you! Daph
  11. daph

    Checkbox values in arrays

    Hi, Is there a way to pass some kind of null value when a checkbox isn't checked? The reason why I'm asking is because I have a list of checkboxes that will be saved in an array in PLSQL. If there are three checkboxes and the second one hasn't been checked, I still need the values to be in the...
  12. daph

    IE6 Does not start with Homepage Specified

    Hi! I have IE6 installed. I have the icon on my desktop and I also have it in my MS Office Toolbar. Here is my little problem...When I use the icon on the toolbar to start up IE, it never opens to my homepage. It always opens to...
  13. daph

    Creating Views in Access?

    Hi everyone, Is it possible to create something similar to Views (like in Oracle) in an access database? I'd like to have a dynamic table that would update automatically, when the tables associated with it are updated. I'm open to suggestions. Thanks a lot! Daph
  14. daph

    Using variables in a query

    Hi guys, Would you please do me a favor and check if there is something wrong with the coding below? (It's just a part of it of course) strMovieCDI = CStr(rsSQL("MOVIE_CD").Value) intMovie_cdI = CInt(strMovieCDI) strSQLeval = "SELECT SUM(RATING) AS SUM_RATING, COUNT(RATING)...
  15. daph

    Link Opening in New Window (Excel 97)

    Hi everyone, Small question: I added some web links in an Excel document. When I click on them, I have to click BACK to return to my Excel document. (Closing the web document will close my excel document). I know that I can open the link in a new window by right-clicking and choosing the option...
  16. daph

    About Queries in ASP

    Hi, Got a question for you guys. Say I have this in my code: strSQL = "SELECT DISTINCT MOVIES.MOVIE_CD, TITLE FROM MOVIES ORDER BY MOVIES.MOVIE_CD DESC" Set rsSQL = objDBConn.Execute(strSQL) varMovieCD = rsSQL("MOVIE_CD").Value And in my table, the field...
  17. daph

    Error: Too few parameters. Expected 2.

    Hey everyone, Well, I just started programming in ASP (With Access DB) and I have a little dilemma here. I have this error in some of my pages: Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. /tenderpaws/testing/list.asp...
  18. daph

    Question on Net Send

    Hi everyone, I got a little question for you and hopefully you can help me out. Here's my situation: My boyfriend and I have this little LAN at home and sometimes, just to tease each other, we send messages with Net Send on our computers. Problem is, he knows more about computers than I do and...
  19. daph

    ORA-01628: max # extents (505) reached for rollback segment R05

    Hi everyone, I got a problem and hopefully, someone can help me out. I got the following error message in SQL Plus: ERROR at line 1: ORA-01562: failed to extend rollback segment number 5 ORA-01628: max # extents (505) reached for rollback segment R05 I thought I had figure out how to fix the...
  20. daph

    Having trouble converting from string to in

    Hi everyone, I'm new to JSP and I've been trying to do some basic stuff to get used to it. Now, I've been trying to convert a string to a int, but no matter how I try it, I get errors. What package do I need to import for this? What function should I use? I tried Integer.parseInt but that...

Part and Inventory Search

Back
Top