Recent content by cassie99

Dagon, You are right on target! Thanks for clarifying. -Cassie

Hi Mufasa, Yes. Depending on the schema we are querying, this target table may contain five hundred thousand records or more. Thanks. -Cassie

Thanks SantaMufasa. Was able to solve this with PARTITION BY and RANGE BETWEEN INTERVAL. Will take your advice (above) when I post my next question. -Cassie

Hello, I have a database table that I can query for store items. Each item in the table has an associated purchase date and an associated store. How would you suggest writing a PLSQL script that first sorts the data in the table by store, item and purchase date and then only prints out only...

Thanks Chris. Removing the ";" solved the problem. -Cassie

Thank you for your responses. -Cassie

Hello, I am receiving an invalid character error message when I attempt to execute the SQL below in my VBA application(db is Oracle 9i). Oddly enough, I can get this SQL to execute in TOAD without any warnings or errors. Any assistance would be greatly appreciated. Thanks in advance. -Cassie...

Hello, Please bear with me, I am very new to Tomcat installations. I am able to successfully install and configure Tomcat 5.5 on my laptop. To my understanding, there is a patch that needs to be applied to Tomcat 5.5 in order to execute servlets with the servlet invoker and compile jsp pages...

Santa M... Mission accomplished. I had an issue with one of the joins between two views. Thanks. -Cassie

Hello SantaMufasa, I receive the following message: ORA-00937: not a single-group group function -Cassie

Hello. Help. I cannot figaure out what is wrong with this SQL. I am trying to display an average cycle time per site. I end up getting the same result for all sites. Thanks in advance. -Cassie select SITE, AVG(CycleTime) as AVG_CT from (select SITE, ROUND(DEC_DATE-VIS_DATE,2) as CycleTime...

Hello, The code below successfuly opens a remote database. Is there an option that I can add to the path that opens XP_Foo.mdb if it is password protected? Thanks in advance. Cassie <SNIP> Dim strAccDB As String Dim strAccLoc As String strAccDB = """" &...

Hello. Please bear with me. I am not very savy with wireless technology. Oddly enough, the problem that I am experiencing follows a pattern. After approximately 30 minutes of strong network connectivity, my network signal is lost (regardless of proximity to the access point). I'm quite...

Hello. I have a command button on a MS Word form. I would like to open a MS Outlook window with the MS Word form as an attachment. That's easy enough... Private Sub cmdSendOfficeReq_Click() Options.SendMailAttach = True ActiveDocument.SendMail End Sub The question is how can I...

Bob, That's exactly what I wanted to do. Thanks so much. Cassie