Search results for query: *

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

Hello. Currently, the report footer of my report contains a chart. I am looking for a way to display just the chart on the footer (I do not want to see the report header here). Is there a way to print the report footer without my page header? Thanks in advance. Cassie

Thanks Gavin. Your post is very similar to what I ended up using. //get julian day int getJulianDay() { time_t d1; struct tm *f; time(&d1); f = localtime(&d1); int jul; jul = (f->tm_yday)+1; return jul; } Regards, Cassie

Hello. My dilemma: I would like to create a function that returns the UNIX system date with a julian day format (date +%j). Since it doesn't look like I can use: int jul; jul=system(&quot;date +%j&quot;); return jul; Any ideas on what I could use to make this work? Thanks in advance. Cassie

Robert, Thanks. That should take care of business for me. I need to run different batch processes throughout the evening. I launch the processes from a timer event associated with a form. I also read your FAQ &quot;How do I log users off a database and keep them off?&quot;. It was very...

Hello. Is there any way to open a form when referencing the path of a database at the command line? Is there a switch available to do this? Thanks in advance. C:\Program Files\SomeDbFolder\SomeDb.mdb ?frmSomeForm? Cassie