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
User Profile
Collapse
-
Converting column data type of SQL server view
-
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. -
How to show distinct column values when it doesn't come in query result
Hi All,
This yeilds the correct value.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;
What I get is
What I need is a count for each ticket_sev even if there is no entry. So ticket_sev...Code:ticket_sev ticket_count 11 1 4 2 1 6
-
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... -
Usingworked for me.Code:IndexIgnore *
I can still open files directly without seeing the index listing when I just do upto /upload -
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
It stops listing all files but in the...Code:deny from all
-
Found the problem. Its $_SESSION instead of $_session. Didnt know small caps would have caused problems. Thanks for looking at it anyway. :)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.Leave a comment:
-
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']++;... -
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;
... -
Removing node/element from DOM
I came across this problem where I cant remove element from the document.
Here is my code.
Basically...Code:DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance(); DocumentBuilder builder = dbf.newDocumentBuilder(); Document document = builder.newDocument(); document = builder.parse(new InputSource(new StringReader(string)));
-
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... -
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 -
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
... -
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"%>
-
Thanks for the reply, I went there but which editor do I add? there is a big list of them.
Cheers...Leave a comment:
-
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 -
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; -
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.Leave a comment:
-
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.Leave a comment:
No activity results to display
Show More
Leave a comment: