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 strongm 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: raphael75
  • Content: Threads
  • Order by date
  1. raphael75

    trying to call Sybase stored procedure with parameters from PHP

    I'm trying to run a stored procedure on a Sybase 11.0.1.2596 database (Micros RES 3700) in a PHP file using PDO and dblib as the driver. I can call a procedure with no parameters with no problems using something like: call custom.show_clocked_in_employees This works perfectly. However, if the...
  2. raphael75

    installation errors on AWS Linux AMI

    I was trying to install ase160 on an AWS linux AMI instance, and I got these errors when running ./setup.bin: Preparing to install... Extracting the JRE from the installer archive... Unpacking the JRE... Extracting the installation resources from the installer archive... Configuring the...
  3. raphael75

    Micros Res 3700 - How/when do entries get added to hist_job_rate_dtl (pay rate history)

    I'm trying to figure out how & when data gets added to the hist_job_rate_dtl table. I thought maybe it was copied there from the job_rate_def table when the end of night runs for rows where the rate_effective_datetime matches the current date, but that doesn't appear to be it. Does it come from...
  4. raphael75

    Does Micros store Cash Tips as a discrete value?

    We have Micros Res 5.2. When our servers clock out they see a screen that looks like the image in the attachment. I'm trying to find out if Micros stores the Cash Tips value the server enters as a discrete value somewhere in its labyrinth of tables, or if it only stores the Net Tips value. I...
  5. raphael75

    help with query getting max number per row with multiple rows

    I have data that looks like this: id escalation_id escalation_user_id level dt_added status_type_id 126 92 390 0 12/02/15 01:52 PM 4 127 93 390 0 12/02/15 01:53 PM 4 128 93 77 1 12/02/15 01:57 PM 1 129 94 390 0 12/02/15 01:58 PM 4 130 94 77 1 12/02/15 02:19 PM 2 131 93 77 2 12/02/15 02:20 PM 1...
  6. raphael75

    Firefox super slow at adding event listeners

    I have a website on our Intranet that is used by our accounting dept for financial planning. The site has about 20 tabs, and each tab has about 572 <input type="text"> boxes. When the pages load, the program adds event listeners to each textbox. On Firefox, this takes about 48 seconds, but in...
  7. raphael75

    load data from micros sp into table

    I would like to load data from the micros.sp_R_sys_menuitem_fam_grp stored procedure into a temporary table so I can run some queries on it. I tried: select * into #t_test_sp from micros.sp_R_sys_menuitem_fam_grp(); but I get this error: COMMIT/ROLLBACK not allowed within atomic operation...
  8. raphael75

    vbs connection to Micros database

    I have to write another script to connect command-line vbscript to Micros, which uses SQL Anywhere 11. When I try to make the connection I get this error: The specified dsn contains an architecture mismatch between the driver and application code 80004005 and the connection: Set Connection...
  9. raphael75

    sales tax on discounted items

    Does anyone know what table in Micros would store the sales tax value on discounted items? Thanks!
  10. raphael75

    PHP command line, echo, &amp; exec

    I have a PHP script running on the command line on Apache/Windows. It calls exec() to run an external program (dbisql). While it's waiting for the program to finish running, which could be from 1 second to 10 minutes, I am trying to have it output something to indicate that it's still "alive". I...
  11. raphael75

    v_R_sys_menuitem_fam_grp

    We have a script on our server that uses dbisql to get the quantity of menu items sold for the current day from v_R_sys_menuitem_fam_grp. This script worked perfectly for over a year, but 2 Fridays ago it stopped working for a random selection of 10-15 of our 36 stores. The affected stores...
  12. raphael75

    micros net sales at clockout

    Hello, We have a system that calculates the tip share for our employees. I created a custom Crystal Report and stored procedure in micros that runs when the server prints out their server report at the end of their shift. The report figure out what the server's net sales were, and calculates...
  13. raphael75

    micros.dtl.dtl_type, micros.trans_dtl.type codes

    Re: thread693-1164015 Can you please let me know where you found what the codes stand for? For example, is it possible the "V" code might stand for "void" and not "voucher"? Thank you!
  14. raphael75

    database error when running Crystal Report

    We have a custom Crystal Report that gets data from a custom stored procedure. This report has been running for over a year at 2 of our restaurants with no issues. We just rolled it out to about 16 more stores, and 1 of them is having a wierd issue. The report prints out at the end of the...
  15. raphael75

    mas90 import file csv fields

    Someone at our company many years before I started here created a script that generates a sales import for MAS90. The format of the files seems to be: SJ,00xxxxx,<mmddyy>,<gl code>,<field name>,<field name>,<debit>,<credit> I can't find the manual for MAS90 to look up what all these fields are...
  16. raphael75

    scheduled task to copy files fails (works from command line)

    We have a PHP script that copies files and folders from a Windows 2008 R2 computer to a Debian Linux webserver. The script works perfectly when run from the command line. However, when we try to run it as a scheduled task, it can't "see" any files or folders on the Windows computer. I used...
  17. raphael75

    streaming timeout

    I have a web server Apache 2.4 VC11 (http://www.apachelounge.com/download/) running on Win 7. On my server I have some mp3's. I can queue them up in Winamp and the 1st one will begin streaming. However, after it plays for about 20-30 minutes it stops streaming, almost as if some time limit has...
  18. raphael75

    powerpoint 2007 macro error

    I'm trying to create a simple macro in powerpoint 2007 to save the active presentation as a pdf. I tried the example on the MS site here: http://msdn.microsoft.com/en-us/library/office/ff746080.aspx Public Sub ExportAsFixedFormat_Example() ActivePresentation.ExportAsFixedFormat...
  19. raphael75

    Possible to schedule a task to the second with schtasks?

    I have a file that creates a scheduled task using schtasks: <?php $cur_dt = new DateTime('now'); $cur_dt->add(new DateInterval('PT60S')); $cmd = 'schtasks /create /sc once /ru uname /rp pwd /tn "repost_labor" /tr "' . $fname . '" /st ' . $cur_dt->format('H:i:s') . ' /sd ' ...
  20. raphael75

    search for files that don't contain specified string

    Is there any software for Windows 7 that will let me search a folder and find all the .txt files in all subfolders that don't contain the string "cheese"? Thanks!

Part and Inventory Search

Back
Top