Recent content by wickyd

Dear forum members I am using Joomla for this particular project. To achieve certain functionality, I am using Mighty Extensions components. Their components give me the following URL: http://www.example.com/en/username In other words: domain/language/registered user. I have been told that...

You totally nailed it. I made the assumption that the Windows machines were pointing to the local DNS server, but they were not. This is a small network. The subdomains are defined as: subdomain1.mydomain.com. IN A ip.of.the.server subdomain2.mydomain.com. IN A ip.of.the.server There is one...

Hi folx I created subdomain2.mydomain.com using Webmin, it takes the form: subdomain2.mydomain.com. IN A ip.of.the.server From any linux server on the local network, I can ping and nslookup the new subdomain as expected. However, when I point any browser to the new subdomain, it tells me...

Syntax error on line 528 of /usr/local/apache2/conf/httpd.conf: Invalid command 'ProxyRequests', perhaps misspelled or defined by a module not included in the server configuration httpd not running, trying to start I am running Slackware 10.2.0

Unfortunately, this doesn't work. Let me try and explain again ... Server 1: Domain: somedomain.com IP: some.public.ip.1 Service: apache running the company website Server 2: Domain: Doesn't have a domain IP: some.public.ip.2 Service: login system Both IPs are in the same range. End User...

Rob, thank you for the very fast response. I am new to apache, so unfortunately I don't understand your response at all :) If possible, please relate your answer to my pseudo domain names above. Naturally, the names are not correct, but they are in the exact form that I need to translate, ie...

Hi folks. I have server1 running the domain: somedomain.com I have server2 running the software that I need users to register and log into. I want the user to type: login.somedomain.com and by doing so it will serve the file one-of-my-ips/dir/file.php I do not want the user to know that...

Hi PHV The following error message: Aggregate functions cannot be used within expressions has negated all the effort that was put forward in this thread. DBISAM has a function called TOP N, but N has to be an integer. I tried TOP with COUNT and CAST but I get the same error: Aggregate...

Hi PHV Can you please explain in pseudocode how you tackled the problem. I can then try and modify what you gave me so that I can get to an answer. Thank you.

Hi PHV If I try your suggestion, I get the following error message: Aggregate functions cannot be used within expressions The joys of using built-in SQL engines.

I really do appreciate your help Current error message: Right parentheses expected, instead found 'COUNT' in source column expression Just to give you an idea: SELECT COUNT(TOTAL) FROM INVOICES will give me an answer of X. SELECT COUNT(0.5 * TOTAL) FROM INVOICES gives me the SAME answer of...

As I don't understand what you are doing, I am going to give you the error messages as I see them :) Current error message: Right parentheses expected, instead found '1.0' in source column expression

Hi JarlH Thank you for your response. Unfortunately, the version of DBISAM I am using does not support CASE. Here is all the code I use to get to the sample data above: SELECT ACCNUM, SUM(IF(DOCTYPE = 'I',(TOTAL - TOTALVAT),-(TOTAL - TOTALVAT)))NETTSALES INTO RESULT1 FROM INVOICES WHERE...

Hi folx I am using DBISAM, so here is a list of unsupported SQL: ALLOCATE CURSOR (Command) ALLOCATE DESCRIPTOR (Command) ALTER DOMAIN (Command) CASE (Expression) CHECK (Constraint) CLOSE (Command) CONNECT (Command) CONVERT (Function) CORRESPONDING BY (Expression) CREATE ASSERTION (Command)...

I have a table with three columns. I create the table as follows: SELECT ACCNUM, AREA and NETT INTO AREA1 FROM ALLAREA WHERE AREA = '01'; I now want to add a fourth column, a AUTOINC column which starts at 1 and ends at the last row. How do I add this row? I am using DBISAM V3.21 Thank...