User Profile

Collapse

Profile Sidebar

Collapse
Alien
Alien
Last Activity: Oct 4 '12, 11:47 AM
Joined: Sep 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Alien
    started a topic Converting column data type of SQL server view

    Converting column data type of SQL server view

    Hi is it possible to change the column data type of a view in SQL server?

    I have a view and would like to chance the data type from nvarchar to varchar.

    Using SQL server 2008

    Cheers
    See more | Go to post

  • Alien
    started a topic HTML td with fixed width

    HTML td with fixed width

    Hi
    I want to make sure that in my table the columns are fixed width. So if the content of it is very large the column can expand downwards but no across. I have tried using the width attribute with no luck.

    How can I achieve this? Thanks.
    See more | Go to post

  • How to show distinct column values when it doesn't come in query result

    Hi All,

    Code:
    select DISTINCT t.ticket_sev, count(t.ticket_id) as ticket_count 
    from tickets t
    where t.ticket_start > 1338938508 
    group by t.TICKET_sev;
    This yeilds the correct value.

    What I get is

    Code:
        ticket_sev ticket_count
    	11	1
    	4	2
    	1	6
    What I need is a count for each ticket_sev even if there is no entry. So ticket_sev...
    See more | Go to post

  • How does MYSQL handle NOT NULL columns when added to tables with records?

    Hi guys,

    I am trying to work out how MYSQL deals with NULL values.

    When a new column is inserted on a table already populated with records (40,000 in my case), and I specify it as NOT NULL, I can insert values without any issues. I was expecting some kind of DB errors to throw up.

    This is when adding new records from both PhpMyAdmin & the PHP applications.

    Does MYSQL have any utility...
    See more | Go to post

  • Using
    Code:
    IndexIgnore *
    worked for me.

    I can still open files directly without seeing the index listing when I just do upto /upload
    See more | Go to post

    Leave a comment:


  • How do I use .htaccess to stop webserver listing all files in directory?

    Hi guys,

    Currently in my webserver I got a directory call: ..../htdocs/upload/

    Currently, all files are listed when users go to www.mysite.com/upload/

    The way it works, when user click on a file link in my system, they redirected to this directory like this:

    www.mysites.com/upload/invoice.txt

    So If I have

    Code:
    deny from all
    It stops listing all files but in the...
    See more | Go to post

  • Alien
    replied to Session in php
    in PHP
    Found the problem. Its $_SESSION instead of $_session. Didnt know small caps would have caused problems. Thanks for looking at it anyway. :)
    See more | Go to post

    Leave a comment:


  • Why not do a while statement with mysql_fetch_arr ay( ) ?

    Code:
    $counter = 1;
    $maxRows = 5;
    $query1 = "# SELECT * FROM Testtable where County = '$county'  
    #   ORDER BY MerchantType";
    <table>
    while($counter < $maxRows)
    {
        $row_details = mysql_fetch_array($query1)
        
    // each $row_details will have a row from the table, just output it onto a table.
    ...
    See more | Go to post

    Leave a comment:


  • Alien
    started a topic Session in php
    in PHP

    Session in php

    Hi guys,

    I was doing a bit of experiment in php's session so i can apply something similar to another problem I am working on.


    Basically I am implementing a clicker which will count the number of clicks using sessions.


    [code='php']
    <?php
    session_start() ;

    if(!isset($_ses sion['val']) )
    $_session['val'] = 0;
    else
    $_session['val']++;...
    See more | Go to post

  • Alien
    started a topic Connecting via TCP/IP in C#

    Connecting via TCP/IP in C#

    Hi Guys,

    I am trying to learn how to use TCP/IP with C#. When I try to run my code, I get this error

    No connection could be made because the target machine actively refused it 121.218.51.204: 3000



    My code for TCP server is:

    [code=csharp]
    using System;
    using System.Collecti ons.Generic;
    using System.Linq;
    using System.Text;
    using System.Net.Sock ets;
    ...
    See more | Go to post

  • Alien
    started a topic Removing node/element from DOM
    in Java

    Removing node/element from DOM

    I came across this problem where I cant remove element from the document.

    Here is my code.

    Code:
    DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
    		
    DocumentBuilder builder = dbf.newDocumentBuilder();
    		
    Document document = builder.newDocument();
    		
    document = builder.parse(new InputSource(new StringReader(string)));
    Basically...
    See more | Go to post

  • Alien
    started a topic JSP Href
    in Java

    JSP Href

    Hi,

    I have a big table of href that all points to a jsp file, what I need in my jsp is to know which link called it, is there anyway I can check this?

    Basically i have a table of products and each product has its own xml description, and I need to divert the URL (in stylesheet) to this one jsp page so and it will do the formatting with transformerFact ory down the road.

    I can do so in the stylesheet by...
    See more | Go to post

  • Alien
    started a topic 2 buttons in a html form
    in Java

    2 buttons in a html form

    Hi guys,

    I got a html form which calls itself when clicked:

    Code:
    <% 
    	// This code deals state ADD_MORE_TRACKS
    	if(state == ADD_MORE_TRACKS || state == -1)
    	{
    		out.println("Please add your track listing");
    %>
    <form method="post" action="input.jsp">
    	<table>
    		<tr><td>Track Name:</td> <td><input
    ...
    See more | Go to post

  • Alien
    started a topic Eclipse Error: "org.apache cannot be resolved"
    in Java

    Eclipse Error: "org.apache cannot be resolved"

    Hi guys,

    I am doing JSP stuff in eclipse and when I open my file, i get a red cross on the line:

    [code=java]
    <%@page import="org.apa che.xml.seriali ze.*"%>
    [/code]

    When i move my mouse over it says:

    Multiple annotations found at this line:
    - The import org.apache cannot be
    resolved
    - The import org.apache cannot be
    resolved


    ...
    See more | Go to post

  • Alien
    started a topic Java beans question
    in Java

    Java beans question

    Hi Guys,

    I am learning JavaBeans and while playing around with the <jsp setProperty> and <jsp getProperty>, I wanted to try something out.

    Basically the the bean class has attributes, name, address, postcode...simp le one just for demonstration with accessors and mutators as usual.

    Code:
    <%@page import="java.io.*"%>
    <%@page import="dca.address.AddressBean"%>
    ...
    See more | Go to post

  • Alien
    replied to Content assist for JSP in Eclipse?
    in Java
    Thanks for the reply, I went there but which editor do I add? there is a big list of them.

    Cheers...
    See more | Go to post

    Leave a comment:


  • Alien
    started a topic Content assist for JSP in Eclipse?
    in Java

    Content assist for JSP in Eclipse?

    HI guys,

    I am currently learning JSP and Eclipse Gallileo seems to be a terrific tool to do so except it doesnt offer content assist when I hit crtl+space at the right spots which normally comes when I do normal Java apps.


    Anyone knows how to activate it if Eclipse does run it for JSP?

    Cheers,

    Alien
    See more | Go to post

  • Alien
    started a topic The {0} in C#

    The {0} in C#

    Hi,

    I am learning C# in csharp station website but theres one part I am little confused and the tutorial doesnt offer any explanation.

    Here is the code:
    Code:
    using System;
    
    class Unary
    {
        public static void Main()
        {
            int unary = 0;
            int preIncrement;
            int preDecrement;
            int postIncrement;
            int postDecrement;
    ...
    See more | Go to post

  • Alien
    replied to Line break in Java
    in Java
    Oh I think I get what you mean,

    Some thing like this:

    date 1 is : <%= d1%> <br>
    date 2 is : <%= d2%>

    and putting the remainder in a scriplet <% %>.

    Thanks.
    See more | Go to post

    Leave a comment:


  • Alien
    replied to Line break in Java
    in Java
    Yes its HTML but I dont think you can insert any HTML or non-Java stuff between <% %>

    I tried it didn't work. But outside that yes, <br> works like it normally would.
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...