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 Rhinorhino 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: *

  1. cassie99

    Date compare question in PLSQL

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

    Date compare question in PLSQL

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

    Date compare question in PLSQL

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

    Date compare question in PLSQL

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

    [Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid characte

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

    [Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid characte

    Thank you for your responses. -Cassie
  7. cassie99

    [Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid characte

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

    Tomcat 5.5 Install and Config

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

    Oracle SQL

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

    Oracle SQL

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

    Oracle SQL

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

    Open a password protected database

    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 = """" &...
  13. cassie99

    Wireless connection drops after ~30 min

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

    Automatically

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

    Hiding a report header on the last page of a report (report footer)

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

    Hiding a report header on the last page of a report (report footer)

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

    command line &gt; date +%j

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

    command line &gt; date +%j

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

    Open a form from a command line

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

    Open a form from a command line

    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

Part and Inventory Search

Back
Top