Recent content by CartoonDog

Ok, got it working, my editor does not like the 'AS' keyword.

No probs on the typo, I caught it when Typing it in. I think you are on the right track, but my SQL+Worksheet is choking on something. It doesnt seem to like the left join immediatly followed by the select without some keyword in between. This is Oracle 9.2. Any idea?

yes, sorry about the typo of the second where. It does not seem to work. Part 'X' in the parts table that does not show a Class 'I' transaction between today and 1/1/2007 should show in the results list, but does not. It may although have other Classes of transactions, as long as they are not...

No, sorry, that was just a typo in the forum.

Ive tried it both ways and it doesnt work correctly.

I am have been trying to write a sql statement and could use some help. I am querying two tables. The first table holds the part numbers called PART. The second holds the transactions for the part table and is called TRANS. I need to find all the parts that have not had any transactions...

I am have been trying to write a sql statement and could use some help. I am querying two tables. The first table holds the part numbers called PART. The second holds the transactions for the part table and is called TRANS. I need to find all the parts that have not had any transactions...

Hi all any help would be appriciated. Making inbound or outbound calls results in a ringing phone on both ends as it should. When connected, neither party can hear what the other is saying. Internal calling is fine. My calls go outbound though a TI/PRI. I am starting my search there. Any...

Hello, I have a ICS7750 running callmanager 3.3(2)spC. All my phones are 7960's. This version of CM cameout prior to the 7970G. Is there a way to fool CM into thinking that the 7970G is a 7960? Or any other way without upgrading the entire CM to get this to work? I happen to have a 7970G...

Hi I am using 3.32 and looked into the SQL table for CDR information, and it was blank. The CDR Insert service is started under the control center. Is there a config utility for the CDR of some sort? THanks.

Hi gang. I am not concerned with performance, just getting the accurate results. My original report has a range of values that uses this selection criteria: {CUST_ORDER_LINE.PROMISE_DATE} in {?Due Date} ?DueDate is a Date Range with no default values. The above report selection seems to...

Problem solved... helps when you spell the app name correctly!

The error message actually says, '"Time Clock" failed to start.' Time Clock is the name of the Application

Hi, I have XPe running on W2k server sp4. I am trying to publish a timeclock app for my MRP system (Visual). The icon looks like a plain window, akin to dos. When launched from a pc, it opens a dos window, and runs an app akin to telnet. When I try to run this app on the citrix server, it...

Hotel Valencia in SJ, Ca.