Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dabase
  • Order by date
  1. Dabase

    Live TV on Web Site

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

    MySQL converting ? to ì

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

    MySQL converting ? to ì

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

    CREATE ... SELECT: Error 1064

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

    MySQL converting ? to ì

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

    MySQL converting ? to ì

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

    CREATE ... SELECT: Error 1064

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

    CREATE ... SELECT: Error 1064

    No because "AS" is optional Thanks Dabase
  9. Dabase

    CREATE ... SELECT: Error 1064

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

    CREATE ... SELECT: Error 1064

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

    PostgreSQL 8 - handling accents for Portuguese

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

    CREATE ... SELECT: Error 1064

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

    PostgreSQL 8 - handling accents for Portuguese

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

    PostgreSQL 8 - handling accents for Portuguese

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

    PostgreSQL 8 - handling accents for Portuguese

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

    w3wp.exe hogging CPU

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

    The connection to the server was reset

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

    Domain availability

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

    Error Messages when submitting email

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

    XML and JavaScript Issues with Firefox 1.5.0.1

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

Part and Inventory Search

Back
Top