Search results for query: *

Hi, I need to set up a site with live TV and was wondering how to go about setting this up. I would really appreciate it if someone could point me in the right direction. Thanks Dabase

I found some useful info: This shows the list of character sets currently supported by your version of MySQL: SHOW CHARACTER SET; This alters the database, but does not alter existing tables, only tables created after this alter statement will take greek encoding into effect: ALTER DATABASE...

Hi, After some research on the net, I have gathered that the most probable cause is due to encoding. But I am concerned that if I change the encoding to greek, the database will then stop recognising the english alphabet, is this going to be the case? Thanks Dabase

Now I am baffled, because after adding the ';', the query ran with no errors [neutral] Thanks Dabase

Hi, Apologies for the previous thread, it is converting the greek letter 'miu' into ì Thanks Dabase

Hi, My MySQL seems to be converting ? to ì, any ideas why this is happening? MySQL version: 4.1 Thanks Dabase

The problem was that I was missing a ";" at the end Thanks Dabase

No because "AS" is optional Thanks Dabase

Hi mbrooks, Are you saying that it is fishy because of the way that the alias has been defined. That is usually how I define tables aliases, is there a better way to do it? Thanks Dabase

Hi, There was a ';' missing at the end so that the statement looks like: CREATE TABLE `criteria` ( select PGC.PGC_P_ID, P_Title, GROUP_CONCAT(A_ID,'|', C_Title) AS Criteria from tblproductsgroupcriteria PGC join tblproducts P on PGC_P_ID = P_ID join tblproductsgroupindustry PGI on...

misterjoe, Thanks for the response. The encoding is SQL_ASCII /usr/local/pgsql/bin/createdb -E SQL_ASCII test I did manage to connect to the server from PGAdmin installed on another machine and saw that it was picking the accents, etc... so a star for ceco I will try to use rpm --no-deps...

Hi, I am trying to create a table as follows: CREATE TABLE `criteria` ( select PGC.PGC_P_ID, P_Title, GROUP_CONCAT(A_ID,'|', C_Title) AS Criteria from tblproductsgroupcriteria PGC join tblproducts P on PGC_P_ID = P_ID join tblproductsgroupindustry PGI on PGInd_P_ID = P_ID join tblcriteria...

Hi ceco, Once again, thanks for the response. I have done the following: ... /usr/local/pgsql/bin/initdb --locale=pt_PT -D /usr/local/pgsql/data ... /usr/local/pgsql/bin/createdb -E SQL_ASCII test When I performed the restore I did not get the errors I was experiencing before. However...

Hi ceco, Thanks for the reply. After I installed Postgres, I tried to restore a database that contains characters with accents and I got some errors. Could you please advise me on where I can find information on encoding. My understanding of clustering is having more than one server, which is...

Hi, During or after installation of PostgreSQL 8 on FC4, is there a configuration option or an add-on that handles accents for the Portuguese languange? Thanks Dabase

Hi, We have a web application (ASP), that is hosted on a server with the following specifications: Windows Server 2003 - Web Edition IIS version 6.0 CPU: Celeron 2.0GHz, 512MB RAM Database (residing on the same server): SQL Server 2000 with SP3a At certain times during the day, the web site...

Hi, I have an asp page that queries an SQL Server 2000 database, the user should then be able to save the resultset as an Excel file, using IE6 <% '********************************* '* Web Page: GenerateUsers.asp '********************************* %> <% Response.expires = 0...

DotNetGnat, Thanks for the suggestion, what I am actually looking for is to be able to search for various TLD's at one go, much like how you can search on www.simply.com. Any help on this would be much appreciated. Thanks Dabase

Apparently the ISA Server at my client's site was misconfigured, thus creating the problem. The ISA Server is currently being reconfigured, hopefully this will resolve the fault. ASPWizard, thanks for the advice. Thanks Dabase

Hi, We have an ASP site that works fine with IE 6.0, but when I try it in Firefox, certain areas of the site are not displaying correctly (and not displaying at all sometimes). For example search results throughout the site are not displaying (XML is used here for displaying results), and...