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!

  • Congratulations wOOdy-Soft 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
  • Content: Threads
  • 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 ì

    Hi, My MySQL seems to be converting ? to ì, any ideas why this is happening? MySQL version: 4.1 Thanks Dabase
  3. 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...
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. Dabase

    Error Messages when submitting email

    Hi, I am not sure that this is the correct forum to be posting this, but as I am only getting the error below when submitting through an asp page, I thought I should post here. I have tried sending test e-mails from outlook to the e-mail address and get no errors it is only when submitting...
  9. Dabase

    Domain availability

    Hi, I have an asp page that looks up domain names to see if they are available for purchase. I am using Microsoft.XMLHTTP for the purpose (see below some sample code) Dim sDomain, sDomainFlag sDomain = strDomainName & "." & arrTLDs(1,i) ' Introduce the url you want to visit GotothisURL =...
  10. Dabase

    HTML Editor

    Hi, Does anybody know of a free HTML editor I can use (in place of <TEXTAREA>)? What I am trying to achieve is to give flexibily to the user (ie. to be able to select different fonts, size, colors, create hyperlinks, etc...) Any help on this would be much appreciated. Thanks Dabase
  11. Dabase

    Response.Redirect redirecting but not showing correct url

    Hi I have an ASP page that redirects the user to a url, depending on what group the user belongs to. Code: ... ElseIF session("domain") = "1" or session("domain") = "3" Then Response.Redirect("homepage.asp") ElseIF session("domain") = "2" Then...
  12. Dabase

    PDA Emulator for Windows XP

    Hi, Does anyone know where I can find a free PDA Emulator that I can install on Windows XP? Any suggestions would be much appreciated. Thanks Dabase
  13. Dabase

    Setting Identity to No

    Hi, Is it possible to set the identity of a column to "No" using a T-SQL statement? Thanks Dabase
  14. Dabase

    Updating a column based on multiple columns from another table

    Hi, I am trying to update a column in a table based multiple columns of another table. Below is the script that I am using: UPDATE tblNews SET N_PS_IDs = (case isnull(InfraNewsMigration.dbo.thedatafile.Col027, '0') when '1' then '11' end) + ', ' + (case...
  15. Dabase

    Inserting non duplicate values

    Hi, I have 2 tables as follows: MyTable ------- Australia USA UK OtherTable ---------- Australia Argentina Armenia Ukraine Uganda USA UK I need to insert the values from OtherTable into MyTable without creating any duplications. Any ideas how I can go about doing this? Thanks Dabase
  16. Dabase

    Violation of PRIMARY KEY constraint

    Hi, I am trying to INSERT data to MyTable using a SELECT statement from another table, I am getting the following error: Server: Msg 2627, Level 14, State 1, Line 4 Violation of PRIMARY KEY constraint 'PK_MyTable'. Cannot insert duplicate key in object 'MyTable'. The statement has been...
  17. Dabase

    Getting data from one column to write into 2 others

    Hi, I have a column in my table with data in the following format: Col05 ----- June 2005 xxx 15 May 2005 xxx 14 April 2005 xxx 11 March 2005 xxx 9 For each record, I need to write the Month and Year (eg. June 2005)into Col06 and the ID (eg. 15) into Col07. Is there a function (or any other...
  18. Dabase

    Max character count for a column

    Hi, Is there any way that I can obtain the maximum character count (including spaces) for a column? Thanks Dabase
  19. Dabase

    Row length exceeds 8060 bytes

    Hi, I am trying to create a new table in an SQL Server 2000 database. After I run the script to create the database, I get the following message: Warning: The table 'tblTest' has been created but its maximum row size (11023) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE...
  20. Dabase

    Obtaining the size of a file

    Hi, I am trying to obtain the size of file that resizes on the server where the ASP application is hosted. Is there any way of achieving this in ASP? Any help would be appreciated. Thanks Dabase

Part and Inventory Search

Back
Top