Search results for query: *

Having an issue with sending email from a RedHat Linux server. When sending a test message via the telnet <servername> 25 ehlo method, it is received succesfully. However, when using mail -s "subject" recipient@somewhere.com < fileattachment the emails just do not materialise. /var/log/maillog...

Can anyone offer an explanation on the following? When connecting to an ftp over http site e.g. ftp://ftp.sitename.com, some (not all) sites refuse to open, when they should be prompting for ID/password details. It gives the error: "Internet Explorer cannot download / from ftp.sitename.com The...

The following script sends an email if certain processes have failed, but sends no email if no error is reported. This works great when ran manually, but for some reason when I add this to run under crontab it will trigger the email event anyway - sending it to the recipient address (not local...

IE6 refuses to load https pages:'Cannot find server or DNS Error' is the message. It doesn't appear to even attempt to load the pages, so I used Paros to view the request & responses - and it appears to receive the data normally after all. Just will not display it! I have tried the following so...

Hi I have a string field (called 'Transaction') where several components exist, seperated by full-stops, eg: "ContractName.Location.Code.Type.System" Sometimes the string can contain an extra ccomponent, so I would like to tell Crystal that if there are 5 full-stops in the string, return the...

Hi I'm suffering from the 'summary total field could not be created' message and need help (again). The story: An old helpdesk report I have summarises the number of tickets raised in a month and the percent that were inside the service level. In a normal world (!) the resolution time of a...

Hi I am trying to calculate the SLA resolution times for a call management system, but the main table's close date field actually records the last time the call was closed. If it was closed, re-opened and closed again, it updates. To see when a call was initially closed, I have to look in an...

Hi I do not have the remove function, is there an alternative way to remove carriage returns from text fields in v7?

Hi I'm running a billy-basic report from a helpdesk application database into a csv file that needs to be scheduled weekly but need the customer email address included, something the helpdesk DB does not contain. I have an Access DB with the emails included and can link it using the userID's -...

Hi I have a call management report detailing all active calls by group name. <GH1> - this summarises the number of calls by groupname into age ranges of (a)0-3days old, (b)4-10days, (c)11days-1mnth and (d)1month+. <GH2> - displays each 'incident' or call reference (and related fields) - I have...

Any online Dow Jones/FTSE100 datasources that can be used to create charts via CF? This would certainly save any hassle of having to put the figures into a DB manually on a regular basis. Advice appreciated!

How can I set a parameter, so when a user schedules a report without selecting any parameters, it will default to all relevent values, as though the parameter never existed in the 1st place? Better explanation: A user schedules a report, forgetting to set the 'From' Date parameter, so instead...

Hi I'm creating a noticeboard system, whereby each record on a database is displayed in individual 'Card' image holders, and displayed in a grid system, containing a max number of 4 records per row. When the number of records to view (or cards) exceed 4 items, the board will carry the following...

Hi Anyone offer any advice on how to make a Cross-Tab report that displays the TopN records? The data I am using returns too many records to display on 1 page, and the TopN option is greyed out (Crystal V7.2 only). Any help appreciated..

Hi Anyone have an idea on how to either supress a group header or its contents so they do not appear on drill-down?

This is something that has been baffling me for a while - My Lotus Notes R5 Welcome page just dissappeared one day, never to return. The initial page is just grey. Anyone came across this before?

Hi Since performing a complete upgrade to accomodate a GeForce4 MX440, my PC has been giving me the most problems I have ever witnessed in my 10yrs building these things. The most common is cold-booting, get error: Registry is corrupt, you have restored a good registry, please restart'. On...

I have the following application.cfm template, but wish to modify it so when a user closes the browser the session closes with it - any suggestions? <CFAPPLICATION NAME=&quot;HelplineLogin&quot; SESSIONMANAGEMENT=&quot;YES&quot; SESSIONTIMEOUT=&quot;#CreateTimeSpan(0,0,30,0)#&quot...

I have a database that lists server names and their IP addresses for a large corporation. The main table lists the Host name, IP address & other aspects such as domain, role etc (this will be for webpages). To keep the IP addresses upto date, I have created a link table from the DNS servers'...

As you will see, the Subject of this message wasn't easy to put into a few words.... This is in relation to a Helpdesk database: I have 2 tables, joined by a field called 'Problem_ID'. Tablename'Problem' is the main table for each problem raised on the system, and has a unique 'Problem_ID' -...