Search results for query: *

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

...the following: Ping: Ping request could not find host subdomain2.mydomain.com. Please check the name and try again. Nslookup: From any windows pc on the local network, I get: *** dns.cache.server.of.isp can't find subdomain2.mydomain.com: Non-existent domain Where have I gone wrong? wickyd

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.

...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 X, not half X

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

...WHERE AREA = '101'; If I add your code, which I understand as the following: SELECT ACCNUM, NETTSALES, CASE WHEN (SELECT 1.0 * COUNT(*) FROM RESULT2 WHERE NETTSALES < S.NETTSALES AND AREA = S.AREA) / (SELECT 1.0 * COUNT(*)...

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

PHV I appreciate your help. I certainly did try your solution but the following error appeared: "Right parentheses expected, instead found 'Count' in source column expression." Is there some way of changing your SQL into a way where I can write one set of results into one table, write...

Hi PHV I can't have multiple selects in one query. I can however run as many queries as I want separated by semi-colons whereby I write each result set to a table and then join the tables later. See my example query above. With that in mind, can you possibly help? Thank you. Regards wickyd

Hi dnoeth, Unfortunately CASE is unsupported. That would not solve my problem though, as my original code does work, but if I have two distinct invoices and two small credit notes for that customer, the NETTCOUNT is zero which is incorrect. I want the solution to say INVCOUNT = 2 and CRNCOUNT...

...NAME, SUM(TOTAL - TOTALVAT)CRNTOTAL INTO RESULT2 FROM INVOICES WHERE (DOCTYPE = 'C' AND REP = 2) GROUP BY NAME ORDER BY NAME ASCENDING; SELECT * INTO RESULT3 FROM RESULT1 LEFT OUTER JOIN RESULT2 ON RESULT1.NAME = RESULT2.NAME; UPDATE RESULT3 SET CRNCOUNT = 0 WHERE CRNCOUNT IS NULL; UPDATE...

DBISAM Version 3.21