Search results for query: *

Hi guys, Thanks for the quick response. I appreciate it. There is no WHERE clause or any functions in the query. It's a very simple query. I ran tkprof. Here are the results from that. Without ORDER BY clause: call count cpu elapsed disk query current rows ------ ------ ----...

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)...

Is there a way to do this in the code? I would like to check this without using a third-party application/tool. Thanks, Daph

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

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...

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...

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...

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

That's ok :) For the primary key, it is unique. It is a unique login that is used on the network. No two will be alike. It's not just a common name. Thanks for your reply anyways, I appreciate it! Daph

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...

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...

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...

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

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...

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...

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

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)...

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...

Thanks a whole lot Gorkem, I will try that and see if it corrects the error. I truly appreciate it! Daph

Thanks guys, onpnt, the reason I'm asking is because I did this quite a few times on my web site and I thought maybe it was the reason why I have some errors. I have this error popping up once in a while and it drives me crazy: Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC...